A/R Aging Summary
This guide explains the A/R Aging Summary report of MyCloudBook: how to open it, how the open invoices of each customer are split by their age, how to change the periods, and how to print the report or download it as an Excel file.
Overview
The A/R Aging Summary shows how much each customer owes the company and how long the money has been due. A/R stands for Accounts Receivable: the money that customers owe for their invoices. The report has one row for each customer with open invoices, and one column for each age period.
The first column, Current, holds the invoices that are not past their due date. The next columns hold the invoices that are 1 to 30, 31 to 60, or 61 to 90 days past due, and the last column holds the invoices that are more than 90 days past due. The company uses the report to see which customers pay late and which amounts need a reminder.
The A/R Aging Details report lists the same invoices one by one.
How to open the report
- In the left navigation, click Reports. The Reports tab lists the reports in four groups.
- In the group Aging Reports, double click A/R Aging Summary.
- The report opens in its own tab and is created at once with the default settings. When the tab is open already, it becomes the active tab and keeps its settings.
A report tab can be closed with its x. The next double click opens the report again with the default settings.
- 1The Reports tab. It is always the first tab of the Reports page.
- 2Standard Accounting Reports: Trial Balance, Balance Sheet, Income Statement, and Cash Flow Statement. A click on the title of a group hides or shows its reports.
- 3Aging Reports: A/R Aging Summary, A/R Aging Details, A/P Aging Summary, and A/P Aging Details.
- 4Sales Reports: Sales Summary.
- 5Tax Reports: Sales Tax Liability.
- 6A report, here Trial Balance. A double click opens it.
The report screen
The report screen has two parts. The center shows the report as a Portable Document Format (PDF) document in the PDF viewer of the browser. The Report Setting panel at the right holds the settings of the report. After a change of the settings, click Reload to create the report again. The arrow in the header of the panel hides the panel, so the report gets more room.
The example shows the company Bright Bean Coffee Co. with the As Of date Oct 16, 2026 and the default periods.
- 1The A/R Aging Summary tab. The x closes it.
- 2The download and print buttons of the PDF viewer of the browser.
- 3The title of the report, A/R AGING SUMMARY, the As Of date, and the name of the company.
- 4The periods Current, 1 - 30, 31 - 60, 61 - 90, and 91 and over, and the column Total.
- 5One row for each customer with open invoices. Each cell shows the open balance of the customer in the period.
- 6Total. The open balance of all customers in each period. The last cell, 7,595.65, is the open balance of all invoices.
- 7Report Setting. The panel with the settings of the report.
- 8As Of. The day of the report. It starts with today.
- 9Days Per Period. The length of each past-due period in days. It starts with 30.
- 10Number Of Periods. The number of past-due periods. It starts with 4.
- 11Customer. One customer, or empty for every customer. The x empties the field.
- 12Reload. Creates the report again with the settings of the panel.
- 13Download Excel. Downloads the report as the Excel file A_R Aging Summary.xlsx.
The settings
| Field | Required | Purpose and rules |
|---|---|---|
| As Of | Required | The day of the report. The report lists the open invoices that are dated on or before this day, and it computes the age of each invoice on this day. |
| Days Per Period | Required | The number of days of each past-due period, for example 30. |
| Number Of Periods | Required | The number of past-due periods, for example 4. The last past-due period has no end. The period Current is added to these periods. |
| Customer | Optional | One customer, or empty for every customer. The list shows the active customers with their balance. Type a part of the name to filter the list, and click a customer to select it. The x empties the field. |
How to read the report
| Part | How MyCloudBook computes it |
|---|---|
| Invoices | The invoices that are not fully paid and are dated on or before the As Of date. A partly paid invoice counts with the part that is still open. |
| Other sales documents | A receipt is a sale that is paid at once, so it is never in the report. Draft invoices, estimates, and sales orders are not counted. |
| Open balance | The total of an invoice minus the payments of the receipt vouchers that are applied to it. |
| Period | The age of the invoice on the As Of date, counted from its due date. |
| Customer rows | One row for each customer with at least one open invoice. A customer without an open invoice has no row. |
| Total column | The open balance of the customer in all periods. |
| Total row | The sum of the customers in each period. |
| Empty cell | The customer has no open balance in this period. |
In the example, Downtown Cafe LLC owes 3,965.75 in total. Of this amount, 1,944.75 is not due yet, 376.25 is 1 to 30 days past due, and 1,644.75 is 31 to 60 days past due. The customers Riverside Hotel & Suites and Green Leaf Bistro have amounts that are 1 to 30 days past due. No invoice is more than 60 days past due.
To see the invoices behind an amount, open the A/R Aging Details report with the same As Of date and select the customer in Customer.
The periods
The age of an invoice is counted from its due date. On the As Of date, an invoice that is due on that day or later is in the period Current. An invoice that is past its due date is in one of the past-due periods. Days Per Period sets the length of each past-due period, and Number Of Periods sets the number of past-due periods. The last past-due period has no end.
| Days Per Period and Number Of Periods | Periods of the report |
|---|---|
| 30 and 4 (the default) | Current, 1 - 30, 31 - 60, 61 - 90, 91 and over |
| 15 and 2 | Current, 1 - 15, 16 and over |
| 7 and 4 | Current, 1 - 7, 8 - 14, 15 - 21, 22 and over |
| 30 and 1 | Current, 1 and over |
In the summary reports, the periods are columns, for example 1 - 30 and 91 and over. In the details reports, the periods are groups of rows, for example 1 - 30 days past due and 91 or more days past due. Change the settings and click Reload to see the new periods.
A later As Of date shows how the open invoices will age if they stay unpaid. For example, with the last day of the month, the report shows which invoices will be past due at the end of the month.
Printing and Excel
- To print the report, click the print button of the PDF viewer. To keep it as a PDF file, click the download button of the PDF viewer.
- To work with the figures in a spreadsheet, click Download Excel. MyCloudBook creates the report with the settings of the panel and downloads it as A_R Aging Summary.xlsx. The Excel file has the same rows, a header that stays visible, and a print setup with page numbers.
- The report shows the posted data at the moment of the Reload. After new documents are saved, click Reload again.
Messages and their meaning
Questions and answers
What does the A/R Aging Summary show?
The open balance of each customer, split by the age of the invoices. The column Current holds the invoices that are not past their due date, and the other columns hold the invoices that are past due.
How is the age of an invoice computed?
From the due date of the invoice to the As Of date. An invoice that is due on the As Of date or later is in Current. An invoice that is 10 days past its due date is in 1 - 30.
Which invoices are in the report?
The invoices that are not fully paid and are dated on or before the As Of date. A partly paid invoice counts with its open part. Receipts, draft invoices, estimates, and sales orders are not in the report.
How do I change the periods?
Change Days Per Period and Number Of Periods, and click Reload. For example, 15 and 2 give the periods Current, 1 - 15, and 16 and over.
How do I see the invoices of one customer?
Open the A/R Aging Details report, select the customer in Customer, and click Reload. The report lists the open invoices of the customer one by one.