1. Open invoices
CSV export from your invoicing tool. Needs an invoice number, customer, amount and date column.
2. Bank transactions
CSV export from your bank. Needs a date, an amount (or credit) column and a description. Outgoing lines are ignored.
0payments matched
0amount applied
0payments unmatched
0invoices still open
Only ticked rows are exported. Import the file into your accounting tool or use it as a checklist.
Matches
Unmatched payments
Invoices still open
How it works
- Invoice numbers found in the bank description are matched first.
- Then exact amounts, preferring the customer named in the description.
- Then lump sums: it searches for the combination of that customer's open invoices that adds up to the payment.
- Partial payments are flagged and the invoice stays open for the remainder.
Every match shows a confidence and a reason. Untick anything you disagree with before exporting. Your files never leave your computer: there is no server, this page is plain JavaScript.