Accounts Receivable Aging Report

An accounts receivable aging report is an accounting document that gives the business an overview of its outstanding payments from customers and how long they are past due.

Most businesses have accounts receivable in their accounting ledger.

Accounts receivable refers to sales for which payment has not yet been received, meaning the customer has not paid for the good or service received at the time of the transaction.

Instead, the business has extended credit and expects to receive payment for the transaction at some point in the future. Accounts receivable are typically collected in two months or less.

While in a perfect world all accounts receivable will be collected in the standard amount of time, this is not always the case. Accounts receivable collections is the process a business undergoes to ensure that customers follow through on payments for services or products provided.

The business can and must take different proactive measures to remind and encourage customers to follow through with payment.

These measures help the business ensure that uncollected debts are kept to a minimum.

Before initiating collections, the business must make an evaluation of its accounts receivable. To aide in this evaluation, the business will produce an aging report. A

n aging report will provide the business with a snapshot of the status of all its accounts receivable by categorizing them according to how long they are past due.

The aging report is a vital resource for the business that serves some very important functions:

1. The aging report allows accounting staff to make an evaluation about accounts receivable, to determine which accounts should go to collections, and which collections measures should be applied based on the amount of time they are past due.

2. The aging report provides vital information to management to evaluate how effective the business is at converting sales to cash. This evaluation reflects on the policies the business follows for extending credit and its procedures for collecting payment once they are past due.

3. The aging report is also used as a tool for estimating potential bad debts, which are then used to revise what is known as the allowance for doubtful accounts. To remain consistent with the matching principal, businesses will write-off bad debt by setting aside a reserve for expected bad debts or doubtful accounts. This reserve, or allowance, is also referred to as a contra asset account because it “nets” or balances against the accounts receivable assets listed in the balance sheet. The aging report helps the business calculate these estimates by providing a standard amount of time its accounts receivable go uncollected and how many are charged off.

The aging report organizes individual accounts receivable into past due groups. The typical groupings are:

• 0-30 days

• 31-60 days

• 61-90 days

• More than 90 days

The status of each group reflects the time that has elapsed since an invoice was issued to the customer. The aging report will help the business organize and evaluate the status of its accounts receivable.