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

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?

8 Comments 8
TaxDetective
Level 3

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?

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

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?

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
Level 2

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?

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 

RashmiS
Level 2

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 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?

AlexV
QuickBooks Team

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?

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.

leebrendalee
Level 3

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?

ok I just had the same issue and I checked all the deposits and sure enough it said "exclusive or inclusive" of GST, when in fact mine should say OUT OF SCOPE..Because mine is different, but my income statement is correct, so that's the figure I will use but I'm fixing up all my entries to it should match p n l going forward.

inkamloops
Level 1

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 had the same problem.

 

By following your instructions, I discovered that some personal contributions (deposits) into the business were "exclusive of tax" & "exempt (sales)." I found them at the bottom of the revenue list under "not specified".

 

To fix it, I changed the "exclusive of tax" to "Out of Scope" and saved the change for each personal contribution. Problem solved!

 

Thank you very much for the insight.

HPark
Level 2

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?

USD Sales are not OUT OF SCOPE, which is why you are having difficulty. Zero rated is for Wholesale (items classified as "zero-rated" under the Goods and Services Act) and Exempt would be used for USD sales. Technically, you should also be tracking CDN sales to one GL code and USD sales to another GL Code, so they can be separated into Line 90 and Line 91, which cumulatively make up Line 101 on the HST return. When you file HST through the electronic banking system, it doesn't allow you to separate these line, but if you report it through CRA's, My Business Account, you have the option of choosing the correct line items. Then to pay the amount owing, just make a GST Balance payment (rather than file an GST return & Payment option together) via the online banking system (or write a cheque if you are doing it the non-electronic way). Happy filing

Need to get in touch?

Contact us