QuickBooks Online Pre-File Check Flags Sales Tax Discrepancies

QuickBooks Online Plus, Advanced, and Intuit Enterprise Suite include a feature called the pre-file check — a review tool that cross-references income figures before a sales tax return is filed. The tool has drawn attention from users trying to understand exactly what it compares, why it flags certain transactions, and how to clear the discrepancies before filing.

What the Pre-File Check Compares

The feature pulls income data from the Profit and Loss report and holds it alongside the gross sales figures reported for a specific sales tax return. When the two numbers do not match, the pre-file check surfaces the difference and itemizes the individual transactions contributing to the gap. For each flagged item, it offers guidance on what to review and gives users the option to dismiss differences that are legitimate — for instance, income sources that are correctly excluded from sales tax.

The practical value is straightforward: it reduces the manual work of comparing reports line by line and directs attention to the specific transactions most likely to cause a filing error.

Why the Numbers Diverge

Several common issues drive the mismatches the tool catches. The Profit and Loss report captures total income from all sources — taxable sales, nontaxable sales, and other revenue. The Sales Tax Liability report, by contrast, organizes gross sales by tax agency. Reconciling the two requires combining the state gross sales figures from each tax agency, any transactions subject to custom tax rates, and any sales not tied to a specific tax agency at all.

Before relying on the comparison, two setup details matter. Both reports must use the same accounting basis — cash or accrual — and the date ranges must be identical. A mismatch on either front will produce apparent discrepancies that have nothing to do with actual data problems.

Clearing Flagged Transactions

When the pre-file check flags a transaction, the underlying cause is often incomplete record-keeping rather than a calculation error. A companion report — the Nontaxable transaction review, accessible from the Reports dropdown on the sales tax returns screen — surfaces sales that appear on the Profit and Loss report but are absent from the Sales Tax Liability report.

For each flagged transaction, four data points need to be present and correct: the customer name, the transaction date, the Ship From location, and the Ship To location. When any of those fields are blank, the transaction may not flow into the sales tax return as expected. Filling in the missing details, updating the tax calculation on the transaction, and saving the change typically resolves the issue — the transaction should then appear on the Sales Tax Liability report.

Third-Party App Connections

For businesses importing sales data through a connected third-party application, the pre-file check can expose gaps in what that app sends to QuickBooks. Sales tax needs to be enabled in the app itself, and the business must be configured to collect tax in every state where it has a filing obligation.

Beyond the tax settings, the app needs to pass along the full set of details QuickBooks uses to classify each sale: the product description, the tax designation for the item or transaction, and the actual tax amount applied where relevant. Missing any of those elements can cause transactions to land on the Profit and Loss report without making it into the correct sales tax return — which is precisely the scenario the pre-file check is designed to catch before filing.