How do I set up a simple finances spread sheet in excel?

[guapo337]

I wanna track how much money is coming out, and if I can handle paying certain monthly payments. How exactly should I set it up? What should the various columns be?

 

[conjur]

I did something like this. You can figure out the formulas that would have been in the next column

Monthly Budget
Income
Salary



Expenses

Rent
Car Payment
Gas/Oil/Tires
Groceries
Utilities
Cable
Internet
Phone
Clothes
Entertainment
Cell Phone
Pet care
Car Insurance
Renter's Insurance
Haircuts
Child Support
School Supplies/Fees
Bank Fees
Postage

Total Expenses
Monthly Income

Once a year expenses
Birthdays
Christmas

Net Income
Yearly Income

 

[guapo337]

Impressive

 

[BrunoPuntzJones]

LInk

A ton of premade spreadsheets, I'm sure you'll find a good one and can modify it. Was very useful when I got my Axim

 

[MaxDSP]

Originally posted by: BrunoPuntzJones
LInk

A ton of premade spreadsheets, I'm sure you'll find a good one and can modify it. Was very useful when I got my Axim

sweet, wish I had known about this sooner. Thanks