Tag: Excel Export

DOT Compliance Experts

FAQs

100

What Additional Compliance Features Are Planned?
How Does Advanced IFTA Support Overall Compliance?
Can Advanced IFTA Identify NY HUT Reporting Issues?
Can Advanced IFTA Identify 2290 Filing Issues?
Can Advanced IFTA Help Identify IRP Exceptions?
What Other Mileage and Weight Taxes Are Tracked?
What is New York HUT?
What is Form 2290?
What Is IRP?
How Does IFTA Relate to IRP?
What Happens If Records Are Missing?
Can Advanced IFTA Identify Audit Risks?
How Do I Respond to an Audit Request?
What Are Common Audit Findings?
How Can I Reduce Audit Risk?
What Documentation Should Be Available?
How Does Advanced IFTA Help Prepare for Audits?
What Triggers an IFTA Audit?
How Long Should IFTA Records Be Retained?
What Records Are Required During an IFTA Audit?
How Do Exceptions Affect Audits?
How Should Exceptions Be Resolved?
What is a Fuel Purchase Variance Exception?
What is a High MPG Exception?
What is a Low MPG Exception?
What is a Missing Fuel Exception?
What is a Missing Mileage Exception?
What Exceptions Does Advanced IFTA Identify?
Why Are Exception Reports Important?
What is an Exception Report?
Can Routes Be Saved for Future Use?
How Are State Miles Allocated?
Can Mileage Be Calculated for Previous Quarters?
How Do I Correct Missing Trips?
Can Calculated Mileage Be Added Directly to Adjustments?
How Accurate Is Calculated Mileage?
Can Interim Stops Be Included?
How Does Route Mileage Calculation Work?
When Should the Mileage Calculator Be Used?
What is the Mileage Calculator?
How Do Adjustments Affect Tax Liability?
Can Adjustments Be Made After Filing?
What Documentation Should Support Adjustments?
How Are Adjustments Reflected in Reports?
Can Adjustments Be Deleted?
Can Adjustments Be Edited?
How Do I Enter a Fuel Adjustment?
How Do I Enter a Mileage Adjustment?
When Should Adjustments Be Used?
What Are IFTA Adjustments?
What Happens When ELD Data Conflicts With Fuel Records?
How Do I Verify Imported Mileage?
What If a Vehicle Changes ELD Providers?
Can Multiple ELD Providers Be Used?
How Are Unidentified Driving Events Handled?
Can I Manually Correct ELD Mileage?
What If ELD Data Is Incomplete?
How Often Is ELD Data Updated?
Which ELD Providers Are Supported?
How Does Advanced IFTA Import ELD Data?
How Long Should Fuel Receipts Be Retained?
What is Tax-Paid Fuel Credit?
How Are Fuel Purchases Allocated by State?
Can Fuel Be Claimed Without a Receipt?
What Happens if Fuel Receipts Are Missing?
How Do I Report DEF Purchases?
How Do I Report Bulk Fuel?
Can I Use Credit Card Statements as Proof of Purchase?
What Information Must Appear on a Fuel Receipt?
What Fuel Receipts Are Required?
What Documentation Supports Mileage Records?
How Do I Report Mileage from a Rental Vehicle?
What if a Driver Forgets to Log a Trip?
How Do I Correct Mileage Errors?
How Are Deadhead Miles Treated?
What Are Non-Revenue Miles?
Are OFF-Road Miles Reported?
How Do I Report Personal Conveyance Miles?
What if My ELD Misses Mileage?
How is State Mileage Determined?
What Records Should I Retain?
What Reporting Periods Are Required?
How Do I Calculate Fleet MPG?
What is Non-Taxable Fuel?
What is Taxable Fuel?
How Do I Report Tax-Paid Fuel?
What Fuel Purchases Qualify for IFTA?
What Mileage Must Be Reported?
How Are IFTA Taxes Calculated?
What Information is Required for an IFTA Filing?
Who is Required to File IFTA?
What Vehicles Qualify for IFTA?
What is a Qualified Motor Vehicle?
How Often Must I File IFTA?
What Happens if I Don’t File IFTA?
Which States Participate in IFTA?
How Do I Obtain an IFTA License?
What Are IFTA Decals?
When Should Decals Be Displayed?
What Is IFTA?

Exception Reports

13

Virginia VRT Exception Specifications
Oregon WMT Exception Specifications
New Mexico WDT Exception Specifications
Kentucky KYU Exception Specifications
Connecticut HUF Exception Specifications
New York HUT Exception Specifications
Form 2290 Exception Specifications
MCS-150 Exception Specifications
IRP Exception Specifications
IFTA Exception Specifications
Trucking Compliance Filings Spreadsheet
IFTA Carrier Knowledge FAQ
IFTA Audit Risk and Exception Prevention Guide

Troubleshooting

95

Compliance Deadline Reminder Not Received
Audit Package Missing Fuel Receipt Images
Exception Report Shows Resolved Items
Support Document or Guide Link Is Broken
User Can’t Download Attached Documents
Exported Spreadsheet Columns Do Not Fit on Printed Page
Company Information Is Incorrect On Reports
Quarter Was Selected Incorrectly
State Miles Show Zero for an Active Vehicle
Route Mileage Differs from Drivers Actual Route
Bulk Fuel Withdrawal Assigned to Wrong Vehicle
Fuel Receipt Uploaded to Wrong Quarter
New Vehicle Not Appearing in Current Quarter
Vehicle Was Sold or Removed but Still Appears in Reports
ELD Provider API is Temporarily Unavailable
Tax Credit Carryover Missing
Filing Submitted but Not Reflected
Filing Status Not Updating
Prior Quarter Data Missing
State Tax Rate Appears Incorrect
Quarterly Filing Missing Vehicles
Filing Totals Changed Unexpectedly
Amended Return Not Calculating Correctly
Filing Locked and Can’t Be Modified
Return Can’t Be Finalized
Exception Report Missing Vehicles
Adjustment Can’t Be Deleted
Adjustment Linked to Wrong Quarter
Adjustment History Missing
Unsupported Adjustment Detected
Fleet MPG Appears Unrealistic
Exception Report Numbers Do Not Match Filing Totals
Vehicle Appears on Exception Report Unexpectedly
Missing Mileage Exception Will Not Clear
Missing Fuel Exception Will Not Clear
Fuel Purchase Missing Gallons
Fuel Receipt Date Incorrect
Fuel Purchase Appears Twice
Fuel Tax Credit Lower Than Expected
Bulk Fuel Records Missing
Fuel Card Transactions Not Importing
Fuel Purchase Assigned to Wrong Driver
Fuel Purchase Assigned to Wrong Vehicle
Fuel Receipt Image Too Blurry
OCR Fuel Receipt Not Reading Correctly
Rental Vehicle Mileage Not Included
Deadhead Mileage Missing
Personal Conveyance Mileage Missing
Jurisdiction Mileage Missing
Odometer Does Not Match Reported Mileage
Vehicle Mileage Suddenly Decreased
State Border Crossing Not Recorded
Mileage Calculator Not Saving Results
Toll Route Selected Instead of Preferred Route
Mileage Calculator Route Longer Than Expected
ELD Provider Connection Lost
Vehicle Not Reporting Movement
Vehicle Assigned to Wrong Driver
Driver Assigned to Wrong Vehicle
Imported Mileage Differs from ELD Portal
Duplicate ELD Trips Imported
GPS Data Missing
ELD Sync Taking Too Long
ELD Credentials Invalid
ELD Connection Expired
Quarterly Filing Totals Do Not Match Expectations
Data Does Not Match Another System
Contacting Support
Pages Not Loading Properly
System Running Slowly
Audit Risk Score Too High
Missing Audit Documentation
User Can’t Access Features
Vehicle Not Available For Selection
Credit Balance Appears Incorrect
Tax Due Appears Incorrect
PDF Export Problems
Report Will Not Generate
Low MPG Exception
High MPG Exception
Excessive Exceptions Reported
Unable to Edit Adjustment
Adjustments Not Appearing in Reports
State Mileage Appears Incorrect
Route Can’t Be Calculated
Duplicate Fuel Purchases
Fuel Purchases Not Appearing In Reports
Missing Fuel Receipts
Total Fleet Mileage Appears Too Low
State Mileage Does Not Match Expected Values
Missing ELD Trips
Vehicle Missing From ELD Import
Password Reset Email Not Received
ELD Data Not Importing
Unable to Log In

Audit Readiness

20

How Advanced IFTA Helps You Stay Audit Ready
Audit Risk Indicators
Building an Audit Package
Annual Audit Review Procedures
Quarterly Audit Review Procedures
Monthly Audit Review Procedures
Using Exception Reports to Reduce Audit Risk
Missing State Mileage and Audit Risk
Duplicate Fuel Transactions and Audit Risk
Unsupported Adjustments and Audit Risk
Missing Mileage and Audit Risk
Missing Fuel Receipts and Audit Risk
Common IFTA Audit Findings
Required Vehicle Documentation
Required Filing Documentation
Required Fuel Documentation
Required Mileage Documentation
Audit Ready Checklist
What Auditors Look For
Understanding IFTA Audits

View Categories

Home
Advanced IFTA Knowledge Base
Excel Export

Excel Export

Exported Spreadsheet Columns Do Not Fit on Printed Page

New Windsor, MD. 21776

support@atsfleetmanagement.com

(570) 445-8805