Household Expenses

Posted on October 27, 2009
Filed Under Finance |

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 here.

You can read and download my other templates below :

Tags: expenses, expenses recorder, expenses tracker, household, household expenses spreadsheet, household expenses worksheet, household finance, monthly expenses, personal expenses

Comments

4 Responses to “Household Expenses”

Mike Toole on December 4th, 2009 1:44 pm

Thanks a Lot…. I downloaded some of your excel spread sheets and will start using them. Mike
Makki on February 25th, 2010 8:59 am

I was just about to develop a very simple expenses sheet, but this is awesome. Thanks for sharing
AllyT. on March 1st, 2010 4:36 pm

I have not taken excel training - but I came across this template and I think I can manipulate it w/o training. All I have to do is download the budget template or family budget template - enter my groups - then enter my bills? I think I understand that the formulas are already embedded and will substract/add for me - correct?
Can I use this same excel sheet for a grocery list? I know the approx costs of items - I just want to be able to come up with a list and if I have gone over my budget - just delete the food item… The budget format is WONDERFUL - Thanks - but I can I use it for a shopping list - if so - Super Wonderful. I agree- Thanks for sharing
LIN on June 10th, 2010 8:16 am

if i already finish for that yr and i want to continue for the nxt yr? wat should i do?