Separate smaller pot of money from a larger one.

[Carteani]

Good evening Mr Excel and helpers (I`m in England and it`s 22:22 at the mo).

I have a question and I would really appreciate your help.

I have a budget spreadsheet that has really helped over the years but now I`d like to refine it. My goal is to have a pot of money for my "pleasure" (beers, a meal out now and again, a treat for my children and so on). My spreadsheet covers all "in comings" (salary, pension etc) and all out goings (elastic trickery, gas etc). For the sake of this question, let`s say my monthly budget is £1000 and, after all bills are paid (let`s say my bills are £400) I have £600 left of the budget; out of this, I would like a personal "pot" of £100. The remainder of which will be carried forward to the next month. Could somebody be good enough to provide a formula that will allow this. Thank you very much in advance. Cartini.

 

[etaf]

Can you treat it as a BILL "personal " and just deduct £100 each month from the income

I do this as a line on my budget sheet (slightly more complicated) and i then transfer to a savings account each month
as i say more complicated , as i also have any annual deductions setup up and use a totla to cover those each month
say i pay - car tax £200 and insurance £1000 - then 1000+200 = 1200 / 12 months = 120
so i put away 120 a month to cover those as a line in the budget and then when i pay - either i transfer from savings to account if in credit or from account to savings if a deit

 

[Carteani]

Can you treat it as a BILL "personal " and just deduct £100 each month from the income

I do this as a line on my budget sheet (slightly more complicated) and i then transfer to a savings account each month
as i say more complicated , as i also have any annual deductions setup up and use a totla to cover those each month
say i pay - car tax £200 and insurance £1000 - then 1000+200 = 1200 / 12 months = 120
so i put away 120 a month to cover those as a line in the budget and then when i pay - either i transfer from savings to account if in credit or from account to savings if a deit

Hi etaf, thank you.

I`d never considered counting it as a bill, so I`ll give that a go. Thank you.

 

[etaf]

you are welcome