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

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

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.

Hi Amanda:

This is a helpful Report too... a more direct route to the core of the problem, however what I guess I am really trying to determine is if I have chosen a Tax on Purchases or on Sales.

This makes the calculation of Line 101 in the Tax Return, in corrrect if the wrong Tax by Sales or Purchases is chosen...

Janice

Thank you Trish:

This report is exactly what I needed.

Janice

Hi there Janice,

I'm happy to hear that you were able to find the report you needed. if you have any other questions, feel free to reach out here.

How do the sales #s end up on Line 101? My line 101 is showing zero. I've pulled the Trans wo Sales Tax report for All Sales and it totals my P&L. There is a wonky set up that seems to be due to the Clio app being connected to QBO, but wondering how to ensure my line 101 fully populates properly?

Hi Lala63,

Thanks for joining us here.  To ensure a smooth transition of your transactions into QuickBooks Online, I recommend reviewing the settings in Clio.  If you require additional assistance, please reach out the the Clio customer support team.

If you have other questions or concerns, feel free to reach back out.  We'd be glad to assist!