Finance controls

How to reconcile credit notes with invoices and payments

A credit note reduces a charge only when the correct document and amount are reflected in the reconciliation. Trace the credit from its reason and original invoice through posting, allocation and settlement, without losing the history of the transaction.

Separate the document from its application

Receiving a supplier credit note, posting it and applying it to an invoice are separate events. A PDF in an email inbox does not show that the accounting system has recorded the credit. A posted credit balance does not show which invoice it has reduced. Keep the document and its application record together.

Microsoft's settlement guidance describes applying one transaction to another to change their balances, including applying a credit memo to an invoice. It also distinguishes posting from later settlement. Those are useful checkpoints when tracing a supplier credit through an accounting system. See Settlement overview.

Start with the supplier, legal entity, currency, original invoice reference and reason for the credit. A return, a price correction and a service-level credit need different supporting evidence. Retain the relevant return record, agreement or calculation rather than treating the presence of a credit number as a complete explanation.

Reconcile a fictional partial payment and credit

In this fictional example, Ridgeway Distribution receives a $7,500 invoice from Delta Safety Equipment. The supplier later issues credit note CN-184 for $900 of returned goods. A $6,000 payment has settled against the invoice. All documents are in USD, and the example excludes tax, discounts and exchange differences.

ComponentAmountEvidence needed
Original invoice$7,500Supplier invoice and posted transaction.
Credit applied−$900Credit note, supported return and application record.
Payment applied−$6,000Settled payment and invoice allocation.
Remaining balance$600Reconciliation to the supplier account and open-item record.

The calculation is $7,500 less $900 less $6,000. If the system still shows $1,500 outstanding, inspect whether the credit was posted but left unapplied, allocated to another invoice or omitted entirely. Each cause requires a different correction. Do not simply overwrite the balance with $600 and discard the explanation.

If the full $7,500 had already settled before the credit, the review would instead need to trace the resulting $900 supplier credit balance. Establish whether it will be refunded or applied to another eligible obligation under the agreed process. A supplier promise to refund is not a bank receipt.

Control allocations when documents have several relationships

A single credit can relate to several invoices. Preserve an allocation schedule with each destination and amount. A $900 credit allocated as $400 and $500 has no remaining unallocated amount. Applying the same $900 again to another invoice would consume the credit twice.

Payments can also cover several invoices. Obtain their allocations rather than subtracting the whole payment from every referenced invoice. Reconcile at both document and supplier-account level: a correct total supplier balance can hide an allocation to the wrong invoice, with consequences for aging and later payment selection.

Keep signs consistent in the reconciliation. State whether credits are stored as negative amounts or as positive amounts in a separate credit column. Preserve source values and document any conversion. Mixing conventions can make an adjustment increase the balance it was intended to reduce.

Distinguish a credit from a canceled-and-reissued invoice

A supplier may replace an incorrect invoice with a new document. Identify how the original was canceled or credited and whether the replacement is a new payable record. Link all related documents so the original and replacement are not both selected for payment.

Inspect repeated credit references as well. An emailed copy and a portal download may be two copies of one credit, not two adjustments. Compare the source documents and posting history before totaling the benefit. Preserve the comparison population across requests; our invoice and payment experiment shows what can change when related records are split.

Where currencies or tax amounts differ, keep the difference explicit and involve the responsible accounting reviewer. Record the applicable treatment and adjustment entries instead of forcing a match through an unexplained net figure. This workflow does not determine jurisdiction-specific tax treatment.

Close the reconciliation with a disposition

Useful outcomes include credit posted and applied, credit awaiting supplier confirmation, misallocation corrected, refund awaiting settlement and unresolved supporting evidence. Name the owner and next action. Include the posting, allocation or refund reference that will allow another reviewer to verify completion.

Recheck open items after correction and retain the before-and-after reports. If the issue arose because credits were missing from an export, investigate the extraction scope. Correcting one spreadsheet row will not address the same omission in the next payment review.

Keep the current product boundary explicit

OpenAuditor's financial pack does not currently provide a dedicated credit-note record or a general credit-allocation ledger. Its payment balance check uses supplied invoices and earlier payments; it does not automatically subtract supplier credit notes. Do not describe that check as completing the reconciliation above.

The contract-compliance pack separately supports an invoice's supplied credits-applied amount and defined service-level credit checks. That amount does not establish the authenticity, posting or settlement of a separate credit document. See contract invoice review for that narrower workflow.

Maintain the allocation schedule and source documents in your accounting review process. Use supported verification results for the conditions they actually test, with the wider disposition recorded in the audit trail. When documents agree, still examine whether they inherited the same unverified fact.