Most VAT and sales tax problems we see on inherited books are not filing problems. They are recording problems that nobody caught for eleven months, and then the return would not reconcile.
VAT and sales tax errors in QuickBooks and Xero almost always come from the tax code applied at the transaction line, not from the return itself. Five failure modes account for the great majority: the wrong code on a repeated transaction, zero-rated treated as exempt, a rate that changed after setup, lines with no code at all, and reverse charge recorded as ordinary input tax.
Need a second pair of eyes on your VAT ledger before the next return? WhatsApp us and tell us which software you are on.
Quick Summary
| Failure mode | Where it shows up | What it costs |
| Wrong tax code on a recurring transaction | Repeats every month until someone notices | Cumulative under or over-declaration |
| Zero-rated booked as exempt | Output tax looks right, input tax recovery does not | Lost or disallowed input recovery |
| Rate changed after the code was created | Old rate keeps applying silently | Shortfall plus interest on the difference |
| Line with no tax code | Falls outside the return entirely | Return does not tie to the ledger |
| Reverse charge treated as normal input tax | Only one side of the entry is posted | Understated output tax |
💡 TaxKitab Tip: Before you look at a single return, run the transactions-by-tax-code report — in Xero, Reports → Tax → Transactions by Tax Rate; in QuickBooks, Taxes → Reports → Transaction Detail by Tax Code — for the full period. Almost every error in the table above is visible in that one report, because an incorrectly coded transaction sits under a code where it does not belong. We run it as the first step on every new overseas file we take on, before touching anything else.
The Wrong Code on a Recurring Transaction
Recurring bills and invoice templates carry a tax code with them. Set it wrong once and it repeats on schedule, with no warning and no error.
The usual culprits are subscriptions, rent, insurance and professional fees — transactions that look settled and never get re-examined. We have picked up files where the same software subscription had been coded at the standard rate for three years when the supplier was not charging tax at all.
Check every recurring template and every bank rule separately from the transactions themselves. A bank rule applying a default tax code to anything matching a description is the most productive place to look, and the reasons for that are the same ones set out in our note on bank rules in QuickBooks and Xero.
Zero-Rated, Exempt and Out of Scope Are Three Different Things
This is the error that does the most quiet damage, because the output tax figure can look correct while the input tax position is wrong.
Zero-rated is taxable at 0%. The supply is inside the system, and input tax on related costs is normally recoverable.
Exempt is outside the charge. Input tax attributable to it is normally not recoverable, and it may restrict recovery across the business.
Out of scope, or no tax, is not a taxable supply at all, and it should not appear in the return boxes that exempt supplies do.
Software ships with codes for all three, often with similar names, and whoever enters the invoice picks the one that looks closest. Export sales booked as exempt rather than zero-rated is the version we see most often, and it understates recoverable input tax.
A Rate That Changed After the Code Was Created
Tax codes in both platforms carry a rate. When a jurisdiction changes a rate, the code does not update itself — someone has to create a new code and stop using the old one for transactions after the effective date.
Two things then go wrong. Either the old code keeps being applied to new transactions, or the new code is applied retrospectively to transactions dated before the change. Both produce a return that does not match the ledger. Keep a dated list of which code applies from which date, outside the software.
Lines With No Tax Code at All
A transaction line with a blank tax code is not an error the software will stop you on. It simply does not appear in the return.
These accumulate from journal entries, opening balances, bank feed transactions matched without review, and imports from a previous system. Run the transactions-by-tax-code report and read the “no tax” or blank grouping. If the total there is material, the ledger and the return are measuring different populations and the return cannot be relied on.
Reverse Charge Recorded as Ordinary Input Tax
Where the recipient accounts for the tax instead of the supplier — common on imported services in the UK, the EU and the UAE — the entry has two sides. Output tax goes up and input tax goes up, usually netting to nil in cash terms, but both legs have to appear in the return.
Booked as an ordinary input-tax purchase, only one leg is posted. Output tax is understated and the return looks like a larger reclaim than it should. Both platforms have dedicated reverse-charge codes; the fix is to use them.
Pre-Filing Checks That Catch Most of This
Run these in order, before the return rather than after.
- Reconcile the tax control account to the return. If the balance sheet liability does not agree to the return figure, something is coded outside the return.
- Run transactions-by-tax-code and read the blank or no-tax grouping first.
- Sort the standard-rate grouping by supplier and look for suppliers who should never appear there.
- Check the zero-rated and exempt groupings against each other. Anything with an overseas customer sitting under exempt is worth opening.
- Confirm the effective dates on every rate code used in the period.
- Reconcile the tax payments actually made to the bank, so prior-period adjustments are visible.
Where the underlying books are the problem rather than the tax codes, sequence matters: fix the inventory and valuation entries first, because tax coding sits on top of them. And where the question is whether this work should sit in-house at all, the trade-offs are set out in in-house vs outsourced accounting — CPA firms looking specifically at the delivery model will find it in outsourcing bookkeeping to India.
Frequently Asked Questions
Can I fix a wrongly coded transaction from a period already filed? You can correct the ledger, but the correction then has to be carried into a return — as an adjustment on the next one or through a formal amendment, depending on the jurisdiction and the size of the error. Fix the ledger and flag it to whoever files; do not silently re-code a closed period.
Does QuickBooks or Xero handle multi-jurisdiction tax better? Neither is clearly ahead for recording. Xero’s tax rate objects are easier to audit because the transactions-by-tax-rate report is cleaner. QuickBooks’ automated sales tax handles US state rates with less setup, but it is harder to see what it decided and why.
What is the fastest sign that the VAT ledger is unreliable? The tax control account on the balance sheet not reconciling to the sum of returns filed, less payments made. If that does not tie, stop and investigate before filing anything.
Do bank rules need checking every period? Not every period, but every time a supplier changes their billing entity, their country, or their tax treatment. That is when a rule that was correct becomes wrong without anyone touching it.
Does TaxKitab file VAT or sales tax returns for overseas clients? No. Our overseas scope is accounting and bookkeeping — recording, reconciliation and reporting. Returns are filed by the client or their local tax agent, working from books we have reconciled.
References
- QuickBooks Online: Taxes → Reports → Transaction Detail by Tax Code
- Xero Central: Reports → Tax → Transactions by Tax Rate
- Reverse charge and zero-rated treatment are set out in each jurisdiction’s own VAT or sales tax law
⚠️ Software menu paths change between releases, and rates and treatments differ by jurisdiction. Verify both against your own file and with your local tax agent before relying on a code.
Call or WhatsApp: +91 7448200422 | Email: info@taxkitab.com
See our Outsourced Accounting service if your business sits outside India, or the UK and UAE pages for how engagements are usually set up. Get in touch.
