Sales Tax Reconciliation: A Step-By-Step Guide for Businesses

Sales tax reconciliation isn't required in most states but is essential to ensure you're accurately fulfilling your filing and remittance obligations. Learn how to reconcile sales tax and why it's so important to avoid costly surprises.

Published: May 14, 2026

Many companies set up a process to collect sales tax, then assume their job is done until it's time to file and remit. Unfortunately, if your business simply files your tax forms and sends payment without doing an additional accounting task, you're exposing yourself to significant risk.

That accounting task is called sales tax reconciliation. It involves reviewing sales records, accounting data, and tax returns to confirm there's no mismatch between tax you collect and the tax you report and remit.

This guide explains how reconciliation works, and when states require it. It also offers a step-by-step guide to sales tax reconciliation, and offers tips on what to do if the numbers don't align.

What is sales tax reconciliation?

Sales tax reconciliation is the process of comparing multiple different sales tax records to ensure that the numbers align across all sources.

For most companies, this is an internal monthly accounting process, but in Hawaii and Michigan, annual reconciliation filings are required.

Typically, the reconciliation process includes comparing:

• Data from where your sales are recorded, such as your Point of Sale system, invoicing system, sales platform or storefront
• Data from your accounting software such as QuickBooks or Xero
• The actual tax returns you filed or plan to file

While you're not required to complete this process, or submit evidence of reconciliation in most jurisdictions, reconciling sales taxes can save you from expensive mistakes.

If your accounting or sales records show you collected $4,800 in sales tax but your returns report just $4,400, you've under-remitted. If an auditor spots the discrepancy, you may owe back taxes, penalties and interest, and even face possible criminal charges and reputational damage.

Monthly vs. annual sales tax reconciliation

While internal sales tax reconciliation is optional, Hawaii and Michigan require annual reconciliation. It's important to understand both processes, and the differences between them.

Internal reconciliation (ongoing)

Internal reconciliation is the routine accounting practice companies do to ensure they're reporting the correct amount of sales tax. This is the process described above, that involves comparing your sales data, accounting data, and remittance.

Most companies should do this process monthly—or quarterly at a minimum—if they don't have a large volume of sales. Your company can set its schedule based on your filing requirements in each state. If you're required to file monthly, monthly reconciliation makes sense.

Your internal reconciliation process should be completed before sales tax filings are due in any state—typically between the 15th and the end of the month—so you can fix any discrepancies before you file tax forms with errors or remit the incorrect payment amount.

State-mandated annual reconciliation

In two states, reconciliation is not optional and is not just a bookkeeping exercise. Both Hawaii (which charges a general excise tax instead of sales tax) and Michigan require a formal annual reconciliation return in addition to routine monthly, quarterly, or annual filings.

Michigan sales tax reconciliation

Michigan requires you to file Form 5081 by February 28 of the year after the tax year. The form is required for all registered companies that withhold income tax and/or that collect sales or use tax, regardless of whether they file monthly, quarterly, or annually.

It must include:

• Total sales tax collected and owed
• Total withholding from employees

Hawaii sales tax reconciliation

Form G-49 in Hawaii must be submitted on the 20th day of the fourth month after the close of your tax year. If you are a standard calendar year filer, your form would be due April 20.

How to reconcile sales tax: a step-by-step process

This step-by-step guide explains how to reconcile sales tax so your company can complete this critical task.

1) Pull your reports

The first step is to gather the data you need including:

• Sales data from your POS system, invoicing software, ecommerce platform, or where it's recorded.
• Your sales tax payable balance obtained from your accounting software, such as QuickBooks or Xero.
• Data on the amount you'll remit to each state. This should be obtained from your tax software, or your tax return if you prepared one already.

2) Compare the numbers

Next, compare the numbers from all three data sources:

• Total tax collected: This should come from your sales data.
• Total tax recorded: This should come from your accounting software.
• Total tax remitted/scheduled to remit: This should come from your tax software or return.

To compare these numbers at a glance, create a table with columns showing the tax collected, recorded, and remitted from each of your different sources. Include rows for each state or jurisdiction where tax was collected.

3) Identify and categorize discrepancies

Once you've flagged any discrepancies, you must find an explanation for the differences. Most discrepancies result from:

• Timing differences: For example, a refund processed after filing or a transaction that was posted late.
• Rate errors: The wrong rate was charged due to incorrect product classification.
• Platform errors: Your ecommerce platform or system didn't work properly or was wrongly configured.
• Bookkeeping errors: Data entry mistakes, missing or duplicated entries, and incorrect account mapping could lead to divergent numbers.

4) Resolve before filing

The purpose of reconciliation is to catch errors before they turn into audit penalties. When you spot discrepancies, resolve them before filing:

• Correct bookkeeping errors in your accounting software.
• Document timing differences.
• Update your tax settings in your POS, billing system, sales platform, or tax software.

5) Archive your reconciliation

Finally, at the close of the reconciliation process, save the completed reconciliation in an accessible format. Include:

• The reports you obtained
• Your comparison table
• Notes on any discrepancies
• Information on how you resolved discrepancies

Common discrepancies and what causes them

As mentioned above, discrepancies are very normal during sales tax reconciliation, especially early on. Here are some common issues:

Rate errors

If the wrong tax rate is applied, you'll collect and/or remit the wrong amount of tax. Common causes include:

• Rates that have changed recently
• Incorrect defaults in the platform location
• Complex state tax situations

Misclassified products

Examples include:

• Exempt items being taxed or taxable items treated as exempt due to incorrect classification.
• Variations in state rules.

Refunds and credits not accounted for

If you processed a customer return in a different time period than the original sale, discrepancies may arise.

Multi-platform mismatches

Selling across multiple platforms complicates reconciliation, especially with marketplace facilitators like Amazon that collect and remit taxes on your behalf.

Timing differences from tax software recalculations

Discrepancies occur when tax is recalculated after the sale has been finalized, especially if the platform updates due to changes in rates or rules.

Sales tax reconciliation for multi-channel sellers

If you are a multi-channel seller, this makes reconciliation more complex. The table below shows how some common ecommerce platforms manage sales tax collection:

How Numeral can help you manage sales tax reconciliation

Reconciliation is important because sales tax data lives across multiple systems. Numeral provides a seamless system that supports tax compliance for ecommerce businesses, offering:

• Connecting to your sales systems
• Free nexus monitoring
• Auto-registering in relevant states
• Preparing and filing state tax returns
• Managing a virtual mailbox for state tax notices.

To find out more about how Numeral can simplify sales tax compliance, book a demo today.