Reading and interpreting the AP Aging Summary report
Understand what each column and row means, and how to spot cash flow risks.
The AP Aging Summary report has a simple layout: rows are vendors, columns are age brackets, and each cell shows how much that vendor owes you in that age range.
How to read it
Vendor column (leftmost): Shows the vendor name and total balance owed.
Age columns: Each column represents a time bucket:
- Current (0–30 days): Bills due within the next month, or recently due.
- 31–60 days: Bills overdue by one to two months.
- 61–90 days: Bills overdue by two to three months.
- Over 90 days: Bills very overdue; this is a cash flow and relationship risk.
The numbers in each cell are the amounts (in your selected currency) that fall into that age bucket.
Total row (at the bottom): Sums all amounts in each age bracket, giving you a quick picture of your overall payables by aging.
Why it matters
This report helps you:
- Prioritize payments: vendors with large "Over 90 days" balances should be paid soon to maintain relationships and avoid penalties.
- Forecast cash needs: if most of your payables are "Current," your immediate cash need is lower. If many are overdue, cash is tight.
- Spot problems: vendor refunds or credits (which appear as negative amounts) reduce the owed balance. If a vendor's total looks wrong, check whether refunds are involved.
- Plan settlements: if you have advance payments from vendors or are negotiating payment terms, this report shows where you stand.
How it works in Usystems
Usystems calculates aging from the bill's due date (or posting date, depending on your configuration). Every unpaid bill or unapplied refund is included. Once a bill is fully paid, it no longer appears in the report.
Where you see it
- Run it from Reports → AP Aging Summary any time you need a quick check on vendor payables.
- Export it to Excel or PDF for sharing with your finance team or bank.
Was this helpful?