How to reconcile your debtors ledger to your general ledger in Orion
At the end of each month you should be reconciling your Debtors Ledger to the General Ledger in Orion to ensure there are no balance mis-matches.
|Find the month|
|Find the detail|
|Balancing over multiple months|
Find the month
You will need to compare two reports to each other:
- Current periods Debtors Aged Trial Balance can be found in the Accounts module
Reports > Debtors > Debtors Aged Trial Balance
- Historical Debtors Aged Trial Balance can be found in the Accounts module
Enquiry > Archived Reports > select the month > Detailed_Debtors_ATB.pdf
General Ledger Balance History
- This can be viewed by going into the Accounts module
Enquiry > Debtors Balance History > Click on Totals
Find the detail/individual transaction(s)
If the figures from the above two reports do not match then:
Compare the following reports to each other:
Debtors Audit Trial Report
This can be found in the Account ModuleReports > Debtors > Debtors Audit Trail
Select the period you are out and select detailed.
GL Code Source Transactions
This can be found in the Accounts moduleReports > General Ledger > GL Code Source Transactions
Run this report for your accounts receivable GL code and select the period you are out.
Mark off each individual transaction to the GL Code Source Transactions report.
Once you have completed marking off each transaction, you will be left with transactions which have possibly caused the discrepancy in your system.
You can either reverse the transaction which was causing an issue (e.g. if you had created a manual journal to the debtors control account you will need to reverse this journal) or you can ask the helpdesk for some guidance.
The helpdesk will not be able to give you any accounting advice, you will need to contact your accountant for this service.
Balancing over multiple months
If you haven’t reconciled your debtors for a long period and the balances do not match, it is best practice to create a spreadsheet like below and compare the debtors sub account values to the general ledger values.
There should be an obvious month that the totals have start going out of balance.
Once the month has been identified, you can use the reconciliation process "Find the detail" suggested above.