Harbor Supply Co., September 2026: three vendor statements, matched
This page runs Statement Match on an invented distributor and three of its vendors. The statements are a real text PDF, an Excel file and a CSV, matched line by line against a sample AP export. The Excel and CSV files are read by the same code that reads yours. The PDF's AI read is precomputed for this page (the model's answer is stored, not fetched on each visit); the checks and clean-up that follow it are the same code as yours. Nothing here is a real company or a real number.
What went in
- midwest-fastener-statement.pdf · Midwest Fastener Supply: Text PDF statement
- lakeshore-packaging-statement.xlsx · Lakeshore Packaging: Excel statement
- ridgeway-industrial-statement.csv · Ridgeway Industrial Supply: CSV, with a credit memo and payments statement
- ap-open-items.csv · Open AP items, as exported from the ERP
- ap-payments-90-days.csv · Payments from the last 90 days
What came out
| Missing in AP | 1 | $918.75 |
| Credit not applied | 2 | $927.60 |
| Payment not posted by vendor | 1 | $2,207.70 |
| Amount mismatch | 1 | $180.00 |
| In AP, not on statement | 1 | $875.00 |
The exception list
In the product each line has a button to ask the vendor for a missing invoice and a field to mark it resolved with a note.
Missing in AP 1 · $918.75
| Vendor | Document | Date | Statement | Your AP | Amount |
|---|---|---|---|---|---|
| Midwest Fastener Supply | INV-49105 | Sep 22, 2026 | $918.75 | $918.75 |
Credit not applied 2 · $927.60
| Vendor | Document | Date | Statement | Your AP | Amount |
|---|---|---|---|---|---|
| Lakeshore Packaging | CM-7710 | Sep 18, 2026 | -$415.00 | $415.00 | |
| Ridgeway Industrial Supply | CM 3302 | Sep 17, 2026 | -$512.60 | $512.60 |
Payment not posted by vendor 1 · $2,207.70
| Vendor | Document | Date | Statement | Your AP | Amount |
|---|---|---|---|---|---|
| Ridgeway Industrial Supply | 20518 | Sep 14, 2026 | $2,207.70 | $2,207.70 |
Amount mismatch 1 · $180.00
| Vendor | Document | Date | Statement | Your AP | Difference |
|---|---|---|---|---|---|
| Midwest Fastener Supply | INV-49017 | Sep 9, 2026 | $2,310.00 | $2,130.00 | $180.00 |
In AP, not on statement 1 · $875.00
| Vendor | Document | Date | Statement | Your AP | Amount |
|---|---|---|---|---|---|
| Midwest Fastener Supply | 49120 | Sep 29, 2026 | $875.00 | $875.00 |
The review screens
Every statement is reviewed before its lines count: the file beside the lines read from it. Here each line also shows how it matched.
Midwest Fastener Supply
Closing balance printed: $5,155.35 · lines add up to it ✓
The statement
Bank and remittance lines removed from the stored text: 3.
Lines read, matched to AP
| Document | Date | Type | Amount | Balance | Result |
|---|---|---|---|---|---|
| INV-48811 | Aug 14, 2026 | Invoice | $1,284.50 | Matched | |
| INV-48902 | Aug 28, 2026 | Invoice | $642.10 | Matched | |
| INV-49017 | Sep 9, 2026 | Invoice | $2,310.00 | Amount mismatch | |
| INV-49105 | Sep 22, 2026 | Invoice | $918.75 | Missing in AP | |
| Lines total | $5,155.35 | ||||
Lakeshore Packaging
Closing balance printed: $7,696.00 · lines add up to it ✓
The statement
| Date | Invoice # | Type | Amount | Balance |
|---|---|---|---|---|
| 08/05/2026 | 300217 | Invoice | 4105.2 | 4105.2 |
| 08/19/2026 | 300388 | Invoice | 1760 | 5865.2 |
| 09/12/2026 | 300512 | Invoice | 2245.8 | 8111 |
| 09/18/2026 | CM-7710 | Credit Memo | -415 | 7696 |
| Total Due | 7696 |
Lines read, matched to AP
| Document | Date | Type | Amount | Balance | Result |
|---|---|---|---|---|---|
| 300217 | Aug 5, 2026 | Invoice | $4,105.20 | $4,105.20 | Matched |
| 300388 | Aug 19, 2026 | Invoice | $1,760.00 | $5,865.20 | Matched |
| 300512 | Sep 12, 2026 | Invoice | $2,245.80 | $8,111.00 | Matched |
| CM-7710 | Sep 18, 2026 | Credit | -$415.00 | $7,696.00 | Credit not applied |
| Lines total | $7,696.00 | ||||
Ridgeway Industrial Supply
Closing balance printed: $5,217.05 · lines add up to it ✓
The statement
| Date | Reference | Description | Charges | Credits | Balance |
|---|---|---|---|---|---|
| 09/01/2026 | Balance forward | 3,150.00 | 3,150.00 | ||
| 09/04/2026 | PMT 77120 | Payment received - thank you | 3,150.00 | 0.00 | |
| 09/10/2026 | 55021 | Invoice | 1,980.40 | 1,980.40 | |
| 09/15/2026 | 55107 | Invoice | 2,604.00 | 4,584.40 | |
| 09/17/2026 | CM 3302 | Credit memo - returned goods | 512.60 | 4,071.80 | |
| 09/24/2026 | 55190 | Invoice | 1,145.25 | 5,217.05 | |
| Amount Due | 5,217.05 |
Lines read, matched to AP
| Document | Date | Type | Amount | Balance | Result |
|---|---|---|---|---|---|
| Sep 1, 2026 | Other | $3,150.00 | $3,150.00 | Not matched (informational) | |
| PMT 77120 | Sep 4, 2026 | Payment | -$3,150.00 | $0.00 | Matched |
| 55021 | Sep 10, 2026 | Invoice | $1,980.40 | $1,980.40 | Matched |
| 55107 | Sep 15, 2026 | Invoice | $2,604.00 | $4,584.40 | Matched |
| CM 3302 | Sep 17, 2026 | Credit | -$512.60 | $4,071.80 | Credit not applied |
| 55190 | Sep 24, 2026 | Invoice | $1,145.25 | $5,217.05 | Matched |
| Lines total | $5,217.05 | ||||
Run it on your own vendors
$99 a month for up to 150 vendors. Upload a vendor list and this month's AP export, and Statement Match starts collecting statements.
Get startedStatement Match is run by PhoneScreen AI LLC. See the sample · Privacy and data · Terms · statement-match@coinudge.com