cancel
Showing results for 
Search instead for 
Did you mean: 
tcorso
Level 1

How do I find the "total gross sales" in order to fill our my sales tax filing?

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!

tcorso
Level 1

How do I find the "total gross sales" in order to fill our my sales tax filing?

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.

TirzahC
QuickBooks Team

How do I find the "total gross sales" in order to fill our my sales tax filing?

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.

  1. Go to your Taxes menu and Click the Report blue link.
  2. Select the Tax Liability Report

Also, you can still review the rates for each tax agency from the Sales Tax Center. Here's how:

  1. Click on Taxes at the left pane, then choose Sales Tax.
  2. Tap on Sales tax settings.
  3. 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!

tcorso
Level 1

How do I find the "total gross sales" in order to fill our my sales tax filing?

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.

AlexV
QuickBooks Team

How do I find the "total gross sales" in order to fill our my sales tax filing?

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:

  • Google Chrome: Ctrl Shift + N
  • Safari 11 or newer: ⌘ Shift N
  • Mozilla Firefox: Ctrl Shift P
  • Microsoft Edge: Ctrl Shift P  

 

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 AmountTaxable 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!

chemncafe
Level 1

How do I find the "total gross sales" in order to fill our my sales tax filing?

Any idea why my reports keep showing me ZERO data??!?

QueenC
Moderator

How do I find the "total gross sales" in order to fill our my sales tax filing?

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:
 

  • Google Chrome: Ctrl + Shift + N
  • Mozilla Firefox: Ctrl + Shift + P
  • Microsoft Edge: Ctrl + Shift + P
  • Safari: Command + Option + P

 

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:
 

  • Google Chrome
  • Mozilla Firefox
  • Safari 11 or newer

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.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us