ComplianceDecember 18, 2020|UpdatedFebruary 19, 2022

Accounts receivable aging schedule illustrated

The accounts receivable aging schedule is a useful tool for analyzing the makeup of your accounts receivable balance. Analyzing the schedule allows you to spot problems in accounts receivable early enough to protect your business from major cash flow problems.

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

Tip

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, but always check, and don't forget to solicit your accountant's advice.

Using the receivables aging schedule

The aging schedule can be used to identify the customers that are extending the time it takes to collect your accounts receivable. If the bulk of the overdue amount in receivables is attributable to one customer, then steps can be taken to see that this customer's account is collected promptly. Overdue amounts attributable to a number of customers may signal that your business needs to tighten its credit policy toward new and existing customers.

The aging schedule also identifies any recent changes in the accounts making up your total accounts receivable balance. Almost every business has to deal with customers that are slow to pay; you should expect the same for your business.

However, if the makeup of your accounts receivable changes, when compared to the previous month, you should be able to spot the change instantly. Is the change the result of a change in your credit policy? Was the change in accounts receivable caused by some sort of billing problem? What effect will this change in accounts receivable have on next month's cash inflows? The accounts receivable aging schedule can help you spot these problems in accounts receivable, and provide the necessary answers early enough to protect your business from cash flow problems.

Back To Top