Sales Aged Balance disagrees with Debtors Control by (amount)

[Kasia1972]

Sales Aged Balance disagrees with Debtors Control by (amount)

My TB balance and customers have credit notes on accounts that will be used as opening balances.

When running last year sales aged report the balnce was different the Debtors control.

How can I fix this?

But the difference is quite big around £4500 and the accountant is thinking that is the removed transactions from the sage and need to be fixed by sage but I havent got support.

Also I never got error sign there is only warning?

[brucedenney]

Journal the difference to the account.

[Kasia1972]

But the difference is quite big around £4500 and the accountant is thinking that is the removed transactions from the sage and need to be fixed by sage but I havent got support.

Also I never got error sign there is only warning?

The rest of accounts are fine and evrything balance for me .

What about data checking , strangely if I ran last year TB it doesnt show amount that is on the sales aged balance?
It looks as the sales aged balance is building up for some reason

[brucedenney]

I doubt it is a removed transaction, if it were then the tools would recalculate the balance.

Look in the history on the account and see if you can find a journal. (Accountants tend to tell clients to journal to it, even though you shouldn't)

[Chellebear]

I agree with Bruce, its more likely that a journal has been posted to the control account.

Highlight the debtors control account on your NL. Working backwards in time, run a nominal activity for each year end (include balance brought forward) and also run a debtors summary for the same (tick to exclude later payments). You should get back to a year end when the list and TB agreed. That will help you find which year it happened in. If you have a massive number of transactions, once you find the year, you can then do monthly reports, to isolate the month where it went wrong.

Hope this helps