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
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
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.
An OPEN BALANCE invoice or credit note has been posted to a customer’s account.
If you are still unable to trace the error and correct your data you should seek assistance from your Sage Business Partner..