Help protect children from gaming harms.

Take our survey

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