Strong Tower Consulting has engineered production-grade automated IFTA reconciliation systems for asset-based motor carriers operating 150 to 2,500 power units. These solutions eliminate the manual distance and fuel reconciliation steps that traditionally consume 120-200 labor hours per quarter while producing audit-ready documentation that withstands state fuel tax examinations.
Our approach combines high-frequency telematics data, polygon-based geofencing, fuel transaction matching, and direct integration with leading TMS platforms including Truckmate, McLeod, and TMW. The resulting engine calculates jurisdiction mileage, allocates tax-paid gallons, generates IFTA-100 and IFTA-101 forms, and maintains a complete chain-of-custody audit trail.
The Technical Data Pipeline
The system ingests raw GPS pings at 5- to 30-second intervals from ELD or telematics providers. Each ping is processed through a bearing-aware route reconstruction algorithm that determines the precise moment a vehicle crosses a state or jurisdictional boundary. Unlike simple point-in-polygon tests, our engine uses heading, speed, and previous-ping context to prevent false boundary crossings at rest areas or terminals located near borders.
State mileage is accumulated in real time and stored in a normalized SQL schema that mirrors the carrier's existing TMS tables. Fuel transactions are imported nightly via secure FTP from major fuel card providers or through direct API connections. Receipt images are processed through OCR when structured data is unavailable. Each gallon purchased is matched to a specific driver, tractor, and jurisdiction using both purchase location and subsequent GPS travel history.
| Data Source | Frequency | Purpose | Integration Method |
|---|---|---|---|
| High-frequency GPS pings | 5-30 seconds | Route reconstruction & boundary crossing | Telematics API / SQL staging |
| Fuel card transactions | Daily FTP/API | Tax-paid gallon import | Comdata, T-Chek, PFJ |
| TMS load & settlement data | Real-time | Driver pay, fuel surcharge validation | Direct SQL (Truckmate/McLeod/TMW) |
| EDI 214 / 210 events | Event-driven | Detention & accessorial mileage validation | EDI translator to SQL |
Jurisdiction Boundary Geofencing & Polygon Management
Accurate IFTA reporting depends on precise jurisdictional polygons. Our engine maintains an updated library of state, county, and special fuel-tax districts using both public GIS sources and carrier-specific terminal polygons. When a vehicle crosses a boundary, the system records the exact latitude/longitude, timestamp, heading, and speed. This data becomes the legal basis for distance allocation and can be exported as evidence during an audit.
Fuel Receipt Reconciliation & Tax-Paid Gallon Allocation
Fuel purchases are reconciled against driver settlements and fuel surcharge billings within the TMS. The engine flags discrepancies such as cash fuel purchases, split loads, or bulk tank fills. Tax-paid gallons are then prorated across the jurisdictions traveled since the last fill based on actual GPS mileage rather than flat percentages. This approach routinely reduces over-reported tax liability in high-mileage states.
Automated Quarterly IFTA-100/101 Generation
At quarter close, the system assembles the IFTA-100 summary and IFTA-101 detail reports directly from the reconciled dataset. Output files are generated in both PDF and CSV formats suitable for electronic filing through the IFTA clearinghouse. Carriers retain full control of the final filing while benefiting from dramatically reduced preparation time and fewer transposition errors.
Audit Defense Capabilities
When an IFTA audit notice arrives, the system produces a complete evidence package within minutes: GPS route maps with boundary crossings highlighted, fuel receipt matching reports, exception logs, and a narrative summary that references specific IFTA Articles. This documentation has repeatedly reduced or eliminated proposed assessments for our clients.
Carriers using this architecture typically achieve 98%+ automated reconciliation rates, with only complex exceptions routed to fuel tax analysts for review. The solution scales from regional fleets to multi-thousand-unit operations running in 48 states and Canadian provinces.
Ready to Eliminate Manual IFTA Reconciliation?
Our team will evaluate your current telematics, TMS, and fuel card environment and deliver a detailed architecture recommendation. The assessment typically requires less than two weeks and includes a projected ROI based on your fleet size and current labor allocation.
Request IFTA Automation Assessment
Founded in Minnesota in 2008 by Scott Elliott, Strong Tower Consulting, LLC has spent more than 18 years helping motor carriers and freight brokers optimize operations through technology and process excellence. Call 763-244-1373 to speak with our team.