Skip to main content
JanicePickwell
Jan 5, 2023 10:42 PM UTC
Solved

How does QBO calculate line 101 (Total Sales) for the GST Return?

As in, does it total all Sales based on the tax code used?
it is not obvious from the P & L where the total is coming from
LeithG
LeithGAnswer
Jan 5, 2023 11:32 PM UTC

Hi Jane

 

The sales amount on line 101 is all sales regardless of tax code for the reporting period.  If your P&L isn't matching, there are a couple things that could be happening:

1. The date/period chosen when running your P&L doesn't match to the report; by default, the P&L report will run current Fiscal Year-To-Date (as of today).  Be sure to set your start and ending dates to the same dates as the tax report.

2. Some items may be misqualified as revenue depending upon the tax code you choose for certain entries.  For example, if you perform a journal entry and selected the (Tax Sales) instead of (Tax Purchases) code from the drop down.

 

Hope this helps!

Leith

View in thread

9 replies

LeithG
LeithGAnswer
Jan 5, 2023 11:32 PM UTC

Hi Jane

 

The sales amount on line 101 is all sales regardless of tax code for the reporting period.  If your P&L isn't matching, there are a couple things that could be happening:

1. The date/period chosen when running your P&L doesn't match to the report; by default, the P&L report will run current Fiscal Year-To-Date (as of today).  Be sure to set your start and ending dates to the same dates as the tax report.

2. Some items may be misqualified as revenue depending upon the tax code you choose for certain entries.  For example, if you perform a journal entry and selected the (Tax Sales) instead of (Tax Purchases) code from the drop down.

 

Hope this helps!

Leith

    JanicePickwellAuthor
    Jan 6, 2023 10:54 PM UTC

    Hi Leith:

     

    Thank you, your explanation, it helped me find the problem.  

    Resulting in my having to hand correct the Exempt Tax code from Sales to Purchases.

     

    I would love to be able to check my handiwork to see if I have found all the culprits, is there a way to generate a Report on that specific Tax Code? "Exempt on Sales".  I have had to open each JE individually to check the tax code mapping to identify the problem ones.

     

    I did check the available filters on Custom Reports and did not find a way to accomplish this.

    Plus the on screen report,  if you add the column for Tax Code it doesn't tell you if its for Sales or Purchases. so you have to open every journal entry individually.  I've likely missed something and so would like a way to check.

     

    The incorrect journal entries were created by A2X to import Amazon data into Quickbooks.  I accepted their automapping rules on setup and this deeper level of Tax Code Mapping was not done correctly resulting in the issue at hand.  

     

    thanks for your help

    Amanda-B
    Jan 6, 2023 11:59 PM UTC

    Hey JanicePickwell,

     

    Thanks for reaching back out to us here. Being able to find specific reports you need is important. I would be happy to provide some information.

     

    In Transaction Detail by Tax Code Report you have the ability to add Transaction type to your report, as well as tax code. To do this, find the report suggested and click on Customize. Locate Change columns, you will see a drop down arrow beside Transaction type. You can chose which transactions to choose from. I hope this helps! Don't hesitate to reach back out.

    Terms & ConditionsAccessibility statement