Established MMXXVRemote-first · Serving clients worldwideConversions both directions
care@ezconvertbooks.com

October 19, 2026

QuickBooks sales tax liability report doesn’t match the Pay Sales Tax window: fix it before you migrate

The short answer: when the Sales Tax Liability report and the Pay Sales Tax window show different amounts due, the cause is usually not missing money. It is most often a different date range or report basis, followed by stray payments, journal entries and future-dated transactions. Intuit’s help article for QuickBooks Desktop (updated 8/5/2026) walks through those causes in order. Clear them before a migration, because the sales tax payable balance becomes an opening balance in the new system, and whichever number you carry across is the one your next return starts from.

Why it matters before a conversion

A migration copies balances and transactions; it does not decide which of two disagreeing reports is right. If the liability report says one amount and the Pay Sales Tax window says another, the converted file inherits the confusion, and you find it at the next filing. Reconcile the two while the old file is still open and every transaction is one click away.

Check in this order

These steps follow the order of Intuit’s article. Back up the file first, and make any change on a copy if you are close to cutover.

  1. Match the dates. Open Reports > Vendors & Payables > Sales Tax Liability, delete the From date, and set the To date to the date in “Show sales tax due through” on the Pay Sales Tax window.
  2. Match the basis. In Edit > Preferences > Sales Tax > Company Preferences, see how “When do you owe sales tax?” is set (“As of invoice date” is accrual, “Upon receipt of payment” is cash). The preference controls the Pay Sales Tax window, while the report basis can be changed, so set the report to the same basis.
  3. Audit the Sales Tax Payable account. In the report, double-click the amount in the Sales Tax Payable column and look for tax payments, journal entries, adjustments and checks. Their dates move the report. Either correct the dates or change the report’s ending date to include or exclude them.
  4. Look for future-dated transactions. Intuit notes the Pay Sales Tax window reflects some future transactions, though not invoices or sales receipts, so it can show a lower figure. Run the liability report for All Dates to see whether it then agrees.
  5. Check items and groups. Review sales tax preferences, sales tax items and sales tax groups for errors.

The Write Checks trap

A separate Intuit article on common sales tax issues (also updated 8/5/2026) says to always use the Pay Sales Tax window and not Write Checks when you pay sales tax. If payments were entered through Write Checks, Sales Tax Payable can be wrong. Intuit’s fix: back up the file, find the incorrect payments in the bank register, re-enter them through Vendors > Sales Tax > Pay Sales Tax, remove the original entries, then run the liability report through the current date and compare it with the Sales Tax Payable balance. It also notes that a negative sales tax payable on a cash-basis Balance Sheet can come from paying on an accrual basis while reporting on a cash basis, so confirm the basis with your accountant and tax agency.

A simple example

Illustrative numbers only. The Pay Sales Tax window shows 4,200 due through 30 September, and the liability report shows 4,650.

  • The report still has a From date, so it includes older periods. Clearing it and setting To to 30 September gives 4,500.
  • Double-clicking the payable column shows a 300 journal entry dated 2 October. Moving it into the right period, or ending the report on 30 September, removes it and the two agree at 4,200.

Nothing was missing. The two reports were answering slightly different questions, which is the normal case.

What to do before the cutover

Once the two agree, print or export the liability report and the Pay Sales Tax window as of the cutover date, and keep them with your conversion tie-out. Your opening balance for sales tax payable should equal that agreed figure. Related cleanups worth doing in the same pass are undeposited funds, unapplied payments and credits and the opening balance equity account. If a file is too damaged to reconcile cleanly, see verify and rebuild. This is general information, not tax advice, so confirm your basis and filing position with your accountant.

Frequently asked questions

Why does the Sales Tax Liability report differ from the Pay Sales Tax window?

Intuit's help article says the two may not use the same date ranges or report basis. Match the report's To date to the “Show sales tax due through” date and make sure both use the basis set in your sales tax preferences.

Which date should I use on the report?

Clear the From date and set the To date to the same date as “Show sales tax due through” on the Pay Sales Tax window. Intuit also suggests running the report for All Dates to test for future-dated transactions.

Can I pay sales tax with Write Checks?

Intuit's guidance is to always use the Pay Sales Tax window rather than Write Checks, because payments recorded through Write Checks can leave Sales Tax Payable incorrect. Fix any that were recorded that way before you convert.

Should I delete or merge the Sales Tax Payable account to tidy it?

No. Intuit says QuickBooks does not let you delete the Sales Tax Payable account, you may rename it, and you should not create sub-accounts under it. Fix the transactions, not the account structure.

Does this apply to GST or VAT countries?

The Intuit article is written for QuickBooks Desktop sales tax setups. If your edition uses GST or VAT reports with different names, check the help article for your edition before applying these steps.

Related service: QuickBooks support

Thinking about a conversion?

Send us your details for a free, fixed-price quote within one business day.