QuickBooks Pre-file check: Explain Every Dollar Between P&L Income and Sales Tax Total Sales Before You E-file

QuickBooks Pre-file check compares the income on your profit and loss report with total sales on your sales tax liability report and lists transactions behind the difference. The two totals don't have to be equal. Your job before e-filing is to explain every dollar between them, then tie the tax to the ledger, which the check doesn't do yet.

Why this matters now

On 2026-10-27 Intuit used its Intuit Connect event to announce Enhanced Sales Tax preparation, "with a redesigned liability report, a Pre-File Check that flags discrepancies, and in-app eFiling and payment", rolling out to U.S.-based businesses and accounting firms starting that day. The press release gives it one sentence. The product documentation says more. Intuit's help article on reviewing total sales with Pre-file check, updated 2026-10-06, says the check compares "the income on your Profit and loss report with the total sales on your Sales tax liability report," sorts the differences into three groups ("Probably need to resolve," "Worth reviewing," and "Likely can be ignored"), doesn't change transactions on its own, and "doesn't yet flag detailed sales tax calculation issues." It is available in QuickBooks Online Plus, QuickBooks Online Advanced, and Intuit Enterprise Suite, in the United States only.

A companion article, how the pre-file check works, also updated 2026-10-06, names the usual causes: nontaxable transactions that are missing a customer, date, or location, and transactions synced from third-party apps without complete details. Its fixes are to put both reports on the same accounting basis and date range, work through the Nontaxable Transaction Review report, and confirm that connected apps send the customer, date, location, and tax status with every sale. Intuit's older guidance on why total sales differs from total income, updated 2026-08-05, is blunter: the two "will not always match," and the way to find out why is to run both reports with identical settings and compare them line by line.

What none of that tells an owner is what to conclude from a difference. Part of the gap is usually an error on the return. Part of it is an error on the profit and loss. Part of it is correct and should stay. The rest of this article is the test that separates those three, a worked October tie-out with real-sized numbers, and the second check that still has to happen by hand: proving the tax amount against the sales tax payable balance in the ledger before anyone presses file.

Why profit and loss income and taxable sales should not match

The profit and loss report answers one question: how much did the business earn in the period, on the basis you chose. The sales tax liability report answers a different one: how much did the business sell to customers in the jurisdictions it files in, split into taxable and nontaxable. Both are flow measures for the same month, and both come from the same ledger, but they read different fields. The profit and loss reads the account on each transaction. The sales tax report reads the sales form, the customer, the ship-to location, and the tax status of each line. A transaction that has an income account but no sales form shows up on one report and not the other.

Here is a self-contained rule you can quote to your accountant: profit and loss income and sales tax report total sales agree only to the extent that every dollar of ordinary income was recorded on an invoice or sales receipt with a customer, date, and location, and no dollar of non-customer income was posted to an ordinary income account. Every exception to that rule is a line in your reconciliation, and each one belongs in one of three buckets.

The bucket column is the point. A deposit without a sales form understates the return and could understate the tax. A vendor refund in income overstates revenue and the margin you manage from, but has nothing to do with the return. Interest income belongs on the profit and loss and will never belong on a sales tax return. Pre-file check's three groups map to these buckets closely, but the tool is sorting by pattern. You are sorting by what actually happened.

One business's October tie-out, line by line

Harbor Lane Candle Co. is a one-owner business that sells at weekend markets, through its own online store, and wholesale to four gift shops. It is on QuickBooks Online Plus, files one state sales tax return monthly, reports on the accrual basis, and has Automated Sales Tax turned on. The numbers are illustrative. The method carries to any business that sells goods.

The two totals and the gap

For October 2026 the profit and loss shows total income of $48,920.00. The sales tax liability report for the same month, same basis, shows total sales of $44,150.00. The difference is $4,770.00. Pre-file check lists three items behind it, and the owner works each one before touching anything.

Item one: a $2,400.00 wholesale deposit with no invoice

A gift shop paid a $2,400.00 wholesale order by bank transfer. When the deposit arrived in the bank feed, the owner categorized it straight to Sales income. There is no invoice, so the sales tax report has nothing to read. The check puts it under "Probably need to resolve," and that is right, but not because tax is owed. The shop holds a valid resale certificate, so the sale is nontaxable. It still has to appear on the return as nontaxable sales, because the state expects gross sales and then the exempt portion.

The fix is to create the invoice dated the day of the sale, marked nontaxable with the resale reason, with the shop as customer and its address as the location, and then match the existing deposit to it so the income isn't counted twice. After the fix, profit and loss income is unchanged at $48,920.00. Sales tax report total sales rises by $2,400.00 and nontaxable sales rises by the same amount. Taxable sales and the tax due don't move. Deposits posted directly to income are the single most common cause of this gap, and the undeposited funds guide explains why the sales form, not the deposit, should carry the revenue.

Item two: a $1,850.00 vendor refund sitting in income

A packaging supplier refunded $1,850.00 for a cancelled order. The refund landed in the bank feed and was categorized to Sales income because the feed suggested it. The check lists it under "Worth reviewing" as a possible vendor refund. This one is an error on the profit and loss, not the return. The fix is to reclassify it to the Packaging Supplies expense account the original purchase hit. Income falls by $1,850.00, packaging expense falls by $1,850.00, and net income is unchanged. The sales tax report never saw it and still doesn't.

Item three: $520.00 of insurance proceeds

The business received $520.00 from its insurer for a damaged display tent. It was recorded in Sales income. The check lists it under "Likely can be ignored" as income from a non-customer source. The owner marks it ignored in Pre-file check and, separately, moves it to Other Income so the sales margin on the profit and loss isn't flattered by a claim payment. That reclassification is good bookkeeping, not a filing requirement.

The totals after the fixes

Profit and loss ordinary income is now $48,920.00 less $1,850.00 less $520.00, or $46,550.00. Sales tax report total sales is $44,150.00 plus $2,400.00, or $46,550.00. The two agree, and every dollar of the original $4,770.00 is explained: $2,400.00 was missing from the return, $2,370.00 was never revenue. The owner keeps that three-line explanation with the October file. Next month the check will produce a new list, and the explanation is the evidence that this month's was handled.

The check Pre-file check doesn't do: the tax itself

Agreeing total sales proves the return starts from the right base. It doesn't prove the tax. Intuit's documentation is explicit that the check doesn't yet flag detailed sales tax calculation issues, so this part is manual. Nontaxable sales on the report are $9,900.00, the $2,400.00 wholesale order plus $7,500.00 of other resale-certificate sales. Taxable sales are therefore $46,550.00 less $9,900.00, or $36,650.00. At the business's combined 8.25% rate, the tax due is $3,023.63.

Now the ledger. Sales Tax Payable is a liability with a credit balance, and its balance at October 31 is a point-in-time number, unlike the month's sales, which are a flow. Opening balance at October 1 was $2,780.40, the September liability. The September return was paid on October 20 for $2,780.40, bringing the balance to zero. October's sales added $3,023.63 of tax collected, so the closing balance should be $3,023.63. The ledger shows $3,061.13. The $37.50 difference traces to a journal entry that debited Sales Tax Payable and credited the bank for a tax refund given to a customer who produced a resale certificate after being charged tax. The entry took the cash out correctly, but it never changed the tax status of the original sale, so the report still counts that sale as taxable. The right fix is a credit memo against the original sale, marked nontaxable, which corrects the report and the liability together. After it, the report's tax due and the ledger balance both read $3,023.63, and the return can be filed from either.

Accounting controls for the sales tax tie-out

Source data: the profit and loss for the filing period on the basis the state requires, the sales tax liability report for the same period and basis, the Pre-file check list with its three groups, the Nontaxable Transaction Review report, the Sales Tax Payable account register for the period, the prior return and its payment confirmation, and the resale or exemption certificates behind every nontaxable customer. Record the report basis and date range on each printout, because a cash-basis profit and loss against an accrual-basis sales tax report will never agree and will waste an afternoon.

Calculation: three deterministic equations, each one reproducible by anyone with the same reports. First, profit and loss ordinary income less explained non-customer items plus sales forms created equals sales tax report total sales. Second, total sales less nontaxable sales equals taxable sales, and taxable sales times the applicable rate equals tax due, computed per jurisdiction when the return requires it. Third, opening Sales Tax Payable plus tax collected in the period less payments made in the period equals the closing balance, and that closing balance equals the tax due on the return plus any prior periods still unpaid. Keep polarity straight: income accounts and Sales Tax Payable both carry credit balances, so a correction that debits one of them reduces it. Keep flows and balances separate: the month's sales and tax collected are flows, the payable at month end is a balance, and the third equation is the bridge between them.

Review: someone other than the person who categorized the transactions, which for a one-owner business usually means the bookkeeper or accountant at quarter end, re-performs the first equation from the reports rather than from the Pre-file check summary, inspects every item marked ignored and asks whether it really is non-customer income, samples at least one nontaxable sale back to its certificate, and re-performs the third equation from the account register. The reviewer also confirms that corrections were made with sales forms and credit memos rather than journal entries, because a journal entry fixes the balance without fixing the report. A business that already runs a monthly review of its five profit and loss numbers can add the sales tax tie-out to the same sitting; it takes about twenty minutes once the explanation list is a habit.

Decision: the owner decides which differences are accepted as correct and signs the return, and that decision is recorded with the three-line explanation and the date. The accountant decides the reporting basis and the treatment of any transaction type that isn't on the table above, such as gift card sales or shipping charges, and documents the rule once so it isn't re-decided every month. Nobody files on the strength of a "Pre-file check complete" message alone, because the message says the totals agree, not that the tax is right.

Limits and common mistakes

Pre-file check is available only in QuickBooks Online Plus, Advanced, and Intuit Enterprise Suite in the United States, and Intuit's own documentation says it doesn't yet flag detailed sales tax calculation issues. Nothing above describes product behavior beyond what Intuit has published, and the feature is new enough that the groups and suggestions may change. The reconciliation itself is older than the tool and works without it: run both reports with the same settings and explain the difference.

The first common mistake is treating every flagged item as an error on the return. Two of the three items in the worked example were errors on the profit and loss, and one of those was harmless to the filing. Fixing them by creating sales forms would have put non-customer income on the return and overstated gross sales.

The second is fixing differences with journal entries. A journal entry to an income account or to Sales Tax Payable changes a balance and leaves the sales tax report, which reads sales forms, exactly as it was. The gap moves instead of closing. Use invoices, sales receipts, credit memos, and refund receipts, which update both.

The third is ignoring items in bulk. The ignore option exists for legitimate non-customer income. Used on a list of app-synced sales that are missing locations, it silently drops taxable sales from the return. Businesses that sell through a point-of-sale or online store should fix the mapping at the source; the daily sales reconciliation guide covers how to get those syncs to carry customer, location, and tax status in the first place.

The fourth is reconciling on the wrong basis. If the state wants cash-basis reporting and the profit and loss is accrual, the two reports will differ by the change in receivables, and no amount of transaction review will close that gap. Match the basis first.

Frequently Asked Questions

What does QuickBooks Pre-file check compare?

According to Intuit's help documentation updated October 6, 2026, Pre-file check compares the income on your profit and loss report with the total sales on your sales tax liability report for the filing period, lists the transactions behind any difference, sorts them into "Probably need to resolve," "Worth reviewing," and "Likely can be ignored," and suggests fixes. It doesn't change transactions on its own.

Should profit and loss income equal total sales on the sales tax liability report?

Not necessarily. The two agree only when every dollar of ordinary income was recorded on an invoice or sales receipt with a customer, date, and location, and no non-customer income such as interest, refunds, or insurance proceeds was posted to an ordinary income account. Each exception is a line to explain, and some exceptions are correct and should stay.

Does Pre-file check verify the sales tax amount itself?

No. Intuit's documentation says the check focuses on confirming total sales and doesn't yet flag detailed sales tax calculation issues. You still need to confirm taxable sales times the applicable rates equals the tax on the return, and that the Sales Tax Payable balance in the ledger agrees with that amount plus any unpaid prior periods.

Which QuickBooks plans include Pre-file check?

Intuit's help articles list QuickBooks Online Plus, QuickBooks Online Advanced, and Intuit Enterprise Suite, in the United States. Intuit announced the broader Enhanced Sales Tax rollout, including the redesigned liability report and in-app e-filing and payment, on October 27, 2026.

What should I do with a deposit that was recorded straight to income?

Create the invoice or sales receipt the deposit paid for, dated the day of the sale, with the customer, location, and correct tax status, then match the existing deposit to that sales form so the income isn't counted twice. Profit and loss income stays the same, and the sale now appears on the sales tax report as taxable or nontaxable as appropriate.

Once the two totals agree, the next question an owner or their accountant asks is where the income came from and whether the month looks right against last month. FinBoard reads the QuickBooks Online ledger into one reporting view, so income by customer, location, or month can be traced from the profit and loss down to the sales forms behind it without rebuilding reports by hand. See how FinBoard turns the monthly tie-out into a report you can drill into.