Excel spreadsheet of house hold income and bills. HELP!

Question

Im trying to make a spreadsheet that estimates how much is being spent in ahouse hold based on the house hold income.

Can anyone help me create this? Im trying to get all of my bills layed out in one spread sheet that shows how much each bill is monthly which will be deducted out of a total amount of house hold income. HELP.

Answer 1

Send me your email, I made one that works great for us.

Answer 2

List all your titles in first column...then the amounts in second column...formulate your totals at the bottom  In the next column put all your income totals for each week, take that formulated total and subtract it from the bills, then you can formulate it to divide by either 4 or 5 weeks pay, depending on your pay day. You should be able to come out with a weekly spending amount and how much you have left over. Good Luck!

Answer 3

Easy:

One column should be income; include wages, interest income, and anything else you earn.  Be detailed.  Wages should be after taxes.

The other column is expenses.  Rent/mortgage, car, phone, energy bill (gas/electric or combo), groceries (have seperate entries for every visit to a food store), mobile phone/internet, cable and/or satellite tv, any other monthly expense (medical/dental bills, credit card(s), home security, cleaning services, other loans, etc.).

Include any personal items (shopping for personal items, clothes, household goods, etc.).

For your credit card bills, note the interest rate and the balance.