How to reconcile the debtors ledger in SAM
At the end of each month you should be reconciling your Debtors Ledger to the General Ledger in SAM to ensure there are no balance mis-matches.
SAM Debtors ledger is almost always 5300.10
TABLE OF CONTENTS
Identify the Month(s) out of balance
When balancing multiple months at a time it is suggested that you enter the figures into
Spreadsheet
This is an example - setup in Excel to make your life easier
| Month | Debtors Balance History | General Ledger | Variance |
|---|---|---|---|
| March | |||
| April | |||
| May | |||
| June | |||
| July | |||
| August | |||
| September | |||
| October | |||
| November | |||
| December | |||
| January | |||
| February | |||
| March |
Debtors Balance History
This can be done by going Enquiry (1) > Debtors Balance History (2) > Click on Totals (3)
General Ledger
Click on GL (1) > Monthly Totals (2) > Progressive Totals (3) Make sure you have the Correct GL code (4) and note each month's total in the spreadsheet (5)
Look for GL Code 5300.10 (Debtors Ledger Control)
Identify the transaction
Start with the first month that doesn't balance
For this we will compare the following reports:
- Debtors Audit Trail to
- GL Code Source Transactions
Debtors Audit Trail
1. Select the correct period
2. Tick Detailed
3. Sort by Date, Customer, Type
GL Code Source Transactions
Go to Reports (1) > General Ledger (2) > GL Code Source Transactions (3)
1. Choose the correct GL code
Look for GL Code 53000.10010 (Accounts Receivable)
2. Select the correct month
3. Sorted by Date
Compare the figures from both reports against each other
Didn’t find what you were looking for?
Our Support team are here to help, you can reach us by submitting a support ticket