Blog · Finance metrics and formulas · Finance and FP&A teams
Measure cash collected against a defined pool of receivables for the month. This example sets the denominator, separates credits and write-offs from cash, and reconciles customer rates to the closing balance.
A collection rate for accounts receivable measures the cash applied to a defined receivable pool during a stated period. Divide cash collected by that pool and express the result as a percentage. The denominator must be written beside the rate: otherwise two teams can report different answers from the same invoices.
For a monthly review of all customer trade receivables, use this defined method:
Receivable pool = Opening gross receivables + New credit invoices − Approved credit memos + Signed noncash adjustments
Monthly collection rate = Cash applied to the pool / Receivable pool × 100
Write-offs stay in this denominator and appear separately in the reconciliation. They represent balances removed without cash. Excluding them would make the percentage improve when management writes off invoices, even if no customer pays more.
This is a stated operational convention, not a universally prescribed accounting ratio. Another team may measure cash from an opening invoice cohort or only invoices due during the month. Those measures can be useful, but their names, populations and dates must distinguish them from this one.
The SEC's financial-statement guide distinguishes cash flows from income earned. Apply that discipline here: a recorded sale is not a collection, and a receivable reduction is not necessarily cash.
Start with the opening aging report, current credit-invoice register, credit-memo register, receipt allocations, write-off register and closing aging report. Use customer ID and invoice ID to connect the rows. Retain posting date, due date, currency, transaction ID and amount.
Cash applied should reflect receipt allocations to invoices in the pool, net of reversed applications. Exclude sales paid immediately outside these receivable accounts, refundable deposits and money still awaiting allocation. Reconcile unapplied cash separately so operations can see money received but not yet matched.
The dates need an explicit rule. This example uses receivables posting dates for the September reporting period and a September 30 cutoff for receipt applications. It measures settled invoice balances in the subledger. A treasury report based on bank value dates may differ, so explain the timing bridge rather than mixing the two.
Keep original currency and reporting currency separate. Cash settled in one currency must be compared with a pool on the same basis. Show exchange-rate effects as signed adjustments, with enough detail to distinguish them from customer payments.
A US parts distributor reviews September 2026. Opening balances are at August 31, and the company has no currency or other signed adjustments in this example. All USD amounts are hypothetical whole dollars; percentages are rounded to two decimal places after division.
| Customer | Opening gross AR (USD) | New credit invoices (USD) | Approved credits (USD) | Receivable pool (USD) | Cash applied (USD) | Collection rate |
|---|---|---|---|---|---|---|
| Atlas Supply | 100,000 | 160,000 | 10,000 | 250,000 | 200,000 | 80.00% |
| Beacon Parts | 80,000 | 120,000 | 5,000 | 195,000 | 140,000 | 71.79% |
| Cedar Industrial | 60,000 | 80,000 | 10,000 | 130,000 | 70,000 | 53.85% |
| Total | 240,000 | 360,000 | 25,000 | 575,000 | 410,000 | 71.30% |
The company pool is $240,000 + $360,000 − $25,000 = $575,000. The total rate is $410,000 / $575,000 × 100 = 71.30%.
Calculate the total from amounts, not the average of the displayed customer percentages. The unweighted average of the unrounded customer rates is 68.55%, which gives Cedar's smaller pool the same influence as Atlas's larger one. Weighting each unrounded rate by its receivable pool returns the company rate of 71.30%.
For a repeated monthly view, the accounts receivable dashboard can organize the results. Keep its denominator definition visible alongside customer comparisons.
During September, Beacon also has an approved write-off. Separate it from the cash numerator:
| Customer | Pool (USD) | Less cash (USD) | Less write-offs (USD) | Closing gross AR (USD) |
|---|---|---|---|---|
| Atlas | 250,000 | 200,000 | 0 | 50,000 |
| Beacon | 195,000 | 140,000 | 5,000 | 50,000 |
| Cedar | 130,000 | 70,000 | 0 | 60,000 |
| Total | 575,000 | 410,000 | 5,000 | 160,000 |
The proof is $575,000 = $410,000 + $5,000 + $160,000. The final amount must match the September 30 gross aging report and receivables control account. The receivable balance formula gives the complete movement reconciliation when additional transaction types exist.
OpenStax's allowance-method example shows a write-off reducing receivables and the allowance rather than recording cash. Adding Beacon's write-off to cash would produce $415,000 / $575,000 = 72.17%, an incorrect collection rate under this definition.
Removing write-offs from the denominator instead would give $410,000 / $570,000 = 71.93%. That may be reported as a separately labeled adjusted measure, but it cannot silently replace the 71.30% result. Keep the write-off visible whichever convention management approves.
Atlas collected a greater share of its monthly pool than Cedar, but that alone does not prove better collection work. Cedar may have invoiced later in the month or granted longer terms. Split remaining balances by due status before deciding which collector or account manager needs to act.
A pool containing invoices not yet due cannot be interpreted as though every dollar should already have been paid. For a due-only measure, freeze the eligible invoice list and apply credits and receipts to that same list. Do not compare a due-only percentage with the all-invoice example above.
Review the credit-memo register too. A smaller denominator can increase the rate without more cash arriving. The ledger must still show legitimate returns, pricing corrections and canceled invoices, but their separate presentation explains what actually moved the result.
Use the AR turnover ratio for the separate relationship between sales and average receivables. Use investment in accounts receivable when the question is how customer credit affects funding needs. Neither substitutes for this cash-to-pool percentage.
Bring your invoice, receipt-allocation and aging exports to Covirage; it maps the columns, and its tools compute the agreed rates and check the balance reconciliation. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own export.
See Covirage for finance teams for the surrounding reporting work.
There is no useful universal threshold without a denominator and period. A pool containing new invoices not yet due has a different expected rate from an overdue-only pool. Compare consistent cohorts, credit terms and your own prior results.
It can happen when receipts include invoices outside the denominator, opening balances are missing, or cash sales and deposits enter the numerator. For a closed, correctly reconciled invoice pool, cash cannot exceed the amount available to collect.
No. A credit memo reduces the amount a customer owes without producing cash. The method here deducts approved credits from the receivable pool and shows them separately, so cancellations and returns cannot appear as customer payments.
No. Collection rate expresses a share of a defined receivable pool converted to cash. DSO expresses receivables relative to credit sales in days. They can move differently when sales timing, customer mix or payment terms change.