Ticket Match

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.

7 of 15lines matched clean
$4,080.54at risk of $21,137.39 billed
1Duplicate · $1,703.52
1Billed, no ticket · $1,766.25
1Quantity differs · $72.00
1Rate differs · $26.93
1Arithmetic · $10.00
1Over PO quantity · $113.60
1No PO or job · $388.24
1Ticket not billed

The exception sheet

FlagTicketLineWhat is wrongAt risk
Duplicate1045116Ticket 104511 is billed twice (also line 5).$1,703.52
Billed, no ticket10454015No ticket 104540 came with the invoice.$1,766.25
Quantity differsRA-1045127Billed 25.30 t; the ticket's net is 24.30 t.+$72.00
Rate differsRA-1045219Billed at $26.25; PO 4480 says $24.75.+$26.93
Arithmetic1045331323.12 x $78.50 is $1,814.92; the line says $1,824.92.+$10.00
Over PO quantityRA-10452210PO 4480 is for 50.00 t; with this ticket 54.59 t has been delivered.$113.60
No PO or jobRA-10453011Job 2699 (Crusher Run) is not on your PO list.$388.24
Ticket not billedRA-104532Ticket 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

No. RA-104512 · 2026-09-03
HMA Base 19mm
Net 24.30 t · Job 2614 · PO 4472

Ridgeline Asphalt & Aggregate · Scale ticket

No. RA-104530 · 2026-09-10
Crusher Run
Net 21.10 t · Job 2699

Ridgeline Asphalt & Aggregate · Scale ticket

No. RA-104532 · 2026-09-11
HMA Surface 9.5mm
Net 22.76 t · Job 2614 · PO 4471

The PO and job list

POJobMaterialRatePO qty
44712614 Route 9 overlayHMA Surface 9.5mm$78.501,200.00 t
44722614 Route 9 overlayHMA Base 19mm$72.001,500.00 t
44802631 Elm St lot#57 Stone$24.7550.00 t
44852638 Fairview Rd wideningCrusher Run$18.40400.00 t

The invoice

Ridgeline Asphalt & Aggregate

Example data

Invoice 58217 · September 2026 · Bill to Cole Brothers Paving

TicketDateProductTonsPriceExtended
10450109/02HMA Surface 9.5mm22.41$78.50$1,759.19
10450209/02HMA Surface 9.5mm21.87$78.50$1,716.80
10450309/02HMA Surface 9.5mm23.05$78.50$1,809.43
10451009/03HMA Base 19mm24.12$72.00$1,736.64
10451109/03HMA Base 19mm23.66$72.00$1,703.52
10451109/03HMA Base 19mm23.66$72.00$1,703.52
10451209/03HMA Base 19mm25.30$72.00$1,821.60
10452009/08#57 Stone18.20$24.75$450.45
10452109/08#57 Stone17.95$26.25$471.19
10452209/08#57 Stone18.44$24.75$456.39
10453009/10Crusher Run21.10$18.40$388.24
10453109/11HMA Surface 9.5mm22.90$78.50$1,797.65
10453309/11HMA Surface 9.5mm23.12$78.50$1,824.92
10453409/12HMA Base 19mm24.05$72.00$1,731.60
10454009/12HMA Surface 9.5mm22.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.