How to reconcile the Creditors ledger in SAM - only necessary for SAM sites using the Elite package with GL
At the end of each month you should be reconciling your Creditors Ledger to the General Ledger in SAM to ensure there are no balance mis-matches.
SAM Creditors ledger GL code is almost always 6300.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 | Creditors Balance History | General Ledger | Variance |
|---|---|---|---|
| March | |||
| April | |||
| May | |||
| June | |||
| July | |||
| August | |||
| September | |||
| October | |||
| November | |||
| December | |||
| January | |||
| February | |||
| March |
Creditors Balance History
This can be done by going Enquiry (1) > Creditors 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 6300.10 (Creditors Ledger Control)
Identify the transaction
Start with the first month that doesn't balance
For this we will compare the following reports:
- Creditors Audit Trail to
- GL Code Source Transactions
Creditors 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 6300.10 (Creditors Ledger Control)
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