Meet the Other Phone. Child-safe in minutes.

Meet the Other Phone.
Child-safe in minutes.

Buy now

Please or to access all these features

Chat

Join the discussion and chat with other Mumsnetters about everyday life, relationships and parenting.

Any bookkeepers/accountants/money savvy mners about can help me with something?

27 replies

Graphista · 25/10/2021 20:16

I'm normally good myself at keeping a handle on my money but with recent lifestyle changes I'm in a little bit of a muddle.

Not in terms of being skint but I get very anxious around this because of previously being skint!

So I like to be organised.

I have a spreadsheet that for last few years I use for my current account. But between the lifestyle changes and wanting to build/keep a good credit rating I'm now also using credit card (always paid off in full each month) and occasionally dipping into a savings account which is not for anything I'm really saving for just for using if necessary and to help me save where I can by not having the funds in my current account where it's physically easier to spend from (the savings account cannot be accessed except in person and by doing a transfer which there are several steps so it's not an instant thing which makes me consider doing so more - I hope that makes sense)

Where I'm stuck is keeping track of it all!

Is it better to have TOTAL amount on the main/usual spreadsheet or have separate spreadsheets and watch them all or have separate spreadsheets and link them somehow?

I've also only this year got a laptop to be able to DO spreadsheets properly I was previously doing on phone but this was super basic!!

And it's been a LONG time since I had a proper computer and I've forgotten loads of how to work things on technical side I'm relearning a lot!

So...those of you with multiple accounts how do you work it all?

I used to know this stuff I swear! I'm even getting in a muddle where I can't seem to cope with physical cash withdrawals from the current account or accounting for the cash in my purse within the spreadsheet.

Ironically I used to do this stuff as a job and my minds just gone blank!

I've tried googling and all I can find is super complicated stuff that's of no help at all I need a real idiots guide!

Can you guys help? I hope so

OP posts:
Graphista · 26/10/2021 03:17

Specific excel question

I think it SHOULD be possible to do the following indeed I'm sure I used to know how to do this!

Create a formula on one sheet that draws its data from cells on another sheet in the same workbook

So sheet a is weekly
Sheet b is monthly

Updating sheet A weekly

Have a formula that adds the 4 weekly amounts FROM sheet A to produce the monthly amount in the appropriate cell on sheet B

I think there is even a name for this function but I can't for life of me think what it is

OP posts:
Graphista · 26/10/2021 03:30

Never mind figured it out - still can't remember what it's called though!

OP posts:
New posts on this thread. Refresh page