Sales Tax Collected, Filed and Paid: Why the Numbers Must Reconcile

Illustrative accounting workspace with reports, a calculator and a waterfront view.

Your sales system shows tax collected. A sales tax return shows an amount due. The bank shows a payment. If those figures differ, the question is what explains the difference—not which number should replace the others.

Sales tax reconciliation connects the records across the process. Preparing a filing package is one step; understanding what remains in the books after filing and payment is another.

Compare the same period and business

Check the reporting dates, entity and relevant sales channels. A bank payment made this month may relate to an earlier filing period. Comparing it only with this month’s sales can create a difference that is entirely about timing.

Preserve the filed return and supporting calculation. An unsubmitted draft may differ from the figures that were ultimately authorized and filed.

Explain the movement in the balance

A useful working schedule starts with the opening sales tax balance, identifies activity recorded during the period, and then explains payments and supported adjustments. The ending balance should connect with the underlying ledger.

In a simplified bookkeeping illustration, an opening liability is $400, new amounts credited to that liability total $900, and a $400 payment settles the earlier obligation. With no other activity, the remaining liability would be $900. That example describes a ledger roll-forward, not how to calculate a sales tax return.

Investigate differences rather than force a match

Possible questions include whether refunds were recorded, whether a payment was posted to the correct account and whether an amendment changed an earlier amount. Purchase-related use tax or other applicable adjustments may also require review.

Do not assume every discrepancy is harmless rounding or a valid credit. Connect the explanation with source records and the applicable filing.

Keep collections distinct from ordinary business revenue

New York’s sales-tax recordkeeping guidance explains vendor recordkeeping and collection responsibilities. The accounting system should make it possible to identify the relevant tax amounts rather than burying them in an unexplained sales total.

How your software reports gross charges, net sales and tax can vary. Review the report definitions with your accountant before importing totals into the books.

Retain evidence of payment

Keep the confirmation, bank reference, period and taxpayer account details needed to identify the payment securely. A bank withdrawal with an abbreviated description may not explain which obligation it settled.

If an amount was paid twice, applied incorrectly or rejected, preserve the evidence and seek the appropriate correction. Do not simply clear the remaining balance because money left the bank.

Connect filing support with the books

Go Tax Dude offers sales tax support within the services agreed with each client and can coordinate it with small business accounting. For the earlier preparation stage, see our guide to organizing sales records for filing.

Schedule a consultation to discuss unexplained balances or ongoing support. We will review your records and confirm the scope before starting.

General educational information. Accounting and tax treatment depend on your business and circumstances.

Go Tax Dude Team

Tax and accounting articles from our CPA and EA team in Port Washington, New York.

Get to know our team →

This article provides general information, not advice for your specific situation.

← Back to all articles