AP Aging & KPI Dashboard (2026)

1Tell us where to send it
Your name and work email — nothing more.
2Check your inbox
Your dashboard arrives in seconds, not days.
3Use it with your team
Editable and ready to share — make it your own.

A peek inside

See exactly what you're getting

Free Excel template

Spotsaas · 2026

AP Aging & KPI Dashboard

✓ Instructions

✓ Aging by Vendor

✓ KPI Dashboard

Get the dashboard →

What it is

The AP Aging & KPI Dashboard is an Excel tool that shows your accounts-payable health at a glance — combining a classic aging report with a KPI scorecard that grades each metric red/amber/green against finance benchmarks. You enter open balances by vendor across standard aging buckets (Current = not yet due, then 1–30, 31–60, 61–90, and 90+ days past due), and the dashboard rolls up totals per vendor and per bucket, computes the share of payables in each bucket, your Days Payable Outstanding (DPO), and your overdue percentage, then assigns a RAG status to each KPI. Concentration in the older buckets signals process bottlenecks, strained vendor relationships, and missed early-pay discounts.

The workbook is organized as an Instructions tab, an Aging by Vendor tab, and a KPI Dashboard. On Aging by Vendor you enter each vendor's open balance split across the five buckets; the sheet totals each vendor row and each bucket column and computes an Overdue $ figure (everything except Current). On the KPI Dashboard you enter annual purchases so DPO can be computed, and the dashboard returns the bucket mix percentages, DPO, overdue percentage, and a RAG status for each metric versus its target. The benchmark targets are concrete: DPO in a healthy 30–45 day range, overdue under 10% of total AP, the 90+ bucket under 2%, and the Current bucket above 70%.

What makes the dashboard actionable is the RAG grading and the computed verdict. DPO is calculated as (total AP ÷ annual purchases) × 365 — the average days you take to pay — and is graded against your target. Overdue percentage and the 90+ share are graded the same way. The Overall read returns a verdict: healthy when overdue AP is within target, action-needed when 90+ balances exceed 4% (escalation risks), or watch when overdue exceeds target. The dashboard works as a standalone monitoring tool and as a way to see, before and after, what an AP automation platform like AvidXchange or Tipalti does to your aging by accelerating approvals and pulling balances into Current.

What it's used for

The dashboard is used to monitor AP health, spot trouble before it strains vendors, and report payables status to finance leadership. Teams use it in the monthly close cycle, in working-capital reviews, and when diagnosing why payables are aging — too much in the older buckets points to approval bottlenecks and missed discounts that need fixing.

✓ Entering open AP balances by vendor across the five standard aging buckets to see, at a glance, where payables are concentrated.
✓ Rolling up totals per vendor and per bucket and computing an Overdue $ figure (everything past Current) automatically.
✓ Computing Days Payable Outstanding as (total AP ÷ annual purchases) × 365 to measure the average days you take to pay and grade it against a 30–45 day healthy range.
✓ Calculating overdue percentage and bucket mix and grading each red/amber/green against benchmark targets (overdue under 10%, 90+ under 2%, Current above 70%).
✓ Flagging 90+ day balances as escalation risks and surfacing them through the action-needed verdict so they get prioritized.
✓ Diagnosing whether aging concentration reflects an approval bottleneck, strained vendor relationships, or missed early-pay discounts.
✓ Demonstrating the before-and-after impact of faster approvals or AP automation by watching balances move into the Current bucket and overdue percentage fall.

Who uses it

The dashboard is for the people who manage and report on payables health — AP leadership who own the aging, the controller who reports it, and the treasury and FP&A functions that care about DPO and working capital. It turns a raw aging report into a graded scorecard those audiences can act on.

AP ManagerOwns the aging and uses the RAG scorecard to spot growing overdue and 90+ balances and to prioritize which invoices to push through approval.

ControllerReports AP health to leadership and uses the verdict and benchmark grading to flag when the approval cycle needs tightening or escalation is required.

Treasury / Cash ManagerWatches DPO to manage working capital — paying too fast strains cash, too slow strains vendors — using the 30–45 day healthy range as a guide.

CFO / FP&AUses DPO and overdue trends as working-capital and vendor-relationship indicators and to judge whether AP process investment is paying off.

AP Automation EvaluatorCompares aging before and after automation to quantify how much a platform like AvidXchange or Tipalti pulls balances into Current and lowers overdue.

Context & good to know

An AP aging report is one of the oldest tools in accounting, but on its own it's just a table of numbers — it tells you where balances sit without telling you whether that's good or bad. This dashboard's contribution is the KPI scorecard layered on top: it grades each bucket and headline metric red/amber/green against finance benchmarks, so an AP manager sees not just that 90+ balances are $2,000 but that they exceed the 2% target and represent escalation risk. The RAG grading turns raw data into a prioritized action list, which is what makes the difference between a report that's filed and one that's used.

Days Payable Outstanding is the metric that connects AP to working capital. Computed as (total AP ÷ annual purchases) × 365, DPO measures how long, on average, you take to pay suppliers. A higher DPO conserves cash, but pushed too far it strains vendor relationships and forfeits early-payment discounts; too low and you're paying faster than you need to. The healthy 30–45 day range is a starting benchmark that varies by industry, and the dashboard grades your DPO against your own target so you can manage the trade-off deliberately rather than letting it drift.

Concentration in the older aging buckets is a symptom, and the dashboard helps you read it. Balances piling up in 31–60, 61–90, and especially 90+ usually point to an approval bottleneck — invoices stuck in routing rather than genuine disputes — and that bottleneck is exactly what costs you early-payment discounts and prompts vendor calls. The targets (Current above 70%, overdue under 10%, 90+ under 2%) are the thresholds that distinguish a healthy aging profile from one that needs intervention. The action-needed verdict fires when 90+ balances become escalation risks, so the worst balances get attention first.

AP automation's effect on aging is direct and measurable. By accelerating approval and matching, automation pulls invoices through faster, shifting balances out of the overdue buckets into Current and lowering overdue percentage — the same mechanism that improves discount capture. Platforms like AvidXchange and Tipalti are marketed partly on this outcome. For buyers asking 'what is the best accounts payable software?', running this dashboard before and after a pilot turns the question into evidence: which platform actually improved our aging mix and DPO? The dashboard provides the baseline and the scorecard to hold a tool accountable to a real result.

✓ Independent · vendors can't pay to rank

Built on verified data, not vendor spin

Every Spotsaas resource draws on the Spotsaas Score — a blend of verified review ratings, review volume, and feature depth across 38 AP automation software tools. Refreshed regularly; data as of June 2026.

FAQ

Questions, answered

What is Days Payable Outstanding (DPO)?

DPO is the average number of days you take to pay your suppliers, computed as (total accounts payable ÷ annual purchases) × 365. A higher DPO means you're holding cash longer before paying; a lower DPO means you're paying faster. A healthy range is roughly 30–45 days, though it varies by industry. DPO is a key working-capital metric — push it too high and you strain vendors and miss discounts, too low and you give up cash unnecessarily.

What are AP aging buckets?

Aging buckets group open payables by how long they've been outstanding: Current (not yet due), then 1–30, 31–60, 61–90, and 90+ days past due. They show the age profile of what you owe. A healthy profile has most balances in Current (target above 70%) and very little in the older buckets (90+ target below 2%). Concentration in older buckets signals approval bottlenecks, strained vendor relationships, or missed early-pay discounts.

What does the overdue percentage tell me?

Overdue percentage is the share of total AP that's past due — everything except the Current bucket — divided by total AP. It's a quick health indicator: a target below 10% means most of what you owe isn't yet late. A rising overdue percentage usually points to approval delays or process bottlenecks rather than deliberate cash management, and it's often accompanied by missed discounts and vendor complaints.

What is RAG status in the dashboard?

RAG stands for Red/Amber/Green — a traffic-light grading of each KPI against its benchmark target. Green means the metric is within target, Amber means it's drifting and needs watching, and Red means it's breached the threshold and needs action. The dashboard applies RAG to each aging bucket and to DPO, overdue percentage, and the 90+ share, turning raw numbers into a prioritized, at-a-glance read of AP health.

Why are 90+ day balances a concern?

Because they're the oldest, most overdue payables — typically escalation risks where a vendor relationship may already be strained or a dispute is unresolved. The target is to keep 90+ below 2% of total AP. When 90+ balances exceed about 4%, the dashboard's verdict flags action needed, because these balances rarely resolve themselves and often indicate invoices stuck in approval or genuine disputes that need direct intervention.

What's a healthy DPO range?

Roughly 30–45 days is a common healthy benchmark, though it varies significantly by industry and vendor terms. The goal is to pay close to terms — capturing early-pay discounts where the APR justifies it — without stretching so far that you strain vendors or risk supply. The dashboard grades your DPO against your own target so you can manage the working-capital trade-off deliberately rather than letting payment timing drift.

How does my aging affect early-payment discounts?

Directly. If invoices are aging into the overdue buckets because of slow approvals, you've almost certainly missed their early-payment discount windows — the 10-day window in a 2/10 net 30 term closes long before an invoice reaches 31–60 days. A healthy aging profile with most balances in Current is also the profile that captures discounts, because both depend on getting invoices approved and paid quickly. Aging concentration and missed discounts are two symptoms of the same bottleneck.

What inputs does the dashboard need?

Two things: each vendor's open balance split across the five aging buckets (entered on the Aging by Vendor tab), and your annual purchases or total AP spend (entered on the KPI Dashboard tab, needed to compute DPO). You can also set your DPO target and overdue-percentage target. Everything else — vendor totals, bucket mix, overdue dollars, DPO, RAG grading, and the verdict — calculates automatically.

How can I improve a poor aging profile?

Tighten the approval cycle so invoices move through faster and balances shift from the overdue buckets into Current. Prioritize the oldest 90+ balances first, since they're escalation risks, and investigate whether they're stuck in approval or genuinely disputed. The most durable fix is faster, more automated approval routing — the dashboard's verdict recommends prioritizing and automating approvals precisely because slow routing is the usual root cause of aging concentration.

Can AP automation improve my aging and DPO?

Yes. By accelerating matching and approval, automation pulls invoices through faster, shifting balances into the Current bucket, lowering overdue percentage, and giving you finer control over DPO. Platforms like AvidXchange and Tipalti are marketed partly on this outcome. Running this dashboard before and after an automation pilot quantifies the effect — turning 'what is the best accounts payable software?' into a comparison of which tool actually improved your aging mix and DPO.

Keep exploring