Open Office Savings Spreadsheet

flopsy1973

kuratowski said:

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

Hi 
tried to download this but comes up with adobe could not open due to file type not supported 
what am i doing wrong i have downloaded openoffice and java help please

EthicsGradient

flopsy1973 said:

kuratowski said:

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

Hi 
tried to download this but comes up with adobe could not open due to file type not supported 
what am i doing wrong i have downloaded openoffice and java help please

The file is type .ots (an OpenOffice Template for a Spreadsheet), so ought to be opened by OpenOffice (/ LibreOffice), not by anything Adobe-related. You'll have to find how your operating system has wrongly associated the type with Adobe with its help, I'm afraid, but in the meantime, if your downloads go to a standard place (eg a Downloads folder), you can start OpenOffice/LibreOffice on its own without giving it a file, then select 'Open...' from the 'File' menu, go to the Downloads folder, and open it manually.

PragueAddick

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.

Just to say, I liked the sound of this, and thanks for mentioning it, but I use Macs and it refused to open it as "Apple cannot check it for malicious software". I'll try to notify the developers if it is easy enough to do so.

Eco_Miser

DoneWorking said:

Eco_Miser 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

You say you're useless at spreadsheets, but you've already defined what you want.

Just open a new Calc document in LibreOffice, put the column headings in the first six columns

Fill in the following rows with the data for each account.

In the following row, put the words 'current total balance' in the first column, then put the cursor in the Current Balance column, same row, and click in the Sigma button (Select Function on the tooltip) on the toolbar, select Sum, click again. The formula '=SUM(F2:F11)' or something similar should appear in the cell, with a blue rectangle round all the Current Balances. Click the green tick.

That's it. Save the spreadsheet with your choice of name. Job done.

To add extra accounts, click in the left margin, in the row below where you want to add, right click, select 'Add rows above', then fill in the new row created. The total should adjust to still include all rows.

How do I resize the columns to suit the text and account details 

Any of the ways mentioned already. I put the cursor in the cell with the overflowing text, then press Shift+Alt+right arrow on the keyboard. Alt+arrow changes the width or height of a column or row depending on arrow direction.

Note: pressing F1 will normally open searchable help in your browser. A few hours exploring that (a few minutes at a time as questions arise) should get you much less useless at spreadsheets.