VERY simple spreadsheet to track a single bank account.

eskbanker

Korkyb said:

I’ve never delved into excel before but that sounds doable.

I’ll have a crack when I get home.

thanks !

If your mother in law wants to do this and has a Windows PC with Excel, surely she'd be best placed to do all this, or are you accessing her bank account under power of attorney?

MikeJXE

Yorkie1 said:

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!

I'm sure you are spot on with that 

But why does she pay for Excel (if she only understands simple) when there are plenty free spreadsheets that do a simple job like that ? 

libra10

Is it something straightforward, like this example?

You can run totals as far as required.

Korkyb

eskbanker said:

Korkyb said:

I’ve never delved into excel before but that sounds doable.

I’ll have a crack when I get home.

thanks !

If your mother in law wants to do this and has a Windows PC with Excel, surely she'd be best placed to do all this, or are you accessing her bank account under power of attorney?

She is 85 years old - I'm just doing as she has asked :-)

My wife does have power of attorney but they aren't being exercised - we just help keep her finances straight & she wants to play her part..

Korkyb

She has Excel Word on her PC as I have an annual family subscription to MS Office & gave her 1 of the 6 user slots.

Korkyb

Thanks for the Excel help chaps.

I've managed to get the formula working so that it adds and subtracts from the running total.

Is there a way to stop the running total being displayed all the way down the column (F) until a particular row has been populated.

I've popped an image below to show what I mean.

Thanks again.

Runner_Duck

Microsoft Office has an Excel Template called Statement of Account which should work for you. Enter date, description, and value of the credits or debits and a formula that calculates the running balance.

MikeJXE

Yes with an IF statement before the formula 

Syntax. Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it's false. For example: =IF(A2>B2,"Over Budget","OK")

eskbanker

Korkyb said:

eskbanker said:

Korkyb said:

I’ve never delved into excel before but that sounds doable.

I’ll have a crack when I get home.

thanks !

If your mother in law wants to do this and has a Windows PC with Excel, surely she'd be best placed to do all this, or are you accessing her bank account under power of attorney?

She is 85 years old - I'm just doing as she has asked :-)

My wife does have power of attorney but they aren't being exercised - we just help keep her finances straight & she wants to play her part..

Fair enough, but the impression in your original post was that she wanted to monitor things for herself, so even if you do some initial setup work for her, she presumably needs to drive the process of regularly extracting data from her online banking and updating the spreadsheet?  If you're in that loop, accessing her account without PoA, that would be against the terms and could cause complications for her....

Korkyb said:

My elderly mother in law wants to keep track of her bank account on her computer.

npfmedia

Where you have In and Out columns that are blank, if you just populate them with £0. When you come to your sixth entry excel should automatically calculate and populate the formula to complete the row, rather than (as you say) copying the whole formula down.

Hope this helps.