Skip to main content
L
lori10
March 12, 2019
Question

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?

  • March 12, 2019
  • 2 replies
  • 0 views

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?

2 replies

TaxDetective
TaxDetective
March 12, 2019
Lori, do you know what the difference is made up of?
I
IntuitSharon
March 12, 2019

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

    O
    OEC
    July 21, 2019

    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 

    H
    HPark
    April 24, 2021

    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

    Terms & ConditionsAccessibility statement