When a customer payment is returned, remove that receipt from observed cash, confirm whether the accounting system has reopened the invoice, and rebuild the invoice's forecast treatment from current evidence. A returned check or reversed payment is not a late receipt. It reverses a cash event that previously appeared complete and can restore an open receivable.

Intuit's returned-payment guidance explains that recording the returned payment and linking it back to the original transaction reopens the invoice. Intuit's payment-recording guidance shows why invoice and payment application need to remain connected. Those source-system steps belong to the business and its accountant; the forecast should reflect the resulting observed state without changing the books.

Correct the actuals boundary first

Preserve the date the original payment was recorded, the date it was returned, the amount, the affected invoice, and the report snapshot used by the prior forecast. If the prior forecast marked the payment as actual cash, reverse that actual in the comparison record rather than rewriting the old forecast.

Create a new dated snapshot after the accounting entry is reviewed. The new snapshot should show whether the invoice is open again and the amount currently outstanding. Keep the original export and prior assumption as evidence of what was known at each review date.

Rebuild the invoice assumption

Use four separate states:

  • **Returned, invoice reopened:** the balance is open again and needs a new expected week or an unconfirmed label.
  • **Returned, source not reconciled:** the bank event is observed but the invoice population has not been corrected; block the row from expected cash.
  • **Replacement payment pending:** an initiated or promised replacement is evidence, not cash.
  • **Replacement payment observed:** record cash only after the approved source shows the receipt and its invoice application.

Do not automatically reuse the original collection week. The failed payment method, a new promise, an internal correction, or missing evidence may materially change timing.

Keep fees outside the invoice assumption

A bank fee and any separate customer charge are not the same source row as the reopened invoice. Record them through the approved accounting workflow. In the forecast, preserve the reopened invoice's supported open amount and avoid adding an assumed fee to expected collections unless a separately issued open invoice appears in the authorized receivables source.

Add a returned-payment exception record

For each event, capture:

  1. invoice identifier and source-row reference;
  2. original payment and return dates;
  3. returned amount and current open balance;
  4. accounting reconciliation status;
  5. replacement-payment evidence, if any;
  6. internal owner, next action, and review date;
  7. current forecast week or unconfirmed status.

The cash-receipt cutoff guide helps separate prior actuals from later postings. The paid-invoice troubleshooting guide covers the opposite mismatch: a recorded payment that has not been applied to the intended invoice.

Decision rule

A returned payment changes both actual cash and invoice evidence. Treat the receipt as reversed, require a reconciled open balance, and assign new timing only from current support. Never net the returned amount against unrelated receipts or present a replacement attempt as certain cash.

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, change accounting records, contact customers, or promise a payment outcome. Finance owners can apply for AR Pulse after the reopened invoice population is reconciled.