AP Aging Report Generator
Accounts payable aging report with 30-60-90 day buckets
Enter open vendor bills, pick a report date, and see bucket totals. Export CSV for Excel or month-end packs. No login.
How it works
- 1
Set the report date
Choose the as-of date for month-end or your review period.
- 2
Add open bills
Enter vendor, invoice number, dates, due date, and amount for each unpaid bill.
- 3
Export the schedule
Review bucket totals and vendor lines, then download CSV for Excel or ERP import.
Worked example
An example of the result AP Aging Report produces.
Worked example: three vendor bills bucketed by days past due.
| Vendor | Invoice | Amount | Days past due | Bucket |
|---|---|---|---|---|
| Acme Supplies | INV-1042 | $1,200 | 0 (not due) | Current |
| Northwind | INV-881 | $450 | 18 | 1–30 |
| Contoso | INV-219 | $2,800 | 47 | 31–60 |
What is AP Aging Report?
An accounts payable (AP) aging report groups unpaid vendor bills by days past due: Current (not yet due), 1-30, 31-60, 61-90, and 90+ days. This generator ages each row from its due date against the report date you choose, shows vendor lines inside each bucket, and exports CSV. Manual entry here; use Invoice to CSV to pull due dates and amounts from PDF bills.
Frequently Asked Questions
Everything you need to know about the AP Aging Report.
What is an AP aging report?
An AP aging report (accounts payable aging report) lists unpaid vendor invoices grouped by how long they have been outstanding: Current, 1-30, 31-60, 61-90, and 90+ days. Finance teams use it to see which bills are coming due, which are late, and how much cash is committed in each window.
What date is aging calculated from?
Each row is aged from its due date against the report as-of date you pick at the top of the tool. Change the report date to rerun month-end or a prior close without retyping bills.
What are the standard accounts payable aging buckets?
Current (not yet due), 1-30 days past due, 31-60 days, 61-90 days, and 90+ days. This generator assigns each open bill to one bucket based on days past due from the due date.
Can I export this AP aging report to Excel?
Yes. Download CSV with the report as-of date, vendor lines, days past due, and bucket labels. Open it in Excel or Google Sheets, or use it as a handoff for ERP import.
What is the difference between an AP aging report and an AR aging report?
AP aging tracks money you owe vendors (payables). AR aging tracks money customers owe you (receivables). This generator is accounts payable only.
Can I populate this from PDF invoices automatically?
This page is manual entry. To pull vendor, due date, and amount from PDF bills, use the free Invoice to CSV converter, then paste or merge rows here.
Related Resources & Automation Solutions
Invoice Data Extraction
Extract invoice numbers, line items, totals, and vendor details from any PDF or scanned invoice — no templates required.
PDF to Excel: 6 Ways to Automate Data Extraction
Learn the easiest ways to convert complex PDFs into clean Excel data — from AI batch processing to simple desktop tools. No manual entry.
Invoice to CSV Converter
Extract invoice fields and line items into a CSV file.
Automate AP aging from invoice PDFs
Extract structured data from PDFs in bulk — invoices, receipts, and financial documents processed automatically. No manual entry.
Start Free TrialFree trial · No credit card required