Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
How did you get the report to show 4 columns? My report only shows the TAXABLE AMOUNT and TAX AMOUNT columns. I really need the Gross Amount and Non-taxable Amount columns as well!
HoneyLynn, can you please advise how you were able to get 4 columns on the Sales Tax Liability report? I followed your instructions and I only get 2 columns (Taxable Amount and Tax). I really need the other 2 columns.
Glad you made it here, tcorso. I'll make sure to help you figure this out.
Once you use the new sales tax feature for your invoices and sales receipts, QuickBooks automatically calculates sales tax based on the location of the transactions which is the Automated Sales Tax feature determines the rates based on the customer's billing and shipping address on the sales form. If you want to continue the old feature, here’s a workaround that may work for you.
Also, you can still review the rates for each tax agency from the Sales Tax Center. Here's how:
Review the rates from there.
I'll be adding a few related articles for you to be familiar with Automated Sales Tax:
I've additionally included a few detailed resources about working with reports that may come in handy moving forward:
Please know that you can always tag me if you have any other QuickBooks report concerns. I'm always here to help and provide you additional assistance. Take care!
Sorry Tirzah this didn't help too much. I need to have the Gross Amount and Non-Taxable Amount columns on the Sales Tax Liability Report. There are a bunch of workarounds posted here but I have not found one that works.
Hi tcorso!
Thanks for the reply. Let me further assist you in running the Sales Tax Liability report.
The Sales Tax Liability report has four columns in default. These are the gross amount, non-taxable, taxable, and the tax amount. Make sure to pull up the said report from the Reports menu.
You'll want to use an incognito window and check the report from there. Incognito won't save your browsing history which can result in an error. These are some of the shortcut keys:
Also, you'll want to clear the cache and make sure you're using a supported and up-to-date browser. This can fix any browser-related issues.
Another way to get the gross Amount and non-taxable amount is to pull up the Sales by Product/Service Detail report. Then, click the small Gear icon next to the Export button and check the Taxable, Tax Amount, Taxable Amount, and Tax Name boxes.
I've added the links you can check to see the available reports in QuickBooks Online and how to customize them:
Also, here's the article on how to settle your sales taxes: File your sales tax return and record tax payment in QuickBooks Online.
Leave a comment again here if you need more help. Take care!
Any idea why my reports keep showing me ZERO data??!?
I can help you make the desired data appear on your report, @chemncafe.
But before we get started, would you mind if I ask what report are you trying to pull up? This is for me to provide you with an appropriate answer based on the report you're trying to run.
Meanwhile, we can filter the Report period and make sure it is set to an appropriate date range. If it isn't, make the necessary changes. When done, click on Run report.
However, if there's still no data after confirming the date range of the report, let's check if this could have something to do with temporary internet files.
You can open a private window and see if the data on the report appear. Here's how to access incognito mode in some of the most commonly used web browsers:
If it's displaying the desired data, it's safe to say that it's being caused by the browser. It can be fixed by clearing your cache and cookies. In the event it continues occurring while using incognito, you'll initially have to try switching to another browsing application.
Here's a list of supported browsers:
Moreover, here's an article I got for you in case you want to export your reports so you can easily download the data entered into your file to your local hard drive: Export reports, list, and other data in QuickBooks Online.
We'll be here to continue helping in case you need assistance with regard to running reports in QuickBooks Online. Take care.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here