Free spreadsheet template
Expense tracker spreadsheet template
Copy or download a simple CSV template for tracking income, expenses, currencies, categories, payment methods, and notes. Use it in Google Sheets, Excel, Numbers, or your own workflow.
Template preview
| Date | Type | Amount | Currency | Category | Description | Payment Method | Business/Personal | Notes |
|---|---|---|---|---|---|---|---|---|
| 2026-07-01 | Income | 1200 | USD | Client Payment | Website milestone | Bank Transfer | Business | Paid invoice INV-001 |
| 2026-07-02 | Expense | 18.40 | USD | Software | Hosting renewal | Card | Business | Monthly subscription |
| 2026-07-03 | Expense | 12.00 | USD | Meals | Client lunch | Cash | Business | Discussed project scope |
| 2026-07-04 | Income | 500 | USD | Deposit | Logo project deposit | Bank Transfer | Business | 50 percent upfront |
Why these columns matter
The template is intentionally plain. The goal is not a beautiful spreadsheet; it is a record you can keep clean enough to review.
Date
When the transaction happened.
2026-07-01
Type
Income or Expense.
Expense
Amount
The number only, without symbols.
18.40
Currency
Keep multi-currency records clear.
USD
Category
A simple label for review.
Software
Description
What the transaction was for.
Hosting renewal
Payment Method
How money moved.
Card
Business/Personal
Separate work and personal spending.
Business
Notes
Context you may forget later.
Monthly subscription
Simple formulas to add
After importing the CSV, add these formulas in your spreadsheet if you want quick totals.
Total income
=SUMIF(B:B,"Income",C:C)Total expenses
=SUMIF(B:B,"Expense",C:C)Net cashflow
=SUMIF(B:B,"Income",C:C)-SUMIF(B:B,"Expense",C:C)Business expenses
=SUMIFS(C:C,B:B,"Expense",H:H,"Business")The problem is usually capture, not the spreadsheet.
Spreadsheets are good for review. They are not always good for recording a coffee, subscription, or client payment while you are in the middle of the day.
Use the sheet for review
Keep the spreadsheet as your weekly or monthly cleanup place.
Use chat for capture
Record entries as soon as they happen so context is not lost.
Export when needed
NotaWA Plus can export CSV records when you need a cleaner handoff.
Common questions
A few practical notes before using the template.
Can I use this in Google Sheets?
Yes. Copy the CSV text or download the CSV file, then import it into Google Sheets, Excel, Numbers, or another spreadsheet tool.
Should I track income and expenses in the same sheet?
For freelancers and small operators, yes. Seeing income and expenses together makes cashflow easier to understand.
When should I stop using a spreadsheet?
Keep the spreadsheet if it works. Move daily capture into a tool like NotaWA when you keep forgetting entries before review time.
Want faster daily capture?
Use the spreadsheet for review and NotaWA for quick WhatsApp entries.