Your cash position is only as good as your visibility into it. When accounts payable and accounts receivable live in separate systems, you find out about a cash crunch after it has already happened. The fix is a short list of the right KPIs, wired into dashboards that update as invoices move. This guide covers the AP and AR metrics that actually predict cash health, how to calculate them, what good looks like, and which platforms surface them well in 2026.
Key takeaways
- Three numbers carry most of the signal. DSO tells you how fast you collect, DPO how long you hold cash, and the cash conversion cycle ties them together.
- Track AP and AR in one view. Managed separately, they hide the net cash picture. Together, they show whether your working capital is actually improving.
- Formulas matter. A dashboard that shows DSO without defining how it is calculated invites teams to game the number. Agree on the formula first.
- Watch for stale vendor picks. Airbase, once a common standalone name here, is now part of Paylocity after a 2024 acquisition. The AP/AR analytics field keeps shifting.
- Real-time beats month-end. The value of these metrics is proactive. A DSO you learn about three weeks late is a history lesson, not a lever.
Why AP and AR belong on the same dashboard
Cash flows in through receivables and out through payables. Look at either one alone and you are seeing half the picture. A finance team can be proud of a falling DSO while quietly stretching suppliers to the point of straining the relationship, or hold a healthy payables balance while receivables quietly age past 60 days. The point of a combined AP/AR dashboard is to show the net position and the trade-offs between the two, not just two disconnected scorecards.
The second reason is timing. With manual reporting, these numbers arrive at month-end close, which means you act on last month’s reality. When the dashboard syncs directly from your ERP and banking feeds, every approved invoice and every collected payment updates the metric, and you can act while it still matters.
The AP/AR KPI reference table
Start with the metrics, their formulas, and what a healthy reading looks like. Benchmarks vary by industry, so treat the “what good looks like” column as direction rather than a universal target.
| KPI | Side | What it measures | Formula | What good looks like |
|---|---|---|---|---|
| Days Sales Outstanding (DSO) | AR | Average days to collect after a sale | (Accounts receivable / credit sales) × days in period | Lower, and stable near your payment terms |
| Collection Effectiveness Index (CEI) | AR | Share of receivables actually collected in a period | Collected / (opening AR + credit sales − closing current AR) × 100 | Closer to 100% is better |
| Average Days Delinquent (ADD) | AR | Average lateness of overdue invoices | DSO − best possible DSO (based on terms) | As close to zero as possible |
| Bad Debt Ratio | AR | Sales written off as uncollectible | Bad debt / total credit sales × 100 | Low and trending down |
| Days Payable Outstanding (DPO) | AP | Average days you take to pay suppliers | (Accounts payable / COGS) × days in period | Higher helps cash, but not at supplier expense |
| Invoice Cycle Time | AP | Receipt to payment, per invoice | Average of (payment date − receipt date) | Days, not weeks |
| Discount Capture Rate | AP | Early-payment discounts you actually take | Discounts captured / discounts available × 100 | High; missed discounts are lost yield |
| Exception Rate | AP | Invoices needing manual intervention | Exception invoices / total invoices × 100 | Low; each exception adds cost and delay |
| Cost per Invoice | AP | Fully loaded cost to process one invoice | Total AP processing cost / invoices processed | A few dollars automated vs much higher manual |
| Cash Conversion Cycle (CCC) | Both | Net days cash is tied up in operations | DSO + DIO − DPO | Lower, and some businesses run it negative |
The receivables metrics that predict collections
On the AR side, DSO is the headline, but it is easy to misread on its own. A DSO of 45 days looks fine on net-30 terms only if your best possible DSO is close to that. That is what Average Days Delinquent captures: the gap between how fast you could collect and how fast you actually do. Pair DSO with ADD and you separate slow terms from slow collections.
The Collection Effectiveness Index answers a different question: of the money that came due, how much did you actually get in? A team can lower DSO by cherry-picking easy accounts while leaving hard receivables to rot, and CEI catches that. The Bad Debt Ratio is the backstop, showing how much you gave up on entirely. Read together, these four tell you not just how long collections take, but how good they are.
The payables metrics that protect cash without burning suppliers
DPO is the mirror image of DSO, and the temptation is always to push it higher, since holding cash longer flatters your working capital. The risk is that stretching payments too far frays supplier relationships and can cost you priority, better terms, or early-payment discounts worth far more than the float. Read DPO next to your Discount Capture Rate: if you are lengthening payment cycles while leaving 2/10 discounts on the table, you are trading a high-yield return for a small timing gain.
Invoice Cycle Time, Exception Rate, and Cost per Invoice measure the health of the AP process itself. Long cycle times mean discounts expire before approval. High exception rates mean people are touching invoices that should flow through untouched. Cost per invoice ties it together and is the cleanest way to show the return on AP automation, since automated processing typically costs a few dollars per invoice against much higher fully loaded manual costs.
The cash conversion cycle ties it all together
The single metric that unites AP and AR is the cash conversion cycle: DSO plus Days Inventory Outstanding minus DPO. It tells you how many days your cash is locked up in operations before it comes back as cash. Lower is better, and companies with strong buyer leverage sometimes run it negative, meaning they collect from customers before they pay suppliers. If you track only one combined number on an executive dashboard, this is the one, because every AP and AR improvement shows up in it.
Dashboards worth building
Metrics need a home. Five dashboard views cover most finance teams:
- Cash flow overview: inflows, outflows, and net position in real time.
- Working capital: DSO, DPO, and CCC together, trended over time.
- Collections performance: aging buckets, recovery trends, and results by collector or segment.
- AP efficiency: cycle time, exception rate, and discount capture, with bottlenecks flagged.
- Executive summary: a CFO-level snapshot of cash balance, outstanding invoices, and forecast liquidity.
Good dashboard design does as much work as the metrics. Use color to flag what needs attention, put the highest-impact KPIs where the eye lands first, allow filtering by entity, region, or customer segment, and pair current readings with trend lines so a single bad month does not get mistaken for a pattern.
What to look for in the software
The tooling splits into a few groups. Dedicated AR platforms focus on collections and cash application. AP platforms focus on invoice processing and payments. Some suites cover both, and general BI tools like Power BI, Tableau, and Looker sit on top of any of them for custom reporting. Before you shortlist, confirm the tool syncs in real time with your ERP, because a dashboard fed by a nightly batch is not a real-time dashboard. Also check that it defines each KPI transparently, so finance and operations are reading the same number the same way.
One caution on vendor lists: this category consolidates quickly. Airbase, which used to appear on every AP/AR analytics roundup, was acquired by Paylocity in 2024 and folded into a broader HR and payroll platform. Always verify a vendor’s current ownership and product focus before you commit.
| Platform | Focus | Strength | Watch for |
|---|---|---|---|
| HighRadius | AR + cash forecasting | AI cash application and predictive DSO | Enterprise scale and price |
| Versapay | Collaborative AR | Customer-facing collections portal | Lighter on the AP side |
| BlackLine | AR + financial close | Cash application tied to the close | Broad suite, longer rollout |
| Tipalti | AP automation | Cycle-time and cost-per-invoice metrics | AP-centric, pair for AR |
| BILL | AP + AR for SMB | Both sides in one tool, simple dashboards | Less depth for large enterprises |
| Coupa | Spend + AP | Unified procurement, AP, and expense views | Broad platform commitment |
Pitfalls to avoid
The most common mistake is tracking vanity metrics that look good without moving cash. A wall of 20 charts just becomes noise that everyone learns to ignore. Pick the handful that drive decisions and cut the rest. The second mistake is optimizing one metric at the expense of the system: pushing DPO ever higher while your discount capture collapses, or lowering DSO by tightening credit so far that sales suffer. The third is trusting a number whose formula nobody agreed on, which is how two teams end up citing two different DSOs in the same meeting. Define each KPI once, in writing, and make the dashboard show that definition.
Frequently asked questions
Which KPIs should a small finance team start with? DSO, DPO, and the cash conversion cycle. Those three cover how fast you collect, how long you hold cash, and the net effect. Add Discount Capture Rate and Cost per Invoice once the basics are in place.
What is a good DSO? It depends on your payment terms and industry, so compare DSO to your own terms rather than a universal number. A DSO close to your best possible DSO, meaning low Average Days Delinquent, matters more than any single target figure.
Can our ERP show these without extra software? Most ERPs report DSO and DPO, but they are often weaker at real-time collections dashboards, cash application, and forecasting. Dedicated AP/AR platforms or a BI layer on top of the ERP usually give finance teams a clearer, faster view.
How often should these dashboards update? As close to real time as your data allows. The value of these metrics is acting before month-end, so a nightly sync is a floor and continuous updates are better.
Is a negative cash conversion cycle good? It can be excellent. It means you collect from customers before you pay suppliers, so operations effectively fund themselves. It is common for businesses with strong buyer leverage and fast inventory turns, though not realistic for every model.
The verdict
Cash health comes down to a short list of metrics, read together and kept current. DSO, DPO, and the cash conversion cycle are the core, with CEI, Average Days Delinquent, Discount Capture Rate, and Cost per Invoice adding the detail that shows why a number is moving. Put them on dashboards that sync in real time with your ERP, agree on the formulas so everyone reads the same number, and resist the urge to optimize one metric at the cost of the whole system. Whether you build on a dedicated AP/AR platform like HighRadius, Versapay, Tipalti, or BILL, or layer BI tools over your ERP, the goal is the same: see the cash picture early enough to act on it.