An aged accounts receivable schedule sometimes referred to as an aged debtors report, is used as a management tool to monitor the age of the outstanding receivables from customer sales invoices, allowing early action to be taken to collect the overdue amounts. In addition, it can be used as the basis for estimating the allowance for doubtful debts.
The report is produced by analyzing customer sales invoices into several different age classifications based on the number of days the invoice is past its due date. For example, if the invoice is unpaid 27 days after its due date it would be placed in the 0-30 days classification column, or if the invoice was unpaid 55 days after its due date it would be placed in the 31-60 days column.
On the report, a sub-total is drawn showing the aged accounts receivable for each customer, and a total line shows the aged accounts receivable for the business as a whole. Finally, a line is added to show what percentage of the total outstanding accounts receivable is represented by each age classification. For instance, in the example aged accounts receivable report below, the amount outstanding between 31-60 days is 6,100, and this represents 6,100/18,000 or 34% of the total aged accounts receivable.
|Customer||Amount||0 – 30||31 – 60||61 – 90||> 90|
Aged Accounts Receivable and the Allowance for Doubtful Debts
The aged accounts receivable report can be used to estimate the allowance for doubtful debts based on past experience of bad debts. This method is known as the aging of accounts receivable method, and provides an alternative to basing the allowance on a percentage of the revenue for the accounting period.
For example, if from past experience, the business has the following bad debt history:
|Ageing||% Bad debts|
|> 90 days||30%|
Then based on this information and the aged accounts receivable report above, the business can estimate the allowance for doubtful debts needed by applying the relevant percentage to each aged accounts receivable column in the report.
|Ageing||% Bad debts||Aged balance||Allowance|
|> 90 days||30%||4,000||1,200|
Based on this information the aging of accounts receivable method shows that the allowance for doubtful debts should be 2,135.
About the Author
Chartered accountant Michael Brown is the founder and CEO of Double Entry Bookkeeping. He has worked as an accountant and consultant for more than 25 years and has built financial models for all types of industries. He has been the CFO or controller of both small and medium sized companies and has run small businesses of his own. He has been a manager and an auditor with Deloitte, a big 4 accountancy firm, and holds a degree from Loughborough University.