Accounts Receivable Aging Schedule

The accounts receivable aging schedule is a listing of the customers making up your total accounts receivable balance. Most businesses prepare an accounts receivable aging schedule at the end of each month. Analyzing your accounts receivable aging schedule may help you identify potential cash flow problems.

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.

The following is a sample accounts receivable aging schedule from Roth Office Supply:

Accounts Receivable Aging Report Roth Office Supply October 31, 2011
Customer Name	Total Accounts Receivable	Current	1-30 Days Past Due	31-60 Days Past Due	Over 60 Days Past Due
Quick Computer Supply	$1,600	$ 300	$ 500	$ 500	$ 300
Kitchens by Voels	2,800	2,800	----	----	----
Jansa's Sport Stores	1,000	1,000	----	----	----
Bradley Farms, Inc.	1,600	----	1,600	----	----
TrueBrew Unlimited	2,000	1,100	500	400	----
Enneking Enterprises	400	----	400	----	----
Hove and Sanborn LLC	600	600	----	----	----
J. Siegel, CPA	1,200	1,200	----	----	----
Total	$11,200	$ 7,000	$ 3,000	$ 900	$ 300

If you're using one of the many available accounting software packages for billing and accounts receivable processing, check it first to see if it prepares the aging schedule automatically. Most accounting software packages will prepare an accounts receivable aging schedule at the touch of a button!