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.
Built and reviewed by the FleetOpsClub research team. Preview it free below. Enter your name and email to unlock the full template and the editable spreadsheet — a CSV that opens in Excel, Google Sheets, or Numbers.
- Editable CSV — yours to keep
- Print or save as PDF
- No spam · unsubscribe anytime
What you get
- 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
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.
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 |
Free unlock
Unlock the full template
Enter your name and email to reveal the complete template and download the editable spreadsheet. You can print it, save it as a PDF, or adapt the columns to your own vehicles. It's a fair trade: the preview costs nothing, and the full file costs you about 20 seconds.
- Editable CSV
- Every row & section
- Branded PDF
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.
Related guides & tools
- Fuel card management: a complete guide
- How to reduce fleet fuel costs
- Glossary: Fuel card
- Fuel management software
Looking for more? Browse all fleet templates or run a fleet calculator.