workflow-checks: sample outputs

These pages are the actual output of running the three demos in the repository on their bundled sample data (review date 2026-09-28), after their test suites passed. Rebuild them yourself with python scripts/build_pages.py.

Freight: detention packets and carrier invoice audit

Input: a TMS load list, telematics or tracking stop events, rate confirmations and carrier invoices for 24 loads. Output: 15 draft detention/late-arrival packets, 12 invoice flags, 18 evidence-backed fines, 5 exceptions held for a person, and a settlement worksheet (22 READY, 3 HOLD).

Draft packets (one per load; calculation, evidence timeline, approval block): LD260900 LD260907 LD260914 LD260921 LD260928 LD260935 LD260949 LD260956 LD260977 LD260991 LD261005 LD261019 LD261026 LD261033 LD261061

Invoice flags

invoice_noload_idflagdetailvarianceevidence
CAL-7101LD260907LINEHAUL_MISMATCHlinehaul: invoiced $1,532.00 vs rate-con $1,382.00$150.00carrier_invoices.csv:row6;RC-48001.txt
CAL-7104LD260928FUEL_MISMATCHfuel surcharge: invoiced $656.77 vs rate-con $614.02$42.75carrier_invoices.csv:row17;RC-48004.txt
CAL-7107LD260949DETENTION_UNSUPPORTEDdetention invoiced $200.00 but telematics supports $75.00$125.00carrier_invoices.csv:row25;RC-48007.txt
CAL-7110LD260970ACCESSORIAL_NOT_ON_RATECONTONU $250.00 billed but not on rate-con$250.00carrier_invoices.csv:row35;RC-48010.txt
CAL-7113LD260991ACCESSORIAL_OVER_RATECONLUMPER: invoiced $255.00 vs agreed $175.00$80.00carrier_invoices.csv:row44;RC-48013.txt
CAL-7116LD261012TOTAL_MISMATCHheader total $1,883.64 != line sum $1,783.64$100.00carrier_invoices.csv:row53

Showing 6 of 12 rows. Full CSV

Settlement worksheet

invoice_noload_idinvoicedapprovedfinesnet_payablestatushold_reasons
BLU-7100LD260900$2,499.22$2,499.22$0.00$2,499.22READY
CAL-7101LD260907$2,221.25$2,071.25$50.00$2,021.25READY
PEC-7102LD260914$2,322.06$2,322.06$50.00$2,272.06READY
BLU-7103LD260921$3,005.70$3,005.70$0.00$3,005.70READY
CAL-7104LD260928$3,492.77$3,450.02$0.00$3,450.02READY
PEC-7105LD260935$1,884.99$1,884.99$50.00$1,834.99READY

Showing 6 of 25 rows. Full CSV

Exceptions (never claimed, sent to a person)

load_idstopreasonevidence
LD2609422geofence entry has no matching exit (export gap or still on site)telematics.csv:row12;RC-48006.txt
LD2609701geofence entry has no matching exit (export gap or still on site)tracking_stops.csv:row14;RC-48010.txt
LD2609841geofence entry has no matching exit (export gap or still on site)telematics.csv:row17;RC-48012.txt
LD2610331geofence entry has no matching exit (export gap or still on site)tracking_stops.csv:row26;RC-48019.txt
LD2610472geofence entry has no matching exit (export gap or still on site)telematics.csv:row32;RC-48021.txt

Showing 5 of 5 rows. Full CSV

Physical therapy: authorization worklist

Input: a visit schedule, authorizations, a per-payer rules table and patients (40 synthetic patients, 842 visits, 46 auths). Output: a prioritized daily worklist of 26 items (11 P1, 15 P2), each with a reason code, a submit-by date and the payer checklist. Open the printable daily digest.

prioritypatient_idpayerauth_noreasonsvisits_remainingsubmit_bydetail
P1SYN-1014Medicare Advantage Plan (placeholder)AUTH-70039UNCOVERED_VISIT|REAUTH_BY_VISITS12026-09-238 scheduled visit(s) outside any approved auth, first 2026-10-04 (V1271, V1272, V1273, V1274 ...) / 1 of 7 visits left (payer threshold 4)
P1SYN-1038Commercial Plan A (placeholder)AUTH-70111UNCOVERED_VISIT|REAUTH_BY_DATE222026-09-269 scheduled visit(s) outside any approved auth, first 2026-10-03 (V1777, V1778, V1779, V1780 ...) / auth ends 2026-10-01 (3 days); 11 visit(s) still scheduled
P1SYN-1037Commercial Plan B (placeholder)AUTH-70108UNCOVERED_VISIT|REAUTH_BY_VISITS22026-09-278 scheduled visit(s) outside any approved auth, first 2026-10-03 (V1760, V1761, V1762, V1763 ...) / 2 of 18 visits left (payer threshold 2)
P1SYN-1026Commercial Plan A (placeholder)AUTH-70075UNCOVERED_VISIT|REAUTH_BY_VISITS22026-09-279 scheduled visit(s) outside any approved auth, first 2026-10-05 (V1517, V1518, V1519, V1520 ...) / 2 of 17 visits left (payer threshold 3)
P1SYN-1023Commercial Plan A (placeholder)AUTH-70066UNCOVERED_VISIT|REAUTH_BY_DATE232026-09-289 scheduled visit(s) outside any approved auth, first 2026-10-04 (V1451, V1452, V1453, V1454 ...) / auth ends 2026-10-03 (5 days); 10 visit(s) still scheduled
P1SYN-1025Commercial Plan B (placeholder)AUTH-70072UNCOVERED_VISIT|REAUTH_BY_DATE202026-09-298 scheduled visit(s) outside any approved auth, first 2026-10-04 (V1491, V1492, V1493, V1494 ...) / auth ends 2026-10-02 (4 days); 10 visit(s) still scheduled

Showing 6 of 26 rows. Full CSV

Utilities: bill exceptions and payment queue

Input: utility accounts, 274 bills, payments and unit occupancy for 31 accounts. Output: 12 flags (spikes against the same month last year, rate changes, duplicates, overlaps, missing bills, late fees, payment mismatches, vacant-unit usage), 2 exceptions, and 12 clean bills queued for approval (not paid). Open the full report.

propertyutilityaccount_nocodedetailevidence
Bayou Flats (synthetic)electricSYN-7005LATE_FEE_OR_PAST_DUElate fee $179.02, prior balance $3,222.36 on the billbills.csv:88
Bayou Flats (synthetic)waterSYN-7007PAYMENT_MISMATCHowed $4,232.12; 2 payment(s) totalling $8,464.24bills.csv:126 payments.csv:120 payments.csv:121
Bayou Flats (synthetic)trashSYN-7008PAYMENT_MISMATCHowed $1,258.66; 1 payment(s) totalling $1,108.66bills.csv:143 payments.csv:137
Bayou Flats (synthetic)gasSYN-7006PERIOD_OVERLAPservice period 2026-06-22..2026-07-31 overlaps prior bill B50106 (2026-06-01..2026-06-30); 9 days may be billed twicebills.csv:108 bills.csv:107
Bayou Flats (synthetic)waterSYN-7021VACANT_UNIT_USAGEunit 201 vacant; 0.360 kgal/day vs standby ceiling 0.05 (possible leak or running equipment)bills.csv:243 occupancy.csv:5
Bayou Flats (synthetic)waterSYN-7021VACANT_UNIT_USAGEunit 201 vacant; 0.360 kgal/day vs standby ceiling 0.05 (possible leak or running equipment)bills.csv:244 occupancy.csv:5
Cypress Court (synthetic)trashSYN-7004RATE_CHANGE$123.7817/pull vs trailing median $92.0173 (x1.35); check tariff/rate planbills.csv:69
Cypress Court (synthetic)gasSYN-7002USAGE_SPIKE92.7 therm/day vs 49.4 same month last year (x1.88)bills.csv:33 bills.csv:21
Cypress Court (synthetic)waterSYN-7003USAGE_SPIKE17.9 kgal/day vs 10.0 same month last year (x1.79)bills.csv:51 bills.csv:39
Gaylord Ridge (synthetic)trashSYN-7012DUPLICATE_BILLsame invoice number as B50212 (HAUL-50212); hold, do not pay twicebills.csv:214 bills.csv:213
Gaylord Ridge (synthetic)electricSYN-7009MISSING_BILLno bill for service month 2026-04; check vendor portal / mail before a late fee landsaccounts.csv:10
Gaylord Ridge (synthetic)gasSYN-7010UNPAID_PAST_DUEdue 2026-09-06, no payment on filebills.csv:179

Showing 12 of 12 rows. Full CSV

Want this on your own exports?

A scoped pilot runs on your own redacted exports and is compared against a manual audit. See jacobmetoyer.com. Code: https://github.com/Jacob-Met/workflow-checks (MIT).