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

Category : Basic Accounting
Tags :
  • Accounts Receivable
  • Basic Accounting
Load more comments
Thank you for the comment! Your comment must be approved first
New code
comment-avatar

20% off ADP Payroll Services

Manage your cash flow with ADP's payroll service. Includes direct deposit, tax filing, and general ledger interface.

$99 Business Plan Offer
From LivePlan

Create a comprehensive pitch and business plan with 1-year of LivePlan access. Includes templates and financial forecasting.