AP Aging List
Review remaining approved balances by supplier and due date, retaining the as-of basis.
Explain aging, supplier spend, invoice exceptions and payment outcomes.
This quarter
How far records got this quarter
| Stage | Reached | Step | |
|---|---|---|---|
| Draft | 40 | ||
| Pending match | 8 | 20% | |
| Pending approval | 2 | 25% | |
| Approved | 1 | 50% |
Sample totals per stage
Review remaining approved balances by supplier and due date, retaining the as-of basis.
Distinguish opportunities from discounts actually applied to eligible payments.
Follow quantity, price and receipt discrepancies to their source evidence.
Track owners, supplier responses and resolution outcomes.
Separate selected, released, transmitted and cleared amounts before reporting cash movement.
Keep missing W-9 information and unresolved rule questions visible in the reporting population.
Review the configured filing owner, approved snapshot and actual partner result.
Trailing-12-months total Cleared Payments per Vendor, ranked, with month-over- month delta and concentration metric (top-10 share of total AP spend). The strategic-sourcing input. Drills into per- Vendor Bills and into bill lines by GL account.
Per period: count and percent of Bills with Outcome: Mismatch or partial match, broken down by Vendor and by discrepancy type (quantity vs. dollar variance). The control-effectiveness report — a rising mismatch rate from one Vendor flags either a process break or a vendor-side billing problem.
Per payment run: Item count, total amount, total discount taken, breakdown by payment method (ACH / Check / Wire), Funded / Posted timing. Drills into per-Bill payment run items and into per-Vendor Payments.
Per tax year: count of Vendors with Required1099 = TRUE, count missing W-9, count Computed / ready to file / Filed, total reportable dollars by form1099 box. The pre-January-31-deadline Controller report that drives W-9 solicitation and the filing partner handoff.
Per period: count of Disputes opened, closed, average days-to-resolution by Reason type; total vendor credits issued, applied, remaining balance. The AP Manager’s vendor-management report.
Forward- looking 4-week forecast of cash out: Approved Bills bucketed by due date (current week / next week / wk+2 / wk+3), net of available early pay discounts and held payment run items. The Treasury / Controller cash-planning report.
Start free, then use Proto to change fields, steps and approvals before your team goes live.