Deleted
Joined: Apr 28, 2024 23:01:05 GMT -5
Posts: 0
|
Post by Deleted on Jan 16, 2011 23:04:01 GMT -5
I put it on an excel worksheet and everything. I filled in my fixed budget for every month with formulas to take my net for the month and add it to my savings amount. So when I put in an amount for miscellaneous spending it immediately takes it off the total I can save for the year. I think I am going to find this very motivating.
|
|
❤ mollymouser ❤
Senior Associate
Sarcasm is my Superpower
Crazy Cat Lady
Joined: Dec 18, 2010 16:09:58 GMT -5
Posts: 12,857
Today's Mood: Gen X ... so I'm sarcastic and annoyed
Location: Central California
Favorite Drink: Diet Mountain Dew
|
Post by ❤ mollymouser ❤ on Jan 16, 2011 23:06:51 GMT -5
Cool! Did you include a line item for lottery tickets? (grin)
|
|
Deleted
Joined: Apr 28, 2024 23:01:05 GMT -5
Posts: 0
|
Post by Deleted on Jan 16, 2011 23:08:43 GMT -5
That is the miscellaneous line. Right now I don`t want to put ANYTHING on that line!
|
|
Sharon
Senior Associate
Joined: Dec 19, 2010 22:48:11 GMT -5
Posts: 11,151
|
Post by Sharon on Jan 16, 2011 23:12:38 GMT -5
I am going to have to learn how to do formulas. I have a spreadsheet and bunches of categories and it looks cool and I enter in everything I spend then at the end of the month auto sum my line. That is about the sum and substance of my spreadsheet ability.
|
|
Deleted
Joined: Apr 28, 2024 23:01:05 GMT -5
Posts: 0
|
Post by Deleted on Jan 16, 2011 23:26:03 GMT -5
Formulas in excel are easy! I do revenue minus expenses. Go to the cell you want the total to show up in. Identify the cell that holds your total revenue. For this lets say it`s C7. Then identify the cell that holds your total expenses. For this let`s say that is C35. The formula is =(C7-C35)
|
|
NastyWoman
Senior Associate
Joined: Dec 24, 2010 20:50:37 GMT -5
Posts: 14,354
Member is Online
|
Post by NastyWoman on Jan 17, 2011 0:59:40 GMT -5
Formulas in excel are easy! I do revenue minus expenses. Go to the cell you want the total to show up in. Identify the cell that holds your total revenue. For this lets say it`s C7. Then identify the cell that holds your total expenses. For this let`s say that is C35. The formula is =(C7-C35) I also sum by certain categories, such as electricity and cc (my misc. category) to compare with my forecast over the full year
|
|