What a finished audit looks like
One supplier, one month, six representative lines. These are illustrative figures, not a real customer’s invoices — but the columns, the reasons and the unmatched explanations are exactly what you get from your own files.
Overcharged this batch
$3,888.00
Billed under contract
$52.80
Lines needing a decision
2
| SKU | Description | Qty | Invoiced | Contract | Gap | Status |
|---|---|---|---|---|---|---|
| TPO-060-10 | TPO membrane, 60 mil, 10′ x 100′ rollBilled above the contract price in effect on 12 Jun. | 24 ROLL | $1,284.00 | $1,195.00 | $2,136.00 | Overcharged |
| ISO-2.6-4X8 | Polyiso insulation board 2.6″, 4x8Priced from an expired list; current list started 1 Jun. | 480 EA | $41.90 | $38.25 | $1,752.00 | Overcharged |
| FAS-3IN-BOX | Roofing fasteners 3″, box of 1000Unit of measure normalized: invoice priced per each, contract per box. | 40 BOX | $0.09 | $89.00 | -$3,556.44 | At contract |
| SEAL-10OZ | Pourable sealer, 10 oz tubeBilled below contract — flagged so a later true-up is not a surprise. | 96 EA | $7.40 | $7.95 | -$52.80 | Under contract |
| TPO-CVR-STRP | TPO cover strip, 6″ x 100′No contract line for this SKU. Closest family match: TPO-CVR-6X100 at $141.00. | 18 ROLL | $148.00 | — | — | Unmatched |
| DELIVERY | Jobsite delivery surchargeNon-catalog charge — not covered by the price agreement. | 1 EA | $175.00 | — | — | Unmatched |
It says why, not just what
An unmatched line names its reason — no contract line, expired list, non-catalog charge — and suggests the closest product-family candidate.
Units are reconciled first
Per-each versus per-box, bundles, pack quantities. Most false overcharges are unit mismatches, so they are normalized before anything is flagged.
Gaps become claims
Each overcharge can be turned into a supplier-ready claim with an owner and a status, tracked until the credit actually lands.
Run this against your own invoices
Your first 500 invoice lines are free, no card required. Bring a price list and a month of invoices in CSV, Excel or PDF.