Amicable collection
-
5
 min read

Collection agency performance metrics and a cohort scorecard

Compare collection agency performance using cumulative net cash recovered by day 30, 60 and 90 as a share of the balance sent to each agency. Compare placements from the same period with similar invoice age, debtor country, balance size and currency. Give each case the full observation window before you use it in that day's result.

By Lars Holdgaard, Founder & CEO of Debitura

Collection agency performance metrics and a cohort scorecard

This scorecard measures the cash outcome on balances already assigned to external providers. For the broader receivables your own team manages, see the collection effectiveness index (CEI).

Define the balance and the cash outcome

Placement balance is the original principal still open when the agency accepts the case, after payments and credits already applied. Keep that figure fixed for each placement. Record later credit notes, write-offs and withdrawals separately. Include closed and zero-recovery cases that reached the reporting age. If source data shows the opening balance itself was wrong, correct the error and keep a record of the change.

Net cash recovered is verified principal cash recovered on the placed balance, less principal refunds or reversals and the external collection fees and case costs paid or withheld by the cutoff. Include confirmed direct payments to the creditor allocated to the same case. Count underlying receipts once. A collector's payout is a reconciliation record when the underlying receipt is already included, and any withheld fee is deducted once. Credits, write-offs and promises produce no cash. Flag missing remittance or fee details so readers can distinguish provisional figures from reconciled figures.

Cumulative net recovery rate at day 30, 60 or 90 equals cumulative net cash through that day divided by the original placement balance for the same cases, multiplied by 100. Take the dates from the same accepted-placement event for both providers. Report the number of cases and the amount placed beside each rate.

Match the placements and apply the cutoff

  1. Set the matching fields. Use the same placement month or quarter, debtor country, invoice age at placement, balance size band and currency. Calculate invoice age from the due date to placement. For cases covering several invoices, use the same written rule for every agency, such as using the oldest due date within the placed balance. Match or flag materially different dispute histories and previously placed accounts where the data allows.
  2. Build an eligible set for each horizon. At the reporting cutoff, a day-60 case has had at least 60 days since placement. Sum only that set's initial balances. For each of those cases sum net cash only through its own day 60. Use the same rule for days 30 and 90. Show a dash or “pending” when no cases have reached that age.
  3. Show a fixed-group view for trends. If you want to see how the same cases progressed from day 30 to 90, use only the cases that have reached day 90 for all three columns. Report currencies separately. If you need an overall provider score, apply the same balance weights to the matched groups for both providers and disclose those weights.

Copy this scorecard

Use one row per provider, matching group and horizon. Keep the case-level data underneath so you can trace the totals.

Field Value to enter
Provider and placements Provider, placement period, debtor country, age band, starting balance band and currency
Cutoff and horizon Reporting date and 30, 60 or 90 days since placement
Eligible case count Cases with a complete observation window
Eligible placement balance Sum of initial principal for those cases
Cumulative net cash Verified principal cash minus reversals and cash collection fees and costs through the horizon
Net recovery rate and notes Net cash ÷ eligible placement balance × 100, plus any missing records or mix differences

Worked example where the denominator reverses the result

Two fictional agencies handle EUR placements for customers in France. The cases in both agencies' matured groups were placed in the same month, were 61–90 days overdue at placement and carried initial balances of EUR 2,500–7,500 per case. Agency A has 20 cases with EUR 100,000 placed. Agency B has 10 comparable cases with EUR 50,000 placed. All 30 cases have reached day 90. Agency B also has EUR 50,000 of newer placements from a later month that have yet to reach day 30.

Provider Matched placement balance Day 30 net cash and rate Day 60 net cash and rate Day 90 net cash and rate
A EUR 100,000 EUR 8,000 (8%) EUR 15,000 (15%) EUR 20,000 (20%)
B EUR 50,000 EUR 5,000 (10%) EUR 10,000 (20%) EUR 15,000 (30%)

Agency B’s day-90 net cash is EUR 17,000 in verified principal receipts minus EUR 500 in reversals and EUR 1,500 in paid or withheld fees. If you divide B's result by its entire EUR 100,000 book, it appears to recover 15% versus A's 20%. Removing the EUR 50,000 that has yet to mature raises B's comparable day-90 rate to 30%, ahead of A's 20% for this group.

Use the matched results to ask about gaps in timing or cash yield. Check how many cases their totals represent and repeat the comparison on other matched placement groups before shifting volume. If the review identifies a geography where you need a new provider, use the international collection agency comparison.

Sources

Subscription

Sign up to our newsletter

Get updated on best practices, tips and tricks about international debt collection and accounts receivable management.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.