We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
VERY simple spreadsheet to track a single bank account.
Options

Korkyb
Posts: 634 Forumite


Hi all
My elderly mother in law wants to keep track of her bank account on her computer.
Is there a spreadsheet that will be simple to use and just has money in and money out (with a description of what the income expenditure is out with a running total.
It doesn't need to have any budgeting features but just a running total of her single bank account for each month.
She uses a windows PC and does have Excel.
Emphasis again on the SIMPLE :-) (All the spreadsheets I've found do too much and will just confuse her).
Thanks in advance.
My elderly mother in law wants to keep track of her bank account on her computer.
Is there a spreadsheet that will be simple to use and just has money in and money out (with a description of what the income expenditure is out with a running total.
It doesn't need to have any budgeting features but just a running total of her single bank account for each month.
She uses a windows PC and does have Excel.
Emphasis again on the SIMPLE :-) (All the spreadsheets I've found do too much and will just confuse her).
Thanks in advance.
Was it really "everybody" that was Kung Fu fighting ???
0
Comments
-
She should be able to download data from her bank in CSV or XLS format, which can then be copy/pasted into a spreadsheet following the bank's download format? Any such downloads I've seen always have columns for transaction date, description, money in, money out and balance....0
-
Thanks
She has access to her bank online but wants to have a manual spreadsheet which is separate / stand alone from her bank account.Was it really "everybody" that was Kung Fu fighting ???0 -
Korkyb said:Thanks
She has access to her bank online but wants to have a manual spreadsheet which is separate / stand alone from her bank account.0 -
I understand.
I'll have a fiddle with that.
Was it really "everybody" that was Kung Fu fighting ???0 -
Why does she want it? Is it too keep track of upcoming direct debts?0
-
Yes direct debits / spending / bills.
I tried downloading her banks csv file (all they provide) - the resultant spreadsheet doesn't have much info on it and doesn't automatically calculate income or outgoings (sorry I should have said that would be useful to minimise human error).
Ideally it would look like:
date / description / £ in / £ out / / running total (calculated automatically)..
Was it really "everybody" that was Kung Fu fighting ???0 -
Korkyb said:Yes direct debits / spending / bills.
I tried downloading her banks csv file (all they provide) - the resultant spreadsheet doesn't have much info on it and doesn't automatically calculate income or outgoings (sorry I should have said that would be useful to minimise human error).
Ideally it would look like:
date / description / £ in / £ out / / running total (calculated automatically)..
Likewise 'running total' - presumably the download format includes balance but is she perhaps wanting something that resets to zero at the start of each month? Is she wanting to use it on a regular basis during the month or just use it as a repository for occasional analysis?
The key point being that downloading the raw bank data is an enabler, but beyond that it'll need to be tweaked to reflect exact requirements - obviously the more functionality that's added, the less simple it is....0 -
It would be easy enough to set this up with 5 columns, as described above (columns A - E)
Row 1 is headings for each column
Row 2 would be the opening balance in cell E2
Row 3 onwards is entries
I think the formula for cell E3 (running total column) would be "=E2+C3-D3"
Then the formula for the next entry (row 4), i.e. cell E4 would be "=E3+C4-D4"
And you can drag the formula down the column E, to autopopulate with future entries in rows.
Someone else will definitely let you know if my excel skills are even rustier than I think!
2 -
Korkyb said:Yes direct debits / spending / bills.
I tried downloading her banks csv file (all they provide) - the resultant spreadsheet doesn't have much info on it and doesn't automatically calculate income or outgoings (sorry I should have said that would be useful to minimise human error).
Ideally it would look like:
date / description / £ in / £ out / / running total (calculated automatically)..
The only calculation you need is the running total and that should be equal to the running total from the line above plus the amount in the income cell of this line minus the amount in the outgoing cell of this line.1 -
I’ve never delved into excel before but that sounds doable.
I’ll have a crack when I get home.
thanks !Was it really "everybody" that was Kung Fu fighting ???1
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 351.1K Banking & Borrowing
- 253.1K Reduce Debt & Boost Income
- 453.6K Spending & Discounts
- 244.1K Work, Benefits & Business
- 599K Mortgages, Homes & Bills
- 177K Life & Family
- 257.4K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards