Reading and interpreting the AP Aging Detail report

The AP Aging Detail report shows one row per outstanding bill. Each row contains the bill's key information so you can track exactly which bills are overdue and how much you owe.

How to read it

Vendor column: The name of the vendor who issued the bill.

Bill/Reference number: A unique identifier for the bill (e.g., "INV-2026-0045"). Use this to look up the bill in the system or discuss it with the vendor.

Bill date: The date the vendor issued the bill.

Due date: The date the bill is (or was) due for payment.

Amount: The outstanding balance for this bill. Refunds appear as negative amounts.

Age bucket: Which time bracket the bill falls into:

• Current (0–30 days)
• 31–60 days
• 61–90 days
• Over 90 days

Days overdue: (if shown) how many days past the due date. A negative number means the bill is not yet due.

Why it matters

This report helps you:

1. Track individual bills: instead of seeing just a vendor total, you can see exactly which bills need attention.
2. Contact vendors: if a bill is very overdue, you have the bill number and amount ready to discuss with the vendor.
3. Prioritize payments: sort by "Days overdue" or "Age bucket" (mentally or by exporting to Excel) to pay the most urgent bills first.
4. Investigate discrepancies: if a vendor's statement doesn't match your records, use this report to find the specific bills in question.
5. Plan negotiations: if you're renegotiating payment terms or asking for an extension, this report gives you proof of your exact outstanding amounts.

How it works in Usystems

Usystems calculates aging from each bill's due date. Every unpaid bill and unapplied refund is shown as a separate row. Once a bill is paid in full, it disappears from the report. Partial payments reduce the Amount, but the bill remains listed until fully paid.

Where you see it

• Run it from Reports → AP Aging Detail any time you need detailed line-by-line payables information.
• Export to Excel to sort, filter, or manipulate further.
• Print or save as PDF for vendor discussions or your records.