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.
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.
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. Eventhough 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.
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.
You can download the file below.
Household Expenses Calculator V1.2 (1.0 MiB, 15,688 hits)