Remit MatchExample data A fictional supplier, Midwest Fastener Supply, and one customer's remittance.
One remittance, 12 lines, matched
Lakeshore Hardware, Inc. paid $21,701.70 against a stack of invoices and sent this remittance advice. Remit Match read its lines and matched each one to Midwest Fastener Supply's open invoices: by invoice number first, then PO number, then the amount. This is the real matcher on example data.
The remittance
Lakeshore Hardware, Inc.
Example dataRemittance advice · ACH 0048213 · 2026-10-09 · Pay to Midwest Fastener Supply
| Invoice | PO | Gross | Deduct | Paid |
|---|---|---|---|---|
| INV-10412 | 7781 | $1,248.00 | $1,248.00 | |
| 10415 | 7783 | $3,612.50 | $3,612.50 | |
| INV 10418 | 7784 | $912.00 | $46.80 | $865.20 |
| INV-10421 | 7786 | $2,104.00 | $2,104.00 | |
| 10422 | 7786 | $455.00 | $455.00 | |
| INV-10412 | 7781 | $1,248.00 | $1,248.00 | |
| PO 7790 | $1,730.40 | $1,730.40 | ||
| Pmt ref 88213 | $642.75 | $642.75 | ||
| INV-10431 | 7795 | $5,980.00 | $5,980.00 | |
| INV-99817 | $318.60 | $318.60 | ||
| INV-10433 | 7795 | $1,120.00 | $1,120.00 | |
| INV-10436 | 7799 | $2,377.25 | $2,377.25 | |
| Total payment | $21,701.70 | |||
[bank details removed]
In the app, a PDF like this is read for you; a spreadsheet is read by its columns. You check the lines beside the file before anything is matched.
The matches
| # | Remittance says | Paid | Open invoice | Open | Off by | Flag |
|---|---|---|---|---|---|---|
| 1 | INV-10412 PO 7781 | $1,248.00 | 10412 Lakeshore Hardware Inc · by invoice number | $1,248.00 | Matched | |
| 2 | 10415 PO 7783 | $3,612.50 | 10415 Lakeshore Hardware Inc · by invoice number | $3,612.50 | Matched | |
| 3 | INV 10418 PO 7784 | $865.20 deducted $46.80 | 10418 Lakeshore Hardware Inc · by invoice number | $912.00 | -$46.80 | Short pay |
| 4 | INV-10421 PO 7786 | $2,104.00 | 10421 Lakeshore Hardware Inc · by invoice number | $2,104.00 | Matched | |
| 5 | 10422 PO 7786 | $455.00 | 10422 Lakeshore Hardware Inc · by invoice number | $445.00 | +$10.00 | Overpay |
| 6 | INV-10412 PO 7781 | $1,248.00 | 10412 Lakeshore Hardware Inc · by invoice number | $1,248.00 | Duplicate | |
| 7 | no invoice no. PO PO 7790 | $1,730.40 | 10426 Lakeshore Hardware Inc · by PO number | $1,730.40 | Matched | |
| 8 | Pmt ref 88213 | $642.75 | 10429 Lakeshore Hardware Inc · by amount, one open invoice | $642.75 | Matched | |
| 9 | INV-10431 PO 7795 | $5,980.00 | 10431 Lakeshore Hardware Inc · by invoice number | $5,980.00 | Matched | |
| 10 | INV-99817 | $318.60 | no open invoice | Not found | ||
| 11 | INV-10433 PO 7795 | $1,120.00 | 10433 Lakeshore Hardware Inc · by invoice number | $1,120.00 | Matched | |
| 12 | INV-10436 PO 7799 | $2,377.25 | 10436 Lakeshore Hardware Inc · by invoice number | $2,377.25 | Matched |
Run it yourself
Download the sample's two files and upload them on the free run, or bring your own remittance spreadsheet and open-invoice export.