AP Aging Report
See what you owe and how overdue it is. DocuClipper's accounts-payable aging report buckets open bills by age (current, 1-30, 31-60, 61-90, 90+) with a per-vendor breakdown.
Last updated
The AP aging report answers the core accounts-payable question: what do we owe, and how late is it? DocuClipper takes the open bills in a project and buckets them by how overdue they are, with a per-vendor breakdown so you can see which suppliers are carrying the oldest balances.
What it shows
Open bills are grouped into standard aging buckets based on their due date relative to the report date:
| Bucket | Meaning |
|---|---|
| Current | Not yet due. |
| 1–30 | 1 to 30 days overdue. |
| 31–60 | 31 to 60 days overdue. |
| 61–90 | 61 to 90 days overdue. |
| 90+ | More than 90 days overdue. |
For each bucket you get the number of bills and the total owed, plus a grand total across all buckets. Below that, a by-vendor breakdown shows each vendor's total owed, bill count, how old their oldest open invoice is, and how that balance spreads across the buckets.
Which bills are included
The report counts only genuine open payables:
- Document type is a payable / bill / expense (sales invoices are excluded).
- The bill has a due date (without one, an invoice can't be aged).
- It still has a balance owed.
- It hasn't been rejected in approval or deleted.
Bills DocuClipper has confirmed as paid in QuickBooks or Xero drop out of aging automatically — see paid-status sync in The AP queue.
Choosing the report date
By default the report ages everything as of today. You can set a different as-of date to see how your payables looked at, say, month-end. You can also filter to a single vendor when you want one supplier's aging in isolation.