A customer payment dated before the related invoice is observed cash, but it is also a date-order exception. Do not forecast that amount again when the invoice later appears. Preserve the receipt, confirm the intended customer and obligation, link it to the invoice when the source supports that relationship, and investigate whether either transaction date is incorrect.

Why transaction order matters

Intuit explains that unapplied customer payments can remain in accounts receivable when they have not been linked to invoices, including cases where the corresponding invoice is missing. Its troubleshooting guidance separates the payment record from the outstanding transaction to which it should be applied.

A payment-before-invoice sequence can be legitimate, such as an advance received before billing, or it can reflect late invoice entry or an incorrect date. The forecast should not choose among those explanations without evidence. What is certain is narrower: the receipt happened once, and the later invoice should not create a second expected-cash amount for the same obligation.

Use the unapplied payments aging guide to identify the negative or unlinked row. If a bank deposit exists but the invoice link is missing, follow the deposit-to-invoice checklist.

Create a date-order exception

Record:

  • payment identifier, customer, amount, and recorded date;
  • bank or processor evidence and availability date;
  • invoice number, invoice date, due date, and open amount;
  • evidence that connects the receipt to the obligation;
  • whether either date was edited after entry;
  • the accounting owner and next reconciliation action; and
  • the forecast snapshot in which each row first appeared.

Then apply a simple control. Count the receipt in observed cash for the period when it occurred. Set expected future cash for the linked portion of the invoice to zero. Keep any unsupported residual invoice balance separate. If the payment cannot yet be linked, preserve both source rows and classify the relationship as unresolved rather than silently netting them.

The cash receipt cutoff guide helps assign the receipt to the correct observed period. It should not be used to move a receipt merely to match the invoice date.

Decision rule

Transaction order is evidence to review, not permission to duplicate cash. Preserve the original dates, verify the relationship, and bridge the two records into one supported settlement. Escalate date changes or missing source support to the bookkeeper or controller.

AR Pulse works from an authorized QuickBooks receivables export and highlights source-level exceptions before building a four-week collections range. It does not correct books or provide accounting advice. View the example report to see the separation between source evidence and forecast timing.