AugTool Documentation
Check Aging by Organisation
The Check Aging by Organisation report calculates the aging for each day in the date range and compares it to the ledger balance for the relevantly classified accounts for the same day. The date Range filters based on the document date. This report then shows any dated which have a mismatch between the aging and the ledger figures. .
Select the customer/supplier and click on submit. Only if there are any differences will they show in the table. If there are no differences then the report will be blank. It will list the organisations where there were differences. An investigation will then need to be done.
It is important to run the report, daily to avoid having to go through large amounts of transactions to identify the differences.
If there are any differences then you can go and look at that specific supplier or customer. If there is a difference between the ledger and the aging then a statement for that organisation would need to be run and compared to the aging detail breakdown. As can be seen below there are two amounts on the ledger for A.M.Steenkamp. The one is the invoice for R 28,750.00 which is correct and the value of the receipt of R 900.00 is correct.
If there is a difference between the Aging balance and the Statement balance one would go into the organisation and then click on the statement option as per the above and select the relevant day. Then go into the general ledger and run that report for the specific day and compare the two. In this example the statement shows an invoice for R 28,750.00 which agrees to the ledger but the receipt is reflecting as R 1,000.00 on the statement while the ledger is only showing as R 900.00. This would mean that there is a problem with the receipt.
Go into the receipt and see how the allocation of the receipt has been done and check that all is correct.