[1] | Place cursor on Red Triangles in each cell for more information. BE SURE TO READ THE INFORMATION IN "E. AVERAGE FLEET MPG" BEFORE ENTERING ANY DATA! All underlinded text is a hyperlink. | 5/26/2004 12:13 | |||||||
Calculation worksheet for Quarterly IFTA Report | |||||||||
Current Calculated MPG | A. Total IFTA Miles |
B. Total Non-IFTA Miles |
C. Total IFTA & Non-IFTA Miles |
D. Total Gallons Consumed |
E. Average Fleet MPG |
The only cells you will be able to type in are the white cells. Cell "E" MUST have a value in it at all times in order to perform the calculations on the form. You can change it at any time. | |||
5.267 | 173,408 | 0 | 173,408 | 32,923 | 5.260[2] | Enter data in columns H, I, L, N, & P | |||
Jurisdiction colors: Green canadian, light Orange Non-IFTA, Blue USA | Place cursor here for information[3] | $865.31 | |||||||
Jurisdiction | H. Total IFTA Miles |
I. Taxable Miles |
K. Taxable Gallons Consumed |
L. Tax Paid Gallons |
M. Net Taxable Gallons |
N. Tax Rate[4] |
O. Tax Credit/ Due |
P. Interest Due |
Q. Total Credit/Debit |
AB | 0 | 0 | 0.2595 | $0.00 | $0.00 | ||||
AL | 5,742 | 5,742 | 1,092 | 1,140 | (48) | 0.1700 | ($8.22) | ($8.22) | |
AK | 0 | 0 | $0.00 | $0.00 | |||||
AR | 22,815 | 22,815 | 4,337 | 3,325 | 1,012 | 0.2250 | $227.80 | $227.80 | |
AZ | 0 | 0 | 0.2600 | $0.00 | $0.00 | ||||
BC | 0 | 0 | 0.4325 | $0.00 | $0.00 | ||||
CA | 0 | 0 | 0.2780 | $0.00 | $0.00 | ||||
CO | 0 | 0 | 0.2050 | $0.00 | $0.00 | ||||
CT | 0 | 0 | 0.2600 | $0.00 | $0.00 | ||||
DC | 0 | 0 | $0.00 | $0.00 | |||||
DE | 0 | 0 | 0.2200 | $0.00 | $0.00 | ||||
FL | 0 | 0 | 0.2707 | $0.00 | $0.00 | ||||
GA | 67 | 67 | 13 | 0 | 13 | 0.1110 | $1.41 | $1.41 | |
IA | 0 | 0 | 0 | 0.2250 | $0.00 | $0.00 | |||
ID | 0 | 0 | 0 | 0.2500 | $0.00 | $0.00 | |||
IL | 944 | 944 | 179 | 0 | 179 | 0.2960 | $53.12 | $53.12 | |
IN | 901 | 901 | 171 | 416 | (245) | 0.1600 | ($39.15) | ($39.15) | |
IN | Fuel Surcharge Calculations | 171 | 0.1100 | $18.84 | $18.84 | ||||
KS | 2,996 | 2,996 | 570 | 0 | 570 | 0.2600 | $148.09 | $148.09 | |
KY | 37,552 | 37,552 | 7,139 | 10,149 | (3,010) | 0.1200 | ($361.18) | ($361.18) | |
KY | Fuel Surcharge Calculations | 7,139 | 0.0520 | $371.24 | $371.24 | ||||
LA | 0 | 0 | 0.2000 | $0.00 | $0.00 | ||||
MA | 0 | 0 | 0.2100 | $0.00 | $0.00 | ||||
MB | 0 | 0 | 0.3143 | $0.00 | $0.00 | ||||
MD | 12 | 12 | 2 | 0 | 2 | 0.2425 | $0.55 | $0.55 | |
ME | 0 | 0 | 0.2570 | $0.00 | $0.00 | ||||
MI | 0 | 0 | 0.2280 | $0.00 | $0.00 | ||||
MN | 0 | 0 | 0.2000 | $0.00 | $0.00 | ||||
MO | 66,911 | 66,911 | 12,721 | 13,034 | (313) | 0.1700 | ($53.26) | ($53.26) | |
MS | 495 | 495 | 94 | 0 | 94 | 0.1800 | $16.94 | $16.94 | |
MT | 0 | 0 | 0.2775 | $0.00 | $0.00 | ||||
MX | 0 | 0 | $0.00 | $0.00 | |||||
NB | 0 | 0 | 0.4872 | $0.00 | $0.00 | ||||
NC | 0 | 0 | 0.2430 | $0.00 | $0.00 | ||||
ND | 0 | 0 | 0.2100 | $0.00 | $0.00 | ||||
NE | 0 | 0 | 0.2480 | $0.00 | $0.00 | ||||
NH | 0 | 0 | 0.1800 | $0.00 | $0.00 | ||||
NJ | 0 | 0 | 0.1750 | $0.00 | $0.00 | ||||
NL | 0 | 0 | 0.4757 | $0.00 | $0.00 | ||||
NM | 0 | 0 | 0.1800 | $0.00 | $0.00 | ||||
NS | 0 | 0 | 0.4440 | $0.00 | $0.00 | ||||
NT | 0 | 0 | $0.00 | $0.00 | |||||
NV | 0 | 0 | 0.2700 | $0.00 | $0.00 | ||||
NY | 0 | 0 | 0.3115 | $0.00 | $0.00 | ||||
OK | 1,365 | 1,365 | 260 | 0 | 260 | 0.2400 | $62.28 | $62.28 | |
OH | Fuel Surcharge Calculations | 260 | 0.0300 | $7.79 | $7.79 | ||||
OK | 250 | 250 | 48 | 153 | (105) | 0.1300 | ($13.71) | ($13.71) | |
ON | 0 | 0 | 0.4123 | $0.00 | $0.00 | ||||
OR | READ NOTE | 0 | N/A | $0.00 | |||||
PA | 687 | 687 | 131 | 0 | 131 | 0.3120 | $40.75 | $40.75 | |
PE | 0 | 0 | 0.3892 | $0.00 | $0.00 | ||||
QC | 0 | 0 | 0.4671 | $0.00 | $0.00 | ||||
RI | 0 | 0 | 0.3000 | $0.00 | $0.00 | ||||
SC | 0 | 0 | 0.1600 | $0.00 | $0.00 | ||||
SD | 0 | 0 | 0.2200 | $0.00 | $0.00 | ||||
SK | 0 | 0 | 0.4325 | $0.00 | $0.00 | ||||
TN | 11,438 | 11,438 | 2,175 | 1,824 | 351 | 0.1700 | $59.59 | $59.59 | |
TX | 12,501 | 12,501 | 2,377 | 2,454 | (77) | 0.2000 | ($15.48) | ($15.48) | |
UT | 0 | 0 | 0.2450 | $0.00 | $0.00 | ||||
VA | 414 | 414 | 79 | 428 | (349) | 0.1600 | ($55.89) | ($55.89) | |
VA | Fuel Surcharge Calculations | 79 | 0.0350 | $2.75 | $2.75 | ||||
VT | 0 | 0 | 0.2600 | $0.00 | $0.00 | ||||
WA | 0 | 0 | 0.2800 | $0.00 | $0.00 | ||||
WI | 0 | 0 | 0.3150 | $0.00 | $0.00 | ||||
WV | 0 | 0 | 0.2535 | $0.00 | $0.00 | ||||
WY | 8,318 | 8,318 | 1,581 | 0 | 1,581 | 0.2536 | $401.04 | $401.04 | |
YT | 0 | 0 | $0.00 | $0.00 | |||||