How do you prepare accounts receivable aging schedule?

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:

1. Column 1 lists the name of each customer with an accounts receivable balance.
2. Column 2 lists the total amount due from the customers listed in Column 1.
3. Column 3 is the "current column." Listed in this column are the amounts due from customers for sales made during the current month.
4. 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.
5. 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.
6. Column 6 lists the amount due from customers with accounts over 60 days past due.