When to Run An Aging Report

Visit Website View Our Posts

Running an aging report is one of the easiest methods for analyzing the state of a company's accounts receivable. This is typically a standard report that can be run in almost any accounting software package. This aging report divides the age of the accounts receivable into various periods of time, which you can sometimes alter within the accounting software to match your billing terms.

When to run an aging report

The accounts receivable aging report is a listing of the customers making up your total accounts receivable balance. Most businesses prepare an accounts receivable aging report at the end of each month. Analyzing your accounts receivable aging report may help you identify potential cash flow problems.

The typical accounts receivable aging report consists of 6 columns:

  1. Column 1 lists the name of each customer with an accounts receivable balance.
  2. Column 2 lists the total amount due from the customers listed in Column 1.
  3. Column 3 is the "current column." Listed in this column are the amounts due from customers for sales made during the current month.
  4. Column 4 shows the unpaid amount due from customers for sales made in the previous month. These are the customers with accounts 1 to 30 days past due.
  5. Column 5 lists the amounts due from customers for sales made two months prior. These are customers with accounts 31 to 60 days past due.
  6. Column 6 lists the amount due from customers with accounts over 60 days past due.

The most common time buckets are from 0-30 days old, 31-60 days old, 61-90 days old, and then older than 90 days. Any invoices that are past the 30 day mark are worthy of raising a red flag, especially if they fall into the older than 90 bucket. If you run aging reports regularly, you can highlight vendors that perhaps you should negotiate different terms with, or require/allow different payment terms for given their ability to pay in a timely fashion - or not.

Would you like to learn more about all of the 15 Tips for Accounts Payable success in 2015?

Download the eBook: 15 Tips for AP Success in '15

by AvidXchange


1 thought on “When to Run An Aging Report”

  1. I'm running an AR aging report, which downloads onto an excel spreadsheet. I'm trying to get the A/R notes to be pulled onto the spreadsheet but can't seem to get it. Can you help?

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Show Buttons
Hide Buttons