When a QuickBooks invoice is open, the expected customer receipt should reconcile to the invoice's current total, including sales tax that the customer owes. But the forecast should keep the tax component labeled separately from service or product revenue. Forecasting the full receipt and treating all of it as operating revenue are different decisions.
Reconcile gross cash before classifying it
Intuit explains that QuickBooks calculates sales tax on invoices from factors such as customer tax status, location, and item category. The invoice total therefore can contain both the seller's charge and an amount collected for a tax agency. Start with the posted open balance because that is the amount requiring customer settlement, then retain the components needed for downstream cash classification.
| Field | Purpose in the review | Common error prevented | | --- | --- | --- | | Gross open balance | Reconciles the customer obligation | Forecasting only the pre-tax subtotal | | Sales-tax component | Identifies cash that is not service revenue | Treating every receipt dollar as revenue | | Credit or correction | Bridges later invoice changes | Keeping an obsolete gross amount | | Expected receipt week | States a timing assumption | Assuming the due date proves cash timing |
The cash-receipt cutoff guide covers the separate question of when a later payment becomes observed cash.
Preserve the invoice version
Record the invoice ID, export timestamp, subtotal, tax, total, open balance, and any later credit or edit. If the tax calculation changes after the forecast snapshot, do not silently replace the old value. Bridge the prior total to the current posted amount and update the remaining expected receipt once.
The edited-invoice workflow shows how to preserve that version history. A tax change is one possible source of an invoice edit; it does not justify guessing why the change occurred.
Avoid two misleading shortcuts
First, do not subtract the sales-tax component from the expected customer receipt merely because it is not revenue. If the posted open invoice includes tax, the customer-facing amount still includes it unless a later source record changes the balance. Second, do not use an invoice total as proof of available bank cash. Payment application, settlement, and cutoff remain separate events.
This page is a forecasting control, not tax advice. The correct tax treatment and filing obligation depend on the business and jurisdiction; Intuit directs users with uncertainty to their accountant or relevant tax authority.
Decision rule
Forecast the reconciled gross open invoice amount, show the sales-tax component separately, and update both only from observed source changes. Then assign timing from invoice-level evidence rather than the tax calculation itself. Finance teams can use the four-week AR forecast guide to connect that amount bridge to a collections view, or review the AR Pulse example for a source-linked action format.