A printable expense tracker is a one-page grid where you write down each purchase (date, what it was, category and amount) and total it by category at the end of the week or month. Below are three expense tracker printable layouts you can copy into Google Sheets, Excel or a word processor and print on a single page: a daily log, a weekly grid and a monthly summary. Each comes with the exact columns, print settings and a filled-in example.
Paper works because it is in front of you. The trade-off is that it only knows what you write on it, so the last section covers how to check it against your bank statement and when to move to a spreadsheet.
Which printable to use
| Layout | You write | Best for | Rows per page |
|---|
| Daily log | Every purchase, as it happens | Building the habit, cash spending | About 30 |
| Weekly grid | One amount per category per day | Quick daily totals, families | 7 days × 8–10 categories |
| Monthly summary | Category totals once a month | Comparing against a budget | One row per category |
Most people use either the daily log or the weekly grid during the month, then the monthly summary to total it up.
Layout 1: Daily expense log (copy this)
One row per purchase. Set it up in portrait orientation with these six columns:
| Date | Item / store | Category | Paid with | Amount | ✓ on statement |
|---|
| | | | | |
| | | | | |
| | | | | |
- Paid with (cash, debit, card) lets you match entries to your bank statement later.
- ✓ on statement is a tick box you fill in at the end of the month. Anything on the statement with no matching row is spending you forgot to write down.
- Leave 30 or so blank rows; that fills one portrait page.
Add a Total row at the bottom. On paper, total in pencil first, then pen once you have checked it.
Layout 2: Weekly expense grid (copy this)
Days down the side, categories across the top, one amount per cell. Use landscape orientation:
| Day | Groceries | Eating out | Transport | Shopping | Bills | Fun & subscriptions | Kids | Other | Day total |
|---|
| Mon | | | | | | | | | |
| Tue | | | | | | | | | |
| Wed | | | | | | | | | |
| Thu | | | | | | | | | |
| Fri | | | | | | | | | |
| Sat | | | | | | | | | |
| Sun | | | | | | | | | |
| Week total | | | | | | | | | |
If you buy two things in one category on the same day, add them up and write the total. The grid is faster to fill in than the log, and the week-total row shows at a glance where the money went.
Layout 3: Monthly summary (copy this)
One row per category, filled in at the end of the month from your daily logs or weekly grids:
| Category | Budget | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Actual | Over / under |
|---|
| Groceries | | | | | | | | |
| Eating out | | | | | | | | |
| Transport | | | | | | | | |
| Shopping | | | | | | | | |
| Bills | | | | | | | | |
| Fun & subscriptions | | | | | | | | |
| Kids | | | | | | | | |
| Other | | | | | | | | |
| Total | | | | | | | | |
Over / under is Budget minus Actual. A negative number means you went over.
A paper-friendly category list
Expense Sorted's local categorizer starts from 14 default categories: Groceries, Shopping, DinnerBars (eating out), Medical, Transport, Utility, Travel, Kids, Business, Living (subscriptions and memberships), Tax, Transfer, Income and Debt Repayment.
That is the right number for a spreadsheet, but too many columns for a printed page. For paper, fold them down to eight:
| Paper column | Folds in |
|---|
| Groceries | Groceries |
| Eating out | DinnerBars |
| Transport | Transport |
| Shopping | Shopping |
| Bills | Utility, Debt Repayment |
| Fun & subscriptions | Living |
| Kids | Kids |
| Other | Medical, Travel, Business, Tax |
Transfer and Income stay off the spending tracker entirely. Moving money between your own accounts is not spending, and income goes on a separate line if you track it at all. If one fold-in gets big (a month with a lot of travel, say), give it its own column next month.
Worked example: one week on the weekly grid
Here is a filled-in week with illustrative amounts:
| Day | Groceries | Eating out | Transport | Shopping | Bills | Fun & subscriptions | Kids | Other | Day total |
|---|
| Mon | 42.10 | | 6.00 | | | | | | 48.10 |
| Tue | | 14.50 | 6.00 | | 89.00 | | | | 109.50 |
| Wed | | | 6.00 | 35.00 | | 15.99 | | | 56.99 |
| Thu | 18.75 | | 6.00 | | | | 12.00 | | 36.75 |
| Fri | | 38.00 | | | | | | | 38.00 |
| Sat | 96.40 | 22.00 | 55.00 | | | | | 24.00 | 197.40 |
| Sun | | | | 19.95 | | | | | 19.95 |
| Week total | 157.25 | 74.50 | 79.00 | 54.95 | 89.00 | 15.99 | 12.00 | 24.00 | 506.69 |
Two checks catch most mistakes:
- Add the day totals down (48.10 + 109.50 + 56.99 + 36.75 + 38.00 + 197.40 + 19.95 = 506.69).
- Add the week totals across (157.25 + 74.50 + 79.00 + 54.95 + 89.00 + 15.99 + 12.00 + 24.00 = 506.69).
If the two numbers match, the grid is right. The week totals then go straight into the Week 1 column of the monthly summary.
How to print it on one page
Google Sheets
- Build the table, then select just the tracker range.
- Go to File → Print and choose Selected cells under Print.
- Set Scale to Fit to width and Margins to Narrow.
- Under Formatting, tick Show gridlines so the empty cells print as boxes.
- Use Portrait for the daily log, Landscape for the weekly grid and monthly summary.
Excel
- Select the range and choose Page Layout → Print Area → Set Print Area.
- Under Page Layout → Scale to Fit, set Width to 1 page.
- Add borders to all cells (Home → Borders → All Borders) so lines print.
- Pick orientation under Page Layout → Orientation.
Word or Google Docs: insert a table with the columns above, set row height to about 0.8 cm so there is room to write, and print.
Print a month's worth at once: four or five weekly grids and one monthly summary.
When the printable stops being enough
Paper is good at one thing: making you notice spending as it happens. It is bad at the spending you never touch.
| Spending type | Printable | Spreadsheet from bank CSV |
|---|
| Cash purchases | Caught, if you write them down | Missed (cash only shows as the ATM withdrawal) |
| Card purchases in person | Caught, if you write them down | Caught automatically |
| Subscriptions and automatic payments | Often missed | Caught automatically |
| Price increases on recurring bills | Missed | Visible month to month |
| Totals and trends | Hand-added | Formulas |
The fix is a monthly check: download your bank statement, tick every matching row in the daily log's ✓ on statement column, and add anything that has no tick. If that check keeps turning up more than a handful of missed items, the paper tracker is costing you accuracy, and a spreadsheet built from your bank's CSV export will do better. Spreadsheet expense tracker: build it in 5 columns walks through that setup.
If you chose paper for privacy, a spreadsheet does not have to mean a cloud app. Offline expense tracker: what works without internet and private expense tracker: 5 tests for who sees your data cover options that keep your data on your own device.
FAQ
What should a printable expense tracker include?
Date, what you bought, category and amount are the essentials. A daily log adds a payment-method column so you can match it to your bank statement later. A monthly summary only needs categories, a budget column, the actual total and the difference.
How do I print an expense tracker from Google Sheets?
Select the tracker range, go to File → Print, choose Selected cells, set the scale to Fit to width, margins to Narrow, and tick Show gridlines under Formatting. In Excel, set a print area first, then use Page Layout → Fit to 1 page wide.
Which is better: a daily, weekly or monthly printable?
Use the daily log if you want to see every purchase while you are building the habit. Use the weekly grid if you only want to write once a day. Use the monthly summary to total things up at the end of the month, whichever log you keep.
How many categories should a paper expense tracker have?
Fewer than on a spreadsheet. Eight to ten fit across a printed page and are quick to choose while you are writing. Group rare categories into one Other column and split them out only if they get big.
Is a printable expense tracker enough on its own?
For cash spending and building awareness, yes. It misses things you do not write down, such as subscriptions and automatic card payments. Check it against your bank statement once a month, or move to a spreadsheet when that check keeps finding gaps.
Related guides
