What is an Aging Schedule?

Aging Schedule

Share This...

Aging Schedule

An aging schedule is a financial report that categorizes a company’s accounts receivable or accounts payable according to the length of time they have been outstanding. The primary purpose of an aging schedule is to determine the credit quality and potential collectability of receivables or the urgency and priority of payables. This report assists companies in managing their cash flow, identifying problematic customers or vendors, and taking appropriate collection or payment actions.

The aging schedule typically organizes outstanding balances into time buckets or periods, such as:

  1. Current (not yet due)
  2. 1-30 days past due
  3. 31-60 days past due
  4. 61-90 days past due
  5. Over 90 days past due

By grouping the outstanding balances into these categories, a company can quickly assess the overall health of its receivables or payables and prioritize actions to improve cash flow and financial stability.

Example of an Aging Schedule

Here’s an example of an aging schedule for a company’s accounts receivable:

Company XYZ – Accounts Receivable Aging Schedule (as of March 31, 2023)

CustomerCurrent1-30 Days31-60 Days61-90 DaysOver 90 DaysTotal
ABC Corporation$1,000$500$0$0$0$1,500
DEF Industries$0$3,000$2,000$0$0$5,000
GHI Enterprises$5,000$0$1,000$0$0$6,000
JKL Limited$0$0$0$1,500$0$1,500
MNO Inc.$0$0$0$0$2,000$2,000

In this example, the aging schedule shows the outstanding balances of the company’s accounts receivable for different customers and groups them into time periods based on how long the balances have been outstanding. Company XYZ can use this report to identify potential collection issues, prioritize collection efforts, and make decisions about extending credit to customers in the future.

Other Posts You'll Like...

Want to Pass as Fast as Possible?

(and avoid failing sections?)

Watch one of our free "Study Hacks" trainings for a free walkthrough of the SuperfastCPA study methods that have helped so many candidates pass their sections faster and avoid failing scores...