The ageing columns will be updated in different column based on the number of days from and to updated in the top of the column. The number of days in different column can be changed as per the requirement.
|Accounts receivable ageing
Accounts receivable aging statement excel file download
Accounts receivable aging statement: accounts receivable aging statement or debtors ageing statement is helpful in reviewing the old pending receivables and to take necessary action for collection of pending receivables. In case the company has any policy to provide fa pending receivables aging statement is helpful in quantify the provision amount.
Inventory ageing statement: Inventory ageing statement is helpful in identifying the slow moving and non moving inventory items. The inventory ageing statement can be prepared by updating the inventory items and latest transaction date in the excel sheet. This statement can be used in planning the procurement and in developing the sales strategies.