Free fleet fuel card reconciliation template
Jump to download form ↓Enter your email below to download this fleet fuel card reconciliation template as a ready-to-use PDF.
Free fleet fuel card reconciliation template (PDF-ready). Match card transactions to vehicles, odometers and litres. Flag mismatches. Download free.
Commercial Director
Updated 18 May 2026
How to use: download the PDF, print or complete digitally on any device.
- PDF format, ready to print or fill on screen
- Use as-is or customise to suit your operation
- Go digital in MapTrack for photos, alerts and audit trails
Download free PDF template
Trusted by teams across Australia and New Zealand
We respect your privacy. Unsubscribe anytime.
Used by construction, mining and field service teams
What is a fleet fuel card reconciliation template?
A fleet fuel card reconciliation template is a worksheet finance and fleet teams use to match every fuel card transaction on the monthly statement against the vehicle, driver, odometer reading and litres pumped recorded in the fleet log. Each line on the card statement should pair to a corresponding entry in the fuel usage log, with rego, date and litres aligned within tolerance. Anything that does not match becomes an exception line for investigation: a missing log entry, a wrong vehicle, an unusually large fill, a weekend purchase, a non-fuel item or a transaction at a station outside the operating area.
Reconciliation matters because fuel cards are the single largest variable cost in most fleets and the most common vector for shrinkage, slippage and outright misuse. The Australian Taxation Office expects records that substantiate Fuel Tax Credit claims under the Fuel Tax Act 2006, and Chain of Responsibility duties under the Heavy Vehicle National Law require operators to keep accurate cost and consumption data for each prime mover. This template gives a structured way to compare card data to fleet data, document exceptions, assign a corrective owner and sign off the reconciliation before the period closes. Over time the exception log reveals the drivers, vehicles and sites that consistently fall outside policy, allowing fleet managers to tighten controls where they actually pay back.
Learn more about gps and fleet tracking in MapTrack.
Benefits of using this fleet fuel card reconciliation template
- Cost control: pairs every card transaction with a fleet log entry so unbilled or duplicate charges are caught before they hit the cost centre.
- Fraud detection: surfaces weekend fills, after-hours transactions, non-fuel items and unusually high litres against tank capacity for investigation.
- FTC substantiation: documents the litres and activity for each vehicle in line with ATO Fuel Tax Credit record-keeping requirements under the Fuel Tax Act 2006.
- Driver accountability: requires the driver name and odometer for each fill, creating a clear chain of custody for every dollar spent on fuel.
- Variance trending: monthly exception counts and dollar value per vehicle reveal high-risk drivers, sites and routes that need a tighter policy.
- Audit readiness: a signed monthly reconciliation provides documented evidence of internal control for external auditors, insurers and regulators.
- Budget accuracy: matched card and log data feed accurate cost-per-kilometre and cost-per-asset figures for fleet budgeting and lease decisions.
Benefits of digitising forms in MapTrack
When you digitise fleet vehicle forms in MapTrack, you get:
- Field users can easily scan a QR code to complete a form on mobile. Unlimited users.
- Automatically get alerts when faults are identified.
- Link every form digitally as a PDF to the relevant asset, location or person.
- Receive a digital PDF copy with every submission to your email.
- Ability to share forms digitally.
- Build conditional logic (show or hide questions based on answers).
- Take pictures or attach photos. Not possible with a paper-based form.
- Electronic signatures.
- Edit forms later without reprinting.
- Restrict permissions (who can view, complete or approve).
- Build forms with AI (describe what you need and MapTrack suggests the form).
- Monitor odometer and service-interval triggers across your entire fleet.
- Capture fuel receipts and trip logs alongside vehicle inspection data.
- Compare vehicle downtime and repair costs to inform replacement decisions.
Book a demo to see how MapTrack handles fleet vehicle forms.
Try MapTrack free for 30 days
Full access to every feature. No credit card required. Per-asset pricing so you scale as your fleet grows.
- No credit card required
- 30 days free trial
- Cancel anytime
Intuitive for field crews
“MapTrack's a great platform - intuitive for the guys out in the field and also has fantastic support.”
Matthew Anderson
Maintenance Planning Supervisor, Supagas
What to include in a fleet fuel card reconciliation template
This fleet fuel card reconciliation template covers 9 key areas:
- Reconciliation header: period covered, fleet or cost centre, reconciler name, supervisor approver and statement reference number.
- Per-transaction details: transaction date, fuel card number, vehicle rego, driver name and station or supplier.
- Quantity captured: litres dispensed, fuel type (diesel, ULP, premium, AdBlue) and unit price per litre on the card statement.
- Vehicle odometer reading at the time of the fill so litres can be compared against expected consumption since the last fill.
- Matching fleet log entry reference (row number or log ID) demonstrating the transaction has a corresponding driver-side record.
- Exception flag and reason code: no log match, wrong vehicle, after-hours, non-fuel item, over-tank-capacity, distance anomaly or station outside region.
- Corrective action and responsible owner with a target date for the driver, fleet supervisor or finance team to close the exception.
- Period totals: total litres, total card spend, exception count, exception dollar value and reconciled balance against the card statement.
- Driver and fleet manager sign-off: signatures and date once the reconciliation is complete and all exceptions are documented.
How to use this fleet fuel card reconciliation template
- Pull the monthly card statement and the fleet fuel log: download the fuel card provider statement for the period and export the matching rows from the fleet fuel usage log so both sources cover the same dates and cost centre.
- Match transactions one to one against the fleet log: walk down the card statement row by row, find the corresponding entry in the fleet log by rego, date and litres, and tick both rows once they pair within the tolerance allowed by your policy.
- Flag exceptions and assign a reason code: any card transaction without a matching log entry, or any log entry without a matching transaction, becomes an exception line tagged with a reason code such as no log match, wrong vehicle, after-hours or non-fuel item.
- Investigate every exception with the driver or supervisor: contact the driver or supervisor for each flagged line, request the receipt or trip notes, verify the rego and odometer, and update either the log or the exception register with the resolution.
- Calculate variance and consumption checks: sum total litres and total spend, compare against expected consumption based on kilometres travelled and historical litres per 100 km, and flag any vehicle outside a 15 percent variance for mechanical or behavioural review.
- Document outcomes and assign corrective owners: record the dollar value, reason and owner for every exception, set a target date for resolution and capture any policy or process change required to prevent recurrence in the next period.
- Obtain driver and fleet manager sign-off: the reconciler signs to confirm every transaction was checked, the fleet manager countersigns to approve the reconciled balance and any write-offs, and the completed file is retained for ATO and audit purposes.
In MapTrack, you can track your fleet with gps and digital pre-starts. Each submission is stored as a timestamped PDF against the asset record.
Get the free templateEnter your email above to download the full fleet fuel card reconciliation template as a PDF.Back to download formHow often should you complete this form?
Fuel cards should be reconciled at the same cadence as the card billing cycle, which for most Australian fleets is monthly. Reconciliation should be completed within five working days of the statement arriving so exceptions are still fresh enough for drivers and supervisors to recall the trip and provide receipts. Operators running larger fleets often complete a lightweight weekly reconciliation against the in-month transaction feed, then a full monthly close once the formal statement is issued. Annual reviews of card limits, allowed merchant categories and after-hours rules should sit alongside the monthly reconciliation so policy keeps pace with the exception trend.
Frequently asked questions
Applicable regulatory standards
This template aligns with the following regulations and standards:
- Fuel Tax Act 2006 (Fuel Tax Credits)
- Heavy Vehicle National Law (HVNL) Chapter 4
- ATO TR 2007/1 (records for FTC claims)
- WHS Act 2011 Section 19
Embed this free template on your website
Run an industry blog, trade association site, or training resource? Drop a preview of this free fleet fuel card reconciliation template straight into your page. The snippet is self-contained, needs no scripts, and links readers back to the full free template.
<div style="max-width:480px;font-family:system-ui,-apple-system,'Segoe UI',Roboto,sans-serif;border:1px solid #E5E7EB;border-radius:12px;padding:20px;background:#ffffff;">
<p style="font-size:12px;font-weight:700;letter-spacing:0.05em;text-transform:uppercase;color:#0E7490;margin:0;">Free template</p>
<p style="font-size:18px;font-weight:700;color:#071D49;margin:6px 0 0;">Fleet fuel card reconciliation template</p>
<ul style="margin:12px 0 0;padding-left:18px;color:#374151;font-size:14px;line-height:1.6;">
<li style="margin:4px 0;">Reconciliation header: period covered, fleet or cost centre, reconciler name, supervisor approver and statement reference number.</li>
<li style="margin:4px 0;">Per-transaction details: transaction date, fuel card number, vehicle rego, driver name and station or supplier.</li>
<li style="margin:4px 0;">Quantity captured: litres dispensed, fuel type (diesel, ULP, premium, AdBlue) and unit price per litre on the card statement.</li>
<li style="margin:4px 0;">Vehicle odometer reading at the time of the fill so litres can be compared against expected consumption since the last fill.</li>
<li style="margin:4px 0;">Matching fleet log entry reference (row number or log ID) demonstrating the transaction has a corresponding driver-side record.</li>
<li style="margin:4px 0;">Exception flag and reason code: no log match, wrong vehicle, after-hours, non-fuel item, over-tank-capacity, distance anomaly or station outside region.</li>
</ul>
<p style="font-size:13px;color:#6B7280;margin:14px 0 0;padding-top:12px;border-top:1px solid #E5E7EB;">Free <a href="https://www.maptrack.com/templates/fleet-fuel-card-reconciliation-template" style="color:#071D49;font-weight:600;text-decoration:none;">Fleet fuel card reconciliation template</a> by MapTrack</p>
</div>Please keep the “by MapTrack” attribution link in the snippet.
Need to track your fleet with gps and digital pre-starts?
Register every fleet vehicle in MapTrack, attach digital forms, and get a complete history of every inspection, service and compliance record.
GPS and fleet tracking · All templates · Pricing · Book a demo