A QuickBooks Open Item statement should not be the only source for an accounts receivable forecast. Intuit describes this statement type as listing open, unpaid invoices from the last 365 days as of a specified date. An older invoice can therefore remain economically open while falling outside that statement's display scope. Build the forecast population from a dated invoice-level aging or open-invoice export, then use the statement as customer-facing reconciliation evidence.

Statement scope is not receivable scope

QuickBooks supports Balance Forward, Open Item, and Transaction statements. Those formats answer different communication questions. A statement summarizes what a customer owes or what changed in a chosen period; an invoice records a specific amount owed for goods or services. Neither the statement date range nor the format changes the underlying obligation.

The practical risk appears when a finance owner treats a clean Open Item statement as proof that every open invoice was reviewed. If an invoice is more than 365 days old, it may be absent from that view. The forecast can then understate the reconciliation population even if the old item is too uncertain to receive an expected collection week.

Use the statement-versus-aging guide to choose the report that matches the decision. The Open Invoices versus A/R Aging Detail comparison explains the invoice-level fields needed for analysis.

Run a completeness control

At the forecast date, preserve:

  • the exact report name and as-of date;
  • customer, invoice number, invoice date, due date, and open amount;
  • the oldest invoice date in the export;
  • any statement start-date or format limitation;
  • the total open AR in the invoice-level source; and
  • an exception count for items absent from the statement.

Reconcile the invoice-level total to the accounting control before assigning cash timing. The QuickBooks aging report date checklist helps prevent a second error: comparing reports generated for different dates.

An old invoice that is absent from the statement should not automatically become forecast cash, bad debt, or zero. Keep it in the source population, label its evidence state, and decide separately whether it belongs in a four-week timing range. That preserves the distinction between completeness and collectability.

Decision rule

Use statements to communicate and reconcile customer activity; use a complete, dated invoice-level report to define the forecast population. If a statement has a date-window limit, record it explicitly and test older open items before relying on the view.

AR Pulse analyzes an authorized QuickBooks receivables export and turns invoice-level evidence into a ranked cash-action list and four-week collections view. It does not send statements, change books, or promise a collections outcome. View the example report to see how source rows and forecast assumptions remain separate.