When QuickBooks closes an invoice by automatically applying an existing customer credit, record zero new cash for that closure. The invoice balance may be settled in accounts receivable, but the settlement event is a credit application rather than a customer receipt. Reconcile the credit to the invoice, remove the resolved open amount from future collections, and preserve the reason the status changed.

A paid status does not identify the settlement source

Intuit explains that QuickBooks can automatically apply customer credits to the oldest unpaid invoices when the setting is enabled. If a credit equals or exceeds the remaining balance, the invoice can close; excess credit can continue to the next oldest invoice. Intuit also directs users to the Audit Log and the linked transaction when an invoice status changes unexpectedly.

That behavior creates a forecasting trap. A status-only process can interpret every newly closed invoice as cash received. If the close came from a credit memo or overpayment already recorded earlier, counting the invoice as a current receipt would duplicate value.

Use the credit-memo pre-forecast check to confirm whether a posted credit is applied or still open. The zero-net balance reconciliation covers the related case where open positive and negative rows still offset at the customer level.

Build a settlement bridge

For every invoice that changed from open to paid, preserve:

  • prior open amount and prior status;
  • current status and the timestamp of the change;
  • linked payment, credit memo, or other settlement transaction;
  • actual cash amount and cash date, if any;
  • credit applied during the period;
  • remaining customer credit after application; and
  • the owner who reviewed an unexpected application.

The bridge should satisfy this control:

`prior open amount - new cash - applied credits - other posted adjustments = current open amount`

Do not invent a cash line merely to make the equation balance. If the linked source is unclear, keep the status change in the exception queue until the source transaction is identified. The forecast variance review can then classify the result as cash collected, credit applied, timing moved, or unresolved.

Decision rule

Remove a credit-settled invoice from future expected collections, but do not report the credited amount as new cash. The supporting record should show which credit was applied and whether any actual receipt occurred in the same period.

AR Pulse analyzes an authorized QuickBooks receivables export and separates source facts from collection assumptions. It does not change credit settings or accounting records. View the example report to see the evidence-first format.