Excel Budget Planners

jemz0001

Hi,

I have heard many of you talking about having created ur own systems to keep track of your money! I would be very interested in recieving these, just to give me a starting point!

If possible I would be greatful if you could send me one through to [EMAIL="tweety_pie_45@hotmail.com"]tweety_pie_45@hotmail.com[/EMAIL]

Thanks,

Jemma

Lokolo

Done

Hope it helps. Mine is a little complicated though

jemz0001

HI Lokolo,

Just wondering do you record daily spends then fill this in at the end of the month?

Lokolo

No I just update it every time I spend.

So if I spend £30 on going out I put £30 straight away.

Then if I spend another £50 a week later I just update it to £80.

KPR11

Sorry to hijack your thread Jemz, any chance I can be cheeky and request the same please? Thanks

jemz0001

Work away KPR11! Great starting point!!

MoneySavingUser

you should upload it Lokolo to some filehosting site

Lokolo

http://www.mediafire.com/?im0ly2t5k2w

Try that.

jemz0001

ANyone else with any other budget planners or how does everyone keep track of their spends?

SimbaSimon

jemz0001 wrote: »

Hi,

I have heard many of you talking about having created ur own systems to keep track of your money! I would be very interested in recieving these, just to give me a starting point!

If possible I would be greatful if you could send me one through to [EMAIL="tweety_pie_45@hotmail.com"]tweety_pie_45@hotmail.com[/EMAIL]

Thanks,

Jemma

Hi Jemma,

This may be a little over the top but heres how I keep track of myself and partners income/expenditure. Note: I've modified the values to fictional ones but you get the idea

So from left to right...
Bills - Monthly regular bills listed with rough amounts and when they come out approximately.
Person 1 Money - Income and regular bills that person 1 receives and pays
Person 2 Money - Same as Person 1 but if you have 2 wage earners.
Below that, Balances - I check balances daily and update these, net worth is what I currently have which is Current Account + Savings - Credit Cards - and Loans = Net Worth. I don't include the mortgage for obvious reasons! :rotfl:
Over to the right I list each regular bill (whether its monthly, quarterly or yearly - I keep this upto date 12 months in advance and plan in car services, and other regular things. At the bottom I get the amount I should have left over that is mine to spend/save as necessary. Regular savings are also listed as these are viewed as money which isn't to be spent (Although I do make changes sometimes).

So I can plan 12 months expenditure and know what I should have spare for the next 12 months. Emergencys aren't allocated for as these are what the seperate savings accounts and left over money is used for.




So thats my summary report :beer: But I also have a monthly calculater which I use to track spending, so moving on...

I track each weeks necessary expenditure, e.g. shopping, petrol, basically anything thats required. This gives me a total for each week which allows me to work out future expenditure for the summary report.

Monthly bills are listed here again to give me a history of whats paid. While the current and next 11 months are on the summary, once one month is cleared I move onto the next month deleting the old one (and creating a month for 12 months time!) So this gives me a history of bills paid. I also have an extras column which lists anything which wasn't required to buy, but was brought and paid for. E.g. clothing that isn't necessary is an extra and can be cut back if required :rotfl:

Finally I have totals for take home pay of person 1 and 2, what they have left after bills plus what % of their salary they have used to pay for bills. I copy the sheet each month so I have a detailed history of what we spent and where over the years, this currently goes back 5 years :eek:



I'd be happy to send it to you, but I understand if its a bit over the top.

Lokolo

Bloody hell, and I thought mine was complicated!