Find the open invoices of that customer whose amounts add up to the payment, after any early-payment discount their terms allow and any bank charge you are willing to absorb, and apply the payment to each of them. If the remittance names the invoices, start there. If two combinations add up, apply to the oldest and confirm with the customer. The numbers below are a made-up example; the same file ships with the tool so you can run it.
| Invoice | Customer | Date | Terms | Open |
|---|---|---|---|---|
| INV-1006 | Harbor Freight Logistics Inc | 2026-10-05 | Net 45 | 3,400.00 |
| INV-1007 | Harbor Freight Logistics Inc | 2026-10-19 | Net 45 | 1,775.25 |
| INV-1004 | Bluebird Bakery Co. | 2026-10-28 | 2/10 Net 30 | 1,000.00 |
| INV-1003 | Northwind Traders LLC | 2026-10-15 | Net 30 | 2,115.40 |
Bank line: 2026-11-04 WIRE IN HARBOR FREIGHT LOGIST 5,160.25. No invoice numbers. The payer name is truncated but is plainly Harbor Freight Logistics.
Their open invoices total 3,400.00 + 1,775.25 = 5,175.25. The wire is 5,175.25 − 5,160.25 = 15.00 short, the size of an incoming-wire fee. Apply 3,400.00 to INV-1006 and 1,760.25 to INV-1007, and write off 15.00 as a bank charge on INV-1007, if your policy absorbs fees that small. Both invoices close.
Bank line: 2026-11-03 ACH CREDIT BLUEBIRD BAKERY 980.00. The only Bluebird invoice is 1,000.00 on 2/10 net 30: 2% off if paid within 10 days of the invoice date. 2% of 1,000.00 is 20.00, so 980.00 settles it in full if the payment is within the window. The invoice is dated 28 October and the money arrived on 3 November, 6 days later. Apply 980.00 and record a 20.00 discount allowed.
Had it arrived on 22 November (25 days after), the discount was not earned. The payment is then short by exactly the discount, which is not a bank fee: apply 980.00, leave 20.00 open, and decide whether to allow the late discount or ask for it.
Bank line: 2026-11-05 ONLINE TRANSFER INV 1003 NORTHWIND TRADERS 1,900.00. INV-1003 is 2,115.40. The payment is 215.40 short, 10.2%: too much for a fee, no discount in the terms. Apply 1,900.00 to INV-1003, leave 215.40 open, and ask the customer: a dispute, a deduction (damaged goods, a pricing difference) or a mistake.
A dental practice on a monthly 395.00 retainer has three open 395.00 invoices and sends 395.00. Any one of them fits. The usual rule is first in, first out: apply to the oldest, so the aging report shows the newest invoices as the open ones, and note that the choice was yours, not the customer's.
The Cash Application Matcher runs these steps on every line of a bank export against an open-invoice export, in your browser, and gives each proposal a confidence (High, Medium, Review or Unmatched) and the sentence above. It searches combinations of up to 40 open invoices per customer, so "which three of these twenty invoices add up to 7,412.18" takes a moment rather than an afternoon. You still post the result.