Budgeting with pots spreadsheet

kerri_dfw
kerri_dfw Posts: 4,556 Forumite
1,000 Posts Combo Breaker Debt-free and Proud!
edited 2 April 2024 at 2:25PM in Budgeting & bank accounts
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.
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
Mortgage: [STRIKE]£399,435.91[/STRIKE] £377218.83
Deposit loan from Dad: £9000[STRIKE]£10000[/STRIKE]
«1

Comments

  • hp48910
    hp48910 Posts: 216 Forumite
    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 prisoner:p
  • kerri_dfw
    kerri_dfw Posts: 4,556 Forumite
    1,000 Posts Combo Breaker Debt-free and Proud!
    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+p :)
    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
    Mortgage: [STRIKE]£399,435.91[/STRIKE] £377218.83
    Deposit loan from Dad: £9000[STRIKE]£10000[/STRIKE]
  • brizzledfw
    brizzledfw Posts: 7,302 Forumite
    Debt-free and Proud!
    Looks interesting Kerri..will have a nose laters x
    MFiT-T4 Member No. 96 - 2022 is my MF goal :D
    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::T
  • HelenPie
    HelenPie Posts: 502 Forumite
    Will take a good look at this. I have my own collection of spreadsheets, which I'm pretty addicted to! :rotfl:
    :j
    Debt Free By Xmas 2013 #010 £16,660.26/£16,660.26 100% paid, DFD 25/06/13! :D
    :j
  • 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, 123

    Mortgage 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)

  • kerri_dfw
    kerri_dfw Posts: 4,556 Forumite
    1,000 Posts Combo Breaker Debt-free and Proud!
    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 :)
    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
    Mortgage: [STRIKE]£399,435.91[/STRIKE] £377218.83
    Deposit loan from Dad: £9000[STRIKE]£10000[/STRIKE]
  • 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.16 :heart:Became homeowners 26.02.16 :heart:Baby girl arrived 27.10.16 :heart:Baby boy arrived 16.09.2018
  • Thanks very much Kerri - I have downloaded it into Excel and will be using it very soon :)
    Pay 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/£320
  • steve1980
    steve1980 Posts: 2,334 Forumite
    kerri_dfw wrote: »
    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!
  • kerri_dfw
    kerri_dfw Posts: 4,556 Forumite
    1,000 Posts Combo Breaker Debt-free and Proud!
    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 understand :)
    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
    Mortgage: [STRIKE]£399,435.91[/STRIKE] £377218.83
    Deposit loan from Dad: £9000[STRIKE]£10000[/STRIKE]
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

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

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.