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
AP Aging Follow-up Tracker
Track aging of unpaid invoices and follow up on items nearing or past the discount cutoff or due date.
Accounts PayableVendor Statement Reconciliation
Reconcile vendor monthly statements to your AP records. Resolve discrepancies and identify missing or incorrectly recorded invoices.
Accounts PayableInvoice Processing Checklist
Standardize the invoice processing workflow to ensure all invoices are received, coded, and recorded consistently.
Ready to streamline your close?
Vergo turns templates into automated workflows with real-time collaboration, integrations, and AI built in.