How to use the Cash Application Matcher
- Paste payments as date, reference, amount.
- Paste open invoices as invoice no, customer, amount, and set an amount tolerance if needed.
- Review the matches, then export the results as CSV.
How it works
For each payment the tool first looks for an invoice number inside the reference. If none, it looks for a single invoice with the same amount, and finally for 2 or 3 invoices that add up to the payment. Short payments, overpayments and ambiguous cases are flagged for review.
Worked example
A payment of 12,500 with reference "NEFT INV-1001" matches invoice INV-1001 exactly. A payment of 6,900 referencing 1003 and 1004 matches the two invoices 4,700 + 2,200.
Limits and good to know
These are suggestions based on rules, not a posting. Always review ambiguous and combined matches, and check customers before applying cash.
Frequently asked questions
No. Everything is calculated in your browser.
Yes. It is free with no sign-up.
No. Your data is processed in your browser and is not sent to a server.