An aging schedule is an accounting table that shows a company’s accounts receivables, ordered by their due dates. Often created by accounting software, an aging schedule can help a company see if its customers are paying on time. It’s a breakdown of receivables by the age of the outstanding invoice, along with the customer name and amount due.
Aging Schedule Example
Sr.No | Customer Name | Total Due | Current (under 30 days) | 1 to 30 Days | 31 to 60 Days | 61 to 90 Days | Over 90 Days |
1 | ABC Incorporation | 1,000,000.00 | 100,000.00 | 500,000.00 | 330,000.00 | 70,000.00 | |
2 | XYZ Ltd | 2,500,000.00 | 1,250,000.00 | 825,000.00 | 100,000.00 | 325,000.00 | |
3 | PQR Inco. | 1,500,000.00 | 150,000.00 | 750,000.00 | 495,000.00 | 105,000.00 | - |
4 | Apple Inco. | 950,000.00 | 95,000.00 | 475,000.00 | 313,500.00 | - | 66,500.00 |
5 | Orange Inco. | 7,500,000.00 | 750,000.00 | 3,750,000.00 | 2,475,000.00 | 300,000.00 | 225,000.00 |
Total | 13,450,000.00 | 1,095,000.00 | 6,725,000.00 | 4,438,500.00 | 575,000.00 | 616,500.00 |
Get Answers For Free
Most questions answered within 1 hours.