How to reconcile orders, invoices and payments

01

Build a transaction trail

Choose a closed period and a manageable group of orders. Gather the agreements and fulfillment records. Add invoices, payment records and any credits. Match them using order and invoice identifiers; document any manual matches and ask the relevant teams to explain missing or ambiguous records.

Include timing in the review. A completed order may be invoiced after the selected period, and a payment may be received before it is applied to an invoice. Separate these timing differences from possible errors.

02

Compare the stages without counting twice

For each completed order, compare the amount billable under the agreement with the net invoice after valid credits. Then compare the net invoice with payments applied and its open balance. Investigate each difference rather than assuming it is lost revenue.

Hypothetical example: an order supports $4,000 of charges. The invoice is $3,800 with no valid adjustment, so $200 needs investigation. The customer paid $3,000 against that invoice, leaving $800 outstanding. The $200 possible billing discrepancy and $800 open invoice balance are different amounts. The open balance might be current, disputed or overdue; its status needs checking.

03

Resolve and prevent repeat exceptions

Record the evidence, owner, amount, reason and next review date for each exception. Check the agreement and supporting records before an authorized person changes an invoice or contacts a customer. Keep the original records and link related exceptions.

Review recurring causes with the teams responsible for each handoff. For example, a regular comparison of completed work with invoices can reveal work that has not reached billing. Track confirmed corrections and payments separately from amounts still under investigation.

04

Handle difficult matches

A single payment may cover several invoices, or one invoice may be settled in installments. Use the remittance information to allocate each payment and leave unexplained amounts in an exception queue until an authorized person resolves them. Check payment dates against the bank record and the accounting period before changing the ledger.

For a recurring review, count completed orders with a documented invoice match and record the total sampled. Also track the number and age of unresolved differences. A high match rate can hide a few large exceptions, so review their values as well. Do not equate an unmatched record with a confirmed loss.

05

Make the review repeatable

Keep one exception record per difference with order ID, invoice ID, amounts, reason and evidence. Match a partial delivery to its authorized billing schedule rather than expecting the full order value immediately. When a difference is corrected, record the adjustment or payment date and link it back to the original exception so the same amount is not reported twice.