Fuel Expense Spreadsheet Template (Free for 2026)

A fuel expense spreadsheet is the simplest free tool for tracking gas purchases. No app to download, no subscription to pay — just a structured template that organizes your fuel data and does the math for you.

This guide walks through a complete spreadsheet template with formulas, explains how to set up monthly and annual summaries, and covers the common pitfalls that cause spreadsheet-based tracking to fail.

The Core Spreadsheet Layout

Your main sheet — call it "Fuel Log" — needs one row per fill-up with these columns:

Column	Header	Format	Example
A	Date	Date (YYYY-MM-DD)	2026-03-15
B	Station	Text	Shell — 4th & Main
C	Fuel Type	Text	Regular 87
D	Gallons	Number (2 decimal)	12.45
E	Price/Gallon	Currency	$3.29
F	Total Cost	Currency	$40.96
G	Odometer	Number	47,832
H	Miles Since Last	Number (formula)	312
I	MPG	Number (formula)	25.1
J	Cost/Mile	Currency (formula)	$0.131
K	Vehicle	Text	2022 Camry
L	Notes	Text	Business delivery

Key Formulas

Miles Since Last Fill-up (Column H):

In cell H3 (assuming row 2 is your first entry and row 3 is the second): =G3-G2

This calculates distance driven between fill-ups based on odometer readings.

Miles Per Gallon (Column I):

=H3/D3

Divides miles driven by gallons purchased to get fuel economy. Leave the first row blank (you need two fill-ups to calculate MPG).

Cost Per Mile (Column J):

=F3/H3

Shows what each mile costs you in fuel. Useful for comparing against the IRS standard mileage rate (72.5 cents/mile in 2026) to see if you are above or below average.

Summary Section

Below your data rows (or in a separate section), add these summary calculations:

Metric	Formula
Total Fuel Cost (YTD)	=SUM(F2:F500)
Total Gallons (YTD)	=SUM(D2:D500)
Average Price/Gallon	=SUM(F2:F500)/SUM(D2:D500)
Average MPG	=AVERAGE(I3:I500)
Total Fill-ups	=COUNTA(A2:A500)
Average Cost/Fill-up	=SUM(F2:F500)/COUNTA(A2:A500)

Monthly Summary Tab

Create a second tab called "Monthly Summary" with this layout:

Month	Fill-ups	Gallons	Total Cost	Avg $/Gallon	Avg MPG
January	4	52.3	$168.40	$3.22	26.4
February	4	49.8	$162.15	$3.26	25.8
...	...	...	...	...	...

Use SUMIFS to pull data from the Fuel Log tab filtered by month:

=SUMIFS('Fuel Log'!F:F, 'Fuel Log'!A:A, ">="&DATE(2026,1,1), 'Fuel Log'!A:A, "<"&DATE(2026,2,1))

This gives you a clean month-over-month view of spending — invaluable for quarterly estimated tax calculations and spotting seasonal trends.

Tax Report Tab

If you use the actual expense method, create a third tab that calculates your deduction:

1. Total fuel cost for the year: pulled from the Monthly Summary tab
2. Business-use percentage: from your mileage log (business miles / total miles)
3. Deductible fuel amount: Total cost × business-use percentage

This number goes directly onto Schedule C (US) or Form T2125 (Canada) as part of your vehicle expense deduction. For details on how the actual expense method works, see our comparison of standard mileage rate vs actual expenses.

Conditional Formatting Tips

Add these visual helpers to catch issues early:

• Highlight gaps over 14 days between fill-ups (formula: next date minus current date > 14). A long gap either means you forgot to log a fill-up or you were not driving — either way, it is worth flagging.
• Flag unusually large fill-ups (e.g., over $80 for a sedan). Could indicate a data entry error or a fill-up that was partially personal.
• Highlight rows with empty Notes/Purpose fields so you remember to add business justification before tax time.

Common Spreadsheet Tracking Mistakes

Forgetting to Log

The number one failure mode. You fill up, drive away, and never open the spreadsheet. By the time you remember, the receipt has faded and the details are fuzzy. Solution: log at the pump. Open the spreadsheet on your phone before you pull away.

Not Backing Up

A local Excel file on your laptop is one hard drive failure away from total loss. Use Google Sheets (auto-saves to the cloud) or ensure your Excel file syncs to OneDrive or Dropbox automatically.

Manual Calculation Errors

Typing "$3.29" in the price column and "12.45" in the gallons column but entering "$41.50" instead of "$40.96" in the total. Use a formula (=D2*E2) to calculate the total automatically and avoid mismatches.

Not Keeping the Receipts

A spreadsheet is a log, not a receipt. For the actual expense method, the IRS expects you to retain the original receipts (or clear digital copies). Your spreadsheet alone may not be sufficient proof of purchase. Photograph or scan each receipt at the time of purchase. For more, see our guide on how to track gas expenses for tax deductions.

When to Upgrade from a Spreadsheet

A spreadsheet works well for people who fill up once or twice a week and have the discipline to enter data consistently. If you find yourself:

• Missing more than 1-2 fill-ups per month
• Spending more than 5 minutes per entry
• Dreading the weekly data entry
• Losing or forgetting to photograph receipts

...it may be time for a dedicated fuel tracker. FuelSnap eliminates manual data entry entirely — scan your receipt or pump display, and every field populates automatically. You get the same data a spreadsheet provides, plus receipt storage and one-click tax reports, without the manual work.

The Bottom Line

A fuel expense spreadsheet is a solid, free starting point for anyone tracking gas purchases. Set up the template with the formulas above, commit to logging at the pump, back up your file to the cloud, and review monthly. If manual entry becomes a bottleneck, upgrade to a scanning tool — but the template gets you 80% of the way there for free.