Aged Debtors Report and Debtors Control Account do not match (Sage Accounts)

Reasons this will happen:

 

1. A journal has been posted to the Debtors Control Account and this will not wash out so it has to be reversed or highlighted to prove the difference
2. A Receipt has been allocated to an invoice with a future date.

 

 

To find out if a Journal has been entered, go to Nominal Reports/Day Books and select Day Books: Nominal Ledger.  When the Criteria box appears, put in the dates and select 1100 Debtors Control Account. If the report is blank then proceed to Future Allocations Query.

 

To find out Future Allocations, go to Customer Reports/Aged Debt Rec Reports, if you do not have this selection of reports contact Support.

Run the various reports and it will highlight any transactions that were allocated after the month end/year end date.  You can fix the dates via Transactions by clicking Unallocate and then allocate again with the correct date.