Accounts Payable Aging Schedule Template
Analyze outstanding vendor invoices by age. Track payment obligations and identify discrepancies with vendor statements.
How to use this template
Extract open vendor invoices
Pull all open vendor invoices from AP subledger. Include invoice date, due date, vendor name, invoice number, and amount.
Age invoices by days outstanding
Categorize each invoice: current, 1-30 days past due, 31-60 days past due, 61-90 days past due, 90+ days past due.
Calculate aging totals
Sum AP in each aging category. Compare total to GL accounts payable account. Investigate any differences.
Identify overdue items
Flag invoices that are significantly past due. Determine if they're in dispute, on hold, or overlooked for payment.
Reconcile to vendor statements
Obtain vendor statements and reconcile to aging schedule. Identify items vendor claims are unpaid that you've recorded as paid.
Why use this template
- Ensures you're paying bills on time to maintain vendor relationships
- Identifies disputed invoices or vendor statement mismatches
- Improves cash flow management and payment planning
- Catches duplicate payments or invoices recorded in error
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.