A/R Aging Report
This section describes the fields and descriptions on the A/R Aging report.
The AR Aging report displays outstanding balances for customers, broken out in 30-day intervals, based on entry dates or due dates.
Outstanding balances represent invoiced amounts minus payments received from customers. The relationship between invoices and payments is based on reconciling customer entries that represent invoices and the customer payments.
Both the entry reconciliation date (which can be in the future) and the reconciliation date (which is the actual date of the reconciliation) must be prior to the statement date for the reconciliation to be included in the report. In addition, only entries and reconciliations that are open as of the statement date are included in the report.
You can drill down on the No & Name column to the company, customer, job, or transaction level. The Total Balance column links to the AR Transactions report. You can run the report to display blocked entries along with an explanation of why the entries are blocked. You can also control whether to sort by period (30-day intervals) and classify entries as due, based on the entry date or due date.
The report corresponds to the Print dialog box and universe report of the same name. However, the corresponding Analyzer report does not dynamically calculate reconciliations based on the statement date, nor does it report values for invoicing on account.
| Column | Description |
| No & Name | This column displays the number and name for the current drill-down level. The drill-down levels are:
|
| Balance, Total | This column displays the total amount outstanding on customer invoices, including entries that are not yet due, based on the statement date. |
| 0-30 days | This column displays the amount outstanding that is up to 30 days old. |
| 31-60 days | This column displays the amount outstanding that is between 31 and 60 days old. |
| 61-90 days | This column displays the amount outstanding that is between 61 and 90 days old. |
| 91-120 days | This column displays the amount outstanding that is between 91 and 120 days old. |
| 121+ days | This column displays the amount outstanding that is more than 120 days old. |
| DSO | This column displays the days of sales outstanding. This is calculated as the sum of individual outstanding balances of entries multiplied by the number of days they are due. The resulting value is then divided by the total outstanding balance. |