Skip to main content
MapTrack
Skip to download form

Free fuel reconciliation log template

Jump to download form ↓

Enter your email below to download this fuel reconciliation log template as a ready-to-use PDF.

Free fuel reconciliation log template. Reconcile fuel card transactions against driver logs, with variance flagging, FBT and GST evidence per ATO rules.

Jarrod Milford

Jarrod Milford

Commercial Director

Updated 25 May 2026
Also see:GPS and fleet tracking →Best fleet management software (AU) →MapTrack vs Fleetio →

Updated 25 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

FreePDFUpdated May 2026

Get your free template

Enter your email to download the fuel reconciliation log template as a free PDF. No sign-up required to use it.

Rated 4.9 on G2Rated 4.9 on Capterra
Your info is secure. No spam, ever.

These templates are free general guides provided as-is. They do not constitute legal, safety or compliance advice. You are responsible for ensuring any form meets your specific workplace obligations, industry standards and applicable regulations.

G2 rating 4.9 out of 5Capterra rating 4.9 out of 5

Trusted by teams across Australia and New Zealand

We respect your privacy. Unsubscribe anytime.

Used by construction, mining and field service teams

Saunders InternationalMineral ResourcesSupagasHacer GroupMetro TunnelUltrabuiltDraintechGenusAxis Services GroupRIXDFES Western AustraliaSaunders InternationalMineral ResourcesSupagasHacer GroupMetro TunnelUltrabuiltDraintechGenusAxis Services GroupRIXDFES Western Australia

What is a fuel reconciliation log template?

A fuel reconciliation log template is a periodic document a fleet operator uses to reconcile fuel card transactions against the actual fuel dispensed into a vehicle as recorded by the driver log and the odometer reading. It captures the vehicle ID, the fuel card number, the reconciliation period (typically weekly or monthly), the opening and closing odometer readings, the kilometres travelled, the litres dispensed per the fuel card transaction report, the litres claimed by the driver against the same period, the variance in both litres and percent, the dollar cost per litre and per kilometre, a variance flag where the gap exceeds the site threshold (typically 5 percent) that triggers an investigation, and dual sign-off from the driver and the fleet manager. The document is the control point that catches fuel card misuse, refuelling at the wrong pump, theft, unrecorded private use and odometer-misreading errors before they roll into the cost-per-kilometre report unchallenged.

The workflow runs from fuel card transaction extract through to driver log capture, side-by-side reconciliation, variance flagging, investigation of any flagged entries, sign-off and posting into the cost-per-kilometre report. AS/NZS ISO 39001 (Road traffic safety management systems) sets the broader fleet management system expectation that fuel data feeds risk and cost reviews. The Heavy Vehicle (Fatigue Management) National Regulation requires odometer and route records that the reconciliation log directly draws on. Australian Tax Office substantiation rules carry the parallel financial duty: the log is the primary evidence supporting Fringe Benefits Tax (FBT) calculations for vehicles with private use, and the fuel card transaction list (with reconciliation back to actual business use) is the document used to support GST input tax credit claims on fuel purchases. In MapTrack the reconciliation log sits against the vehicle ID and the fuel card number with monthly reconciliations auto-generated for fleet manager sign-off and finance posting.

Learn more about gps and fleet tracking in MapTrack.

Benefits of using this fuel reconciliation log template

  • Fuel card misuse interception: variance flagging at the site threshold catches fuel card sharing, wrong-pump refuelling, theft and unrecorded private use before unit cost reports go out
  • FBT substantiation: the log is the primary evidence supporting Fringe Benefits Tax calculations on vehicles with mixed business and private use
  • GST input tax credit defence: the reconciliation back to actual business use is the document used to support GST claims on fuel purchases at an ATO audit
  • Driver accountability: dual sign-off from driver and fleet manager builds the audit trail that any variance was acknowledged and investigated by the driver
  • Cost-per-kilometre accuracy: validated litres-dispensed and kilometres-travelled feed the cost-per-kilometre report with confirmed figures rather than uncontested fuel card extracts
  • Period-on-period trending: monthly variance percent per vehicle exposes the assets and drivers with the consistent gaps that single-period reviews never surface
  • Finance posting evidence: the signed reconciliation log is the document finance uses to clear fuel card invoices and post the cost against the right cost centre

Benefits of digitising forms in MapTrack

When you digitise fuel reconciliation log process documents 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 fuel reconciliation log process documents.

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.

Start free trial
  • 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.”
Supagas

Matthew Anderson

Maintenance Planning Supervisor, Supagas

What to include in a fuel reconciliation log template

This fuel reconciliation log template covers 13 key areas:

  • Vehicle identification: fleet number, registration, VIN, make/model and assigned driver(s) for the reconciliation period
  • Fuel card details: card number, issuer (BP, Caltex, Shell, EG, Ampol, Mobil), card status and any restrictions on pump type or merchant category
  • Reconciliation period: start date, end date and reconciliation frequency (weekly, fortnightly, monthly)
  • Odometer readings: opening odometer, closing odometer, kilometres travelled in the period and any odometer rollover or replacement notation
  • Fuel card transactions: total litres dispensed per the fuel card report, total dollar cost, average dollar-per-litre, transaction count and any out-of-network purchases flagged
  • Driver log claim: litres claimed per the driver fuel diary, refuel events recorded, any unrecorded refuels flagged for investigation
  • Variance calculation: litres variance (driver versus card), percent variance against driver claim, dollar variance and the variance flag threshold rule (typically 5 percent)
  • Variance flag and investigation: yes/no flag where variance exceeds threshold, investigation status (open, complete, escalated), root cause classification (card misuse, wrong pump, theft, recording error, private use)
  • Cost metrics: dollar-per-litre for the period, dollar-per-kilometre, comparison to fleet average and trend versus previous period
  • Private use allocation: where applicable, litres allocated to private use against logbook ratio, with the calculation feeding FBT substantiation
  • GST input tax credit: GST amount claimable on the reconciled litres, with cross-reference to the supplier tax invoice and reconciliation note
  • Driver sign-off: driver name, signature, date and acknowledgement of any variance investigation
  • Fleet manager sign-off: fleet manager name, signature, date, posting to finance and any escalation to HR or driver supervisor where misuse is confirmed

How to use this fuel reconciliation log template

  1. 1. Extract fuel card transactions for the period: pull the fuel card statement from the issuer portal (BP, Caltex, Shell, EG, Ampol, Mobil), filter to the reconciliation period, sum litres dispensed and dollar cost per vehicle and flag any out-of-network or pump-restricted purchases that breach the card policy
  2. 2. Capture the driver fuel log: collect the driver fuel diary for the same period, sum litres claimed and refuel events, cross-check refuel locations against the route plan and note any unrecorded refuels for the variance investigation
  3. 3. Record opening and closing odometer: capture the opening and closing odometer readings from the pre-start sheets or the telematics extract, calculate kilometres travelled and flag any odometer rollover, replacement or suspected misreading event
  4. 4. Reconcile litres dispensed against litres claimed: side-by-side compare the fuel card litres against the driver log litres, calculate the variance in litres and percent, calculate dollar-per-litre and dollar-per-kilometre and compare against the fleet average for the period
  5. 5. Apply the variance flag threshold: where percent variance exceeds the site threshold (typically 5 percent), set the variance flag and open an investigation, classify the root cause (card misuse, wrong pump, theft, recording error, private use) and record evidence
  6. 6. Allocate private use and calculate FBT exposure: where the vehicle has logged private use, apply the logbook ratio to allocate litres between business and private use, with the private allocation feeding the FBT statutory or operating-cost method calculation
  7. 7. Calculate GST input tax credit: extract the GST amount on the reconciled litres from the supplier tax invoices, cross-reference to the fuel card report and stamp the GST claimable for finance posting
  8. 8. Obtain driver sign-off: the driver reviews the reconciliation, signs to acknowledge the variance investigation outcome where applicable, dates the log and returns it to the fleet coordinator
  9. 9. Fleet manager sign-off and post to finance: the fleet manager reviews the reconciliation, signs and dates, posts the cost against the right cost centre, escalates any confirmed misuse to HR or the driver supervisor and files the signed log against the vehicle ID for audit

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 fuel reconciliation log template as a PDF.Back to download form

How often should you complete this process document?

Fuel reconciliation runs on the same cadence as the fuel card statement cycle, typically monthly, with weekly reconciliation on high-cost or high-risk vehicles such as heavy haulage rigs, refrigerated trucks and any vehicle previously flagged for variance investigation. Reconciliation runs concurrently for every vehicle in the fleet so the fleet-wide variance percent and dollar-per-kilometre trend are produced from a single batch. A quarterly review of all reconciliation outputs feeds the cost-per-kilometre report and any pricing review with the fuel card issuer. The annual reconciliation cycle aligns with the FBT year end (31 March in Australia) so the private use allocation has full evidence for the FBT return, and aligns with the financial year end for GST reconciliation. Any fuel card misuse investigation, ATO audit notice, FBT review or significant fuel price movement triggers an out-of-cycle reconciliation of the affected vehicles. MapTrack auto-generates the monthly reconciliation per vehicle and pushes flagged variances to the fleet manager dashboard.

Frequently asked questions

Five percent variance between fuel card litres and driver log litres is the typical site threshold in Australian fleet operations, but the threshold should be calibrated to the asset class and the value of the variance in dollar terms. Heavy haulage rigs and refrigerated trucks may carry a tighter three percent threshold because of the high absolute fuel volume. Light commercial vans may carry a broader eight percent threshold. The threshold rule should be printed against the log so every reconciler applies it consistently, and any vehicle previously flagged for confirmed misuse should run on a tighter threshold until variance returns to within tolerance for three consecutive periods.

AS/NZS ISO 39001 (Road traffic safety management systems) sets the fleet management system expectation that fuel data feeds risk and cost reviews. The Heavy Vehicle (Fatigue Management) National Regulation requires odometer and route records that the reconciliation log draws on. Australian Tax Office substantiation rules carry the financial duty: the Fringe Benefits Tax Assessment Act 1986 requires evidence of private use allocation where vehicles have mixed business and private use, and the GST Act and ATO guidance require evidence supporting input tax credit claims on fuel purchases. The reconciliation log is the primary evidence document at FBT, GST and ATO audit reviews.

Where a vehicle has logged private use during the reconciliation period, the logbook ratio is applied to allocate litres dispensed between business and private use. The private litres are valued at the fleet-average dollar-per-litre for the period and feed the FBT calculation under either the statutory formula method or the operating cost method depending on the election made for the vehicle. The annual reconciliation cycle aligns with the FBT year end on 31 March so the private use allocation has full evidence for the FBT return. The signed reconciliation log is the primary substantiation document at ATO review, supported by the underlying fuel card transactions, driver logs and odometer records.

The reconciliation is typically prepared by the fleet coordinator or accounts payable clerk, who extracts the fuel card transactions, captures the driver log, reconciles the litres and applies the variance threshold. The driver signs to acknowledge any variance investigation outcome where applicable. The fleet manager reviews and signs the completed reconciliation, posts the cost against the right cost centre and escalates any confirmed misuse to HR or the driver supervisor. Where the vehicle has private use, the finance team reviews the private allocation and feeds the figure into the FBT return. Multiple sign-offs build the audit trail that the reconciliation was reviewed by accountable persons rather than rubber-stamped.

Monthly reconciliation aligned to the fuel card statement cycle is the baseline for every vehicle in the fleet. Weekly reconciliation runs on high-cost or high-risk vehicles such as heavy haulage rigs, refrigerated trucks and any vehicle previously flagged for confirmed misuse until variance returns to within tolerance for three consecutive periods. A quarterly review of reconciliation outputs feeds the cost-per-kilometre report and any pricing review with the fuel card issuer. The annual cycle aligns with the FBT year end on 31 March and the financial year end for GST reconciliation. Any fuel card misuse investigation, ATO audit notice or significant fuel price movement triggers out-of-cycle reconciliation.

Yes. This fuel reconciliation log template is completely free to download and use - open the HTML file in any browser and use Print then Save as PDF. No MapTrack account is required. It suits fleet coordinators, accounts payable and fleet managers reconciling fuel card spend against driver logs for variance, FBT and GST evidence. If you later want to move off paper and spreadsheets, MapTrack turns this into a live digital reconciliation log: fuel and odometer entries captured against each vehicle ID and fuel card number, variance flagged automatically against your site threshold, automated reconciliation and finance-posting reminders, and a complete timestamped audit trail for ATO and FBT review, so nothing slips through across your fleet or sites. Start free at maptrack.com/free-trial or book a demo.

Applicable regulatory standards

This template aligns with the following regulations and standards:

  • AS/NZS ISO 39001 (Road traffic safety management systems)
  • Heavy Vehicle (Fatigue Management) National Regulation
  • Fringe Benefits Tax Assessment Act 1986 (ATO substantiation rules)
  • GST Act and ATO input tax credit requirements

Related resources

More fleet templates and guides:

More from this category

Need to track your fleet with gps and digital pre-starts?

Register every fuel reconciliation log in MapTrack, attach digital forms, and get a complete history of every inspection, service and compliance record.

Start free trialBook a demo

GPS and fleet tracking · All templates · Pricing · Book a demo