Budgeting with Google Spreadsheets

So I’m rapidly becoming all consumed with getting my shit together (sorry for the profanity but sh*t says it all…).

Today I’ve spent the best part of 3 hours familiarizing myself with ‘Google Spreadsheets’ for monthly budgeting. Although I love scribbling on paper and in my daily diary, I have to say after pulling my hair out initially, I now LOVE using this spreadsheet! The one I’m using is ‘Monthly Budget’ under the top right hand drop down menu for ‘Templates’. OK so I know in the 1940’s it would have all been done on paper, and I love to keep things simple BUT having this in addition to fill in and update at weekends is making me VERY HAPPY!

OK, I know you are probably thinking right now “for God’s sake woman, go and get a curvy, hairy, beardy man and misbehave” because quite frankly it is a little bit sad that I am getting so excited about  spreadsheets. Trust me, I’ve been thinking that myself recently…..

Infact I know exactly the man I’d pick (in Barnsley) but I’m still slightly “off” men in real-life and not quite ready to jump back in the sheets and do strange and wonderful things…soooooo for now ‘Google Spreadsheets’ it is!

I’m loving the ‘Monthly Budget’ template. CLICK HERE

First of all I worked out how to change the currency from $ to £, next to add extra rows while keeping the formula which does the calculations, I also then changed the spreadsheet to specify what country and time zone. Once that was all done then it was time to fill it in!

I’m filling it in real-time, once a week. This means that I’m adding in all my planned expenses and income and adding in the actual expenses and income as they come in. So when a direct debit comes out in the week I’ll update the spreadsheet, when my son pays me his weekly rent/bills contribution I’ll fill it in on the spreadsheet. By doing this it gives me a real-time up to date tally….isn’t that cool!

Even cooler is the fact that the template comes with a ‘Transaction’ ledger so when you fill it in on the ledger it updates the spreadsheet automatically!

So I’ve brought my February 2018 budget up to-date on my spreadsheet and I’ve taken a snap-shot and it’s below..

I’m hoping budgeting provides enough excitement for me in the coming months to keep me on the straight and narrow until the call of the curvy, hairy, beardy bloke becomes too much to resist….

C xxxxxx

PS: Are we friends yet? Connect with me on-

Facebook, Instagram, YouTube, Pinterest & Twitter!

PS: I was asked about changing the currency settings on the Google Spreadsheet – here is what you have to do

1) Go to https://docs.google.com/spreadsheets and select Monthly Budget from the template gallery.
2) Open up the sheet and select from the top drop down menu FILE > SPREADSHEET SETTINGS > ADJUST LOCALE/TIMEZONE > SAVE SETTINGS… return to main spread sheet.
3) You will notice that the currency symbol underneath the word format in the top drop down menu has now changed to a £ sign. If the sheet does not automatically change the symbols you will simply have to highlight the cell/cells you want to change the currency symbol in, once highlighted you click on the £ currency symbol from the top of the page and it will change all the $ to £ in the cells you have highlighted.
4) To highlight a cell you simply click once in the box then go and click on the £ symbol. To highlight multiple cells in a row then click on the top cell ie Food then hold down the shift button and select the bottom cell ie category 1 and all the cells inbetween will be highlighted too – then just click the £ symbol to change all of them. Alternatively to highlight several sporadically located cells click on 1 cell, hold down the CTRL key and select another anywhere on the page, keep the CTRL key depressed until you have finished selecting all the ones you want to change then goto the £ symbol and select.

I have changed currency and timezones on a spreadsheet for you. You’ll need to make sure that when you are logged in and save it that it is only viewable by yourself.

CLICK HERE FOR £ CURRENCY MONTHLY BUDGET SPREADSHEET

Advertisements