When a customer has open invoice and credit rows that net to zero, do not carry either side into expected collections. First confirm that the transactions belong together and apply the credit to the invoice in QuickBooks. Until that settlement is recorded, keep the rows visible as a reconciliation exception rather than hiding them at the customer-total level.

Why a zero customer total can still require work

An accounts receivable summary can make a customer look resolved because positive and negative transactions offset. The detail can still contain an open invoice and an unapplied credit. Intuit's guidance for clearing zero-net customers instructs users to select the open invoice and the available credit in Receive Payment, then save the settlement. That step matters because the visible net amount and the transaction status answer different questions.

For a cash forecast, the control is straightforward:

`expected cash from offsetting rows = 0`

That does not mean the records should disappear before reconciliation. The invoice could still appear overdue, the credit could remain unapplied, and an automated action queue could incorrectly prioritize the positive row if it ignores the offset.

Reconcile before classifying

Review the customer-level detail and record:

  • invoice number, invoice date, due date, and open amount;
  • credit memo or credit transaction identifier and amount;
  • whether both records belong to the same customer and obligation;
  • whether the credit is available, already applied elsewhere, or disputed;
  • the dated QuickBooks report used for the review; and
  • the owner and next action when the offset cannot be completed.

Use the credit-memo pre-forecast check when the negative row's status is unclear. The negative customer balance guide covers the different case where credits or overpayments exceed invoices rather than netting exactly to zero.

Preserve invoice-level traceability

Intuit distinguishes the A/R Aging Summary, which shows customer totals, from the A/R Aging Detail, which lists individual transactions. Use the detail view to identify the offsetting rows. Do not delete or combine source rows in a working forecast just to make the customer disappear. Instead, assign a reconciliation status such as `credit available`, `matched pending posting`, `settled`, or `needs review`.

After the settlement posts, refresh the dated export and confirm that neither row remains in the open forecast population. If the customer still appears, investigate the new source state rather than manually forcing a zero in the forecast file. The AR-to-balance-sheet reconciliation guide helps when the detail total and control account do not agree.

Decision rule

Exclude offsetting invoice and credit rows from expected cash, but keep them in the exception queue until QuickBooks shows a completed settlement. AR Pulse works from an authorized receivables export and preserves invoice-level evidence so a zero customer total cannot hide an unresolved posting step. View the example report to see how source facts and internal actions stay separate.