Open Office Savings Spreadsheet

DoneWorking

Are there any simple list type spreadsheets to use with my savings accounts
I have quite a few with banks and building societies
I would update the balance for each bank every month and edit each  account as necessary as I move money about to suit  best accounts

The spreadsheet would be used simply to add up the various sums in each account with the different banks and building societies

It's main function would be to keep a record of the money in each account and add the total
from month to month 

nic_c

Yes, plenty on the web. There are even step by step tutorial ones, so you can create/customise to your own specification. 

flaneurs_lobster

nic_c said:

Yes, plenty on the web. There are even step by step tutorial ones, so you can create/customise to your own specification. 

Help this poor old soul out @nic_c with a couple of suggestions.

Me Googling's not what it was, a couple of my keycaps have dropped off and there's a faint smell of burning......

boingy

There are also various free applications you can use. I use KMyMoney
It can handle quite complicated stuff if you want but it can also be used as a simple account manager. There are other applications too, at varying levels of complexity.
I always used to use MS Money but it became increasingly difficult to keep it running properly on newer versions of Windows.

kuratowski

What you need is really just two columns (account name and balance) - almost too simple for a template!  Maybe you could use the template below as the basis of your spreadsheet, ignoring the parts of it that don't apply to you.

https://templates.openoffice.org/en/template/list-financial-accounts-uk

Edit: uploaded a more appropriate template

ChilliBob

I find it's best to do this to suit your own needs and let it expand as you feel necessary to be honest. 

One tip, from my own experience, it's handy to know when accounts were opened and, if relevant, closed. This comes in useful when it comes to tax, you might be tempted to skip thay zero balance account and forget it had a few k in there before which may have applicable tax. 

Other than thay gotcha, I think everything else is self explanatory really. 

This assumes you want something simple where you just update the totals each time and done keep a running record or anything - that would require more thought regarding structure and sfuff 

BooJewels

I use an Open Office spreadsheet to keep track of my accounts and it has evolved significantly over the years and is now pretty extensive.  I would suggest that this is something pretty personal and individual to yourself and you might be as well to start your own - that way you get what you want.   I've never found any software or templates that suited me better than my own system.

The spreadsheet functions for this sort of purpose are pretty simple in spreadsheet formula terms, largely just adding up columns - bread and butter stuff in comparison to the power modern spreadsheet software is capable of.  

I personally do one sheet per account or organisation and then three columns for that account - a wider one for the transaction details I write in, a middle numeric column for projected figures and the right hand one is actual figures once they happen - both of those 2 columns have totals at the bottom.  For example, I already know what the monthly interest will be on a couple of accounts, but it hasn't been paid yet, so in the left column I'd write 'Interest due 7th August 2023' and the amount in the middle column, so that I can see what the total will be after it's added and when it arrives it gets repeated in the right column - that then being what I actually have.  I also colour the description cells depending on whether they're a guess, known number or actually happened.

A fairly recent epiphany for me was finding out that I can transpose the totals from some cells onto other sheets by using the sheet name and cell number.  So, now that I have a few accounts, I also run an overview sheet and the total for each account is repeated on that sheet with sub totals for each organisation where I have multiple accounts and a grand total for all my money.  I don't manually update that sheet routinely (unless I add an account) as the results are generated dynamically from the account sheets that I do update.  Some accounts you need to look at fairly frequently and update your sheet (like your main current account), others maybe only once a month when interest is due or something.  

I also keep a number of other sheets with various lists, projections and calculations in for reference or curiosity - but I'm a bit of a geek and like messing with data.

wmb194

boingy said:

There are also various free applications you can use. I use KMyMoney
It can handle quite complicated stuff if you want but it can also be used as a simple account manager. There are other applications too, at varying levels of complexity.
I always used to use MS Money but it became increasingly difficult to keep it running properly on newer versions of Windows.

MS Money (2005 UK) hasn't been a problem for me. To make it a little more challenging, at the moment I'm running it on a Windows 11 virtual machine on a Mac with an ARM processor i.e. not the microprocessor architecture it was designed for and it works beautifully. If the OP wants something free and good this is a great option.

On the Mac a new one I came across is called MoneyWiz. Seems okay after a quick look but I still prefer Money. If you do things manually it's free but you can have it download transactions for your UK current accounts via OpenBanking if you pay a monthly or annual fee (though I just tried it with Lloyds and it worked but I haven't paid anything).

boingy

wmb194 said:

boingy said:

There are also various free applications you can use. I use KMyMoney
It can handle quite complicated stuff if you want but it can also be used as a simple account manager. There are other applications too, at varying levels of complexity.
I always used to use MS Money but it became increasingly difficult to keep it running properly on newer versions of Windows.

MS Money (2005 UK) hasn't been a problem for me. To make it a little more challenging, at the moment I'm running it on a Windows 11 virtual machine on a Mac with an ARM processor i.e. not the microprocessor architecture it was designed for and it works beautifully. If the OP wants something free and good this is a great option.

On the Mac a new one I came across is called MoneyWiz. Seems okay after a quick look but I still prefer Money. If you do things manually it's free but you can have it download transactions for your UK current accounts via OpenBanking if you pay a monthly or annual fee (though I just tried it with Lloyds and it worked but I haven't paid anything).

Yep, I know people are still using it but I got sick of having to fiddle with it. It stopped working, then someone did a new patch for it, then it worked for a while then the online quotes stopped working so there was a fix for that etc. So I evaluated all of the open source and free Windows alternatives and settled on the one that fitted me best. (The prize for the most unfathomable goes to GnuCash!) I still have MS Money on my old machine so I haven't bothered transferring all the data into KMyMoney, I just started afresh and created a new database of my accounts, pensions and investments. It's not perfect but it does the job and hopefully will require less ongoing fiddling!

Swipe

I just google sheets for all my spreadsheets, that way I can access them from my phone and any PC in the house.

nic_c

boingy said:

There are also various free applications you can use. I use KMyMoney
It can handle quite complicated stuff if you want but it can also be used as a simple account manager. There are other applications too, at varying levels of complexity.
I always used to use MS Money but it became increasingly difficult to keep it running properly on newer versions of Windows.

I also use KMyMoney running 4 current accounts and 9ish savings. The only problem is no password protection unless you store the data in a database rather than the default simple file. Only a problem if you share your computer. 

Totally free and offline (unless you want to use the quotes for share prices), and identifying info like name account numbers etc are optional and I leave off.