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.

Pimbrook Software
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.