The accounts receivable aging schedule is a listing of the customers making up your total accounts receivable balance.
The typical accounts receivable aging schedule consists of 6 columns:
- Column 1 lists the name of each customer with an accounts receivable balance.
- Column 2 lists the total amount due from the customers listed in Column 1.
- Column 3 is the "current column." Listed in this column are the amounts due from customers for sales made during the current month.
- Column 4 shows the unpaid amount due from customers for sales made in the previous month. These are the customers with accounts 1 to 30 days past due.
- Column 5 lists the amounts due from customers for sales made two months prior. These are customers with accounts 31 to 60 days past due.
- Column 6 lists the amount due from customers with accounts over 60 days past due.