Sales tax amounts wrong in QuickBooks Online? Three reports pinpoint the cause
QuickBooks Online users facing sales tax mismatches can trace the cause with three built-in reports before adjusting returns or clearing old filings.
Community threads from Canadian QuickBooks Online plans keep returning to one frustration: sales tax figures that refuse to agree. The return in the Sales Tax Centre shows one set of numbers, the Tax Payable account shows another, and transactions from closed periods linger as if they were still open. The accepted guidance here is procedural rather than a quick fix. Diagnose with reports first, then adjust, and only after the cause is known.
The mismatch users keep hitting
The trouble usually takes one of three shapes. A line on the GST/HST return does not match the balance in the Tax Payable account on the chart of accounts. Or entries from periods already filed keep appearing as though they were still open. Or the software flags exceptions, transactions queued to land on the next filing whether or not you expected them.
None of this is necessarily lost data. More often, one transaction carried the wrong tax code or posted to the wrong account. The reports exist to find that single entry.
Start with the sales tax summary
The first stop is the summary report for your return. That means the GST/HST Summary for most Canadian filings, with PST and QST versions where a province runs its own system. You reach all of them from the Standard reports section of the Reports area.
This report breaks the return down line by line, and each amount is clickable. Clicking a figure opens every transaction feeding that line. That makes it the fastest way to spot problematic entries, because you see the individual culprits behind each total instead of a blob of numbers.
Exceptions queued for the next filing
The Exception Detail Report covers the other end of the timeline. It lists the exceptions that will show up on your next filing. Each one can be opened on its own, and each carries an audit history you can read to see what changed and when. If a figure moved after the fact, the history usually catches it.
The report that lines up both sides
The sharpest tool for the mismatch itself is the Quick Report on the Tax Payable account. Run it from the chart of accounts: open the Accounting section from All apps, locate the Tax Payable account, and choose Run report from the account history dropdown. Set the date range to the period you are checking.
One extra step matters. Open the report’s customization options with the gear icon, choose Show More, and switch on the Tax Amount and Tax Code fields. The reason is simple. The Tax Amount column mirrors what the Sales Tax Centre sees, while the Amount column mirrors what lives in the payable account. Placed side by side, the two columns show exactly where the figures part ways.
Adjustments that leave the books clean
Once the cause is known, the accepted answer lays out two adjustment routes. Both are built into the return workflow rather than worked around it.
A sales tax adjustment, made while preparing the return, raises or lowers any line tied to the Tax Payable account. You must name an adjustment account to offset the change. If you only mean to correct the filing itself, select the Tax Payable account as the offset. That produces a neutral entry which never touches the rest of the chart of accounts.
The second route handles the lingering-entry problem. When the Sales Tax Centre keeps showing transactions from periods already filed, a zero-adjusted filing clears them out. Adjust every affected line to zero, again using the Payable account as the adjustment account. When the net amount due reads zero, prepare the return. The period closes, the entries drop away, and the chart of accounts stays untouched.
Can you undo a filed return?
Here the software draws a hard line. QuickBooks Online offers no self-service way to reverse a filed sales tax return, and the accepted answer does not pretend otherwise. That step runs through an accountant or the vendor’s support channel. When a reversal happens, all transactions from the filed period return to the Sales Tax Centre, exceptions excluded, and a reversing journal entry cancels the original filing. It is not a mechanism you generate by hand.
A workable order of attack
Strip out the detail and the guidance is a sequence, and it is the one we would follow. Run the summary first and click into any line that looks wrong. Check the Exception Detail Report for anything queued against the next filing. Then run the payable account’s Quick Report with the Tax Amount column visible, and compare it against the return. Only after the cause is clear should you adjust, and the neutral adjustment options keep the correction from rippling through the books.
One caution from the guidance is worth keeping. Deciding how to correct tax records is an accounting judgement, not a software setting. The reports tell you where the numbers diverge. What to do about it belongs to whoever owns your books.