How should IFTA-style fuel and mileage records connect to bookkeeping?
IFTA filings report total miles driven and gallons purchased by jurisdiction. Your bookkeeping records fuel as an expense and mileage as supporting data for vehicle costs. These are two different views of the same activity, and they have to agree. When they don’t, either your tax filing is wrong or your financials are wrong, and you won’t know which until someone audits you.
Start with the source documents. Every gallon of fuel purchased should have a receipt or a fuel card transaction record showing date, location, gallons, price, and which truck filled up. Fuel card statements consolidate these into a monthly bill. Your bookkeeping should record fuel expense in totals that match those statements down to the penny. If your fuel card statement shows $14,287 in purchases for the month, that’s what posts to fuel expense in the books.
Mileage comes from ELDs, GPS systems, or driver logs. The total miles each truck runs in a quarter should match what gets reported on the IFTA return. If your ELD shows 47,200 miles for truck 102 and the IFTA filing reports 45,800, something is missing or counted wrong. The same applies to fuel. Gallons reported on the IFTA return should equal gallons recorded in your books for that period, broken out by jurisdiction.
Reconcile monthly, not quarterly. Pull the fuel card statement and tie it to fuel expense in QuickBooks. Pull the mileage report and verify it against dispatch records and driver logs. Spot discrepancies while the activity is fresh. Waiting until you’re preparing the IFTA return means trying to remember why a fuel purchase in South Carolina doesn’t show up on the card statement six weeks later.
Track fuel and mileage by unit when possible. A single fuel expense line for the whole fleet tells you nothing about which trucks are running over budget. Coding fuel to each truck lets you see cost per mile by unit, spot fuel theft, and identify equipment that needs attention. This level of detail also makes IFTA prep easier because the data is already organized.
For trucking companies and other freight and logistics operations, the chain has to be unbroken. Receipts support the fuel card statement. The fuel card statement supports the bookkeeping entry. The bookkeeping entry supports the IFTA filing. When an auditor asks why your Q2 IFTA gallons are 12,000 but your books show 11,400 in fuel for the same period, you need to have an answer that doesn’t involve guessing.
The same discipline applies to mileage. IFTA jurisdictions can audit fuel tax filings going back several years, and they will ask for source documents. ELD reports, trip sheets, dispatch records, and fuel receipts all need to be retained and consistent with what was filed. Clean small business accounting, bookkeeping and tax services in Jacksonville, NC make this straightforward because the reconciliation happens as part of the regular monthly close, not as a panic exercise when a notice arrives.
Trusted Accounting for Small Businesses
First Step:
Start With a Call
Tell us about your business and what you need help with. We'll ask a few questions, evaluate your current situation, and let you know how GMJ can support your books, taxes, and day-to-day operations.
More Questions
How should delivery app sales and fees be recorded in QuickBooks?
The bank deposit from DoorDash or Uber Eats is not your sales figure. You need to record gross sales, commissions, sales tax, tips, refunds, and the net deposit separately for each platform so your books reflect what actually happened.
Read answerWhat is the difference between inventory accounting and ecommerce bookkeeping?
Inventory accounting focuses on tracking stock levels, cost of goods sold, and product valuation. Ecommerce bookkeeping covers all of that plus reconciling sales channels, payment processors, fees, refunds, and sales tax.
Read answerWhen does a small business need fractional CFO support?
When your business has grown past what a bookkeeper can answer but isn't big enough to justify a full-time CFO salary. Common triggers include cash flow surprises, pricing decisions made without data, financing conversations, and adding locations or product lines.
Read answerWhat should a Wilmington cafe track for sales tax, payroll and cash flow?
A Wilmington cafe needs daily POS reconciliation, a separate sales tax payable account, clean tip and payroll records, vendor bill tracking, weekly food cost reviews, and a seasonal cash plan that accounts for the swing between summer tourist traffic and quieter winter months.
Read answerWhat should a small nonprofit do if prior-year books do not match the last Form 990?
Reconcile beginning balances in the books to what was reported on the last filed Form 990, document every adjustment you make, and have a tax professional decide whether the prior return needs to be amended.
Read answerHow should healthcare practices track payroll, contractor payments and benefits?
Healthcare practices need separate payroll categories for providers, clinical staff, and administrative employees, plus careful tracking of 1099 contractors, benefits, and retirement contributions. Monthly reconciliation of payroll liabilities keeps the practice clean for tax filings and audits.
Read answer
