Page 1 of 18

budgeting - how?

Posted: Wed Dec 08, 2010 1:18 am
by 24hr-mum
do any of u guys do mthly budgeting?

how to do? any formula or spreadsheet?

i dont. just keep counting the cts n $ when spending time
sometimes not sure whr to spend or not cos not sure if spend too much that mth

Re: budgeting - how?

Posted: Wed Dec 08, 2010 6:08 am
by ParentingChildren
24hr-mum wrote:do any of u guys do mthly budgeting?

how to do? any formula or spreadsheet?

i dont. just keep counting the cts n $ when spending time
sometimes not sure whr to spend or not cos not sure if spend too much that mth
Hi 24hr Mum,

I do monthly budgeting and below is something that works for me. Hopefully, it can be useful for you too.

1. Plan
For a start, I think we need to have a plan. That can be easily done on a spreadsheet.

Decide how much of your household takehome pay is going to the various expenses/savings for the month. These expenses/savings can be lumped into big groups such as: Children Education Fund, Retirement account, Loans, Groceries, Fun and Others.

This step also depends on how couples choose to contribute towards household expenses/savings. For example, some couples prefer to contribute a sum towards household expenses/savings every month. Others may prefer to pay for certain items individually. I guess it is really a case of what works best for you.

This plan will ensure that you know how much you intend to spend and will serve as a good check when you overspend.

2. Divide the Money
Once you have decided how you would be spending the household income, the next step is to draw the money out and place your money into the various envelopes. With internet banking, you can easily transfer the money to various bank/savings accounts so physical envelopes are not needed.

3. Spend according to Plan
If you are using envelopes, you can tell how much you have left every time you draw out a sum of money from it.

With various credit cards linked to different bank accounts, you can tell how much you have spent through the bill statements online anytime.

4. Review at the end of the month
You may want look through the areas that you have overspend and decide if you can cut down or allocate more money to it.

Posted: Wed Dec 08, 2010 9:03 am
by 24hr-mum
thanks, i seldom use credit card cos lazy to pay the bills
the different timing of expenditure makes it quite complicated.

Posted: Wed Dec 08, 2010 9:47 am
by MMM
Yes I do monthly budgetting using spreadsheet.

I usually forecast my expenses 3 months ahead. I will list down the following :
Income
Forecasted detailed expenses (fees, insurance, maint, parents, loans, living expenses, road tax, estimated credit bills by credit card). Most of the items are predictable but some fees are paid on a term rather than monthly basis.
Balance in bank

I would update the actual credit card bill outstanding and the due date so that I can monitor the funds to know what is in or not. I've 2 bank accounts so I need to manage the cashflow between the 2. On the same spreadsheet, I also monitor my shares portfolio so that I know my total cash potential. So I update my spreadsheet everyday to know my latest position.

I have been doing this religiously for years so that I know my financial situation and whether I can afford to spend or not. Sounds too overboard :? That is my profession so maybe that's why it's easy for me to do it.

Posted: Wed Dec 08, 2010 9:50 am
by 24hr-mum
wow, its very disciplined of u, MMM.
it will be hard to keep track of petty expenses esp those without receipts.
since DH and I share same acct, i wld hv to ask him everyday how much he spent.

do u also update the expenses made by ur hubby?
he will remember them??

Posted: Wed Dec 08, 2010 10:36 am
by MMM
24hr-mum wrote:wow, its very disciplined of u, MMM.
it will be hard to keep track of petty expenses esp those without receipts.
since DH and I share same acct, i wld hv to ask him everyday how much he spent.

do u also update the expenses made by ur hubby?
he will remember them??
Fortunately or unfortunately, my hubby is also in the same profession so he manages his own finances. He will give me a lump sum each month so I will manage all the fees payment and items that we both have a share. I suppose each family is different. Eg. i recently sent him the detailed expenses that we've to share for 2011 so that we can align on the cost that each person has to contribute. If not... he will keep questioning me throughout the year why must he contribute so much,etc.... Then I will show him the proof of email :wink:

I've a lump sum budget for those misc items or living expenses. But for credit card spending, yes, I do update in my spreadsheet the anticipated charges by card. But I also based on past trend. Eg. during my forecast, I will include eg. 1k on misc credit card charges so when actual spending happen, i will offset against this estimate. This also allows me to know how much I've charged and whether have i blown my budget.

Yes, my spreadsheet ties to bank balances.

Actually, I like this exercise as it allows me to have a cashflow projection in few months time, etc.... It also allows me to analyse my spending eg. how % goes into savings and where my money went to.

Posted: Wed Dec 08, 2010 12:58 pm
by titank
MMM wrote:Yes I do monthly budgetting using spreadsheet.

I usually forecast my expenses 3 months ahead. I will list down the following :
Income
Forecasted detailed expenses (fees, insurance, maint, parents, loans, living expenses, road tax, estimated credit bills by credit card). Most of the items are predictable but some fees are paid on a term rather than monthly basis.
Balance in bank

I would update the actual credit card bill outstanding and the due date so that I can monitor the funds to know what is in or not. I've 2 bank accounts so I need to manage the cashflow between the 2. On the same spreadsheet, I also monitor my shares portfolio so that I know my total cash potential. So I update my spreadsheet everyday to know my latest position.

I have been doing this religiously for years so that I know my financial situation and whether I can afford to spend or not. Sounds too overboard :? That is my profession so maybe that's why it's easy for me to do it.
Wow very good leh! Can share with me the excel sheel you have a not?

Posted: Wed Dec 08, 2010 1:17 pm
by MMM
titank wrote: Wow very good leh! Can share with me the excel sheel you have a not?
PM me your email :wink:

Posted: Wed Dec 08, 2010 1:35 pm
by starlight1968sg
I dont count to the cents. Basically, set aside the amount you want to save or not to be touched, then you can use the rest.

Or: salary goes into account A and transfer $x into account B. That a/c B is up to you to spend.

Posted: Wed Dec 08, 2010 1:38 pm
by happymom_aa
MMM wrote:
titank wrote: Wow very good leh! Can share with me the excel sheel you have a not?
PM me your email :wink:

Can share with me too?