TICKETRECON
Exception packet
Synthetic demonstration data — a made-up month on Fairfax County's published FY27 schedule. The tickets, invoice lines, and errors are invented; the method and the math are the real service.
Rate schedule: Fairfax County commercial disposal, FY27 (demo schedule) · Your files were processed in memory and were not stored.
| Source tickets | 40 |
|---|---|
| Invoice lines | 41 |
| Clean invoice lines | 34 |
| Exceptions | 7 |
| Billed total | $27,415.06 |
| Expected total | $25,841.71 |
| Gross overbilled | $2,327.65 |
| Gross underbilled | $754.30 |
| Net effect (billed − expected) | +$1,573.35 |
1. FFX-2609-003 — Duplicate billing
Dollar effect (billed − expected): +$901.60
Billed total: $1,803.20 · Expected total: $901.60
Ticket evidence
- 2026-09-24 · TRK-422 · trash · gross 24.30 t · tare 15.10 t · net 9.20 t · notes: none
Invoice evidence
- Billed net 9.20 t · billed rate $98.00/ton · penalty $0.00 · amount $901.60
- Billed net 9.20 t · billed rate $98.00/ton · penalty $0.00 · amount $901.60
Schedule rule
- trash: $98.00/ton, minimum $89.00 per load.
- Contamination penalty: $185.00/ton only when the ticket documents contamination.
- Expected base $901.60 + expected penalty $0.00 = $901.60.
Finding
- The ticket is billed on 2 invoice lines; the schedule allows one charge per ticket.
2. FFX-2609-007 — Wrong material-class rate
Dollar effect (billed − expected): +$243.75
Billed total: $612.50 · Expected total: $368.75
Ticket evidence
- 2026-09-20 · TRK-204 · brush · gross 20.30 t · tare 14.05 t · net 6.25 t · notes: none
Invoice evidence
- Billed net 6.25 t · billed rate $98.00/ton · penalty $0.00 · amount $612.50
Schedule rule
- brush: $59.00/ton, minimum $39.00 per load.
- Contamination penalty: $185.00/ton only when the ticket documents contamination.
- Expected base $368.75 + expected penalty $0.00 = $368.75.
Finding
- Billed rate ($98.00/ton) does not match the ticket material rate ($59.00/ton).
3. FFX-2609-011 — Inflated billed net weight
Dollar effect (billed − expected): +$73.50
Billed total: $896.70 · Expected total: $823.20
Ticket evidence
- 2026-09-22 · TRK-538 · trash · gross 22.15 t · tare 13.75 t · net 8.40 t · notes: none
Invoice evidence
- Billed net 9.15 t · billed rate $98.00/ton · penalty $0.00 · amount $896.70
Schedule rule
- trash: $98.00/ton, minimum $89.00 per load.
- Contamination penalty: $185.00/ton only when the ticket documents contamination.
- Expected base $823.20 + expected penalty $0.00 = $823.20.
Finding
- Billed net weight (9.15 tons) does not match the ticket net (8.40 tons).
4. FFX-2609-015 — Minimum not applied — undercharge
Dollar effect (billed − expected): -$9.50
Billed total: $29.50 · Expected total: $39.00
Ticket evidence
- 2026-09-20 · TRK-101 · brush · gross 13.70 t · tare 13.20 t · net 0.50 t · notes: none
Invoice evidence
- Billed net 0.50 t · billed rate $59.00/ton · penalty $0.00 · amount $29.50
Schedule rule
- brush: $59.00/ton, minimum $39.00 per load.
- Contamination penalty: $185.00/ton only when the ticket documents contamination.
- Expected base $39.00 + expected penalty $0.00 = $39.00.
Finding
- The billed base amount is below the contractual per-load minimum.
5. FFX-2609-019 — Wrong class and unsupported contamination penalty
Dollar effect (billed − expected): +$716.80
Billed total: $905.60 · Expected total: $188.80
Ticket evidence
- 2026-09-17 · TRK-317 · brush · gross 15.85 t · tare 12.65 t · net 3.20 t · notes: none
Invoice evidence
- Billed net 3.20 t · billed rate $98.00/ton · penalty $592.00 · amount $905.60
Schedule rule
- brush: $59.00/ton, minimum $39.00 per load.
- Contamination penalty: $185.00/ton only when the ticket documents contamination.
- Expected base $188.80 + expected penalty $0.00 = $188.80.
Finding
- Billed rate ($98.00/ton) does not match the ticket material rate ($59.00/ton).
- A contamination penalty is billed, but the ticket carries no contamination annotation.
6. FFX-2609-027 — Ticket never billed
Dollar effect (billed − expected): -$744.80
Billed total: $0.00 · Expected total: $744.80
Ticket evidence
- 2026-09-11 · TRK-204 · trash · gross 21.65 t · tare 14.05 t · net 7.60 t · notes: none
Invoice evidence
- No invoice line exists for this ticket.
Schedule rule
- trash: $98.00/ton, minimum $89.00 per load.
- Contamination penalty: $185.00/ton only when the ticket documents contamination.
- Expected base $744.80 + expected penalty $0.00 = $744.80.
Finding
- No invoice line exists for this valid scale ticket; the charge is unbilled.
7. FFX-2609-999 — Phantom invoice line
Dollar effect (billed − expected): +$392.00
Billed total: $392.00 · Expected total: $0.00
Ticket evidence
- No matching ticket exists in the tickets file.
Invoice evidence
- Billed net 4.00 t · billed rate $98.00/ton · penalty $0.00 · amount $392.00
Schedule rule
- A charge requires a corresponding facility scale ticket; no schedule rate can validate a phantom ticket number.
Finding
- Invoice line has no corresponding scale ticket in the hauler's ticket file.