Invoice Payment Reconciliation - Match Invoices with Bank Payments
Compare invoice spreadsheets with bank payments. Track paid, unpaid and partially paid invoices from CSV/XLSX exports.
Try with sample files | View sample report
Problem statement
Invoice payment reconciliation gets difficult when customers pay in parts, several invoices are settled in one transfer, or the bank reference does not clearly match the invoice number.
Numeric example
| Line item | Amount |
|---|
| Invoices expected | $1,420.00 |
| Bank transfer received | $1,380.00 |
| Open amount difference | -$40.00 |
| Invoices still unpaid | $120.00 |
Why the numbers do not match
- Customers pay one invoice in several transfers.
- One bank payment can cover several invoices.
- References may be missing, truncated, or typoed in the bank description.
- Duplicate transfers and timing gaps can create false paid status.
What files to export
- Invoice export with invoice number, customer, date, due date, total, and open balance.
- Bank statement export with payment date, amount, description, and reference.
- Optional customer ledger or aged receivables report for existing paid and open status.
Manual workflow
- Normalize invoice numbers and bank references.
- Match exact references first.
- Group partial payments by customer and invoice number.
- Compare cumulative paid amount to the invoice total.
- Keep overpayments, underpayments, and ambiguous deposits in review.
Common mistakes
- Marking a partial payment as fully paid.
- Treating one payment for several invoices as a one-to-one match.
- Counting a duplicate transfer twice.
- Ignoring customer name evidence when the invoice number is missing.
How Reconcile Locally helps
- Keeps unpaid invoices, possible grouped payments, amount differences, and unknown bank payments visible together.
- Preserves invoice references and bank descriptions for review before export.
- Exports a clear matched and unresolved report for follow-up or accounting handoff.
What still needs manual review
- Partial or multi-invoice payments still need a reviewer decision before final acceptance.
- Amount-only or customer-name-only matches should stay open until another export confirms them.
- Duplicate transfers need explicit handling instead of being blended into paid status.
Content review and sources
Written and reviewed by the Reconcile Locally product team. Last reviewed June 7, 2026.
Guidance is checked against current product behavior and first-party documentation where available. Reconciliation results still require human review.
Frequently asked questions
How should I handle one payment for several invoices?
Group candidate invoices by customer and reference, then allocate the bank amount across the invoices before marking them paid.
What if the bank reference is missing?
Use amount, customer name, date proximity, and open balance as fallback checks, then keep the row in review until confirmed.