Gas Receipt Template for Self-Employed Workers (Free)

If you are self-employed and deducting fuel expenses on your taxes, you need organized records. A gas receipt template gives you a consistent format to log every fill-up — date, station, gallons, cost, and business purpose — so nothing falls through the cracks.

This guide provides a template you can use immediately (spreadsheet or paper), explains what every field is for, and shows you how to maintain it efficiently.

Why You Need a Gas Receipt Log

A raw stack of gas receipts is not a tax record. It is a pile of paper that fades, gets lost, and takes hours to sort through in April. A gas receipt log transforms those receipts into structured, auditable data.

When the IRS or CRA reviews your fuel deduction, they want to see:

• The amount of each purchase
• The date it occurred
• The place of purchase
• The business purpose of the related travel

A template ensures you capture all four elements consistently for every fill-up. For a deeper dive into IRS documentation requirements, see our guide on writing off gas on your taxes.

The Template: Fields and What They Mean

Here is every field your gas receipt log should include:

Field	Example	Why It Matters
Date	2026-03-15	Ties the expense to a specific day for your records
Station Name	Shell — 4th Ave & Main St	Proves purchase location; cross-references receipt
City / State	Phoenix, AZ	Supports business travel claims
Fuel Type	Regular 87	Verifies vehicle match; flags discrepancies
Volume (gal / L)	12.45 gal	Cross-checks with odometer and vehicle tank size
Price per Unit	$3.29/gal	Validates total; detects entry errors
Total Cost	$40.96	The actual deductible amount
Payment Method	Visa ending 4821	Backup proof via bank statement
Odometer Reading	47,832 mi	Tracks fuel economy; supports mileage log
Business Purpose	Client delivery — Downtown route	Required by IRS; proves business use
Vehicle	2022 Toyota Camry	Necessary if tracking multiple vehicles

Setting Up Your Spreadsheet

Open Google Sheets or Excel and create these columns across the top row. Here is a layout that works well:

Column A: Date
Column B: Station
Column C: City/State
Column D: Fuel Type
Column E: Gallons/Litres
Column F: Price/Unit
Column G: Total Cost
Column H: Payment Method
Column I: Odometer
Column J: Business Purpose
Column K: Vehicle

At the bottom of the sheet, add summary rows:

• Total Fuel Spend: =SUM(G2:G500)
• Total Gallons: =SUM(E2:E500)
• Average Price/Gallon: =G_total/E_total
• Fill-up Count: =COUNTA(A2:A500)

Add conditional formatting to highlight any row where the "Business Purpose" cell is empty. This catches entries you forgot to complete before they become a problem at tax time.

Monthly Summary Tab

Create a second tab that pulls monthly totals from the main log. Use SUMIFS to total fuel cost by month. This gives you a quick overview of spending trends and makes quarterly estimated tax calculations easier.

Paper Template Option

If you prefer pen and paper, create a small notebook with pre-printed columns. Each page covers one week (7 rows). Keep the notebook in your glove box with a pen. The key fields for a paper log:

1. Date
2. Station
3. Gallons
4. Total $
5. Odometer
6. Business Purpose

The paper version is simpler but has real limitations: no automatic totals, no backup if lost, and no way to generate tax reports. It works as a supplement but should not be your only system.

How to Use the Template Effectively

Fill It Out at the Pump

The number one reason tracking systems fail is delayed entry. You fill up, pocket the receipt, and tell yourself you will log it tonight. You do not. The receipt sits in your pocket, then your desk, then a drawer, then the trash.

Log each fill-up within 60 seconds of pumping. If you are using a spreadsheet, open it on your phone, enter the data from the receipt, and you are done. If you are using paper, write it in the notebook before you start the car.

Photograph Every Receipt

Your log is a record of the data. The receipt is proof of the purchase. Keep both. Snap a photo of the receipt immediately after filling up — thermal paper starts fading within months. For more on receipt retention, see our guide on how long to keep gas receipts for taxes.

Review Weekly

Every Sunday, spend 5 minutes reviewing the week's entries. Check for:

• Missing entries (did you fill up Tuesday but forget to log it?)
• Empty "Business Purpose" cells
• Totals that seem off (a $90 fill-up on a car with a 14-gallon tank)

Export Quarterly

Do not wait until April to look at your fuel data. Export a quarterly summary so you can calculate estimated tax payments accurately and catch any gaps while the details are still fresh.

When a Template Is Not Enough

Spreadsheet templates work, but they require discipline. Every fill-up means opening the spreadsheet, typing 8-10 fields, and saving. Miss a few entries and the log becomes unreliable.

If you find yourself falling behind, a dedicated fuel tracking app eliminates the manual entry entirely. FuelSnap reads gas receipts and pump screens in under five seconds — it extracts every field from the table above automatically. No typing, no spreadsheet, no discipline required. You scan, and the data is logged.

For a comparison of all available options, see our roundup of the best fuel tracking apps in 2026.

The Bottom Line

A gas receipt template gives your fuel tracking structure and consistency. Whether you use a spreadsheet or a dedicated app, the goal is the same: capture every fill-up with enough detail to satisfy the IRS or CRA, and keep those records organized for when you need them.

Start with the template above. If manual entry becomes a bottleneck, FuelSnap automates the entire process — scan the receipt, and the data populates instantly.