Running the AP Aging Summary report

The AP Aging Summary report shows the total amounts you owe to vendors, grouped into age buckets (for example, 0–30 days, 31–60 days, over 90 days). This helps you understand which vendor bills are most urgent and plan your cash flow.

Before you start

• You need permission to view Reports.
• The report includes all unpaid bills and refunds from vendors.
• Have a date range in mind (or use the current date as the end date).

Steps

1. Go to Reports from the main menu. Open in Usystems

2. Look for AP Aging Summary in the list of reports.

3. Click Run or Generate next to the report name.

4. (Optional) Choose filters:

   • Vendor: Select a specific vendor to see only their outstanding balance, or leave blank to see all vendors.
   • As of date: Enter the date on which you want to measure aging (defaults to today).
   • Currency: If your company uses multiple currencies, select the one you want to view.

5. Click Run or Generate to produce the report.

6. The report appears on screen showing vendors and their outstanding balances in age columns.

Accounting impact

This is a read-only report. It shows Bills and refunds posted to your Accounts Payable (AP) ledger. It does not create or modify any transactions.

Tips & common mistakes

• Dates matter: aging is calculated from the bill date or due date (depending on your settings). Ask your accountant which date your company uses.
• Refunds are included: vendor refunds (credits) reduce the aged balance; they appear as negative amounts.
• Multi-currency: if you see a "Total" row that looks wrong, check whether vendors are in different currencies. The report does not auto-convert; each currency is summed separately.