Before using month-end accounts receivable in a cash forecast, lock the report date and scope, reconcile the control balance to invoice detail, separate later receipts, and assign every material exception an owner. The goal is a dated decision input, not a report that changes while it is being reviewed.

1. Lock the source definition

Record the company entity, accounting basis, report date and time, aging method, included customer population, currency treatment, and export filename or source reference. Preserve the original authorized export. If a corrected file arrives later, version it rather than replacing the first snapshot.

The QuickBooks AR aging report-date guide explains why the same report can change when its date or method changes.

2. Reconcile totals before prioritizing

QuickBooks documents that Accounts Receivable on the balance sheet and AR reports can differ for reasons such as report settings or transaction details. Compare the control total with the invoice-level detail under the same date and basis. Record any unresolved difference as an exception; do not force the forecast to balance by inserting an unsupported plug.

Use the Open Invoices versus AR Aging Detail comparison to check that the selected report supports the decision and includes the invoice fields the review needs.

3. Apply the cash-receipt cutoff

Choose the observation cutoff for actual cash. Payments and deposits posted after the export can make an invoice appear open in the snapshot even when later evidence exists. Preserve both facts: it was open at month end, and a later receipt resolved or reduced it.

The cash-receipt cutoff checklist provides a bridge from the locked snapshot to subsequent cash without rewriting history.

4. Review exception evidence

For material invoices, check:

  • delivery or buyer-portal status;
  • dispute, credit, or corrected-document status;
  • dated payment commitment and amount;
  • partial payments and residual balance;
  • customer concentration;
  • duplicate invoices or customer identities;
  • missing owner, next action, or review date; and
  • evidence age relative to the current decision.

Do not assign a cash week from the aging bucket alone. Separate invoice date, due date, expected collection date, and observed receipt date.

5. Create the management handoff

Produce two outputs from the same source rows: a ranked exception queue and a four-week collection view. Each material line should retain invoice ID, customer, open amount, evidence, confidence label, owner, action, and review date. Subtotals must reconcile to included invoice rows.

Keep approval of accounting changes, customer communication, and collection actions with the authorized business owner. AR Pulse does not change books or contact customers.

Sign-off rule

A month-end AR snapshot is ready for forecasting when its scope is explicit, totals are reconciled or exceptions are documented, later cash is bridged, and material assumptions are traceable to invoice rows. Controllers can apply for AR Pulse for a ranked action list and four-week range built from an authorized QuickBooks export.