Module 06 · Receivables, Collections and Cash Flow

The Aging Report: Reading 0-30, 31-60, 61-90 and 90+

An accounts receivable aging report groups unpaid invoices by days past due. Learn the buckets, what the totals include, and how to spot slow payers.

5 min readLesson 4 of 9 in this moduleUpdated 2026-10-24

An aging report answers two questions: which customers owe you money, and how late is each balance? In Reyuko, this is the Aging AR/AP page. This lesson shows how to read it, what each bucket means, and where the report stops being enough on its own. For the wider picture of following up on receivables, see accounts receivable automation: how it works.

Illustration: Harbor Wholesale is a fictional business; numbers are examples.

Key takeaways

  • Aging AR/AP is under the Payment menu and needs the Advanced level.
  • Age is counted from the Due Date, not from the invoice date.
  • The buckets are Not Due, 1-30 days, 31-60 days, 61-90 days and >90 days.
  • The report shows totals per contact. Open the Receivable list to see each invoice.
  • The report has no "as of" date field. It counts against today.

Where the report lives

Open Payment > Aging AR/AP and select Receivable (AR). Use Payable (AP) for what you owe to suppliers. The page subtitle is "Outstanding grouped by due-date age".

The five buckets

BucketDays past the due date
Not DueNot yet past the due date. Invoices with no due date also land here.
1-30 days1 to 30 days late
31-60 days31 to 60 days late
61-90 days61 to 90 days late
>90 daysMore than 90 days late

Each row is one contact. The Total Outstanding card shows the sum of all buckets and the number of documents. Rows with any balance over 90 days are shaded red.

A worked example

Harbor Wholesale has three customers with open invoices on the same day:

CustomerNot Due1-30 days31-60 days61-90 days>90 daysTotal
Riverside Mart4,0002,50001,2008008,500
Pine Corner Store001,500001,500
Oak Kiosk3,00000003,000
Total7,0002,5001,5001,20080013,000

Riverside Mart owes 8,500, but 2,000 of it is more than 60 days late. Pine Corner Store's whole balance is in one late bucket. Oak Kiosk has nothing overdue.

What the report does not show

The report has one filter: a search box for the contact name. It has no invoice detail, no classification filter, and no date selector. An invoice on an installment schedule is split into its installment rows. To see which invoice sits in which bucket, open Payment > Receivable, select the contact, and use the Overdue filter. The Receivable page is covered in lessons 51 and 52.

If you need a copy for another person, click Export and choose the columns. The file is CSV.

Doing this in Reyuko
  1. Open Payment > Aging AR/AP.
  2. Make sure Receivable (AR) is selected.
  3. Sort the table by >90 days or 61-90 days to see the oldest accounts first.
  4. Note a contact's name, then open Payment > Receivable and search for that contact.
  5. Click Export if you need a CSV copy.
Common mistake

Reading the Total as all overdue money. The Total includes the Not Due amount. Overdue money is the four buckets from 1-30 days onward. For Riverside Mart, that is 4,500, not 8,500.

Check yourself: which bucket?

An invoice was due on 12 October. Today is 24 October. Which bucket does it fall into?

It is 12 days past the due date, so it is in 1-30 days. Note that the invoice date does not matter here. Only the Due Date counts.

Frequently asked questions

Are aging buckets counted from the invoice date or the due date?

From the due date. An invoice that is not yet due sits in the Not Due column, and its age starts counting only after the due date passes. An invoice issued 45 days ago on 30-day terms is therefore 15 days past due and falls in the 1-30 bucket. Counting from the invoice date would overstate how late most payments are.

What are the standard aging buckets?

The most common buckets are Not Due, 1-30 days, 31-60 days, 61-90 days and over 90 days past due. Some businesses use other cut-offs, so the labels matter less than keeping the same bands every month. The bands show how long money has been waiting, which makes slow payers easier to spot.

Which bucket shows the highest risk?

The oldest bucket, over 90 days, usually carries the highest risk, because the chance of collecting tends to fall as an invoice ages. Money building up in the older columns means cash is tied up for longer. This is a rule of thumb, not a fixed standard, so judge each customer's history and size before deciding how hard to push.

Does an aging report show trends over time?

Not by itself. An aging report is a snapshot of what is outstanding on the day it is run. To see a trend, save the report at regular intervals and compare the totals, or keep the same buckets each month to see whether the older columns are growing.

Does the Total column show only overdue money?

No. In Reyuko's Aging AR/AP report, the Total column includes amounts in the Not Due column as well as the overdue buckets. Read the 1-30 to over 90 columns to see the past-due portion, and use the Total Outstanding card for the full amount owed. A customer row turns red when it has money over 90 days.

Can I run Reyuko's aging report as of a past date?

No. The aging report has no as-of date field and always uses today's date. Its filter only searches by contact name, and it does not list the invoices inside each bucket. To keep a record of a position, export the CSV on the day you need it.

Put this into practice in Reyuko

Reyuko's inventory, purchasing, sales, purchasing and reporting tools work together on one ledger, so your stock and your books always agree.

Download ReyukoSee what's included