The aging bands used across Aiwyn reports, and what each one ages from.
WIP and outstanding AR ages are relative to today; there is no as-of date option. A Date filter changes which items are shown, not how old they are, with the WIP Aging Summary exception noted below.
Bucket endpoints are inclusive: for example, an item aged 30 days is in 0 to 30 days, and an item aged 31 days is in 31 to 60 days. The first Smart Statements bucket is an exception, as described below.
WIP aging — billing performance report
0 to 30 days, 31 to 60, 61 to 90, 91 to 120, 121 to 150, 151 to 180, over 180 days.
Ages from the WIP logged date, relative to today. The WIP Aging Summary chart shows all aging WIP regardless of the date filter and responds to the Created by Aiwyn filter.
AR aging — outstanding AR report
0 to 30 days, 31 to 60, 61 to 90, 91 to 120, 121 to 150, 151 to 180, over 180 days.
Ages from the invoice date. This applies to the AR Aging Summary, the client, partner, and office aging columns, and the Unpaid Invoices table. Median Days Sales Outstanding instead counts days past the invoice due date.
Statement aging — Smart Statements report
0 to 30 days, 31 to 60, 61 to 90, 91 to 120, over 120 days. Although the first bucket may be labeled 0 to 30 days, it includes only invoices 1 to 30 days past due. Invoices that are not yet past due are not included in a bucket.
Smart Statements buckets use days past the invoice due date, unlike outstanding AR aging, which uses the invoice date. Each statement takes the bucket of its most overdue invoice, and the bucket is set when the statement is created. Balances over 120 days past due are grouped into a single bucket.
Related
- Billing performance report reference
- Outstanding AR report reference
- Smart Statements report reference