We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
Budgeting with pots spreadsheet

kerri_dfw
Posts: 4,556 Forumite


I've done a search but couldn't find anything similar but apologies if it already exists.
(Link removed by Forum Team)
I've been reading a lot about budgeting using the envelope system or the pots system, whereby you put away an amount each month to save up for annual spends.
This can be used for paying car insurance, road tax, freezer breakdowns, council tax etc. Anything where you pay extra to pay monthly can be allocated to a pot.
How it works
The spreadsheet can currently hold 11 different bills, but I can adapt it to hold more if required. I only have 8 different bills on mine.
In row 1 you enter the name of the bil then in row 2 type in the amount that bill costs annually.
The other rows then update to say how much needs to be allocated to each "pot" monthly.
Field N3 shows the amount that needs to be set aside each month.
The fields in orange are automatically updated using formulae and do not need any information entered into them.
Paying money in
Each month you update the fields M8 - M19 with the amount that you've put into the pot. These are higlighted in blue with a black border.
Then you transfer money into your pot, either physically with cash, or virtually with bank transfer.
Spending pot money
As these are annual payments, as long as your payments aren't all grouped together you should be able to dip into the pots. So for example in June a lot of my car payments go out, making it a month where I have to find £800+. However, as I've paid in for 6 months I have the money there to pay it in full
I've overestimated my bills slightly in case insurance goes up etc, then there are no surprises.
To record a spend, find the bill and go down the column until you get to the correct month in the "spend" section. This is highlighted in green with a black border. These fields are set to be GDP currency.
Why it's a good practice
Even if you start with one bill that you are charged a premium for paying monthly, you are saving on those interest payments
You'll also always have some "emergency" money, for when the freezer breaks or the car needs new tyres etc.
How to make your own
Go to File > Download As > Excel and you can save the file to your computer. If you then open the file and save as you will be able to edit it yourself as the one I have published is read only.
(Link removed by Forum Team)
I've been reading a lot about budgeting using the envelope system or the pots system, whereby you put away an amount each month to save up for annual spends.
This can be used for paying car insurance, road tax, freezer breakdowns, council tax etc. Anything where you pay extra to pay monthly can be allocated to a pot.
How it works
The spreadsheet can currently hold 11 different bills, but I can adapt it to hold more if required. I only have 8 different bills on mine.
In row 1 you enter the name of the bil then in row 2 type in the amount that bill costs annually.
The other rows then update to say how much needs to be allocated to each "pot" monthly.
Field N3 shows the amount that needs to be set aside each month.
The fields in orange are automatically updated using formulae and do not need any information entered into them.
Paying money in
Each month you update the fields M8 - M19 with the amount that you've put into the pot. These are higlighted in blue with a black border.
Then you transfer money into your pot, either physically with cash, or virtually with bank transfer.
Spending pot money
As these are annual payments, as long as your payments aren't all grouped together you should be able to dip into the pots. So for example in June a lot of my car payments go out, making it a month where I have to find £800+. However, as I've paid in for 6 months I have the money there to pay it in full

I've overestimated my bills slightly in case insurance goes up etc, then there are no surprises.
To record a spend, find the bill and go down the column until you get to the correct month in the "spend" section. This is highlighted in green with a black border. These fields are set to be GDP currency.
Why it's a good practice
Even if you start with one bill that you are charged a premium for paying monthly, you are saving on those interest payments

How to make your own
Go to File > Download As > Excel and you can save the file to your computer. If you then open the file and save as you will be able to edit it yourself as the one I have published is read only.
Diary: Getting back on track for 2013 and beyond
DEBT FREE 13-10-13 :dance::dance::dance::dance::dance:
Beautiful daughter born 11.1.14
Beautiful daughter born 11.1.14
Mortgage: [STRIKE]£399,435.91[/STRIKE] £377218.83
Deposit loan from Dad: £9000[STRIKE]£10000[/STRIKE]
Deposit loan from Dad: £9000[STRIKE]£10000[/STRIKE]
0
Comments
-
Guess what I'll be doing later?! :O)Everything is ok in the end. If it's not ok, then it's not the end
Every penny's a prisoner0 -
Hehe don't forget to copy and paste it as I can't work out how to upload a google doc for others to download, but should work with a c+pDiary: Getting back on track for 2013 and beyondDEBT FREE 13-10-13 :dance::dance::dance::dance::dance:
Beautiful daughter born 11.1.14Mortgage: [STRIKE]£399,435.91[/STRIKE] £377218.83
Deposit loan from Dad: £9000[STRIKE]£10000[/STRIKE]0 -
Looks interesting Kerri..will have a nose laters xMFiT-T4 Member No. 96 - 2022 is my MF goal
Winter 17/18 Savings Rate Goal: 25% [October 30%] :T
Declutter 60 items before 31.03.18 9/60 ** LSDs Target 10 for March 03/10 **AFDs 10/15 ** Sales/TCB Target 2018 £25/£500 NSDs Target 10 for March 02/10 Trying to be a Frugalista:rotfl::T0 -
Will take a good look at this. I have my own collection of spreadsheets, which I'm pretty addicted to! :rotfl::jDebt Free By Xmas 2013 #010 £16,660.26/£16,660.26 100% paid, DFD 25/06/13!:j0
-
thanks for sharing kerri
looks similar to mine actually but might be better....so going to have a proper look now! dfw x
MORTGAGE BALANCE when we moved Aug 2024, £120,000. January 1st £118,267.06. May 1st, £116, 123Mortgage Overpayments - September-December, £152.46. Jan £103.27, Feb £115, March £91.50, April £100, May £200.
Total- £762.23
Goal to pay off 1% of current mortgage in one year. £1200. (63.5% there)
0 -
If anyone wants an emailed copy with it in excel then I can email them one when I'm in work as I don't have office on my home machine, just DM meDiary: Getting back on track for 2013 and beyondDEBT FREE 13-10-13 :dance::dance::dance::dance::dance:
Beautiful daughter born 11.1.14Mortgage: [STRIKE]£399,435.91[/STRIKE] £377218.83
Deposit loan from Dad: £9000[STRIKE]£10000[/STRIKE]0 -
If using chrome you can download it as an excel file which you can then edit x
ETA: Although when I changed a figure in the second row, it went to ######## so not sure what I did!Became Mrs Scotland 16.01.16Became homeowners 26.02.16
Baby girl arrived 27.10.16
Baby boy arrived 16.09.2018
0 -
Thanks very much Kerri - I have downloaded it into Excel and will be using it very soonPay debt in 2012 #278 £2347/£5364
Sealed Pot 5 #1713 £78.57 //Crazy Clothes Challenge #97 £79.49/£100
Grocery Challenge:
Feb £359/£360 Mar £390/£450 Apr £335/£320
May £330/£320 Jun £455/£400 Jul £321/£320
Aug £399/£370 Sep £345/£300 Oct £421/£400 Nov £0/£3200 -
If anyone wants an emailed copy with it in excel then I can email them one when I'm in work as I don't have office on my home machine, just DM me
You can put Open Office (https://www.openoffice.org) on your pc which is free and opens xls/xlsx formats.Estate Agent, Web Designer & All Round Geek!0 -
I think I might be able to upload the spreadsheet to some server space I have for people to be able to download it willynilly
Will investigate this when I get home.
I'll also upload my 2nd purse/stockpile spreadsheet I've made which makes 2nd purse easier to understandDiary: Getting back on track for 2013 and beyondDEBT FREE 13-10-13 :dance::dance::dance::dance::dance:
Beautiful daughter born 11.1.14Mortgage: [STRIKE]£399,435.91[/STRIKE] £377218.83
Deposit loan from Dad: £9000[STRIKE]£10000[/STRIKE]0
This discussion has been closed.
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 350.2K Banking & Borrowing
- 252.8K Reduce Debt & Boost Income
- 453.2K Spending & Discounts
- 243.1K Work, Benefits & Business
- 597.5K Mortgages, Homes & Bills
- 176.5K Life & Family
- 256.1K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards