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

    What's an Invoice?

    An invoice is a document that itemizes a transaction between a buyer and a seller. Invoices can also be called bills or statements.
  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

    The Importance Of Analyzing Accounts Receivable

    While investors often focus on revenues, net income, and earnings per share, they should not overlook the importance of analyzing accounts receivable.
  4. 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.
  5. 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.
  6. Small Business

    What's Capitalization?

    Capitalization has different meanings depending on the context.
  7. 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.
  8. Investing

    What are Receivables?

    Receivables are debts, transactions or other obligations owed to a company by its debtors or customers.
  9. 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.
  10. 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.
Hot Definitions
  1. Money Market

    A segment of the financial market in which financial instruments with high liquidity and very short maturities are traded. ...
  2. Block (Bitcoin Block)

    Blocks are files where data pertaining to the Bitcoin network is permanently recorded.
  3. Fintech

    Fintech is a portmanteau of financial technology that describes an emerging financial services sector in the 21st century.
  4. Ex-Dividend

    A classification of trading shares when a declared dividend belongs to the seller rather than the buyer. A stock will be ...
  5. Debt Security

    Any debt instrument that can be bought or sold between two parties and has basic terms defined, such as notional amount (amount ...
  6. Taxable Income

    Taxable income is described as gross income or adjusted gross income minus any deductions, exemptions or other adjustments ...
Trading Center