QuickBooks Online tax reconciliation tool explains line 101 mismatches
A QuickBooks Online reconciliation tool helps Canadian users trace why profit and loss revenue does not match line 101 on a GST or HST return.
Filing season keeps producing the same surprise for QuickBooks Online users in Canada. The revenue total on the profit and loss report and line 101 of the GST or HST return disagree, and the return will not explain itself. Intuit’s answer, built into the Canadian edition, is a reconciliation tool that names the transactions behind the gap.
Why does line 101 disagree with your profit and loss report?
The tool runs one comparison. It sets total revenue from the profit and loss report against line 101, the sales line, on the return filed with the Canada Revenue Agency or Revenu Québec. When the two figures differ, it lists the transactions that created the difference. Most follow a pattern: income sits in the books, but the tax coding kept it off the return entirely.
The reverse case exists too. The tool’s second section hunts for amounts that reached line 101 yet never touched the profit and loss report. Together the two views cover both directions of the mismatch, which beats squinting at two reports side by side.
How do you reach the tool?
The entry point has moved between interface updates, so treat any set of clicks as provisional. In current Canadian accounts the tool hangs off the sales tax overview, not off a reports menu. You select the agency you file with, open the filing period you are preparing, and the option to view the reconciliation appears alongside it. Only the federal agency and Revenu Québec are supported; other tax agencies get nothing.
Is every flagged transaction an error?
No, and this is the part that saves users the most time. The tool flags income coded as out of scope, plus journal entries where the tax field was left blank. Some are genuine mistakes. A user who meant to pick zero rated or exempt, and picked out of scope instead, has created a silent difference. Recoding the transaction closes it.
Others are correct as written. Some revenue genuinely falls outside the scope of the tax, and leaving it off line 101 is right. The tool cannot tell the two apart. It hands you the list; the judgment stays with you.
The trap is that all three codes look identical day to day. Out of scope, zero rated, and exempt all charge no tax, so the invoice reads the same and the register reads the same. The difference only appears at filing, because zero rated and exempt sales still count toward line 101 while out of scope sales drop off completely. That is how a coding slip from months ago hides until filing week.
Purchase tax codes on income accounts
The first section has a second catch. Money posted to a revenue account can carry a tax code meant for purchases, such as HST on purchases, 0% on purchases, or exempt on purchases. Those codes belong on bills and expenses, not on income. The result is the same class of gap: revenue in the books, nothing on the return. Recoding with a sales type code resolves it.
Rounding can explain what is left
After the real items are resolved, a small residue often remains. The return and the profit and loss report round at different points, so a gap of a few cents or a few dollars can be arithmetic rather than error. Chasing it transaction by transaction rarely pays. If everything material is explained, let the rounding stand.
The limits worth knowing before you file
Four boundaries shape what this tool can do for you. It compares revenue only, so problems on the expense side and with input tax credits stay invisible to it. It serves the federal agency and Revenu Québec only. It is diagnostic rather than corrective: it names transactions, but you open each one and decide. And its blind spot is the journal entry, the one form where a blank tax field is even possible, which makes journals the likeliest source of an unexplained gap.
Our read of the workflow: run the reconciliation before you file, not after the agency asks. Work the list once, recode the true mistakes, and note the legitimate exclusions so they do not alarm you next period. The tool will not make the decision for you, but it turns a mystery number into a short list of named transactions. That is most of the battle.