Tax Data - IFTA Calculation
Trucker Software - IFTA
Nautilus was not designed specifically for IFTA. The IFTA calculation is just yet another feature in this software. While you are using Nautilus to track your finances, loads and miles it tracks IFTA for you as an added convenience. NAUTILUS IS NOT IFTA ONLY SOFTWARE
Download complete Guide to the International Fuel Tax Agreement
The link above is a complete guide that describes how to prepare IFTA. The Nautilus IV trucker software gives you IFTA calculator that will help you to fill out the necessary forms. The calculator gathers data automatically from the trips and presents the driver with the table which is used to fill out the IFTA forms. See the link above for complete instructions on how to prepare IFTA. Calculate IFTA with Nautilus IV
If you enter your odometer miles Nautilus IV will calculate your IFTA automatically. However it is limited to diesel fuel only. Below is the IFTA output screen:
Provided you have entered your state mileage and gallons purchased the
calculation will be done in seconds and you can send it to printer.
Company: B & S Trucking
Driver: John Doe
From 2007-07-01 to 2007-09-30
--------+-----------+-----------+-----------+-----------+-----------+-----------+-----------+---------
State | Mileage | Gallons | Fuel Used | Diff | Tax paid | Tax rate | Mile Tax | IFTA
--------+-----------+-----------+-----------+-----------+-----------+-----------+-----------+---------
AL | 373 | 0.00 | 68.00 | 68 | $0.00 | $0.19 | $0.00 | $12.93
AR | 339 | 0.00 | 62.00 | 62 | $0.00 | $0.22 | $0.00 | $13.96
AZ | 897 | 424.73 | 163.00 | -261.73 | $110.43 | $0.26 | $0.00 | -$68.04
CA | 2,425 | 235.39 | 441.00 | 205.61 | $86.39 | $0.37 | $0.00 | $75.46
CO | 1,192 | 0.00 | 217.00 | 217 | $0.00 | $0.20 | $0.00 | $44.49
IA | 1,802 | 206.06 | 328.00 | 121.94 | $46.36 | $0.22 | $0.00 | $27.44
IL | 747 | 0.00 | 136.00 | 136 | $0.00 | $0.37 | $0.00 | $49.92
S/C IN | 0 | | 19.00 | | | $0.11 | | $2.09
IN | 104 | 179.68 | 19.00 | -160.68 | $28.75 | $0.16 | $0.00 | -$25.70
KS | 617 | 0.00 | 112.00 | 112 | $0.00 | $0.26 | $0.00 | $29.13
MI | 610 | 0.00 | 111.00 | 111 | $0.00 | $0.30 | $0.00 | $33.75
MN | 2,817 | 951.94 | 512.00 | -439.94 | $190.39 | $0.20 | $0.00 | -$87.98
MO | 1,235 | 276.05 | 225.00 | -51.05 | $46.93 | $0.17 | $0.00 | -$8.67
MS | 198 | 0.00 | 36.00 | 36 | $0.00 | $0.18 | $0.00 | $6.49
ND | 141 | 0.00 | 26.00 | 26 | $0.00 | $0.23 | $0.00 | $5.99
NE | 1,161 | 383.06 | 211.00 | -172.06 | $103.43 | $0.27 | $0.00 | -$46.45
NM | 785 | 0.00 | 143.00 | 143 | $0.00 | $0.21 | $0.04 | $64.40
NV | 876 | 112.21 | 159.00 | 46.79 | $30.30 | $0.27 | $0.04 | $47.68
OH | 218 | 198.14 | 40.00 | -158.14 | $55.48 | $0.28 | $0.00 | -$44.27
OK | 676 | 307.45 | 123.00 | -184.45 | $39.97 | $0.13 | $0.00 | -$23.97
SD | 1,879 | 158.29 | 342.00 | 183.71 | $34.82 | $0.22 | $0.00 | $40.42
TN | 233 | 0.00 | 42.00 | 42 | $0.00 | $0.17 | $0.00 | $7.15
TX | 1,954 | 329.36 | 355.00 | 25.64 | $65.87 | $0.20 | $0.00 | $5.13
UT | 1,413 | 105.24 | 257.00 | 151.76 | $25.78 | $0.24 | $0.00 | $37.19
WI | 1,590 | 69.90 | 289.00 | 219.1 | $23.00 | $0.33 | $0.00 | $72.09
WY | 1,803 | 803.77 | 328.00 | -475.77 | $112.53 | $0.14 | $0.00 | -$66.60
______________________________________________________________________________________________________
Total Gallons : 4,741.27
Total Miles : 26,085.00
: ----------
MPG : 5.50
Total IFTA : $204.03
Report produced on Thu Mar 27 11:11:17 GMT-06:00 2008
Report produced with Nautilus IV © www.largosoftware.com
Nautilus does not prepare your IFTA, but it compiles the data from your trips to help you prepare your IFTA. Your IFTA data is only as good as the data you enter in your trip sheets!
Calculate IFTA by hand?If you are not using Nautilus, below are the formulas that help you prepare the FUEL TAX PORTION of IFTA by hand with a calculator and a piece of paper.
You can do this with a calculator or you can have our software do this for you.
Fuel tax for IFTA is calculated based
on four variables. The amount of fuel bought in each state, the
number of miles traveled through each state, the overall fuel mileage
and the tax rate for the given quarter.
As driver enters the fuel purchase data and
odometer reading in each state Nautilus IV automatically collects and
calculate the first three variables.
The fuel bought in each state is
entered under Trips Sheets / Expenses, the state mileage is entered
under Trip Sheets / Odometer. The fuel mileage is calculated based on
that data. The only missing variable is the tax rate in each given
state or province. This information can be either downloaded directly
form the Largo Software website or entered in to the [IFTA matrix] by the
user using the tables available at http://www.iftach.org/
If you create an IFTA matrix yourself you have
to specify the time frame to indicate the start and end date of the
quarter for which you are compiling your IFTA.
The accuracy of the IFTA report depends on accuracy
of your data and IFTA matrix.
NOTE: This calculator only gives you diesel
fuel tax. If you travel through states that require mile tax (highway
use tax) paid you need to contact the authority of those states to
find out exactly what the highway tax is for your vehicle. You can then edit your IFTA matrix and run the calculation.
The IFTA math is as follows:
R – tax rate specified in the IFTA
matrix for each state
SuR – Surcharge tax rate in states:
KY, VA and IN.
MT - Mile Tax (applicable in some
states like for instance New Mexico)
FM (Fuel Mileage) - The fuel mileage is
calculated based on all the miles recorded during the quarter divided
by all the fuel bought during that quarter.
M (Mileage in state) – Gathered for
each state from the recorded trips that fall in to the time frame for
the quarter.
F (Fuel bought per state) – Gathered
for each state from the recorded trips that fall in to the time frame
for the quarter.
FU (Fuel used per state) – Is
calculated based on the fuel mileage multiplied by the number of
miles in state
[FU = FM * M]
TP (Tax paid in the state) – Is
calculated by multiplying the tax rate for the state by the gallons
bought in that state:
[TP = F * R]
D (Difference) – is Gallons of fuel
bought in the state minus the gallons used based on the fuel mileage
and miles driven in the state:
[D = F – FU]
FT (Fuel tax owed / refund for the
state) for state is Difference times the tax rate:
IFTA FORMULA
+----------------------------------------------------------------+
| [Fuel tax] [Surcharge tax] [Mile tax] |
| IFTA = (R * (F - (FM * M))) + (SuR * (FM * M)) + (MT * M) |
+----------------------------------------------------------------+
For instance you have bought 424.73
gallons of fuel in state of AZ and you drove 534 miles in that state.
Your fuel mileage this quarter is 4.96 so you “used” 108 gallons
of fuel in AZ and the difference is 424.72 – 108 = -316.73. The tax
rate for AZ this quarter is $0.19. so -316.73 * $0.19 = -$82.35. You
are getting a refund for state of AZ of $82.35
SuCh - (Surcharge) In states of KY, IN
and VA in addition to the regular tax there is a surcharge tax. For
those states you will be paying an additional fee which is Fuel Used
multiplied by the tax rate. [SuCh = FU * SuR]
In addition to all of that there is a
Mile tax. The mile tax is not introduced in all states. Check with
the states you are traveling through if the Mile tax applies to you.
The Mile tax is calculated simply by multiplying the tax rate by
miles traveled in the state.
When you enter the required data you
should save the file. The file should be saved in to
C:\Nautilus\matrix\ directory. This is the default location for the
IFTA matrix files.
| 
