If a known open invoice is missing from the QuickBooks AR Aging Detail used for forecasting, stop treating the export as a complete source population. Reconcile the invoice before using the report to rank actions or assign expected collection weeks.
Confirm that the invoice is actually open
Start with the transaction itself. Record the invoice identifier, customer, transaction date, due date, original amount, current balance, status, and the time it was last changed. Confirm that a payment, credit, void, deletion, or customer reassignment did not legitimately remove or offset it.
Then rerun the aging detail for an explicit report date. QuickBooks aging reports are designed to show outstanding customer balances and transaction detail, but report settings and transaction changes can alter what appears. Use the QuickBooks AR aging report-date checklist to preserve the cutoff and scope.
Reconcile report settings and populations
Compare the missing invoice across the Open Invoices report, AR Aging Detail, customer transaction history, and the accounts-receivable control balance. Keep these checks distinct:
- Verify the report date includes the transaction and later activity.
- Confirm filters are not excluding the customer, status, transaction type, or period.
- Check whether the invoice was edited after the forecast export.
- Review applied payments and credits for a zero or changed residual balance.
- Confirm that the transaction posts to the expected accounts-receivable account.
The Open Invoices versus AR Aging Detail comparison explains why the two views serve different review jobs. If the report total also disagrees with the control account, follow the AR aging and balance-sheet reconciliation.
Protect the forecast while the gap is open
Do not manually add a guessed duplicate row just to make the forecast look complete. Create a source-integrity exception with the invoice ID, observed transaction facts, reports checked, amount at risk of omission, owner, and next review date.
If the invoice is confirmed open but the export remains incomplete, keep it in a separately labeled reconciliation queue. Assigning a collection week should wait until identity and residual balance are supported. If the invoice is confirmed closed, record the closing event and remove the unsupported expected cash from the current forecast.
Minimum handoff
The handoff should include the report name, report date, filters, invoice ID, customer, open-balance evidence, payment or credit links, observed mismatch, owner, and resolution. Preserve screenshots or exported rows only when authorized and necessary; do not expose customer details in public content.
Decision rule
A missing invoice is first a data-integrity problem, not a collections prediction. Reconcile the source population, then update prioritization and timing. Finance teams can view the AR Pulse example to see how invoice-level traceability supports the review.