Accounts receivable aging summary by period

Use the Accounts receivable aging summary by period report in Menu > Reports to review each customer’s outstanding receivables for a selected accounting period. The report applies payments and other applications through that period and groups the remaining open balance into current and overdue aging buckets.

Run the report

1. Open Menu > Reports. In Search by report or description, enter the report name and press Enter.
2. Select Accounts receivable aging summary by period.
3. Select Change date range, choose the reporting period, and apply the change.
4. Optionally filter by Customer.
5. Review the summarized balances. Select an amount when you need to open its supporting detail.
6. To download the report, select Export as PDF or Export as Excel (.xlsx).

How the report is calculated

The report includes receivables activity posted by the selected accounting period and applies payments and other applications through that period. Transactions posted after the selected period and transactions already closed by that period are excluded. It sums each customer’s remaining open balance into Current, 1-30 days, 31-60 days, 61-90 days, and 91 days or more according to the number of days between the due date and the current date. Total open balance is the sum of all aging buckets.