Skip to the content.

Free Google Sheets Expense Tracker

For owners who pay for materials, fuel and tools with a mix of cards and cash and want every receipt tied to a client or a job long before tax time.

Open the template · Make a copy · Google Sheet, free, no sign-up

What is inside

Tab What it holds
Dashboard Totals and views built from Expenses, Clients and Jobs, no typing needed.
Expenses Columns Date, Vendor, Amount, Category, Description, Payment method, Client ID, Job ID, Tax paid and 5 more.
Clients Columns Client ID and Client name.
Jobs Columns Job ID, Job name and Client ID.
Settings Your own dropdown lists (categories, payment methods and employees), so the choices match how you work.

How to fill it in

  1. Type each purchase on Expenses with vendor, amount, category and payment method.
  2. Paste a receipt link, a photo saved in Drive is enough, so nothing gets lost.
  3. Add the Client ID and Job ID when a cost belongs to one job.
  4. Mark reimbursable items and who paid, so you know what you owe your team.

A tip from the field

The Duplicate check column catches the same receipt typed twice, which happens easily at month end.

Starter files

Each tab with sample rows comes as a CSV file, handy for importing into another tool or starting fresh.

When you outgrow it

Smarfle records expenses on each job, shows real job profit and includes them by category in the accountant export. See how it works on smarfle.com.

All free templates