How to Record Actual Fuel Consumption by Moving Costs from Prepaid Fuel to Expense
Recognizing fuel expense when drivers draw from prepaid fuel cards, reducing the prepaid asset balance.
| Account Name | Type | Debit ($) | Credit ($) |
|---|---|---|---|
| Fuel & Oil Expense | Expense (+) | 500.00 | - |
| Prepaid Fuel | Asset (-) | - | 500.00 |
💡 Accountant's Note
Following the fuel card top-up entry, this recognizes the actual expense when the truck is refilled.
Practitioner & Systems Framework
💻 ERP Architecture
The fuel card provider sends a transaction file (daily or weekly) showing each fill by card number, vehicle, date, litres, and amount. Import this file into the ERP and auto-post: debit Fuel & Oil Expense, credit Prepaid Fuel. Allocate fuel expense by vehicle (fleet code) and by trip (if trip-level cost accounting is used). Calculate fuel efficiency (litres per km or MPG) per vehicle monthly — significant deviations from the vehicle's standard consumption indicate unauthorized use, engine problems, or fuel theft. For client-billed jobs, allocate actual fuel cost to the job for margin analysis.
⚠️ Audit Flags
Auditors compare total fuel consumed (litres × price) to total km driven × expected litres per km — unexplained variances suggest fuel theft or unauthorized use. They also verify that the Prepaid Fuel balance at period-end is not negative (which would indicate more fuel has been expensed than was topped up — a booking error). Fleet telematics data (GPS) should corroborate the fuel card transactions — a fill at a location where the vehicle was not present is a fraud indicator.
📄 Required Documentation
Fuel card transaction file (vehicle, driver, date, litres, amount), Prepaid Fuel drawdown entry, Fuel & Oil Expense ledger by vehicle, km-driven log per vehicle, fuel efficiency analysis (litres per 100km per vehicle), GPS telematics corroboration, and period-end Prepaid Fuel balance reconciliation.
Automate this entry with the JEH Accounting Suite
Stop doing manual entry. Our VBA-powered ERP automatically generates your ledgers, Trial Balance, and Financial Statements.
No Subscriptions. Own your data.
Expert Analysis by Qusai Ahmad
General Accountant Supervisor & IFRS Specialist
Specialized in SAP GUI automation and Middle Eastern tax compliance. Building digital tools for the next generation of finance leaders.