Excel Templates | Excel Spreadsheets | Household Budget


Free Excel Templates

Household Budget

Posted on August 15, 2009
Filed Under Finance | 18 Comments



Share

There are many websites that explaining about how to plan a household budget. And many forms and worksheets available in microsoft word or pdf format that you can download and use as your printable household budget form. And many other providing the budget form or worksheet in microsoft excel format that you can fill the amount of your budget plan.

Household Budget 4

The household budget I created here is basically another alternative for many household budget written in excel you can find in internet. The basic concept probably the same with many others but the approach is different. I divided the this household budget into three big parts, budget with regular repayments, budget with irregular repayments but needed monthly and budget as secondary needs or occasionally needed. I am using this approach based on my expenses where I have to pay all regular repayments first before spare some budget for others.

This file consists of four worksheets with explanation as follows :

Category Worksheet:
This is a worksheet where you can put your household budget category based on your common category. I already put samples there that you can change. You should start from Group Category, then to Category and the last is Subcategory.

Household Budget 1
Monthly Budget Worksheet:
This is a worksheet where you can put all your budget amount based on your category. As I already mention above, if you need a household budget with consideration of paying your regular repayments first, this spreadsheet could be the suitable one for you.

Household Budget 2
Daily Income and Expenses Worksheet:
Once you finished your budget, you can start filling your real income and expenses in this worksheet. You can periodically fill your income and expenses here and the excel formula will do the rest. Don’t forget to select the correct category for your expenses or the formula won’t work as expected.


Household Budget 3


Monthly Expenses Worksheet:
This is your monitor worksheet where you can see your monthly expenses based on your category and compare it with your budget plan. I put a group function on each month (you can see the (-) minus and (+) plus sign on top of the spreadsheet that you can click to hide or unhide the budget and variance columns. You can see in the first picture above.
If this household budget is not suitable with your needs, you can find the suitable one for you in my friend site where he makes a good review on 15 budget spreadsheets in excel.

If you want to give a try on this spreadsheet, you can download it here.




You can read and download my other templates below :

Tags: , , , , , , , ,

Comments

18 Responses to “Household Budget”

  1. budget template on September 28th, 2009 12:25 pm

    I have been using the spreadsheet to do the household finances, planning budget and tracking spending. I must say that it really works. I can see where my money has gone and cut costs on extraneous items.

  2. Household Expenses | Excel Templates on October 27th, 2009 12:07 am

    [...] 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 [...]

  3. Art Casanova on October 30th, 2009 3:13 am

    Hi,
    I modified the template to suit my needs and unfortunately I broke the formula on worksheet Monthly Expenses. Most of the cells works as expected (Real, Budget and Variance) are filled in when data is entered in Daily Income and Expenses except for 8 cells. I have struggled to fix this for a couple of days now but I have reached the limits of ability with Excel . Any help is appreciated.
    Thanks

  4. prasath on October 30th, 2009 10:24 am

    IT IS VERY GOOD

  5. admin on October 31st, 2009 2:21 am

    Hi Art,

    You can email me, so I can see your problem.

    Cheers

  6. Art Casanova on October 31st, 2009 5:21 am

    Admin
    Thank you. What is your email?
    Art

  7. admin on October 31st, 2009 3:38 pm

    You can send your file to info@exceltemplate.net

  8. Michelle on November 2nd, 2009 12:33 pm

    Hi, I find this excel template very interesting and useful.
    As I Started using this, I realise that there are two categories for Cloths figuring in Expenses, so as soon as I add any expense in category clothing, it is added twice in the monthly Expenses. Similarly for Magazines/Books.
    Also, If I add any expense in category Restaurants/Eating out, it does not gets calculated in Monthly expenses.

    Please help in case if I’m wrong somewhere.

    Thanks

  9. Veervikarmajeet on November 22nd, 2009 7:03 am

    Dear Sir/Madam/Admin

    This is really nice and awesome, congrates for creating such a nice worksheet, but there is some amendment required or can treat as advice. To add the anual sheet with some graphs. Please send your email or contact number, i really want to appreciate your work.

    Thanks & Regards
    Veervikarmajeet

  10. Help me Please! on March 16th, 2010 4:47 pm

    Can anyone modify the monthly expenses formula into a simpler formula for windows excel 2007? But it has the same function…

  11. nosaja on March 16th, 2010 4:59 pm

    99999999999999999999999999999999999999999999999999999999999999999

  12. Anthony on May 6th, 2010 11:54 am

    hi i have a problem i want a Excel template that can calculate my cars daily income and expenses monthly please send one to my Email akinyua24@yahoo.com

  13. Sri on November 9th, 2010 8:31 am

    Awesome work

    Very useful templetes

    Thanks for sharing

    Pls keep me updated any new productes

  14. Sri on November 9th, 2010 8:32 am

    my email id

    srinivasanssi@gmail.com

  15. LOPY on December 13th, 2010 10:49 am

    =))

  16. Thoa on September 16th, 2011 10:57 am

    Thank you for your very useful template.

  17. Art Casanova on December 28th, 2011 1:07 am

    Hello Admin,
    I may have fix the broken category issue. Thanks
    Art

  18. Cat on February 1st, 2012 11:03 am

    Hi
    I have loaded all my categories, and finished my budget sheet. Now started to load expenses in the daily Income and Expense sheet, and its not pulling the info over to the Monthly expense sheet.

    Please advise

    Cat

Leave a Reply