Debtors Reconciliation
If I take any Customer Aging report at the end of a period, add to that the value of the Transaction Register, deduct the Receipt Register(Excl Miscelaneous) Receipts, Add/Subtract Adjustments per the Adjustments Register, should I then get the balance of the Aging at the end of the next period.
Eg
Aging as at 31-Dec-2011 500
Add Transaction Register 100
Less Receipts(Excl Misc Receipts) -50
Add/Subtract Adjustments 20
= Aging as at 31-Jan-2012 570
Should this logic work or is there any anomolies to look out for such as application date of receipts etc.
Many Thanks