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
| Bucket | Days past the due date |
|---|---|
| Not Due | Not yet past the due date. Invoices with no due date also land here. |
| 1-30 days | 1 to 30 days late |
| 31-60 days | 31 to 60 days late |
| 61-90 days | 61 to 90 days late |
| >90 days | More 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:
| Customer | Not Due | 1-30 days | 31-60 days | 61-90 days | >90 days | Total |
|---|---|---|---|---|---|---|
| Riverside Mart | 4,000 | 2,500 | 0 | 1,200 | 800 | 8,500 |
| Pine Corner Store | 0 | 0 | 1,500 | 0 | 0 | 1,500 |
| Oak Kiosk | 3,000 | 0 | 0 | 0 | 0 | 3,000 |
| Total | 7,000 | 2,500 | 1,500 | 1,200 | 800 | 13,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.
- Open Payment > Aging AR/AP.
- Make sure Receivable (AR) is selected.
- Sort the table by >90 days or 61-90 days to see the oldest accounts first.
- Note a contact's name, then open Payment > Receivable and search for that contact.
- Click Export if you need a CSV copy.
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.
Reyuko