cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

I am filing my GST and the report incorrectly shows sales and revenue. When I review my sales report and invoices those numbers are correct. How do I fix this?

I am submitting my GST and the sales tax report generated through QB shows incorrect sales and other revenue amount.  When I review invoices, sales report summaries and profit and loss statements the income shows correctly.  How do I fix this?

5 Comments
Frequent Explorer **

Lori, do you know what the difference is made up of?

Lori, do you know what the difference is made up of?
Active Member

Hi Lori, The GST report calculates sales and other revenu...

Hi Lori,

The GST report calculates sales and other revenue a bit differently from the Profit and Loss and sales reports. If a transaction is marked Out of Scope of tax, it will not be included in line 101 on your return.

Here's how you can see which transactions are included in your GST report:

  1. Select Taxes from the menu on the left and click Sales Tax at the top.
  2. Go to the Action column on the right and click the black drop down arrow next to Prepare return.
  3. Select View summary.
  4. Click the amount under the Total column for Line 101 Sales and other revenue. This will pull a detail report of all the transactions that make up line 101 on the return.

You can compare this detail report to your income reports to see which transactions are causing the difference.

Another tool that can help out here is the Transactions without sales tax report. To access it:

  1. Go to the Sales Tax page.
  2. On the right hand side, click the View Reports drop down.
  3. Select Transactions without sales tax.
  4. If needed, adjust the date range for the report and click Run report.

This will show you all transactions for the time period that either don't have a sales tax code or are marked Out of Scope.

Feel free to reach out if you have further questions!

Sharon

OEC
Established Member

Re: Hi Lori, The GST report calculates sales and other revenu...

Hi,

I have the same problem as OP.  My sales and revenues showing on the tax filing report are 6,000 - however my total sales and revenues for that period is 512,854.   The 6000 is in CAD and the rest is in USD and therefore Out of Scope amounts.  

Which of the 2 amounts should I report on line 101 of my GST report?  

Thank you.

Natalie 

Community Contributor **

Re: Hi Lori, The GST report calculates sales and other revenu...

I have the same problem as OP.  In my case, the difference between the sales tax center and the gross income on the Income Statement is due to a couple of refunds that were issued to the customer.  Why does the sales tax center remove customer refunds from the income reported on Line 101?  Is this the correct treatment of a customer refund; that it does not have to be reported on line 101 at all?  On the Income Statement I am showing the full amount of the sale and then the refund coming off in a Cost of Goods Sold account.  How should I get the sales tax center to match the Income Statement?

QuickBooks Team

Re: Hi Lori, The GST report calculates sales and other revenu...

You’ll want to check the way you processed the refund, RashmiS.

 

Refunds shouldn't be included since you returned the money. Although, it will only affect the amount in Line 101 if you assigned a tax to it. You can also reach out directly to your accountant to guide you with filing the return. 

 

The Sales Tax Center and Income Statement can’t be matched. The Sales Tax Center only track the sales tax liabilities. On the other hand, the Income Statement is used to calculate profits by comparing revenue to expenses.

 

You can pull up the Taxable Sales Summary report. This will serve as your guide regarding sales taxes.

  1. From the Reports tab, search and select Taxable Sales Summary.
  2. Set the correct reporting date.
  3. Click Run Report.

You'll want to check this article about Business Sales Tax.

 

Please let me know if you have other questions. I'm here to help.