I have found it useful to make column 6 a paid column. That is, column 1 is the actual column for the reporting period and I use type “A- actual”. Columns 2 to 5 are dated appropriately with column 5 being over 90 days and are all type “O-open”. Column 6 is dated the same as column 1 but the type is “X-closed”.
This report structure is even more useful than the conventional aged report because the amounts that are still outstanding show in the aged columns 2 to 5 and the amounts that have been paid since the period end to the date the report is run show in column 6. For example, if you run the March report on April 23, the report will show the amounts that are still outstanding in the appropriately aged columns 2 to 5 and the amounts that have been paid from April 1 to 23 in column 6.
Post Edited (07-12-04 12:44)