Sales tax is wrong after a QuickBooks import — how to fix it

Sales tax is one of the most common casualties of a QuickBooks migration, because it isn’t just data — it’s a small system of items, agencies and liability accounts that all have to line up. Here’s how to spot what went wrong and put it right.

The symptoms

• Your balance sheet is off by roughly the amount of collected tax.
• New invoices don’t calculate tax, or calculate it wrong.
• The tax liability account doesn’t match what you actually owe the agency.

The usual causes

• Tax posted to the wrong account. If imported tax lines mapped to income or a generic account instead of the sales-tax liability, your balance sheet is off by exactly the tax total.
• Tax items and agencies not set up. QuickBooks calculates tax through tax items linked to agencies. If those weren’t created, historical tax came in as flat amounts and nothing calculates going forward.
• Wrong rates or jurisdictions. Rates that didn’t transfer, or the wrong agency assigned, produce wrong tax on new sales.

How to fix it

1. Set up your tax agencies and tax items correctly, with the right rates and jurisdictions.
2. Re-map any imported tax that landed in the wrong account to the sales-tax liability.
3. Reconcile the tax liability balance to what you actually owe as of the cutover date.
4. Test on a fresh invoice to confirm tax now calculates correctly.