Running the AR Aging Detail report

The AR Aging Detail report lists every outstanding invoice line-by-line, grouped by customer and aging bucket. Unlike the summary report, it shows the specific invoice date, amount, and age for each unpaid invoice, making it ideal for detailed collections work, disputes, or reconciliation.

Before you start

• You need permission to view reports. If reports are missing from your menu, ask your administrator to enable the reports app for your role.
• Know the date as of which you want to measure aging (usually today, or a period-end date for historical review).
• Have the customer name or invoice number ready if you want to filter the results.

Steps

1. Go to Reports. Open in Usystems

2. Under Receivables & Payables Reports, choose AR Aging Detail. Click on the report name.

3. Set the Report Date:

   • Click the date field and pick the date as of which you want to measure aging.
   • All invoice ages will be calculated relative to this date.

4. (Optional) Add filters to narrow the results:

   • Click Add Filter or the filter icon.
   • Choose a filter type: Customer, Currency, Status, Invoice Number, or another option.
   • Type or select the value. Some filters let you choose multiple items.
   • Click Apply or press Enter.

5. Click Run or Generate to execute the report.

   • The report loads showing each customer and their outstanding invoices listed individually.
   • Each row represents one invoice and shows the invoice date, amount, and how many days it has been outstanding.

6. (Optional) Review the detail:

   • Scan the "Days Overdue" column to identify the oldest invoices.
   • Note the invoice numbers and amounts so you can follow up with specific customers.
   • Identify patterns (e.g., a customer with multiple overdue invoices).

7. (Optional) Sort or filter the detail rows:

   • Click a column header (e.g., "Days Overdue") to sort by that column.
   • Identify the worst offenders (largest amounts or longest overdue).

8. (Optional) Drill down or export (see "Exporting and printing the AR Aging Detail report").

Accounting impact

Running the report does not change any balances or records. The report is a read-only itemization of your accounts receivable as of the date you specify. Each row represents an invoice that has not been fully paid; partial payments reduce the outstanding amount but do not remove the invoice from the report.

Tips & common mistakes

• Use this report to follow up. The detail view lets you reference specific invoice numbers and amounts when contacting customers.
• Days Overdue includes partial payments. If an invoice is 60 days old but was partially paid 30 days ago, it still shows as 60 days overdue (the age is based on the invoice date, not the payment date).
• Look for duplicate customers. If one customer appears many times, they have multiple unpaid invoices; prioritize the largest or oldest ones.
• Compare to the Summary report. The Summary report shows totals by aging bucket; the Detail report shows the specific invoices that make up those totals. Use both for a complete picture.

---