Example data A fictional supplier, Ridgeline Asphalt & Aggregate, and its customer Cole Brothers Paving.
One supplier invoice, 15 lines, 14 tickets, checked
Ridgeline Asphalt & Aggregate billed $21,137.39 for September's asphalt and stone, with the scale tickets attached. Ticket Match matched every line to its ticket and every ticket to Cole Brothers Paving's PO and job list, and lists what is missing, billed twice or billed wrong. This is the real matcher on example data.
The exception sheet
| Flag | Ticket | Line | What is wrong | At risk |
|---|---|---|---|---|
| Duplicate | 104511 | 6 | Ticket 104511 is billed twice (also line 5). | $1,703.52 |
| Billed, no ticket | 104540 | 15 | No ticket 104540 came with the invoice. | $1,766.25 |
| Quantity differs | RA-104512 | 7 | Billed 25.30 t; the ticket's net is 24.30 t. | +$72.00 |
| Rate differs | RA-104521 | 9 | Billed at $26.25; PO 4480 says $24.75. | +$26.93 |
| Arithmetic | 104533 | 13 | 23.12 x $78.50 is $1,814.92; the line says $1,824.92. | +$10.00 |
| Over PO quantity | RA-104522 | 10 | PO 4480 is for 50.00 t; with this ticket 54.59 t has been delivered. | $113.60 |
| No PO or job | RA-104530 | 11 | Job 2699 (Crusher Run) is not on your PO list. | $388.24 |
| Ticket not billed | RA-104532 | Ticket RA-104532 came with the invoice but no line bills it. Worth about $1,786.66 at the PO rate. | ||
| At risk if paid as billed | $4,080.54 | |||
Some of the tickets
Ridgeline Asphalt & Aggregate · Scale ticket
Ridgeline Asphalt & Aggregate · Scale ticket
Ridgeline Asphalt & Aggregate · Scale ticket
The PO and job list
| PO | Job | Material | Rate | PO qty |
|---|---|---|---|---|
| 4471 | 2614 Route 9 overlay | HMA Surface 9.5mm | $78.50 | 1,200.00 t |
| 4472 | 2614 Route 9 overlay | HMA Base 19mm | $72.00 | 1,500.00 t |
| 4480 | 2631 Elm St lot | #57 Stone | $24.75 | 50.00 t |
| 4485 | 2638 Fairview Rd widening | Crusher Run | $18.40 | 400.00 t |
The invoice
Ridgeline Asphalt & Aggregate
Example dataInvoice 58217 · September 2026 · Bill to Cole Brothers Paving
| Ticket | Date | Product | Tons | Price | Extended |
|---|---|---|---|---|---|
| 104501 | 09/02 | HMA Surface 9.5mm | 22.41 | $78.50 | $1,759.19 |
| 104502 | 09/02 | HMA Surface 9.5mm | 21.87 | $78.50 | $1,716.80 |
| 104503 | 09/02 | HMA Surface 9.5mm | 23.05 | $78.50 | $1,809.43 |
| 104510 | 09/03 | HMA Base 19mm | 24.12 | $72.00 | $1,736.64 |
| 104511 | 09/03 | HMA Base 19mm | 23.66 | $72.00 | $1,703.52 |
| 104511 | 09/03 | HMA Base 19mm | 23.66 | $72.00 | $1,703.52 |
| 104512 | 09/03 | HMA Base 19mm | 25.30 | $72.00 | $1,821.60 |
| 104520 | 09/08 | #57 Stone | 18.20 | $24.75 | $450.45 |
| 104521 | 09/08 | #57 Stone | 17.95 | $26.25 | $471.19 |
| 104522 | 09/08 | #57 Stone | 18.44 | $24.75 | $456.39 |
| 104530 | 09/10 | Crusher Run | 21.10 | $18.40 | $388.24 |
| 104531 | 09/11 | HMA Surface 9.5mm | 22.90 | $78.50 | $1,797.65 |
| 104533 | 09/11 | HMA Surface 9.5mm | 23.12 | $78.50 | $1,824.92 |
| 104534 | 09/12 | HMA Base 19mm | 24.05 | $72.00 | $1,731.60 |
| 104540 | 09/12 | HMA Surface 9.5mm | 22.50 | $78.50 | $1,766.25 |
| Invoice total | $21,137.39 | ||||
In the app, a text PDF like this is read for you and a spreadsheet by its columns. You check the rows beside the file and approve before anything reaches the sheet.
Run it yourself
Download the sample's three files and upload them on the free run, or bring your own invoice, tickets and PO list.