Running the AP Aging Detail report

The AP Aging Detail report shows every outstanding vendor bill, one row per bill, with its amount, due date, and age bucket. Use this when you need to see which specific bills are overdue and contact vendors.

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 today's date as the "as of" date).

Steps

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

2. Look for AP Aging Detail 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 bills, 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.
   • Age bucket: (if available) show only bills in a specific age range, e.g., "Over 90 days."

5. Click Run or Generate to produce the report.

6. The report appears on screen with a row for each outstanding bill. Each row shows the vendor name, bill number, invoice date, due date, amount, and which age bracket it falls into.

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

• One row per bill: if you owe the same vendor multiple amounts, you will see multiple rows (one for each bill).
• Refunds appear as negative amounts: vendor credits (refunds) show as negative numbers. They reduce the total owed.
• Large report: if you have thousands of unpaid bills, this report can be long. Use filters (Vendor, Age bucket) to narrow it down.
• Find a specific bill: if you are looking for a particular vendor bill, use the Vendor filter and then search on the page (Ctrl+F or Cmd+F) for the bill number.