[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
         

[1]
Cells with Red Triangles in the upper right hand corners have information about how to use certain areas of this program.  This IFTA calculation page will do the correct calculations for each jurisdiction.  After complete a quartly IFTA report, save the program as example; IFTA Report 1Q2004. 
[2]
There must be a value entered in this cell at all times.  You can change the value any time by typing over it.
[3]
The column to the right is the column net total.  Red is the amount you pay.  Black is the amount of refund.
[4]
Tax Rate values can be changed at any time just by typing over them with the correct value.    Before the report is complete make sure the calculation values are current with the quarter being filed.