Director's loan 'bank' account wrong opening balance

Question asked by Lisa Webster 9 years ago

Hi

My director's loan 'bank' account is showing all the correct transactions but the opening balance is from the Accruals account code in the general ledger. Please can you tell me how I can put this right?

Many thanks!

Lisa

13 Replies

Sorry, Kevin - I don't want to take up any more of your time. I've spoken to a member of the CB team on the phone and he suggested same as you did a couple of hours ago, though I will have to do some manual editing of all the entries that are mysteriously in the wrong place! Thanks for all your help.

Hi Lisa

How did the balance get there in the first place, manual journal or via the wizard?

I entered the accruals and the director's loan balances into the opening balances wizard and they are showing correctly there. I might have played around with the chart of accounts - both of these accounts sit within Other Creditors - I can't see why I would have overwritten the system's Accruals code with my director's loan account but it's possible.

I never use the wizard so can't comment.

How about deleting the wizard entries and entering a manual journal just to be sure?

Thanks - I've just tried that but the DL bank account is definitely connecting to the accruals account code. Can I delete the director's loan bank account and start again without losing the money transactions in it? If so, should it be an new entity or connected to the main current account, please?

No, you'll lose the transactions (it won't let you delete anyway because of the audit trail), let me ponder quickly...

How about just changing the chart so what currently says accruals now reads DLA? Then set a new one up for accruals.

I thought I would give that a try but then I reviewed the transactions in both accounts first and I can't work out why some of my director's loan transactions are in one account and some in the other. The transactions from journals I have created recently are all showing in the DLA, as are some recent 'Money out' transactions, but the rest are all in Accruals - many of them older transactions created by 'explaining' bank import lines, but some of them also more recent 'Money out' transactions - I'm at a loss to see what the difference is! I'm reluctant to mess around with the account names in case I make it worse!

I'm more than happy to do a screenshare or something with you before I leave today if you think it'll help? I could poke around for 5 mins and try putting my spin on it - two eyes and all that.

I'll be here till just after 5ish if needed...

Yes, please! Thanks very much. Do I need to do anything or just wait for a request from you?

I'm not CB staff just so you know, just an accountant like you.

Drop me an email on info@platformaccounting.com and also download TeamViewer (free version) if you haven't got it already.

I'm just going into a call but could probably spare 10-15 mins around 345 if that's any good?

Sorry, Kevin - I don't want to take up any more of your time. I've spoken to a member of the CB team on the phone and he suggested same as you did a couple of hours ago, though I will have to do some manual editing of all the entries that are mysteriously in the wrong place! Thanks for all your help.

Glad you've sorted it (sort of!)

You know where I am...

Reply to this question

Attach images by dragging and dropping or upload
 

Your comments will be public and can be answered by anyone in the Clear Books community.

Find out what we do and who we are