How to reconcile customer payments to invoices

Choose the posted payment date range and confirm the bank accounts, processors, currencies, and workspaces in scope. Export open invoices as of a consistent point in time. Keep the source files unchanged and record when each export was created.

At minimum, invoice data needs a stable identifier, customer, original amount, current outstanding balance, invoice date, and currency. Payment data needs a source transaction ID where available, posted date, amount, payer or description, reference, and currency.

Check row counts, control totals, blank required fields, duplicate transaction IDs, duplicate invoices, date formats, and currency parsing. Preview mapped columns before importing. Do not silently drop rows that fail validation.

Normalize copies of names and references for comparison while retaining the original values. Currency values should use fixed decimal units, such as cents, rather than binary floating point equality.

Start with exact amount and currency, then add invoice references, payer similarity, customer identifiers, and a reasonable date window. A payment with an invoice number in the memo and an exact balance is stronger than an amount-only match.

Remove confirmed exact items from the active queue. This reduces the candidate pool for combined and partial cases and gives the reviewer a smaller set of meaningful exceptions.

For one payment covering several invoices, narrow candidates by customer and then search plausible combinations. For partial payments, store the applied and remaining balances. For fees and deductions, show the difference and require evidence before classification.

If multiple candidates remain plausible, leave the item in review. If no responsible candidate exists, keep the payment unmatched and state what information is missing.

Record who confirmed each application, when it happened, the source transaction, selected invoices, prior state, resulting state, and any note. Export confirmed applications separately from unmatched payments and discrepancies.

Finally, verify the exported result in the accounting system and complete any broader accounts receivable or bank reconciliation controls required by the business. Matching assistance does not replace accounting review.