If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.
Would anyone mind posting what they have come up with as far as excel budget sheets. I have made so many different versions that I really dont know which one works. What do you like about yours?
Thank you,
My main sheet is for one month only. Across the top are the categories. Under those are the budgeted amounts. When I spend in that category, it automatically subtracts the numbers and updates the totals at the bottom of the sheet. Lets me know how much is left for that column. I also have it total up across the bottom automatically and then subtracts that total from the total income for the month. (since I know what that will be) That way, I know how much is left to be spent for the month. It also totals up across the budgeted amounts at the top so I can change a column if I see that I need to budget differently there and know I'm not going over income amounts. I have a new sheet for every month so I can track how things have been going in each column. Does that make sense?
Would anyone mind posting what they have come up with as far as excel budget sheets. I have made so many different versions that I really dont know which one works. What do you like about yours?
Thank you,
I attached sheet we use
It puts bills at top and income at bottom. it accounts for bills do each month, once per year, 2X per month etc and then averages it per month.
I get paid 2X month, wife sets paid semi weekly, so we needed to balance things. Changed enough numbers to protect the guilty. I hope.
Comment