Accounts Payable Aging Report Template (Free Excel)

Description
This free Accounts Payable Aging Report template sorts every open vendor invoice into aging buckets - Current, 1-30, 31-60, 61-90, and 90+ days past due - and totals them automatically by bucket and by vendor.


The workbook has two tabs. The first is the AP Aging Report itself: a report date you control, an open invoice table where you list each vendor invoice, and an aging summary above it that totals what's owed in each bucket automatically, with a bar chart. The second tab is a Vendor Summary that rolls the same invoices up by vendor, so you can see immediately which vendor relationship needs a call, not just which invoice.


It's pre-loaded with 16 sample vendor invoices so you can see exactly how the buckets, totals, and chart work before you clear them out and enter your own data. No email signup required.


More free finance templates (cash flow forecast, working capital calculator, balance sheet, and more) at analystnook.com. This template works well for finance teams managing supplier payments, bookkeepers preparing month-end reports, and small business owners who want to see exactly which vendor balance is overdue before it becomes a cash flow problem, not just a rough total. Fully editable Excel formulas throughout, so you can adapt it to your own vendor list and payment terms.