Accounts Payable Aging preview
AP Register sheet listing vendor invoices with aging buckets from Current through 90+ days past due. 1/4

About this accounts payable aging spreadsheet template

This accounts payable aging template gives finance teams a complete system for tracking vendor invoices across five aging buckets — Current, 1-30, 31-60, 61-90, and 90+ days past due. The four-sheet workbook includes an AP Register for logging invoices with vendor details and payment status, a Payment Queue that prioritizes overdue items by urgency, an AP Dashboard with summary charts and vendor-level outstanding balances, and a Vendor Guide that documents payment rules and aging-based action triggers.

Every sheet is fully editable in WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers. Replace the sample vendor data, adjust aging thresholds, reassign payment owners, and update the control logic to match your organization's accounts payable workflow without rebuilding any formulas or structure.

4 integrated sheets

AP Register, Payment Queue, Dashboard, and Vendor Guide work together for end-to-end payables tracking.

Aging bucket breakdown

Automatically categorize outstanding invoices into Current, 1-30, 31-60, 61-90, and 90+ day buckets.

Priority payment queue

Rank overdue payables by urgency with owner assignments, scheduled pay dates, and action notes.

Standard XLSX format

Works with WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers.

Frequently asked questions
The Accounts Payable Aging template is designed for tracking vendor invoices, managing payment priorities, and monitoring outstanding liabilities across aging buckets. Customize the sample data, aging thresholds, and payment rules in WPS Office for your own accounts payable workflow.
Use the native XLSX in WPS Office, Microsoft Excel, or Google Sheets. For Notion workflows, reuse the data and structure in a Notion database; for branded financial documents, adapt the content in Adobe Express.
Download the template, open it in WPS Office, and replace the sample vendor names, invoice amounts, dates, payment owners, and aging rules with your own accounts payable data.
Yes. Select Download to get the editable XLSX file and open it in WPS Office or another compatible spreadsheet application.
Yes. Adapt it for monthly AP close processes, cash flow planning, vendor risk assessment, and finance team reporting. It is available for personal and commercial projects, subject to the applicable template license.