AP Aging Report Template
Formal aging report of all outstanding accounts payable. Shows vendor balances and payment status for management and audit review.
How to use this template
Generate AP subledger
Extract all open vendor invoices from accounting system. Include vendor name, invoice number, invoice date, due date, and amount.
Calculate days outstanding
For each invoice, calculate number of days from due date to period-end date. Classify as current, 1-30, 31-60, 61-90, or 90+ days.
Prepare aging summary
Create summary table showing total AP by aging category. Calculate percentage of total in each bucket. Compare to prior period.
Add vendor detail
Include list of top vendors by payable balance. Note any vendors with unusually old invoices or large pending amounts.
Review and communicate
Review report with accounting leadership. Discuss plan for paying down aged items and resolving any disputed invoices.
Why use this template
- Provides management visibility into AP obligations and timing
- Helps optimize cash flow by planning payment schedule
- Identifies vendors to contact regarding overdue or disputed invoices
- Supports audit assertions about AP completeness and accuracy
Related templates
Prepaid Expense Workpaper
Track and amortize prepaid expenses with a structured workpaper that keeps your schedules accurate and audit-ready every close.
Close ManagementStandard Month-End Close Checklist
A comprehensive checklist to ensure nothing falls through the cracks during your month-end close. Track every task, owner, and deadline in one place.
Close ManagementClose Calendar Template
Plan out your entire month-end and quarter-end close timeline with a structured calendar. Coordinate across teams and set clear deadlines.
Ready to streamline your close?
Vergo turns templates into automated workflows with real-time collaboration, integrations, and AI built in.