Check for any journals posted to the Debtors Control account
Description

There are various reasons why this can happen.

Journals posted to the Debtors Control account change the nominal balance only. They don’t update customer records, so Aged Debtors reports stay unchanged and create a difference.

Post journals to the Debtors Control account only when entering or reversing opening balances.
Cause
Resolution

Run the Day Books: Nominal Ledger report

  1. Go to Nominal codes then select Reports.
  2. Select Day books then Day Books: Nominal Ledger.
  3. Complete the Criteria as follows:
    • Transaction Date: Select Between (inclusive) then enter 01/01/1980 and the last day of the month being reconciled
    • Nominal code: Select Is then enter 1100 Debtors Control
  4. Press OK then check the total amounts in the Debit and Credit columns.

If these values are the same, journals aren't the reason for the difference. If the values are different, subtract one from the other to give the difference.


If there's a difference

Determine if the journals are correct.

  • If they're correct, don't take any further action. There will always be a difference between the aged debtors or creditors and the debtors or creditors control account
  • If they're incorrect, reverse the journal, then post a journal to move the discrepancy to a different nominal account. For example, the mispostings account
  • If you're unsure if the journals are correct, speak to your accountant

[BCB:19:UK - Sales message :ECB]

 

Steps to duplicate
Related Solutions