Open Office Savings Spreadsheet

PixelPound

flaneurs_lobster said:

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......

https://templates.openoffice.org/en/template/monthly-annual-income-expense-tracker

wmb194

boingy said:

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!

You don't need to fiddle with it to get the basic program running - MS fixed the issue it introduced in a Windows update years ago - but yes, online quotes don't work out of the box anymore but the OP wasn't asking about this.

AyJaydee

I also produced my own spreadsheet, using Excel, which I have tailored to my own needs.
The main features of it are:
One page for each account that I have. The columns are date of transaction, transaction detail, debit, credit, statement it appears in, balance.
I also have a separate page to give a summary of all accounts. The columns for this are name of Bank/BS, name of account, type of account (current, monthly saver etc), fixed/variable interest, interest rate, special terms, maturity date, current balance, projection of interest earned per year.   I then sort this in terms of descending interest rate, so that I can be sure that I am always favouring those accounts that pay the highest interest.  Additionally, I also regularly monitor interest rates on a spread of providers and I list any that catch my attention.

Lastly, and most importantly; when I open the file to add any entries (which I do regularly), the first thing that I do is save a copy of it.  That way, if I mess things up, it's not lost.

poseidon1

DoneWorking said:

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 

If you only wish to track balances on your various bank accounts, I heartily recommend the mobile open banking app from Money Dashboard. I use it on my 10  inch tablet with biometric login to the app for quick easy access.

It's open banking architecture will capture bank ( and credit card) balances from the mainstream high Street providers, that you have permitted access. A few of the app based bank accounts such as monzo and chip are also accommodated. It is a read only app, so does not allow you to make bank transactions via the app ( not that you would want to!).

For others accounts such as building societies , nsi products and cash held on investment platforms such as hargreaves lansdown, these can be added manually and updated yourself.

In this way, you get a one page summary for all your account balances under appropriate sub headings ( current accounts, savings accounts, credit cards, other accounts).

The great thing about the app is the real time updates for all daily transactions from your mainstream bank and credit cards providers such as Barclays, Lloyds, Nat west etc. The top of page  gives you a running total for all your cash and credit card balances, including those you periodically entered manually.

Of course  if you don't want to include credit card balance tracking this can be excluded at your option.

The app has budgeting functionality, but this I  ignore.

All in all a great informative  time saver, at the press of a thumbprint on your mobile device and available free on both the Google and Apple app stores, as well as a computer desktop version.

DoneWorking

All I want is a simple spreadsheet with following columns
Bank / Building Society
Account Details
Type of Account
Maturity Date
Interest Rate
Current Balance 

I need a minimum of four rows for different accounts with same Bank/BS

I need a row for current total balance 

The current balances should add up to provide total balance

I would enter the individual sums once per month 

I'm useless at spreadsheets 
Can anyone help 

I'm using LibreOffice

EthicsGradient

DoneWorking said:

All I want is a simple spreadsheet with following columns
Bank / Building Society
Account Details
Type of Account
Maturity Date
Interest Rate
Current Balance 

I need a minimum of four rows for different accounts with same Bank/BS

I need a row for current total balance 

The current balances should add up to provide total balance

I would enter the individual sums once per month 

I'm useless at spreadsheets 
Can anyone help 

I'm using LibreOffice

It sounds like there's only one calculation that it will do - "current total balance".
So, put your 6 column headings in row 1, columns A to F.
In row 2, column F, enter '=SUM(F3:F999)' (I've shown single quotes around what you actually type in)
Then in row 3, enter the details of your first account, the next on row 4, etc.
This will add up any values in column F, from row 3 downwards (I assume you'll never have 999 accounts, even if you leave in past details with a zero balance in a row for closed accounts, I just picked that as a number more than you'll ever have).
You could put "total balance" in column G, row 2, next to the total, so it's clear what it is.

DoneWorking

EthicsGradient said:

DoneWorking said:

All I want is a simple spreadsheet with following columns
Bank / Building Society
Account Details
Type of Account
Maturity Date
Interest Rate
Current Balance 

I need a minimum of four rows for different accounts with same Bank/BS

I need a row for current total balance 

The current balances should add up to provide total balance

I would enter the individual sums once per month 

I'm useless at spreadsheets 
Can anyone help 

I'm using LibreOffice

It sounds like there's only one calculation that it will do - "current total balance".
So, put your 6 column headings in row 1, columns A to F.
In row 2, column F, enter '=SUM(F3:F999)' (I've shown single quotes around what you actually type in)
Then in row 3, enter the details of your first account, the next on row 4, etc.
This will add up any values in column F, from row 3 downwards (I assume you'll never have 999 accounts, even if you leave in past details with a zero balance in a row for closed accounts, I just picked that as a number more than you'll ever have).
You could put "total balance" in column G, row 2, next to the total, so it's clear what it is.

Thanks  so much EG
Do you have a link for doing stuff like this on spreadsheets 

EthicsGradient

DoneWorking said:

EthicsGradient said:

DoneWorking said:

All I want is a simple spreadsheet with following columns
Bank / Building Society
Account Details
Type of Account
Maturity Date
Interest Rate
Current Balance 

I need a minimum of four rows for different accounts with same Bank/BS

I need a row for current total balance 

The current balances should add up to provide total balance

I would enter the individual sums once per month 

I'm useless at spreadsheets 
Can anyone help 

I'm using LibreOffice

It sounds like there's only one calculation that it will do - "current total balance".
So, put your 6 column headings in row 1, columns A to F.
In row 2, column F, enter '=SUM(F3:F999)' (I've shown single quotes around what you actually type in)
Then in row 3, enter the details of your first account, the next on row 4, etc.
This will add up any values in column F, from row 3 downwards (I assume you'll never have 999 accounts, even if you leave in past details with a zero balance in a row for closed accounts, I just picked that as a number more than you'll ever have).
You could put "total balance" in column G, row 2, next to the total, so it's clear what it is.

Thanks  so much EG
Do you have a link for doing stuff like this on spreadsheets 

No, no link - just start with a new spreadsheet (open LibreOffice Calc without giving it an existing spreadsheet, or select New, then Speadsheet from the File menu if you already have Calc open), and then fill the cells as above.

BooJewels

A quick cursory look showed up lots of video tutorials on YouTube for spreadsheets in LibreOffice - I often find it easier to watch someone doing something than reading about it.  Perhaps use the word 'beginner' initially to narrow them down, so that you don't start off with one that's too advanced.

There's also this list of LibreOffice tutorials.

janusdesign

DoneWorking said:

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 

if you wanted an online alternative to using a spreadsheet for this, Money Dashboard (Classic) is what I use to get a snapshot of my account balances.

• for most current accounts, it should be able to (if you want it to) pull the latest balances and transactions from the accounts;
• for savings accounts, you can choose "Offline Sources" and manually edit their balances whenever you need to.