Page 1 of 1

sales aged balance disagrees with control account

Posted: 30 May 2014, 10:23
by Emmacanne
Dear God what have I done... and how do I fix it :shock:

This error warning was brougt to my attention yesterday. Since then I have been trying to pinpoint when it happened. I have, but do not for the life of me know how to fix it.

When I took over this position there was a wee bit of a mess to clean up, which I have been (relatively) successful in doing.. long story short..

There was bank receipts posted to a customer account (in error) sitting as payments on account but they had been picked up in a vat return and I was unable to delete them or reallocate them.
I (obviously suffering from a brainfart) created two sales invoices in order to clear the payments off the account.
In my sheer arrogance I assumed this would simply make the entries on the customer account disappear, which it did because I allocated the payments to said invoices. However it is from this point on that this error warning 'sales/purchase aged balance disagrees with control account' has appeared. :roll:

What incredibly stupid thing have I done!! and can you help me fix it?? I would have done a restore had I bothered to do a file maintenance check at the time and see it, but since then I have entered 4650 transactions... although I am prepared to re-enter every one of these transactions over the weekend... I am hoping you will have a more sensible solution :cry:

thank you
Emmacanne :|

Re: sales aged balance disagrees with control account

Posted: 30 May 2014, 15:03
by brucedenney
I would look for a journal to the control account

Probably someone blindly posting what the accountant told them to do.

Re: sales aged balance disagrees with control account

Posted: 30 May 2014, 16:27
by Emmacanne
Thank you... Iyou are legend. :lol:

But... I am loath to say, I posted the journal... what I was thinking is anybody' guess. :roll:

I appreciate your help
Emmacanne :P

Re: sales aged balance disagrees with control account

Posted: 02 Jun 2014, 08:38
by brucedenney
What I would do in those sorts of situations is to create an account next to the control account and label it
"Creditors control Audit Adj"

This way you can keep both parties (accountant and Sage 50) happy.