GST Summary report, Line 101 is incorrect by $50,000. Incorrect caculation of the transaction amounts. Positive and negative amounts are incrementing the balance.

Hi obonnaius,

Thanks for reaching out here.  QuickBooks Online calculates the sales tax automatically, based on the rates you apply to your transactions.  It's essential that line 101 on your sales tax return is aligned with your books.  I would be glad to assist!

Initially I suggest checking the Report period and the Accounting method on the report.  In addition, it's important to note, journal entries aren't linked to sales tax reports.  If transactions are recorded by general journal entries instead of invoices or sales receipts, many of your reports will be incorrect.  You can reverse a journal entry and re-enter the transaction with the correct form, so it's reported accurately.  You can review a list of journal entries in the Transactions without Sales Tax report.

If you've entered the your transactions correctly and it's still not calculating the sales tax accurately, I recommend contacting the QuickBooks Online support team outside of this forum.   It would be our pleasure to review your situation in more depth, so you can get back to business as soon as possible!

Feel free to reach out again, if you have any other questions.  We would be happy to help!

testing, authentication failed last time, I'll post if this works now

Hi @Trish_T thank you for your speedy response

I sell on Amazon and use the A2X service. Every two weeks A2X provides a journal of my Amazon goods and services transactions. To create invoices for all those transactions every two weeks would be crazy. The calculation for the GST report used to work fine I do not know what has changed.

The sales revenue total in my P/L report is correct but not in my GST report. The balance for line 101 is incorrect because the negative transaction amounts are incrementing the balance. This seems like a software bug to me. BTW, lines 103 and lines 106 transactions do seem to be calculating correctly the negative amounts are decrementing the balance as expected, only the calculation for line 101 is incorrect.

I was on the phone for over an hour with QBO support yesterday and got nowhere with this issue. I will try again.

Hi obonnaius,

Thank you for getting back to me with the additional details of your situation.  Speaking with a member of our Customer Care team is the best course of action at this time.  They will have the ability to review this in more depth, and escalate it for further investigation with our Development Team, if needed.  Although the key here is to isolate the issue and ensure it doesn't continue moving forward, you can go to Sales tax > Filings > Prepare return, and enter any adjustments as you see necessary.

We look forward to hearing back from you, if a resolution has been provided.  This will also benefit other QuickBooks Community members, who may be experiencing the same issue within their books.

I will be here, if you have any other questions.