SUMMARISED DEBTORS AGE ANALYSIS REPORT PROCEDURE
 

Delegated Staff:

Financial Manager & Credit Control Supervisor.

 
  1.  

Use AS400 "SUMMARISED DEBTORS AGE ANALYSIS" report printed at Month end
 
  1.  

Enter the aged values for each Credit Controller number as per AS400 summarised Age Analysis report onto "KCS OFFICE DEBTORS AGE" spreadsheets filed in "MY DOCUMENTS".
 
  1.  

These "DEBTORS AGE SPREADSHEETS" are useful management tools and calculates the movement between the current month and previous month automatically.
 
  1.  

The total of the "DEBTORS AGE SPREADSHEETS" must be equal to the total at the end of the AS400 summarised age analysis for the month.
 
  1.  

Make sure that the total as per AS400 "SUMMARISED DEBTORS AGE ANALYSIS" agrees with the AS400 "DEBTORS CONTROL TOTALS" report. On AS400 "DEBTORS CONTROL TOTALS" report check

 

  •  

A debtors opening balance agrees with previous month’s total on debtors age analysis.
 
  •  

Plus / (minus) movement on debtors control totals.
 
  •  

Debtors closing balance on debtors control totals report must agree with debtors closing balance on age analysis.

 



Document Retention List