Download this template free
No sign-up needed. Word and Excel files also open in Google Docs, Google Sheets and Apple Pages/Numbers. Letter size (8.5 × 11 in).
Expense Tracker
Categories: Housing · Utilities · Groceries · Dining · Transport · Health · Shopping · Entertainment · Personal · Kids · Pets · Gifts · Other
| Date | Description | Category | Paid with | Amount |
|---|---|---|---|---|
| Total spent |
Preview of the template. Highlighted [brackets] show text to replace.
How to use the expense tracker
- Record every purchase with the date, a short description, the category, how you paid and the amount.
- Use consistent categories. The list at the top keeps things simple, so stick to it.
- Update it daily or every few days, using your receipts and banking app.
- Check your total against your monthly budget.
- Review at month end. Total each category and compare it with your budget.
Example entries
| Date | Description | Category | Paid with | Amount |
|---|---|---|---|---|
| 03/01 | Trader Joe’s | Groceries | Debit card | $86.42 |
| 03/02 | Gas, Shell | Transport | Credit card | $41.10 |
| 03/03 | Lunch with coworkers | Dining | Credit card | $18.75 |
| 03/04 | Streaming subscription | Entertainment | Credit card | $15.49 |
What to do with what you learn
After a month, ask yourself:
- Which categories surprised you?
- Which purchases were not worth it?
- What small, frequent purchases add up, such as coffee, delivery fees and convenience-store stops?
- Where could you cut 10% without missing it?
Then set realistic numbers in a monthly budget. For more tips, read how to track your expenses.
Frequently asked questions
How long should I track my expenses?
Track every purchase for at least one full month to see your true spending patterns. Many people keep tracking indefinitely because it keeps them accountable.
Should I track cash purchases?
Yes. Cash spending is the easiest to forget and often hides surprising amounts, so save receipts or note cash purchases on your phone as you go.
How can I see spending by category in Excel?
Select your table and insert a PivotTable with Category in Rows and Amount in Values. In Google Sheets, use Insert › Pivot table. You can also use SUMIF, for example =SUMIF(C:C,"Groceries",E:E).
Related templates and guides
How to Track Your Expenses
Five simple ways to track your spending, how to categorize it, and how to turn what you learn into a budget that works.
TemplateMonthly Budget Template
Plan your month and track where your money actually goes. The Excel version totals income and expenses and shows the difference for every category.
TemplateReceipt and Spending Log
A printable log for recording purchases as you make them and keeping track of receipts, including ones you may need for taxes or returns.
TemplateSubscription Tracker
Find out what you are really paying for streaming, apps, memberships and boxes. The Excel version shows the yearly cost of every subscription.