Production patterns for automating freight bill auditing, carrier rate contract extraction, and discrepancy resolution across LTL/FTL pipelines.
Freightbill is an open, engineering-first knowledge base for the people who turn freight billing from a reactive accounting chore into a deterministic data control system. Every page is grounded in real ETL practice — Pydantic schemas, vectorized rate lookups, dynamic fuel-surcharge formulas, idempotency keys, dead-letter queues, and audit-grade observability — the controls that let a freight audit pipeline survive month-end billing peaks without silent overpayment.
If you own an LTL/FTL audit pipeline end-to-end, this is the reference you wish you'd had when the first carrier changed its EDI feed at 2 a.m.
- Python ETL developers building invoice ingestion and rate-validation pipelines
- Freight auditors who need the logic behind the numbers, not just the numbers
- Logistics analysts mapping carrier contracts, accessorials, and fuel indices
- Transportation ops teams chasing recovered dollars through disputes and reconciliation
The site is organized into four production areas, each with an overview and a set of deep, hands-on guides:
| Area | What it covers |
|---|---|
| Freight Contract Architecture & Rate Mapping | Normalized contract schemas, effective-date versioning, LTL/FTL rate extraction, mileage-band lookups, accessorial taxonomy, and fuel-surcharge formulas that survive amendments and historical reconciliation. |
| Rule-Based Rate Validation & Accessorial Auditing | Weight/zone cross-checks, lane matching, dynamic thresholds, and confidence-scored accessorial auditing that turns billing leakage into recoverable revenue. |
| Automated Invoice Parsing & EDI/XML Ingestion | EDI 210/810 segment parsing, namespaced XML streaming, layout-aware PDF extraction, transport protocols (SFTP, AS2, webhooks), and fault-tolerant async batch workflows. |
| Discrepancy Resolution & Dispute Routing | Charge-variance classification, carrier dispute API integration, short-pay and deduction management, and a double-entry reconciliation ledger that ties every recovered dollar to the cent. |
Every guide follows the same shape freight engineers actually need: problem framing → architecture → production-ready implementation → validation and testing → failure modes → reference tables — with original diagrams and copy-paste Python throughout.
Freightbill is a fast, fully static site with no client-side framework and no tracking:
- Eleventy static site generator (Nunjucks + Markdown)
- Hand-authored, theme-aware inline SVG diagrams (no image bloat, no runtime)
- Structured data (JSON-LD) on every page so machines can read the content cleanly
- Installable PWA with an offline-ready service worker
- Accessible by design — WCAG 2 AA checked, keyboard-friendly, responsive from mobile to widescreen
- Deployed on Cloudflare Pages
npm install
npm run serve # local dev server with live reload
npm run build # production build to _site/The production site builds and ships to Cloudflare Pages:
npm run deployBuilt for the freight audit community · www.freightbill.org