How do I track fuel costs and mileage for a fleet?
Fuel cards are the foundation of fleet expense tracking. Assign one card to each vehicle, not to each driver. When Vehicle 14 fills up, that transaction automatically ties to Vehicle 14 regardless of who was driving. Most fuel card programs give you detailed reports showing gallons purchased, price per gallon, and location. This data flows into your accounting without manual entry.
Require odometer readings at every fill-up. Fuel cards can prompt drivers to enter the reading at the pump. If your cards don’t have this feature, use a simple log sheet in each vehicle. You need mileage to calculate cost per mile, which is the metric that actually tells you how your fleet is performing. A truck that uses more fuel might also drive more miles, so total fuel cost alone doesn’t tell you much.
Set up your accounting software to track expenses by vehicle. In QuickBooks, you can use classes or sub-accounts for each vehicle. Every fuel purchase, oil change, tire replacement, and repair gets coded to that specific vehicle. At month end, you can see total operating cost per vehicle and compare them. A vehicle costing significantly more per mile than others might need mechanical attention or might be due for replacement.
GPS telematics systems automate mileage tracking entirely. They record every trip, calculate fuel efficiency in real time, and flag unusual activity like excessive idling or after-hours use. The upfront cost is higher than manual tracking, but for transportation and logistics companies running more than a few vehicles, the data quality and time savings usually justify it.
Calculate cost per mile monthly. Add up all expenses for a vehicle, including fuel, maintenance, insurance allocation, and any lease or depreciation, then divide by miles driven. This number lets you compare vehicles fairly and helps you bid jobs accurately if you’re billing customers based on mileage or delivery costs.
Keep documentation organized for tax purposes. The IRS allows business vehicle deductions using either the actual expense method or the standard mileage rate, but you need records to support either approach. For company-owned fleet vehicles, actual expenses are typically the better choice and require receipts plus mileage logs. Fuel card statements work well as documentation, but you still need mileage records to show business use.
Review your fleet reports monthly, not just at year end. Sudden changes in fuel efficiency often signal mechanical problems. A vehicle getting 30% worse mileage than usual might have a maintenance issue that costs less to fix now than later. Tracking also catches things like fuel theft or personal use that would otherwise go unnoticed.
A small business bookkeeping service can set up vehicle tracking in your accounting system and generate the reports you need to manage fleet costs effectively. The tracking itself takes discipline, but once the system is in place, the insights are worth far more than the effort.
The Merrimack Valley's Trusted Accounting Partner
The Next Step:
A 15-Minute Call
Tell us about your business and what you're dealing with. We'll listen, ask a few questions, and give you a straightforward quote.
More Questions
How do I give my accountant access to my QuickBooks file?
In QuickBooks Online, go to Settings, then Manage Users, and invite them as an Accountant user. For QuickBooks Desktop, you'll either create an Accountant's Copy or share the file directly.
Read answerHow do I classify workers correctly to avoid IRS penalties?
The IRS evaluates three factors: behavioral control, financial control, and the type of relationship. Massachusetts applies an even stricter test. Getting this wrong means back taxes, penalties, and interest that add up fast.
Read answerHow do I separate personal and business finances?
Open a dedicated business bank account and use it exclusively for business transactions. Get a business credit card, pay yourself through regular documented transfers, and track everything through accounting software from day one.
Read answerWhat financial reports should a healthcare practice review?
Healthcare practices should review standard financial statements plus industry-specific reports like accounts receivable aging by payer, collections rate, and revenue by service type. The AR aging report matters most because insurance reimbursement drives cash flow.
Read answerHow do I handle tip reporting and tip pooling for employees?
Employees must report tips over $20 per month to you, and you include those tips in payroll for tax withholding. Tip pooling rules depend on whether you take a tip credit. Massachusetts has stricter requirements than federal law.
Read answerWhat are the sales tax obligations for Shopify store owners?
Your sales tax obligations depend on where you've established nexus, usually through sales volume. Most states require collection once you exceed $100,000 in sales or 200 transactions, and you'll need to register, collect, and file returns in each state.
Read answer

