Blog · Finance metrics and formulas · Healthcare
Healthcare working capital shows how current assets and liabilities support day-to-day operations. Compare receivable aging, supply inventory and supplier payables across provider units, then reconcile the movement to cash.
Healthcare working capital is current assets minus current liabilities, but the useful operating question is where cash is waiting: receivables, supplies or supplier payments. Build a unit-level schedule from reconciled finance exports, then distinguish actual cash movements from accounting adjustments. That makes the cash requirement visible without needing patient records or billing-workflow detail.
Working capital = Current assets − Current liabilities
Operating working capital for this schedule = Net service receivables + Supply inventory − Trade accounts payable
The first formula is the conventional measure in the SEC's financial statement guide. The second is a deliberately narrower management measure. It leaves out cash, debt, prepayments and accrued payroll so the team can see the balances attached to services delivered and supplies purchased. The working capital glossary gives the concise balance-sheet definition.
It is not a substitute for the balance sheet or a complete cash forecast. A provider still needs to fund payroll, capital spending and other commitments. Use the broader working capital guide for the full balance-sheet calculation; keep this schedule focused on the operating units that explain the change.
Define receivables consistently. This example uses the expected collectible carrying amount after recorded adjustments and allowances, allocated to aging bands. Do not compare that balance with another unit's unadjusted billed charges. Keep separately identified allowance movements available for the cash bridge.
Ask finance for the month-end trial balance, an aggregated receivable-aging report, the supply inventory valuation and the trade-payables report. Use unit codes that match across all four. Central balances that cannot be assigned reliably should remain in a clearly labeled corporate row.
| Export | Fields to retain | Control before analysis |
|---|---|---|
| Trial balance | Period, unit, account, closing balance | Current asset and liability accounts agree with the close |
| Receivable aging | Snapshot date, unit, age band, net balance | Aging totals agree with the receivable control account |
| Supply valuation | Snapshot date, unit, supply category, carrying value | Valuation agrees with inventory accounts |
| Trade payables | Snapshot date, unit, supplier category, amount due | Trade payable totals agree with the ledger |
Use age since the service or invoice date consistently; state which one the export uses. Age is not automatically days overdue. Contractual terms can vary, so this schedule identifies balances to investigate rather than declaring every older balance delinquent.
Keep only aggregated business figures in the analysis file. Names, contact details, treatment information and patient identifiers are unnecessary for comparing operating cash requirements.
Suppose a US provider group reports the following balances on September 30, 2026. All amounts are illustrative USD. The age bands use the same documented invoice-date basis across the group.
| Unit | 0–30 days (USD) | 31–60 days (USD) | 61–90 days (USD) | Over 90 days (USD) | Net receivables (USD) |
|---|---|---|---|---|---|
| Hospital | 1,200,000 | 450,000 | 180,000 | 170,000 | 2,000,000 |
| Clinics | 450,000 | 150,000 | 60,000 | 40,000 | 700,000 |
| Surgery center | 350,000 | 120,000 | 80,000 | 50,000 | 600,000 |
| Total | 2,000,000 | 720,000 | 320,000 | 260,000 | 3,300,000 |
With the unit in column A and the aging bands in B:E, net receivables in F2 are:
=SUM(B2:E2)
Add supply inventory in G and trade payables in H. Operating working capital in I2 is:
=F2+G2-H2
| Unit | Net receivables (USD) | Supplies (USD) | Trade payables (USD) | Operating working capital (USD) |
|---|---|---|---|---|
| Hospital | 2,000,000 | 500,000 | 700,000 | 1,800,000 |
| Clinics | 700,000 | 120,000 | 160,000 | 660,000 |
| Surgery center | 600,000 | 180,000 | 240,000 | 540,000 |
| Total | 3,300,000 | 800,000 | 1,100,000 | 3,000,000 |
For a larger export, summarize by unit and snapshot date with SUMIFS. Microsoft documents SUMIFS as adding amounts that satisfy multiple criteria. If the Aging sheet contains snapshot dates in A, units in B and net balances in D, this returns the receivable balance for the unit in A2 and date in K1:
=SUMIFS(Aging!$D$2:$D$1000,Aging!$B$2:$B$1000,$A2,Aging!$A$2:$A$1000,$K$1)
Use actual date values, numeric amounts and equally sized ranges. Covirage is not affiliated with Microsoft.
The unit calculation must equal the calculation on the totals: $3,300,000 + $800,000 − $1,100,000 = $3,000,000. In the first layout, these two formulas must return the same result:
=SUM(I2:I4)
=SUM(F2:F4)+SUM(G2:G4)-SUM(H2:H4)
Then reconcile the operating measure to conventional working capital. These are the remaining current balances in the example:
| Reconciliation item | Amount (USD) |
|---|---|
| Operating working capital above | 3,000,000 |
| Add current cash | 600,000 |
| Add prepayments | 100,000 |
| Subtract other current operating liabilities | 900,000 |
| Subtract current debt | 200,000 |
| Conventional working capital | 2,600,000 |
Current assets are $4,800,000 and current liabilities are $2,200,000. Their difference is the same $2,600,000. This prevents a manager from mistaking the narrower $3,000,000 operating measure for the total balance-sheet position.
Compare the same units at consecutive month ends:
| Balance | August 31 (USD) | September 30 (USD) | Change (USD) | Cash effect before noncash adjustments (USD) |
|---|---|---|---|---|
| Net receivables | 3,050,000 | 3,300,000 | 250,000 | −250,000 |
| Supply inventory | 760,000 | 800,000 | 40,000 | −40,000 |
| Trade payables | 1,010,000 | 1,100,000 | 90,000 | 90,000 |
| Operating working capital | 2,800,000 | 3,000,000 | 200,000 | −200,000 |
The cash bridge is −$250,000 − $40,000 + $90,000 = −$200,000. Treat this as the working-capital contribution before adjusting for write-offs, allowance changes, acquisitions, transfers or other noncash entries. It does not explain the entire bank movement.
Older receivables are $320,000 + $260,000 = $580,000, or 17.6% of total receivables, rounded to one decimal place. Finance can investigate that concentration while operations checks whether supply growth reflects planned activity or excess stock. Translate comparable balances into time only when the revenue or consumption denominator is appropriate; working capital days covers that separate calculation.
If actual collections reduce receivables by $150,000 and supply consumption exceeds replacement purchases by $50,000, with payables unchanged, operating working capital releases $200,000. That is a scenario, not a promised improvement. Procurement should assess payment terms against supplier agreements and continuity requirements before changing payment timing.
Bring a deidentified, aggregated aging file, supply valuation and payable summary from the same close. Covirage maps the columns, and its tools compute and check the balances and changes; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See Covirage for healthcare for the supporting industry context.
Revenue can be recognized before the related cash arrives, while payroll and suppliers still need payment. Growing receivables or supply inventory can absorb cash despite positive operating income. Compare the balance movements with the cash flow statement before treating earnings as cash available to spend.
Cash belongs in the conventional current-assets-minus-current-liabilities calculation when classified as current. A separate operating schedule can exclude cash and financing balances to isolate receivables, inventory and supplier payables. Label that narrower measure and show its reconciliation to the balance sheet.
A write-off reduces receivables without bringing money into the bank. It can lower the reported operating working capital balance, but it is not a collection. Separate cash receipts, allowance changes, write-offs and transfers when explaining why receivables fell.
Use a reconciled month-end schedule for management reporting and review material cash pressures more frequently. Keep the scope and aging basis consistent. Finance should own the reconciliation, while operating managers confirm supply balances and procurement confirms payable terms and disputed amounts.