Template

Expense Tracker Template

Log every purchase by date, category and payment method. A month of tracking shows exactly where your money goes.

Updated November 19, 2026In Bills & ExpensesFree download: Excel, CSV, PDF

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

Month
Monthly budget$

Categories: Housing · Utilities · Groceries · Dining · Transport · Health · Shopping · Entertainment · Personal · Kids · Pets · Gifts · Other

DateDescriptionCategoryPaid withAmount
Total spent

Preview of the template. Highlighted [brackets] show text to replace.

How to use the expense tracker

  1. Record every purchase with the date, a short description, the category, how you paid and the amount.
  2. Use consistent categories. The list at the top keeps things simple, so stick to it.
  3. Update it daily or every few days, using your receipts and banking app.
  4. Check your total against your monthly budget.
  5. 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