When a QuickBooks accounts receivable aging report does not match the accounts receivable balance, stop the cash forecast and reconcile the report population first. The difference often comes from report settings, customer or job assignments, links between transactions, or payments that have not been applied to the same invoice population. A forecast built on an unexplained difference can rank the wrong invoices or count balances that are not truly open.
Intuit's reconciliation guidance identifies report settings, rebuilt names, damaged links, transactions without a Customer:Job name, and differences between open-invoice and customer-balance reports as possible causes. J.P. Morgan's cash-application guide separately explains that payment matching and reconciliation can be delayed when funds and remittance details arrive separately. Together, those sources support a practical rule: reconcile scope and application before interpreting timing.
Start with a same-snapshot comparison
Run the accounts receivable control balance and the detailed open-invoice report for the same report date, entity, accounting basis, currency, and accounts receivable account. Preserve those settings beside the exported file. A total is not comparable merely because both reports were opened on the same day.
Record three controls before investigating individual rows:
- control-balance total;
- detailed open-invoice total;
- unexplained difference between the two.
Do not silently plug the difference into a forecast. Keep it as a separate reconciliation exception with an owner and review date.
Diagnose the difference in a fixed order
- **Align report settings.** Confirm report date, aging option, basis, filters, customer population, and AR account.
- **Find rows without a usable customer reference.** A transaction can affect the control account without appearing in the expected customer view.
- **Review renamed or rebuilt customer and job records.** Split identifiers can divide what management assumes is one balance.
- **Trace invoice-payment links.** A receipt may exist while the intended invoice remains open because the transactions are not applied to the same customer, job, or AR account.
- **Compare open-invoice and customer-balance views.** Isolate the exact rows that enter one report but not the other.
- **Escalate source-system issues.** If links or data appear damaged, preserve the evidence and use the accounting-system support process. Do not repair books inside a forecasting worksheet.
Separate reconciliation from forecasting
The reconciled export supplies source facts: customer, invoice number, invoice date, due date, open balance, and report date. The forecast adds review fields such as evidence status, expected collection week, internal owner, next action, and review date. Those layers should remain separate.
If a material difference remains unresolved, label the affected population blocked or unconfirmed. Do not distribute the control difference across invoices, net it against expected receipts, or infer which customer owns it. The QuickBooks export checklist explains the minimum invoice-level fields, while the report-date checklist keeps the snapshot boundary explicit.
A compact reconciliation record
For each run, retain the report names, saved settings, control total, detail total, difference, investigated rows, preparer, reviewer, and resolution status. When a source correction is made, generate a new dated export instead of overwriting the original evidence.
AR Pulse analyzes an authorized QuickBooks receivables export to create a ranked cash-action list and a four-week collections forecast. It does not request QuickBooks credentials or change accounting records. Finance owners with a reconciled export can view the example report.