New CereTax SmartResearch. AI tax research. Cited answers. SmartResearch. Cited answers. SmartResearch. Learn more
Your sales tax return is filed. The numbers balance, payments have been made, and the reporting period is closed. Then an auditor asks a simple question: Can you show how the sales reported on this return tie back to your original transactions?
Suddenly, the finance team is searching through invoices, the tax team is locating exemption certificates, and accounting is trying to explain differences between the general ledger and reported sales. The information exists, but it is spread across systems, spreadsheets, and reporting files that do not necessarily agree.
That is where a sales tax audit can become complicated.
An audit is not simply a review of whether you filed returns and paid tax on time. It can involve testing whether reported sales are complete, whether deductions are supported, whether the correct tax was applied, and whether the records substantiate the figures on the return.
The California Department of Tax and Fee Administration (CDTFA), for example, identifies comparisons between book sales and reported sales, tax collected and tax reported, and claimed resale sales and resale customers as part of its sales and use tax audit testing.
For businesses processing thousands of transactions across multiple jurisdictions, even small data inconsistencies can become difficult to explain. Here are five gaps worth identifying before an auditor does.
The first question is whether your sales records support the numbers reported on your sales tax returns.
A return may show total gross sales, taxable sales, exempt sales, and deductions. But those figures should be traceable to the underlying invoices, sales journals, billing records, and accounting entries.
Problems arise when transaction records are incomplete or summarized too aggressively. For example, a monthly sales report may show total revenue without preserving the detail needed to distinguish taxable products, nontaxable charges, shipping, discounts, or adjustments.
An auditor may ask for the original transaction details to verify how the sale was treated.
The CDTFA's Publication 116, Sales and Use Tax Records, explains that sales records should provide enough detail to establish the date of sale, what was sold, taxable and nontaxable charges, and the tax applied.
What to check: Select a sample of reported transactions and trace each one from the original invoice through the tax calculation, accounting entry, and return summary. If the trail breaks at any point, investigate why.
Exempt sales can create significant audit exposure when the supporting documentation is incomplete, unavailable, or disconnected from the transactions receiving the exemption.
Consider a business that reports a substantial volume of resale sales. The customer accounts are marked exempt in the billing system, but the corresponding resale certificates are stored in a separate folder. Some certificates may be missing, incomplete, or associated with a different customer entity.
The exemption may have been applied correctly, but the business needs records to demonstrate that.
Auditors can examine whether claimed exemptions are supported by appropriate documentation and whether the records connect the exemption to the relevant sale.
Pay particular attention to:
The CDTFA's audit guidance identifies resale and exemption certificates among the records it may review. Its recordkeeping guidance also highlights the need to retain documentation supporting nontaxable sales.
What to check: Reconcile the exempt sales reported on your returns against customer-level exemption records. Confirm that each claimed exemption has appropriate supporting evidence and that the documentation relates to the transactions in question.
A transaction can be assigned to the wrong jurisdiction even when the tax calculation itself appears consistent.
This often happens when billing addresses, shipping addresses, customer headquarters, and actual delivery locations are maintained separately. If the address used for tax determination does not reflect the applicable sourcing rules, the business may collect the wrong amount of sales tax.
Local and special district taxes make this especially important. A transaction may be subject to a different combined rate depending on the relevant location and applicable rules.
For audit purposes, the question is not simply whether the system applied a rate. It is whether the rate and jurisdiction were appropriate for that transaction.
The CDTFA specifically lists correct allocation of local tax and use of the correct rate in special tax districts among the matters examined during a sales and use tax audit.
What to check: Compare the addresses stored in your transaction records with the locations used by your tax calculation system. Investigate missing location details, inconsistent address records, and transactions assigned to unexpected jurisdictions.
A return can be mathematically correct and still contain reporting inconsistencies.
For example, gross sales recorded in the accounting system may differ from gross sales reported on the sales tax return. Exempt sales may not agree with certificate-backed transactions. Deductions may have been claimed without a clear connection to supporting records.
These differences do not automatically indicate an error. Timing adjustments, accounting classifications, and reporting rules can create legitimate variations. But your business should be able to explain them.
A useful review compares the following:
The CDTFA's Publication 76, Audits, describes comparisons between book sales and sales reported on returns, as well as between tax collected and tax reported.
What to check: Prepare a return-to-ledger reconciliation for each reporting period. Document timing differences, adjustments, and deductions rather than relying on unexplained balancing entries.
Even accurate records can become difficult to defend when they are scattered across an ERP, billing platform, tax engine, CRM, document repository, and spreadsheets.
An auditor may need to understand how a transaction moved through these systems and how its tax treatment reached the filed return. If the business cannot connect the records, the review becomes slower and the risk of unsupported conclusions increases.
The issue is also one of retention. California, for example, generally requires businesses to retain relevant sales and use tax records for at least four years. If an audit is underway, records covering the audit period should be retained until the audit is complete, even when that extends beyond four years. Other states have their own requirements.
A reliable audit trail should connect:
What to check: Run periodic sample-based reviews to confirm that transaction records, tax calculations, supporting documents, accounting entries, and return summaries can be retrieved together. Also verify that historical transaction data remains accessible for the required retention period.
Preparing for a sales tax audit should not begin when the auditor requests your records. It should be part of the way your business manages transactions and reporting throughout the year.
Start with the five areas above. Review transaction completeness, verify exemption documentation, validate jurisdiction assignments, reconcile return figures, and make sure supporting records can be retrieved without reconstructing the entire reporting process.
Technology can make that process more manageable. CereTax helps businesses manage complex sales tax requirements with configurable tax logic, jurisdiction-level precision, and integrations designed for high-volume transaction environments. By connecting tax determination with the systems that process business transactions, teams can strengthen the consistency and visibility of their sales tax data.
Complex tax. Calculated correctly.