Household Expenses Tracker

  • Version
  • 24'975 Downloads
  • 66 KB File Size
  • January 4, 2022 Updated
  • 16 Number of comments
  • Rating
table of content

This is basically just a strip version of my household budget spreadsheet where it is only can be used to track and record your expenses without budget consideration. It consist of three worksheets, category worksheet, daily income and expenses worksheet and monthly expenses worksheet.

Household Expenses

You can start to customize your spreadsheet by going to category worksheet and define your categories. Define your group category first, followed by subcategory and category. You can simplify the written category if you fill those categories are too detail, or you can customize based on your criteria. You don't have to create all the categories in the beginning, since probably you can't remember all. You can customize again while you recording your expenses and find there is no suitable category for that expenses.

Household Expenses Setup

After customizing the category worksheet, you can start tracking your daily expenses in the daily income and expenses worksheet. Just type your expenses row by row and let the excel formula do the rest of tracking process. Even though I put the title "expenses" in the expenses column, you can put your income and select the appropriate category to record your income. This is useful if you want to compare your income to your total expenses. I provide also a credit card box that will help you summarize your credit card usage within a month.

Household Expenses Tracker

The third worksheet is the monthly expenses worksheet that will summarize all your expenses monthly. And you can compare your expenses with your income in this worksheet also, so you will see the profile of your household financial situation monthly.

How useful was this template?

Click on a star to rate it!

Average rating 4.8 / 5. Vote count: 25

No votes so far! Be the first to rate this template.

We are sorry 🙁

Help us improve!

How we can improve this template?

Electricity Consumption Calculator

44 KB / 19807 downloads
Event Budget

29 KB / 3714 downloads
House Affordability Calculator

8 KB / 4612 downloads
Household Budget

113 KB / 31584 downloads
Simple Personal Budget

27 KB / 21985 downloads
Bill Payment Calendar

6.6 Mb / 103971 downloads
Fuel Consumption Calculator

14 KB / 21816 downloads
Grocery List Cost Estimator

38 KB / 4783 downloads
Grocery Price Comparison Spreadsheet

38 KB / 25211 downloads
View Comments