Finance & Business Maths
Invoice & Deposit Matcher
Enter a lump-sum bank deposit and paste your list of open invoices or receipts. The solver finds the exact subset of numbers that add up to the total.
Quick Scenarios & Presets
Currency Symbol
Bank Deposit / Target Total
£
Open Invoices / Receipts Paste from Excel or Sheets
Accepts numbers separated by new lines, commas, tabs, or with invoice names (e.g. INV-102: 468.50).
Matching Tolerance
Saved to history View history →
🧾
Enter your deposit and open invoices
Hit Find Matching Invoices to compute the exact combination of items.
✔ Exact Match Found
£1,428.50
3 invoices match this deposit total
Diff: 0.00
Matched Invoices in Deposit
Unmatched / Remaining Open Invoices
HOW TO USE
Reconciling Lump-Sum Bank Payments
Clients frequently pay multiple invoices at once without leaving an itemized remittance advice. Here is how to quickly reconcile them:
- Copy & Paste from Excel/Sheets: Highlight your column of invoice amounts or references in Excel and paste directly into the box.
- Adjusting for Card/Merchant Fees: If Stripe or PayPal took a transaction fee, select a tolerance of
±£1.00or±£5.00to find the matching invoices before fee deduction. - Audit Trail: Use the Copy Reconciliation Note button to paste the exact mathematical breakdown into your QuickBooks, Xero, or email remittance notes.