Blog · Finance metrics and formulas · Finance and FP&A teams
The accounts receivable to working capital ratio compares net trade receivables with current assets minus current liabilities. Work it from balance-sheet rows, check collections and liability changes separately, and handle zero or negative working capital.
The accounts receivable to working capital ratio divides net trade receivables by current assets minus current liabilities. It compares customer balances awaiting collection with the company's net current-asset cushion at one date. A high result asks for a closer look at collections and current obligations; it does not by itself establish that customers are late.
Net working capital = Current assets − Current liabilities
Accounts receivable to working capital ratio = Net trade receivables / Net working capital
Multiply the quotient by 100 to display a percentage, or format the spreadsheet cell as a percentage. Use balances from the same entity, reporting date and currency.
The SEC's financial-statement guide defines working capital as current assets minus current liabilities. This article uses that broad balance-sheet definition, including cash and current borrowing. It does not use operating working capital, which may exclude both.
For the numerator, take customer trade receivables after the allowance for credit losses. Leave out employee loans, tax refunds and other nontrade amounts. Regulation S-X's balance-sheet presentation rules distinguish trade receivables from other receivable categories and require separate presentation of the allowance for doubtful accounts. Preserve those distinctions in the export mapping.
Do not confuse this with accounts receivable turnover, which compares credit sales with average receivables over a period. This ratio has no sales denominator and no day count. The general working capital guide covers the underlying current-asset and current-liability arithmetic.
Bring a balance-sheet workbook with account code, description, entity, closing date, currency and balance. Add the receivables aging report and allowance reconciliation for the same date. The balance sheet supplies the denominator; the supporting reports explain the quality and movement of the numerator.
Map every balance once. The receivables numerator must also be included once within current assets. Avoid adding the aging total to a balance-sheet export that already contains the receivables control account.
This illustrative US wholesaler reports the following balances at September 30, 2026. All amounts are USD, and the company has no other current accounts.
| Export row | Balance (USD) | Treatment |
|---|---|---|
| Cash | 300,000 | Current asset |
| Gross trade receivables | 920,000 | Current asset before allowance |
| Receivables allowance | −20,000 | Deduction from gross receivables |
| Inventory | 800,000 | Current asset |
| Prepaid expenses | 100,000 | Current asset |
| Accounts payable | 700,000 | Current liability |
| Accrued current liabilities | 200,000 | Current liability |
| Short-term borrowing | 100,000 | Current liability |
| Current portion of term debt | 200,000 | Current liability |
The allowance is shown as a negative amount in the table. If your export carries credit balances as positive amounts, map the allowance as a deduction explicitly rather than relying on its raw sign.
| Step | Calculation | Result |
|---|---|---|
| Net receivables (USD) | 920,000 − 20,000 | 900,000 |
| Current assets (USD) | 300,000 + 900,000 + 800,000 + 100,000 | 2,100,000 |
| Current liabilities (USD) | 700,000 + 200,000 + 100,000 + 200,000 | 1,200,000 |
| Net working capital (USD) | 2,100,000 − 1,200,000 | 900,000 |
| Receivables / working capital | 900,000 / 900,000 | 100.00% |
Dollar amounts are exact; percentages are shown to two decimal places. The result says receivables equal the net working capital balance. It does not say every current asset is a receivable: cash, inventory and prepayments are also present, while current liabilities reduce the denominator.
Check the calculation in both directions. The unrounded ratio multiplied by $900,000 of working capital must reproduce $900,000 of net receivables. Adding $1,200,000 of current liabilities back to $900,000 of working capital must reproduce $2,100,000 of current assets.
Then check the source reports. Gross receivables of $920,000 must tie to the aging report and the ledger control account. Subtract the $20,000 allowance to reach the balance-sheet numerator. The current-asset and current-liability totals must match the approved balance sheet before the ratio goes into reporting.
Consider two independent variations from that baseline. In the collection case, customers pay $200,000 and the money stays in cash; no invoices, write-offs or other entries occur. In the liability case, an additional $300,000 current expense accrual increases current liabilities; receivables and current assets stay unchanged.
| Measure | Baseline | Collection case | Liability case |
|---|---|---|---|
| Cash (USD) | 300,000 | 500,000 | 300,000 |
| Gross receivables (USD) | 920,000 | 720,000 | 920,000 |
| Allowance deduction (USD) | 20,000 | 20,000 | 20,000 |
| Net receivables (USD) | 900,000 | 700,000 | 900,000 |
| Inventory (USD) | 800,000 | 800,000 | 800,000 |
| Prepaid expenses (USD) | 100,000 | 100,000 | 100,000 |
| Current assets (USD) | 2,100,000 | 2,100,000 | 2,100,000 |
| Current liabilities (USD) | 1,200,000 | 1,200,000 | 1,500,000 |
| Net working capital (USD) | 900,000 | 900,000 | 600,000 |
| Receivables / working capital | 100.00% | 77.78% | 150.00% |
Collection changes the form of current assets from receivables to cash, so net working capital remains $900,000. The ratio falls because the numerator falls. The liability case produces a higher ratio through a smaller denominator, with no deterioration in customer balances.
This is also why a result above 100% can be valid: $900,000 of receivables divided by $600,000 of net working capital is 150.00%. The cash to working capital ratio and inventory to net working capital ratio provide other views of that asset composition without measuring collection speed.
The controller owns the balance-sheet mapping and reconciliation. Credit control investigates aging and disputed invoices. Treasury evaluates whether the timing of expected receipts meets current obligations; this ratio alone cannot answer that cash question.
Upload your balance-sheet workbook and a matching receivables export, keeping entity and month labels. Covirage maps the columns, and its tools compute and check the figures; the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for finance teams for the wider finance reporting context.
Yes. Receivables are one current asset, while working capital subtracts all current liabilities from all current assets. Receivables can exceed that residual balance. A result above 100% therefore does not mean receivables exceed total assets or that the calculation is necessarily wrong.
Use net trade receivables for the balance-sheet comparison described here, after the allowance for credit losses. Gross receivables can be useful for a separate collection analysis. Label that version clearly and avoid mixing gross and net balances across entities or months.
No. Receivables might decline through collections, write-offs or lower sales, while working capital might increase for unrelated reasons. Reconcile the receivables movement and inspect the aging report before attributing a lower ratio to collection performance.
Report the ratio as undefined and show current assets, current liabilities and receivables. Do not replace it with zero. If working capital is negative, flag that condition separately because the signed result cannot be ranked meaningfully with positive-denominator results.