Skip to content
The title slide and first slides of the Car Expense Log template

Car Expense Log

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Minimal
Difficulty
Beginner
Updated
November 15, 2026

Every slide (5)

Overview

Anyone who uses one car for both work and personal driving can use this car expense log to keep a clean record. The Costs tab shows each non-fuel cost with the business-use share and the business part worked out. The Fuel tab records each fill-up with the odometer, gallons and price, and calculates cost and miles per gallon. The Dashboard shows totals, the business part and average fuel economy, and charts costs by category.

Set the business-use percentage from your mileage log, not from memory. Keep the odometer reading on every row so the log doubles as a service history. Fuel sits on its own tab because fill-ups come up far more often than other costs. Ask a tax professional which method applies to you before you use any total.

Useful for

  • Keep one record of repairs, insurance, parking and fuel
  • Watch miles per gallon for early signs of a problem
  • Hand a clean list of car costs to a tax professional

What's included

  • 4 tabs: Dashboard, Costs, Fuel, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Costs: a table
  • Fuel: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Costs tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I track car expenses for work?

Log each cost with its date, vendor, amount and the share used for work. Add a mileage log for the trips themselves. This sheet adds up the business part per category.

Should I record fuel separately?

It helps. Fill-ups happen often, and a separate tab lets you see cost and miles per gallon without crowding the main list of repairs and insurance.

What business use percentage should I enter?

Use business miles divided by all miles from your mileage log. The percentage can differ by cost, such as parking that was all for work. Write the basis in the note column.

  • #tax-tracker
  • #car-expense-log
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…