Fuel Management · Excel template
Free Fuel Card Reconciliation Sheet
A fuel card reconciliation sheet that matches each card transaction to a driver, vehicle, and receipt, so off-policy purchases, mismatched gallons, and possible card abuse surface before the statement closes. Use it alongside our fleet calculators to size the costs this template tracks, or browse fleet management software when you are ready to automate the workflow. See all downloads in the template library, and check the fleet glossary for any unfamiliar terms.
Built and reviewed by the FleetOpsClub research team. Preview it free below.
- A line per transaction: date, card, driver, vehicle, gallons, and amount
- Odometer and resulting MPG columns to flag fills that don't fit the vehicle's pattern
- A receipt-matched flag and variance column to catch missing or mismatched purchases
- An exception note field for off-hours, off-route, or off-product transactions
- Editable CSV. Yours to keep
- Print or save as PDF
- No spam · unsubscribe anytime
How to use it
- 1
Import or enter each fuel card transaction from the provider statement.
- 2
Assign each transaction to the correct driver and vehicle by card number.
- 3
Enter the odometer at fill and let the sheet compute miles and MPG against the prior fill.
- 4
Match each line to a receipt and flag any transaction with no receipt or a quantity mismatch.
- 5
Investigate exceptions (abnormal gallons, off-hours fills, premium fuel on a diesel unit) before approving the statement.
What's inside
- A line per transaction: date, card, driver, vehicle, gallons, and amount
- Odometer and resulting MPG columns to flag fills that don't fit the vehicle's pattern
- A receipt-matched flag and variance column to catch missing or mismatched purchases
- An exception note field for off-hours, off-route, or off-product transactions
- A worked example showing a normal fill, an MPG outlier, and a flagged exception
Preview the template
Here's a real sample of the layout — the actual columns and structure you'll work in. The complete template, plus the editable spreadsheet, unlocks the moment you enter your email.
Preview
Fuel Card Reconciliation Sheet
MPG = miles since last fill ÷ gallons. A figure far outside a vehicle's normal range can signal a missed odometer entry, a fill into the wrong tank, or card misuse.
| Date | Card / Last 4 | Driver | Vehicle | Gallons | Amount ($) | MPG | Receipt? | Exception |
|---|---|---|---|---|---|---|---|---|
| 06/14 | 4471 | J. Alvarez | TRK-007 | 118.2 | 412.30 | 6.4 | Yes | — |
| 06/15 | 4472 | M. Boateng | VAN-014 | 21.0 | 73.50 | 3.1 | Yes | Low MPG: check odometer |
Frequently asked questions
Quick answers to the questions buyers usually ask once the category, software, or rollout details start getting more specific.
Fuel card reconciliation is the process of matching every fuel card transaction to a driver, vehicle, and receipt, then checking each one against expected fuel use. It catches missing receipts, data errors, and potential card misuse before the statement is paid.
Fills that exceed a vehicle's tank size, transactions while the vehicle is parked or off-route, premium fuel on a diesel unit, and MPG figures far outside the norm are all red flags that a reconciliation sheet surfaces line by line.
Reconcile at least each statement period, but weekly is better for larger fleets. The sooner an exception is found, the easier it is to investigate while the driver still remembers the fill.
Provider controls (product locks, gallon limits, time-of-day rules) prevent many issues, but reconciliation against your own odometer and receipt data still catches errors and patterns the card network can't see.