Help & Support – Reconcile Sales Ledger to Nominal Control Account

Sage 200 Reporting  –  Help:

Help and Support

Reconcile Sales Ledger to Nominal Control Account

Sage have provided a new enquiry that helps do the initial reconciliation to show if the period to be reconciled has a difference. 

Click here to view the Debtors Reconciliation Enquiry help pages.

Use the additional links on these help pages to learn more.

Before this enquiry screen was available the standard technique was to perform a manual reconciliation by running a retrospective Aged Debtors (Summary) report up to the period end date and compare the BASE outstanding value to the selected periods balance on the nominal ledger’s Debtors Control account.

If this comparison showed a difference various troubleshooting tasks were performed to try and explain the difference and possibly correct postings.

Click here for other Sage help files that help to explain differences. 

Sage have also provided troubleshooting help under the following two categories.

My aged debtors / creditors report doesn’t match the nominal account

Reconcile your Creditors Control account

In addition to the suggested help available above you may find the steps below a useful path to follow and use the suggested reports to identify the errors.

Step 1 – Confirm that the difference is a ‘timing’ difference and the actual ledgers do agree if the ledgers are reconciled when all postings are considered. Show More To perform this test you should run a non-retrospective Aged Debtors report to confirm the current Sales Ledger balance in BASE currency and compare it to the current NL Debtors Control account balance plus any pending (waiting) and deferred postings. New report # 198 combines these two posting tables into a single report. Click here to learn more. The standard reports can be found by navigating to; Nominal Ledger – Reports – Account Analysis – View Waiting Postings  &  Nominal Ledger – Reports – Account Analysis – View Waiting Postings (Deferred)

Step 2 – If step 1 shows a time difference then it may be a Sales Transaction in the prior period has been posted to the nominal ledger in the next period.  Run the Sales Ledger Transactions (by Period) report to confirm if a S/L transaction has been posted to the next N/L period. Show More You may also need to check if there are some N/L pending (waiting) or deferred postings that explain the time difference error. Go to report # 198 for a new report that will help trace the non-posted transactions.

Step 3 – If step 2 does not show a period time difference the ‘time’ difference may be due to a Back Dated Allocation. If a cash receipt dated early July but has been allocated with an allocation date on or before 30th June a retrospective Aged Debtors report will reduce the outstanding value by the value of a payment received in July but allocated in June. A special report to capture such back dated allocations will be required. Go to Report # 195 to learn more and download the FREE report

Step 4 – If the error is not a timing difference the difference is likely to be a one-sided transaction. A transaction appearing in the Nominal but not in the Sales ledger or a transaction in the Sales but not in the Nominal.

There are three possible reasons for a one-sided posting. The system may have crashed and only the Sales ledger was updated. A Nominal ledger JOURNAL has been posted to the Nominal Control account.

Show More

An OPEN BALANCE invoice or credit note has been posted to a customer’s account.

Show More

If you are still unable to trace the error and correct your data you should seek assistance from your Sage Business Partner..