Basic Accounting

Learn about business accounting methods.

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
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, 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.

Category : Basic Accounting
Tags :
  • Accounts Receivable
  • Basic Accounting

2 Months Free Payroll Processing with ADP®

Get what you need when you need it. ADP's small business expertise and easy-to-use tools simplify payroll and HR, so you can stay focused on growing your business.

Incorporate Now
Save 10%

Start your business with confidence. We offer various incorporation packages to get your business up and running. Starting from $99 and includes 6 months FREE Registered Agent services.