Expense tracker template
A free workbook that adds up every month and every category by itself, with a receipt log beside it, and a printable page for pen and paper.
Free, no sign-up. The workbook opens in Excel, Numbers and Google Sheets.
What's in the template
Five sheets, of which you'll touch three.
- Expenses: one row per receipt, with the date, what it was, the category, the amount, how you paid and where the receipt is kept. The category comes from a dropdown, so a typo never splits one category into two.
- Income: paychecks, side income, refunds, one row each.
- Summary: fills itself in. Every category's total for every month of the year, then what you spent, what came in and what was left over. There's a column for a monthly budget beside each category, so you can see where you're over.
- Categories: sixteen to start with, from rent to savings. Rename them or add up to twenty; the summary and the dropdown follow.
- How to use: the instructions, in five steps.
Green cells are yours to fill in; white cells calculate. The file opens in Excel and Numbers as it is. For Google Sheets, use "Copy to Google Sheets" above, which puts a copy of your own in your Google Drive.
Why it has a receipt log
Most expense trackers stop at the amount. This one asks where the receipt went, because the receipt is what you'll need later: to return something, to claim a warranty, or to back up a deduction at tax time. "Shoebox, March" or "photo on my phone" is enough to find it again.
A printable version
Prefer paper? The PDF is one month on two US Letter pages: a list for your expenses, and a month at a glance with the sixteen categories, a budget column and the money you started and ended the month with. Print one each month and keep them in a folder.
How to use it
- On Summary, enter the year at the top.
- Log each receipt on Expenses the day you get it, while it's still in your pocket.
- Add your paychecks and other income on Income as they come in.
- At the end of the month, look at Summary: which category ran over, and what's left?
An example: in January you log $850 of rent, two grocery runs of $54.30 and $23.10, and a $12.95 café lunch. Summary then shows January with $850.00 under Rent & mortgage, $77.40 under Groceries and $12.95 under Restaurants & cafes, $940.35 in all. With a $2,450 paycheck, $1,509.65 is left over.
Where a spreadsheet gets painful
The template does the math, but it can't do the typing. A big grocery run is twenty lines, and if you want to know how much of it was food and how much was household stuff, every one of those lines goes in by hand. That's usually the week a spreadsheet budget quietly stops.
That part is what Receiptix is for. Its AI receipt scanner reads every line of a receipt from a photo, sorts each item into a category, and keeps the totals this template keeps, without the typing. The two aren't either-or: plenty of people start with the spreadsheet and switch when the typing gets old.
Or skip the typing.
Receiptix reads each receipt from a photo and sorts every line into a category. Free to try on iPhone, Android, Apple Watch and the web.