WorkflowTrucking Fleets

IFTA Fuel Tax Reporting

IFTA reporting that works the quarterly fuel tax return as a sheet you can audit: miles from ELD trips, fuel from cards, receipts and yard tanks, read first as the base jurisdiction's auditor would, then signed by the preparer and a controller.

See one quarter's IFTA return worked screen by screen ↓
Watch with transcript →
The problem

The return adds up, and the proof behind it fails the audit years later

A carrier's quarterly IFTA return is usually right in total. What fails is the proof. A card line keyed by hand at a non-network merchant has no gallons on it, reefer fuel was bought on the tractor's card, the GPS has a two-day hole after a device swap, and a sold truck's ELD keeps reporting miles.

Each of those costs a little tax when the auditor finds it. Records that fail for the fleet as a whole cost far more, because the auditor then sets the fleet's fuel economy instead of using the carrier's own. The burden of proof sits with the licensee, and the audit arrives long after anyone remembers the trip.

Built forFuel tax specialistsAssistant controllersFleet systems administratorsIRP registration clerks

The Problem Today

Card statements, receipts, yard tank logs and GPS trips are matched by hand, and the auditor tests that proof years later.

4.00
MPG imposed by the auditor when fleet records fail as a whole published
15%
of licensees each jurisdiction must audit over five years published

Matched by hand each quarter

  • Card lines
  • Receipts
  • Yard tanks
  • GPS trips
  • Hand-keyed lines claimedCard charges with no gallons go in as tax-paid fuel
  • Miles lost after a device swapA GPS gap leaves miles in no jurisdiction

The Solution

  1. Miles and fuel worked state by stateAgents fill the return from GPS trips, card lines, receipts and yard tanks
  2. Read as the state's auditor wouldA challenger tests each receipt, each gap and the agents' own draft
  3. Missing details requested in fieldsThe card provider, the yard vendor and drivers answer only what is asked
  4. Two people sign before it is filedThe specialist signs; the assistant controller opens the sheet, co-signs and files

Built-in controls

  • Nobody files alone; the co-signer opens the sheet first
  • Outside notes wait for the specialist to read them
  • Rebuilt miles keep their label on the return and in the file

What You Get

The carrier files a return that shows its working, with the proof an auditor asks for already behind each figure.

  • Each cell opens to its recordsTrips, receipts and the rule behind each figure
  • Last audit's findings run as checksAdjustments become standing checks once the controller approves
  • Any quarter packaged for auditSchedule, truck and month detail, signatures and labeled items
Features

IFTA reporting features, from ELD trip miles to a return filed by two people

Fuel tax specialists and assistant controllers use them to prove each figure before the base jurisdiction asks. The screens follow one fleet's third-quarter return.

demoInvented for the sample: the carrier, its tractors and staff, the card provider, the fuel vendor and each figure you see.

  1. 01Worked return

    IFTA return worked as a sheet: miles, taxable gallons, tax-paid gallons, tax

    • Fleet MPG shown as its equation. Miles over gallons sits under the sheet, so each taxable-gallon figure traces back to the one number it depends on.
    • Each cell opens to its trips and receipts. The specialist answers an auditor's question about any jurisdiction from the row itself, not from a folder.
    • Gap rows kept inside the sheet. A charge missing details, reefer fuel or rebuilt miles stays visible on its row until a person closes it, then shrinks to a tag.
  2. 02Auditor's read

    Challenger reads the draft as the base jurisdiction's IFTA auditor would

    • Each point priced as would be assessed. The specialist sees what each weak record would cost on audit and works the expensive ones first.
    • A month sampled and a truck rebuilt. The challenger rebuilds one tractor's miles from its distance record, as an IFTA audit does, before the state does it.
    • Errors in the agents' own draft caught. Reefer fuel counted as tractor fuel comes out of the draft before anyone signs it.
  3. 03Fuel records

    Fuel receipts missing one of the seven details, each with an owner and a clock

    • Card lines sorted by product first. DEF, reefer fuel, scales and washes are set aside, so only diesel placed in a qualified vehicle earns tax-paid credit.
    • Each fill checked for the seven details. A hand-keyed line with no gallons or fuel type is caught at intake rather than by the auditor.
    • Drivers asked in bulk, on a clock. Missing receipts are requested from drivers within the standing deadline instead of at quarter end.
  4. 04Card provider

    Fuel-card provider answers transaction detail in fixed fields

    • Only the fields IFTA needs, per transaction. The provider answers seller, gallons, fuel type, price, unit and purchaser, which is what a third-party transaction listing must show.
    • Typed gallons replace the estimate. The credit moves with what the provider sends, and an empty field keeps the line open instead of guessing.
    • Driver requests withdrawn once covered. When the card detail is complete, drivers stop hunting for paper receipts.
  5. 05Yard vendor

    Mobile fuel vendor types each truck's gallons and whether state tax was paid

    • One delivery split truck by truck. A single card charge for a yard delivery becomes per-unit gallons that can be credited and audited.
    • Tax included answered yes or no. The evidence that state tax was paid becomes a field on the fill record, where the auditor will look for it.
  6. 06Vendor note

    Vendor's free-text note read and routed by the fuel tax specialist

    • Exact words, with sender and time. No agent summarizes or acts on what the vendor wrote; the specialist reads it before the charge can close.
    • Routed with a reason code. A payment question goes to accounts payable, while a gallons question asks for a corrected ticket and keeps the charge open.
  7. 07Rebuilt trip

    Miles lost in a GPS gap rebuilt from bills of lading and a fuel stop

    • Gap found by the ten-minute reading rule. A stretch with no reading for the required interval is flagged, so miles do not fall into no jurisdiction unnoticed.
    • Rebuilt miles labeled on the return. The rebuild travels with the return, the binder and the audit package as rebuilt, never as GPS miles.
    • Accepted only after the record is opened. The specialist opens the trip record and gives a reason before rebuilt miles count.
  8. 08What-if

    IFTA audit what-if on disallowed receipts, the GPS gap and 4.00 MPG

    • Each weak record played forward. The specialist sees the tax at stake if the three charges were disallowed or the gap left unplaced.
    • The fleet-wide failure case priced. What failed records would cost the whole fleet is on screen while there is still time to fix them.
    • Rates and MPG editable as assumptions. Nothing in the what-if changes the return or touches its signatures.
  9. 09Sign and file

    IFTA fuel tax return prepared, co-signed and filed by two people

    • Preparer, then a second person. The assistant controller's co-signature stays locked until the worked return and the rebuilt trip have been opened.
    • What goes to the state beside the signatures. Total miles, gallons, fleet MPG, jurisdictions and net tax are read at the moment of signing.
    • Records kept four years. Trip records, fill records, the yard reconciliation and each signature stay with the quarter for the retention the manual sets.

Who prepares, files and defends the IFTA fuel tax return

The specialist works the quarter, the controller signs second, and systems and registration staff keep the miles whole.

Fuel tax specialists

Work the quarterly return, chase receipts, accept rebuilds and sign as preparer

  • Each cell opening to its trips and receipts
  • Card provider and vendor answering only what is needed
  • What the auditor would assess, before filing
Assistant controllers

Co-sign and file the return, and approve rules, settings and disposal

  • The sheet and rebuilt trips opened before co-signing
  • A hold that someone else must release
  • An audit package for any quarter
Fleet systems administrators

Keep ELD feeds whole and confirm device swaps and sold units

  • Each tractor's ten-minute coverage
  • GPS gaps tied to their work orders
  • Sold units flagged before they add miles
IRP registration clerks

File apportioned registration from the same miles as fuel tax

  • Quarter miles handed over at filing
  • Rebuilt miles still labeled
  • Sold units deleted from the apportioned fleet

Two signatures on the return, and who confirms the records behind it

Fuel tax specialist
Sees
The worked sheet, the challenger's points, the rebuilt trip and the vendor's note
Signs
As preparer, that the figures match the trip and fuel records
Assistant controller
Sees
The worked return and the rebuilt trip, opened before the co-sign button works
Signs
The co-signature, then the filing with the base jurisdiction
Fleet systems administrator
Sees
The reading strip around a gap and the device swap work order
Signs
Confirmation that the swap record explains the gap
IRP registration clerk
Sees
The quarter's miles by jurisdiction, handed over at filing
Signs
The deletion of a sold unit from the apportioned fleet
More screens

Trip miles by truck, the requests, the lessons and four years of quarters

Six more screens from the fuel tax desk and the controller's office.

Trip miles by truckFlagged tractors with miles, gallons and MPG, the reading strip around a device swap, and the sold unit whose ELD kept reporting.
Outside requests, answeredThe card provider's and the vendor's replies as fields, the gallons documented, and the vendor's note held for a person.
The controller's signature pathPreparer signed, the worked return and the rebuilt trip opened by the assistant controller, then co-sign and file in that order.
Lessons from the last auditThree standing checks from the last audit fired this quarter; a new lesson on reefer fills waits for the assistant controller.
Quarters and audits18 quarters with miles, gallons, MPG, net tax and keep-until dates, and an audit package for any quarter in one step.
IRP miles from the same recordsApportioned registration miles by jurisdiction come from the trip records behind the fuel tax return, and the sold unit leaves the fleet.

demoSample data, from the working solution.

Reefer fuel, a GPS gap, three bare charges and a sold truck, before filing

What the agents and their challenger found in one sample quarter, each closed by a source or a person.

Reefer fuel in the agents' own draft

18 second fills the tractor tanks could not hold: 1,264 gallons that went into refrigeration units, worth $781.38. The fuel matcher corrected its own draft.

1,216 miles in no jurisdiction

A device swap left one tractor with no GPS readings for two days. Two bills of lading and a fuel stop placed the miles: Ohio 192, Indiana 128, Illinois 896, labeled rebuilt.

Three charges with no full receipt

Two hand-keyed card lines and one mobile yard delivery, 2,140 gallons, would be assessed $1,069.67. The card provider and the vendor answered in fields.

A sold truck still reporting

A tractor sold mid-quarter logged 9,856 more miles on no fuel. The specialist told the agents mid-run, and the after-sale miles came out with the bill of sale cited.

demoSample data, from the working solution.

What fuel tax teams ask about IFTA reporting

What is IFTA reporting?

IFTA reporting is the quarterly fuel tax return a motor carrier files with its base jurisdiction: miles and fuel by jurisdiction, the fleet's miles per gallon, and the tax due or credited in each. Agents work the return from ELD trips and fuel records, a challenger reads it as the auditor would, and two people sign and file.

What does an IFTA audit look for?

Distance records with frequent enough readings, a receipt holding each required detail for every tax-paid gallon, and yard tank reconciliations. When records fail for the fleet as a whole, the auditor can set the fleet's fuel economy. The challenger tests the draft against the same requirements before filing.

What are the IFTA reporting requirements for fuel receipts?

A receipt or transaction listing needs the date, the seller's name and address, the quantity, the fuel type, the price, the vehicle and the purchaser. Fills missing any of them are queued for the driver, the card provider or the vendor before the return is signed.

How are GPS gaps handled?

A stretch with no readings is flagged, then rebuilt from bills of lading and fuel stops and labeled rebuilt. The specialist opens the trip record before accepting it, and the label stays on the return and in the audit package.

Can the same miles feed IRP apportioned registration?

Yes. The quarter's miles by jurisdiction pass to the IRP clerk at filing, from the same trip records, so the fuel tax miles and the registration miles agree.

Who files the return?

The assistant controller, as the second person, after the fuel tax specialist signs as preparer. The co-signature stays locked until the worked sheet and any rebuilt trip have been opened.

Bring last quarter's
card file and trips.

Bring one quarter's ELD export, fuel-card file and yard tank logs, and we will work the return with each cell tied to its records.