Next video:
Loading the player...

Company managers use accounts receivable aging reports to monitor overdue accounts. The report usually lists each customer’s amount owed broken down into different date range “buckets.” Typically, these buckets are columns titled Current, 31-60 days, 61—90 days, 90+ days.

Most accounting software programs generate multiple variations of the accounts receivable aging report.  A typical report looks like this:

ABC AR Aging

Total

Current

31-60

61-90

90+

A Company

10,000

5,000

5,000

 

 

B Company

15,000

 

15,000

 

 

C Company

12,000

7,000

 

5,000

 

D Company

8,000

8,000

 

 

 

Late Company

5,000

 

 

 

5,000

Total

50,000

20,000

20,000

5,000

5,000

In the collection process, ABC’s collection department will focus on contacting Late Company and C Company to inquire about payment status. In addition, ABC may send out reminders to A and B about the invoices that are in the 31-60 column. 

Companies often analyze their accounts receivable aging reports over time to determine what percentage of invoices are consistently late or written off. This helps them more accurately predict their allowance for bad debt accounts on their balance sheet.

Also, a company’s credit department uses the accounts receivable aging report to make customer credit decisions. For instance, if Late Company places another order with ABC, the credit department may put a credit hold on Late Company’s account until it pays the $5,000 invoice that is more than 90 days past due. The new order will be processed once the late invoice is paid.

Related Articles
  1. Investing

    Accounts Payable

    Accounts payable is the amount of a company's total invoices currently waiting to be paid. These invoices are from vendors for products and services that were recently delivered.
  2. Small Business

    Small Business: Speed Up Receivables To Avoid A Cash Crunch

    Waiting for customers to pay can be a losing game. Look to factoring for quicker cash.
  3. Investing

    What's an Allowance for Doubtful Accounts?

    The allowance for doubtful accounts represents the percentage of the accounts receivable the company expects to write-off as uncollectible.
  4. Investing

    Accounts Receivable

    Accounts Receivable (A/R) is an accounting term used to refer to the money that is owed to a company by its customers.
  5. Investing

    What is the Price-to-Sales Ratio?

    The price-to-sales ratio is an indicator of the value placed on each dollar of a company’s sales or revenues.
  6. Personal Finance

    Accountant: Job Description & Average Salary

    Discover what the job description of an accountant entails, along with education and training, salary and skills necessary for success.
  7. Retirement

    The Impact Of Your Starting Age On Social Security

    Retiring at 62 sounds nice, but it could affect the amount of social security you receive.
  8. Investing

    What are Receivables?

    Receivables are debts, transactions or other obligations owed to a company by its debtors or customers.
  9. Personal Finance

    New Rules That Could Trash (or Help) Your Credit

    Cable bills and similar financial obligations will soon be factored into your credit score. Good news if you're an on-time payer. If not, become one!
Hot Definitions
  1. Aggregate Demand

    The total amount of goods and services demanded in the economy at a given overall price level and in a given time period.
  2. Fixed Cost

    A cost that does not change with an increase or decrease in the amount of goods or services produced. Fixed costs are expenses ...
  3. Blue Chip

    A blue chip is a nationally recognized, well-established, and financially sound company.
  4. Payback Period

    The length of time required to recover the cost of an investment. The payback period of a given investment or project is ...
  5. Collateral Value

    The estimated fair market value of an asset that is being used as loan collateral. Collateral value is determined by appraisal ...
  6. Fiduciary

    A fiduciary is a person who acts on behalf of another person, or persons to manage assets.
Trading Center