IFTA Quarterly
This report will show quarterly fuel purchases per state with gallons of fuel purchased and tax paid, owed, and a balance.
IFTA Data
IFTA Data is only stored for the last 4 Quarters. Reports should be saved to use yearly calculations, as you will not be able to run reports in Ditat for more than 4 quarters in the past.
ELD Miles
Miles are pulled from Samsara once a month, starting on the 4th day of a month, if the miles are not available the system will continue to try and pull the miles until they are collected. Miles are collected per truck, per state, per month.
IFTA Quarterly Parameters
Report Parameters
Field | Description |
Quarter | Choose which quarter this report should be run for. |
Country | Select which country to see results for. |
Fuel type | Select which fuel type the report should be run by. |
Truck | If a truck is selected, only data for that truck will be shown. |
Truck company | If a truck company is selected, only trucks running for that company will be displayed. |
Group by truck | Check this box if the report should be grouped by truck. Totals when grouped by truck may differ due to calculations that are based on MPG. MPG per truck can differ from company total which changes the end result. |
Truck groups | If a truck group is selected, only trucks in that group will display. |
Include TONU trips | Check this box if the report should include TONU trips. |
Only posted trips | Check this box if the report should only display posted trips. |
Miles | Select whether you would like to see results according to Dispatch miles or ELD miles (Samsara) |
View | Select a view for how you’d like results to be displayed. |
IFTA Quarterly Results
Report Columns
Field | Description |
State | State abbreviation |
Miles | Miles for each state |
MPG | Miles per gallon MPG = Total Miles / Total Gallons consumed |
Gallons purchased | Gallons purchased in each state Gallons purchased is provided from imported fuel transactions. |
Gallons consumed | Gallons consumed in each state Gallons consumed = State Miles / MPG |
Extra gallons purchased | Number of extra gallons purchased Extra gallons purchased = Gallons Purchased - Gallons consumed |
Tax rate | Tax rate per state Tax rate is an imported figure. |
Pump rate | Pump rate Pump rate is an imported figure. |
Tax owed | Tax owed for each state Tax owed = Gallons consumed X Tax rate |
Tax paid | Tax that has been paid for each state Tax paid = Gallons purchased X Tax rate |
Balance | Remaining balance Ballance = Tax owed - Tax paid |