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
- Type each purchase on Expenses with vendor, amount, category and payment method.
- Paste a receipt link, a photo saved in Drive is enough, so nothing gets lost.
- Add the Client ID and Job ID when a cost belongs to one job.
- 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.
Related templates
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.