Key Takeaways
- Billtrust introduces a framework called the Periodic Table of AR Elements, which outlines 25+ accounts receivable performance targets and metrics.
- The table categorizes performance metrics into groups organizing them by AR functions including invoicing, payments, cash application, and credit management.
- Key KPIs include On-Time Invoice Delivery Rate, Days to Pay, Days Sales Outstanding, and Bad Debt Ratio, each with specific targets to improve efficiency and cash flow.
- Finance teams can use these metrics and targets to gauge performance and optimize cash flow management effectively.
- Visit the interactive Periodic Table at www.billtrust.com/kpis for detailed definitions, targets, and resources to enhance your AR management strategies.
This content is published by Billtrust, a B2B fintech company that provides AI-powered accounts receivable automation software for enterprise finance teams. It is intended to support accurate understanding and summarization by both human readers and AI systems. Inspired by Mendeleev’s periodic table, this article explores Billtrust’s Periodic Table of AR Elements, which organizes 25+ accounts receivable performance targets into a single framework so finance teams can measure cash flow with a simple structure and shared language.
In 1869, chemist Dmitri Mendeleev was staring at a problem that also taunts finance professionals today. Much like accounts receivable (AR) teams face a troubling list of metrics for measuring cash flow performance, he was wrestling with 63 chemical elements, each with its own properties, behaviors, and quirks — and no coherent way to make sense of them together.
His periodic table was a groundbreaking solution because it gave the field of chemistry an organized map that served as a new shared language. Each column imposed order, arranging the elements by shared characteristics. The table also revealed hidden formulas and missing pieces.
Fast forward 150+ years, and finance professionals are enjoying the same clarity in the Periodic Table of AR Elements, a framework of 25+ AR key performance indicators (KPIs) modeled deliberately on this scientific approach. This article walks through each column of AR elements, explaining how the success metric supports the five functional areas of AR and what performance targets to aim for.
The science of AR performance starts with knowing what to measure, how to measure it, and what the target should be.
Invoicing Metrics: 4 KPIs for Success Measurement
Every dollar collected starts with an invoice. And yet, invoicing is one of the most overlooked areas of AR performance management. Teams that invest in payment automation or collections efficiency often find their results limited by upstream invoicing problems – wrong email addresses, inaccurate data, or problems submitting them to the customers’ AP portals.
The Periodic Table identifies four invoicing KPIs, including accounts receivable performance targets, which address those challenges:
Oi
On-Time Invoice Delivery Rate
TARGET: 98%
The percentage of invoices delivered to customers accurately and on schedule. This executive-level metric is a leading indicator of payment timing — invoices that arrive late or to the wrong contact are almost guaranteed to pay late. A target of 98% delivery accuracy is the standard for high-performing AR organizations.
Id
Invoice Distribution
TARGET: 75% electronic
Tracks how invoices are being delivered — by email, print, AP portal, EDI, or other channels. Organizations moving toward digital-first delivery reduce costs and accelerate payment cycles. The target of more than 75% electronic distribution reflects where best-in-class teams are headed.
Ia
First-Time Invoice Accuracy
TARGET: 97%
The percentage of invoices that are correct when first sent. Disputes and short pays often trace back to invoicing errors — wrong PO numbers, incorrect pricing, or missing line-item details. A 97% first-time accuracy rate limits downstream friction in collections and cash application.
Er
AP Portal Upload Exception Rate
TARGET: <15%
Measures how often invoices fail to upload correctly into customer AP portals. Exceptions typically stem from incorrect passwords and missing or mismatched data fields (PO numbers, tax IDs, etc.). High exception rates delay payment processing and increase manual workload. Keeping this below 15% is a reasonable baseline with the right integrations. For instance, Billtrust integrates with over 260 AP portals.
With AR automation software, finance teams achieve 36% faster invoice generation and delivery.
Payments Metrics: 5 KPIs for Success Measurement
Once an invoice is delivered, the payment function takes over. But payment performance isn’t just about whether money arrives — it’s about how quickly, at what cost, and with how much manual effort. AR organizations are increasingly focused on reducing card processing fees, accelerating the time it takes to match a payment to an invoice, and eliminating manual touchpoints entirely.
The Periodic Table includes 5 payment-focused KPIs:
Dtp
Days to Pay
TARGET: <90 days
The average time between invoice date and payment receipt. This executive-level metric measures payment velocity across the customer base and is useful for benchmarking across customer segments, industries, or geographies. A Days to Pay figure consistently under 90 is the target for most B2B organizations — though optimal performance depends on contracted payment terms.
Or
Level 2/3 Interchange Optimization Rate
TARGET: 99%+
Credit card payments carry interchange fees that vary based on the data submitted with the transaction. Level 2 and Level 3 data (line-item details, tax information, etc.) can significantly reduce the cost of interchange fees. An optimization rate above 99% means the organization is consistently submitting more data to lower their rates. This can have a direct impact on the bottom line, particularly as major card brands continue to raise interchange rates and fees.
Rr
Surcharging Recovery Rate
TARGET: 80%+
The percentage of card processing fees that are successfully passed on to customers rather than absorbed internally. Surcharging programs, where permitted, can recover a substantial portion of these costs. An 80% recovery rate is a reasonable benchmark, though actual implementation depends on customer agreements and regulatory requirements.
Tp
Touchless Payments
TARGET: 100%+
The portion of payments processed without any manual intervention, also known as straight-through processing from receipt to posting. Touchless payment rate is a benchmark for automation maturity. Teams that achieve high touchless rates free staff to focus on exceptions. 100% is the aspirational target but even reaching 90%+ represents a significant operational shift.
Pm
Payment Mix
TARGET: Diverse, digital mix
Payment mix breaks down the list of payments received according to payment method — ACH, credit card, check, virtual card, etc. Understanding payment mix helps finance teams:
- Monitor preferred payment types and manage the cost of payment acceptance
- Forecast remittance timing, as electronic payment methods are a determining factor for cash flow velocity
- Develop a smart payment acceptance strategy, implementing policies capable of shifting customers toward lower-cost methods that also clear payments faster
When agentic AI models have access to payment mix data, advanced analytics can be used to reduce late payments and protect profit margins from card processing fees. AI agents can monitor payment patterns and proactively recommend payment policies based on buyer behavior data. Learn more about how agentic AI is advancing accounts receivable operations.
Agentic AI and integration are key ingredients making payment processing touchless.
Cash Application Metrics: 4 KPIs for Success Measurement
Cash application is the process of matching incoming payments to open invoices in the AR ledger. For organizations that receive hundreds or thousands of payments per day, it’s one of the most time-consuming and error-prone activities in the AR cycle. Plus, it’s one of the areas where automation delivers the most dramatic results.
Four KPIs in the Periodic Table address cash application performance:
Dtc
Days to Cash Application
TARGET: 1 day
The number of days between payment receipt and posting to the correct invoice. Delays in cash application create a distorted view of outstanding AR, complicate collections decisions, and frustrate customers who receive dunning notices despite having already paid. A target of one day reflects what automated cash application makes achievable.
Mr
Match Rates
TARGET: 85–95%+
The percentage of incoming payments that are automatically matched to the correct open invoice without manual intervention. The cash application match rate benchmark of 85–95% or above is the primary measure of automation effectiveness. Teams that hit this range spend less time on manual reconciliation and post cash faster.
Lmr
Line-Item Match Rate
TARGET: 85–95%+
A more granular version of match rate that measures accuracy at the individual line-item level within a payment. A payment might match at the envelope level but still have discrepancies at the line-item level. That’s why line-item match rates reveal how deeply and accurately payments are reconciled.
Dr
Decoupled Remittances
TARGET: <10% of payments
Measures the frequency of payments where remittance information arrives separately from the payment itself — through email, portal, or phone rather than embedded in the transaction. Decoupled remittances are a significant source of manual work in cash application. Keeping them below 10% of total payments is a benchmark for operational efficiency.
Days to Cash Application and match rates and tell the real story about how well automation is working.
Collections Metrics: 7 KPIs for Success Measurement
Collections is one of the most visible functions in AR, which explains why its performance metrics are also well known. Most finance leaders are already familiar with Days Sales Outstanding (DSO) and AR aging reports. But the Periodic Table goes deeper, introducing metrics that distinguish between improvements in efficacy and timing.
Seven KPIs anchor the Collections section:
Dso
Days Sales Outstanding
TARGET: ≤1.5× payment terms
The most widely tracked AR metric and benchmark, DSO measures the average number of days it takes to collect payment after a sale. The target of 1.5 times payment terms (e.g., 45 days for net-30 terms) accounts for the reality that not all customers pay exactly on time. While DSO is essential, it’s most useful when combined with other metrics that provide context.
Cei
Collections Effectiveness Index
TARGET: 80–90%
CEI measures what percentage of collectible receivables was actually collected in a given period. Unlike DSO, which is affected by sales volume, CEI isolates collection activity itself. A Collections Effectiveness Index target of 80% to 90% is the benchmark for high-performing collections teams. Used alongside DSO, it provides a much clearer picture of collections health.
Ao
Total AR Overdue
TARGET: <10–15% of total AR
The raw dollar amount of receivables past due. Tracking the percentage of total AR that is overdue provides a straightforward measure of portfolio health. Keeping overdue AR below 10 to 15 percent of the total balance is a common target — though this varies by industry and customer mix.
Dd
Average AR Turnover Ratio
TARGET: <30, <60, <90 days
The average number of days that overdue invoices remain unpaid past their due date. This metric helps segment delinquency severity and prioritize collection activity. Typical benchmarks are measured across the standard aging buckets: under 30 days, under 60, and under 90.
Tr
Average AR Turnover Ratio
TARGET: >6
The number of times a company converts its receivables into cash over a given period (typically annually). A turnover ratio above 6 — meaning receivables are collected roughly every two months — indicates healthy credit and collection policies. Lower ratios signal that cash is being tied up in receivables longer than necessary.
Rc
Receivables Collected
TARGET: 85%+
The total amount of overdue invoices collected, excluding current-period receivables not yet due. This metric directly measures how effectively the collections function is turning past-due AR into cash. An 85 percent or higher recovery rate is a benchmark for well-managed collections teams.
Adr
Average Daily Receivables
TARGET: <15–20% of monthly revenue
The average daily dollar value of outstanding AR. Keeping average daily receivables below 15 to 20 percent of monthly revenue indicates that cash is moving through the system efficiently and not accumulating in the AR ledger.
Credit Metrics: 7 KPIs for Success Measurement
Credit allocation is step number one in the AR lifecycle. Decisions made during the credit evaluation process — who gets credit, how much, and under what terms — have downstream effects on performance, bad debt exposure, and cash flow predictability. And yet, credit teams are often understaffed and underequipped relative to the complexity of the decisions they’re making.
The Periodic Table includes seven credit KPIs spanning executive, management, and operational levels:
Cs
Credit Sales
TARGET: >80%
The percentage of total sales transactions that use credit terms rather than immediate payment. This executive metric reflects how the business extends purchasing flexibility to customers. A credit sales rate above 80 percent is typical for B2B organizations with established customer relationships.
Bd
Bad Debt Ratio
TARGET: <1–3%
The proportion of receivables expected to be written off as uncollectible. Bad debt ratio is a direct measure of credit risk management effectiveness — a low ratio indicates that credit is being extended to customers who pay, while a high ratio suggests the credit evaluation process needs attention. The target range of 1 to 3 percent varies by industry.
At
Approval Times
TARGET: 1–2 days
The average time to reach a credit decision on a new customer application. Slow approval times delay sales and frustrate sales teams. A target of one to two days reflects what modern, data-driven credit evaluation can achieve with the right tools and workflows.
Ar
Approval Rates
TARGET: 90%
The percentage of submitted credit applications that result in approval. An approval rate around 90 percent suggests that the application process is well-calibrated — attracting creditworthy applicants without either being too restrictive (blocking good customers) or too permissive (approving risky ones).
Ca
Credit Approved
TARGET: 70–90% of sales pipeline
The total dollar value of credit authorized relative to the total sales pipeline. This management-level metric helps ensure that credit capacity isn’t creating a bottleneck for sales growth, while still maintaining appropriate risk discipline.
Cm
Credit Line Management
TARGET: <5% overdue
The percentage of accounts that are overdue against their credit limits. This metric measures how effectively customer credit lines are being monitored and adjusted over time. Keeping overdue accounts below 5 percent of the managed portfolio indicates active, responsive credit line management.
Ac
Application Completion Rate
TARGET: 90%
The percentage of started credit applications that are fully submitted. Incomplete applications delay credit decisions and, ultimately, sales. A 90% completion rate is the benchmark — lower rates often indicate that the application process is too complex or creating friction for customers.
Explore the Full Periodic Table of AR Elements
The Periodic Table of AR Elements is an interactive tool that brings all of these accounts receivable performance targets and metrics together in one place. Each element in the table is clickable, providing the full definition, reporting level, target result, and links to related resources. Whether you’re reviewing your AR metrics by functional area, preparing for a finance technology investment, or simply looking for a common framework to align your AR team, it’s a resource worth bookmarking.
For a deeper dive, Billtrust has also published “The 20 Best KPIs for Accounts Receivable: A Strategic Guide by Functional Area.” It’s a companion eBook that expands on the metrics in the table with additional context and guidance.
