How to keep track of bank accounts (spreadsheets)?

Yorkie006

Hi, 
I've notice people mentioning keeping track of bank account on spreadsheets like Excel or similar.
What exactly do you record there? Account numbers, balances, % rate etc? I've just realised I have 12 accounts (4 current, the rest savings - some only have £1 in) so could do with being a bit more organised. All are paperless so need to log in on my computer every time I need to look something up (have an elderly smartphone so not compatible with apps) .
Thanks!

MACKEM99

I just list mine on an excel spreadsheet on my pc and update when required.  I print them so easy acces.

inspectorperez

If you are a Windows user, there is a very useful app called Moneypoint which helps you maintain all transactions on your bank accounts. This is available FOC in Windows Store

I find it very useful as a forecasting and budgeting tool as well as recording actual transaction histories. There is a memorandum section for each account where you can record S/C and account numbers etc. It's very versatile and you can export reports into Excel spreadsheets if you want to tinker with the way information is presented.

I use this in conjunction with a spreadsheet which records month end balances on all bank/investment accounts and assists in acting as a forecasting tool for investment decisions on fixed term bonds/ISAs etc.

Yorkie006

MACKEM99 said:

I just list mine on an excel spreadsheet on my pc and update when required.  I print them so easy acces.

Thanks, what info exactly do you list there?

tacpot12

I have a list of all my savings and investment accounts in a spreadsheet, mainly so that my representatives could find them all in the event of my death. I record the name of the organisation that holds the account, and the account numbers, and any sort codes. I also keep a note of the balance in the account, and use this to keep an eye on what my assets are. This is useful when I revise my will. 

Jami74

Yorkie006 said:

MACKEM99 said:

I just list mine on an excel spreadsheet on my pc and update when required.  I print them so easy access.

Thanks, what info exactly do you list there?

Account name (eg Halifax Reward). Sort code. Account number. Log in details for online, app, phone banking etc (star out the passwords leaving myself clues). Card number and expiry. Any special requirements (eg pay £500 on card every month). Date opened. Switch incentive received (date and amount). Date switched away and bank.

Have credit cards and savings accounts on additional tabs and include things like credit limits and promotion end dates and interest rates.

There's no way I could remember all the details of all my accounts. 

quirkydeptless

Yorkie006 said:

What exactly do you record there?

I record everything, even the number of postage stamps I have

Thumbs_Up

So much sophistication on show here, I use windows notepad! As for passwords and account numbers anything I don’t want compromised by a security breach I use my trusty notebook and pen.

 

Daliah

I record each and every transaction for my current, savings and investment accounts , so I always know down to the last penny how much money I have where. I also record SOs and DDs which are auto-filled into the respective current account at the relevant dates. Expected maturity dates and amounts for Notice accounts and Regular Savers are also added, at the time I set up the accounts.

As there is a Category assigned to each transaction - e.g. taxable interest, tax-free interest, switch bonus, transfer, dividend,  withdrawal etc etc - I can easily run summary reports for a given category and tax year, calendar year or any other time period. I find this particularly useful for the interest and dividend income I need for my Self Assessments.

I don't record account number per se, but my account naming convention lets me easily identify individual accounts. Login information for all accounts is stored in a password manager.

CooperSF

Tried Emma? https://emma-app.com/

quirkydeptless

CooperSF said:

Tried Emma? https://emma-app.com/

I use Emma. It can't track everything (looking at you, Co-Op) but handy to keep a quick check on the accounts it can.