SAMPLE IFTA worksheet: Q3 2026
A made-up one-truck carrier based in Texas, driving 28 trips in July to September 2026. This is what you get back, as an Excel file and a one-page summary.
| Carrier | SAMPLE Trucking (made up) |
|---|---|
| Base state | Texas |
| Quarter | Q3 2026 (1 Jul to 30 Sep) |
| Fuel | Diesel |
| Total miles | 9,552 |
| Total gallons bought | 1,472.7 |
| Miles per gallon | 6.49 |
| Net tax due (after credits) | $9.10 |
| Due date | Mon 2 Nov 2026 |
State by state
| State | Total miles | Taxable gallons | Fuel bought (gal) | Net gallons | Rate $/gal | Tax (credit) $ |
|---|---|---|---|---|---|---|
| Alabama | 428 | 66 | 0 | 66 | 0.3100 | 20.46 |
| Arizona | 768 | 118 | 140 | -22 | 0.2600 | -5.72 |
| Arkansas | 610 | 94 | 128 | -34 | 0.2850 | -9.69 |
| Georgia | 246 | 38 | 110 | -72 | 0.3730 | -26.86 |
| Illinois | 187 | 29 | 0 | 29 | 0.7380 | 21.40 |
| Kansas | 412 | 63 | 0 | 63 | 0.2600 | 16.38 |
| Louisiana | 602 | 93 | 120 | -27 | 0.2000 | -5.40 |
| Mississippi | 356 | 55 | 0 | 55 | 0.2400 | 13.20 |
| Missouri | 591 | 91 | 151 | -60 | 0.2950 | -17.70 |
| New Mexico | 742 | 114 | 132 | -18 | 0.2100 | -3.78 |
| Oklahoma | 493 | 76 | 139 | -63 | 0.1900 | -11.97 |
| Tennessee | 220 | 34 | 0 | 34 | 0.2700 | 9.18 |
| Texas | 3,897 | 600 | 552 | 48 | 0.2000 | 9.60 |
Negative numbers are credits: you bought more fuel in that state than you burned there, so you already paid that tax at the pump.
Notes we would send
- No fuel bought in Alabama, Illinois, Kansas, Mississippi or Tennessee: normal for pass-through states, so tax is due there.
- Miles per gallon of 6.49 is in a normal range for a loaded tractor. A big change from last quarter is worth a second look.
- Rates are from the official IFTA matrix for 3Q2026. Texas has no surcharge; Kentucky and Virginia would.
SAMPLE made-up data. FuelTax Friend is not a tax preparer and does not file for you. You check these numbers and file your own IFTA return with your base state.