Excel template

Household Budget & Expense Tracker

Log income and expenses in one list. Monthly and annual summaries and budget vs actual by category update automatically. Plan savings goals and split each paycheck between bills and savings. Change the year to keep using the same file.

Get it on Gumroad · USD 7

Opens the Gumroad product page. The price shown there is the one that applies.

Need more than one template? This one is also in the Excel Templates Bundle (all 4) on Gumroad: $19 instead of $30 bought separately.

Free lite edition (xlsx): 10 categories, 300 rows

Direct download, no sign-up. No budget vs actual, annual summary or planning sheets.

See how it works

Animated demo in 3 steps: 1. Type each transaction: date, type, category, amount. 2. Monthly income, expense and balance calculate. 3. Budget vs actual by category updates (January). Fictional sample data.
3 steps, loops. Real sheet, recalculated in LibreOffice. Sample data is fictional.

What the sheets look like

Income, expenses and balance, all 12 months, Monthly summary sheet (screenshot, fictional sample data)
Income, expenses and balance, all 12 months (Monthly summary sheet). Sample data is fictional.
Budget vs actual by category (January), Monthly summary sheet (screenshot, fictional sample data)
Budget vs actual by category (January) (Monthly summary sheet). Sample data is fictional.
One row per transaction, Transactions sheet (screenshot, fictional sample data)
One row per transaction (Transactions sheet). Sample data is fictional.
Sinking funds: amount to save each month, Sinking Funds sheet (screenshot, fictional sample data)
Sinking funds: amount to save each month (Sinking Funds sheet). Sample data is fictional.
What each paycheck must cover, Payday Budget sheet (screenshot, fictional sample data)
What each paycheck must cover (Payday Budget sheet). Sample data is fictional.

What it does

What it does not do

How to use

  1. On Settings, list your categories with their type (Income or Expense) and a monthly budget for expense categories. Yellow cells are inputs.
  2. On Transactions, enter one row per transaction. Type, category and payment method are picked from lists.
  3. If the Check column shows text, fix that row (it is highlighted).
  4. On Monthly summary, enter a year and a month. On Annual summary, enter a year.
  5. Optional: plan savings goals on Sinking Funds and split each paycheck on Payday Budget.

Sheets in the file

Compatibility

Free guide and tool

FAQ

Does it work with my currency?

Amounts use the #,##0.00 format with no currency symbol, so any currency works. Dates are YYYY-MM-DD.

Can I use it next year?

Yes. Change only the year on the summary sheets and the same file keeps working.

Does it connect to my bank?

No. There is no bank or card syncing; you enter transactions yourself.

Household Budget & Expense Tracker

Excel file (.xlsx), no macros. USD 7 on Gumroad.

Get it on Gumroad · USD 7

Digital download. If the file doesn't work for you, email within 30 days for a full refund.

Good to know