Outgrace, home
Capital & FinanceHow-to guide

Building a lender-ready cash conversion analysis for a clinic group

Lenders want to see how long a clinic group waits for cash, payer by payer. Here is how to build that picture from billing data and present it the way a credit officer reads it.

A clinic group that cannot say how long its money takes to arrive will be asked by a lender, sooner or later. The question is harder for groups that bill Medicare and Medicaid alongside commercial insurers and self-pay patients, because each payer runs on its own clock and its own rules. The cash conversion cycle brings those clocks into one figure: the number of days between paying for care and getting cash back in. This guide shows how to build that figure from billing and payer data and set it out the way a credit officer reads it. The public sources we reviewed do not supply clinic benchmarks, so every benchmark must come from your own ledger or from your lender.

Before you start

Three things must be settled before anyone opens a spreadsheet. The first is the definition. The standard credit formula is not in the public sources we reviewed, so the definition used here is our working one: the days between paying for care and suppliers and receiving cash from payers and patients, adjusted for when the group pays its own bills. Lenders will not accept a number whose formula the borrower has not written down. The second is the accounting basis. The International Accounting Standards Board issued IFRS 15 in May 2014. According to the IFRS Foundation's summary of the standard, it sets out the principles for reporting revenue and the cash flows that come from customer contracts. Those principles took effect for annual periods beginning on or after 1 January 2018. A group that reports under IFRS must have its revenue timing fit that standard. A group that reports under another framework should ask its accountant how the same questions are answered there. The third is ownership. Someone inside the group must own the billing extract and be able to explain it.

Before the work starts, also collect the following:

  • A one-page written definition of the cycle, signed off by the finance lead.
  • At least twelve months of billing and cash data, so that seasonal swings show up in the analysis.
  • A reconciliation between the billing system and the general ledger for the same period.
  • The payment terms of each major payer, read from the contract rather than recalled from memory.
  1. Step 1

    Pull billing data by payer and date of service

    Export every claim and self-pay invoice for at least twelve months, tagged with payer, date of service and date of posting. Medicare, Medicaid, commercial plans and self-pay patients each need their own rows. What usually goes wrong is a single insurance category that hides a slow payer behind a fast one, and a monthly total that cannot answer the lender's first question.

  2. Step 2

    Age receivables by payer class

    Age every open balance from its date of service, separately for each payer class. Check the total against the general ledger receivable on the same date and record any gap instead of absorbing it. The gap is often unposted payments or credits sitting in a suspense account, and a lender will find it if you do not.

  3. Step 3

    Measure days to cash, not days to bill

    For each payer class, work out the average number of days between the date of service and the date cash arrives, weighted by value. Days to bill and days to pay are different measures, and lenders care about the second. A group that bills quickly but waits a long time to be paid will look sound on a billing report and weak on a cash report.

  4. Step 4

    Separate denials and write-offs

    Pull denied claims, appeals and write-offs out of the receivable and show them as their own line. Without this, a slow collection and a lost claim look identical. The reader will then ask how much of the receivable is expected to come in at all, and that answer needs its own figure, drawn from the group's own collection history.

  5. Step 5

    Add the payables side

    Work out how long the group takes to pay its suppliers, including drugs, implants and consumables bought on credit, and how long its other trade creditors take. Subtract that from the receivable days to reach the net cycle. Groups often miss that a supplier paid in weeks against a payer paid in months is a funding gap, not a rounding error.

  6. Step 6

    Model the payer mix

    Build at least two scenarios: the current payer mix, and one in which the share of slower-paying patients rises. In our experience, a sensible scenario ties each billed code to a rate you can cite from the payer's own fee schedule or contract, and names that source. CMS says states are preparing for new Community Engagement requirements and that it is offering them help. The page does not say how that will change coverage, so the size of any coverage loss is your judgement, and the lender should

  7. Step 7

    Stress the cycle against a slow payer

    Lengthen the days to cash for the largest payer by a set amount and recompute the funding need. Choose that amount from the group's own worst quarter, not from a guess. State the extra cash required in currency, because a lender will reason in currency, and show whether the group could fund it without breaching any term in its existing facilities.

  8. Step 8

    Package the analysis the way a credit officer reads it

    Put the definition on the first page, the formula second, and the ledger reconciliation third. Attach the payer payment terms and the source extracts, not a single summary number. Have counsel read the covenant definitions in the credit agreement before the cycle is quoted against any covenant, because a term defined loosely in a deck may be defined tightly in the contract.

Where groups go wrong

The commonest error is a single blended number. A group with Medicare, Medicaid, commercial and self-pay balances has four different cash stories, and an average hides the one a lender is most likely to ask about. Show the blend only as a summary line, with the payer classes beneath it. A second error is treating the billing report as the cash report. Billing shows what was sent; the ledger shows what came in. Lenders reconcile the two, and the group should do so first.

The third error is quoting benchmarks without a source. The sources we reviewed give no figures for days in receivables, collection rates, denial rates or payer mix for clinic groups, and they give no lender covenant terms for them either. Any benchmark in a deck must come from the group's own history, from the lender, or from a named dataset the group can produce on request. If the group cannot name one, it should leave the benchmark out and say so.

The fourth error is assuming the regulatory picture is settled. Lenders' risk teams will expect the group to know how its banking partner is supervised. The Federal Reserve's notice dated 13 November 2026 says the agencies extended the comment period on proposed third-party risk management guidance. In our experience, lenders' risk teams ask about outside vendors that hold customer data, and a clinic's billing vendor is one such vendor. Have the answer on who holds the data, where, and under what contract before the meeting. The OCC's website also lists a page on how guarantor support is treated in credit risk ratings. The extract we hold shows only its title, so read the page itself before assuming a personal guarantee will help the rating.

IFRS 15 establishes the principles that an entity applies when reporting information about the nature, amount, timing and uncertainty of revenue and cash flows from a contract with a customer.

IFRS Foundation, IFRS 15 standard summary, ifrs.org
Why not use one average figure for days to pay?

Because the average hides the payer that matters most. A blend of fast and slow payers can look healthy while one book is slipping. Keep the payer classes separate in the workbook and show the blend only as a summary line.

Which accounting rules should the analysis follow?

If the group reports under IFRS, its revenue timing has to fit IFRS 15. If it reports under another framework, ask the accountant how the same questions are answered there. Do not assume the two match.

Does a mid-year change to a payer contract break the analysis?

It changes the days to cash for that payer from the date of the change. Split the period at that date, rerun the ageing on each side, and note the change on the definitions page, so the lender sees it rather than finding it.

Will faster payment rails shorten a slow cycle?

Not by themselves. The Federal Reserve describes FedNow as an instant payments service it built, but a slow payer stays slow whatever rail it uses. Ask the bank what it charges for payment services, and note that the Federal Reserve announced pricing for services to banks and credit unions effective 1 January 2027. Put any resulting cost change into the forecast.

Do we need a lawyer or an accountant for this?

Yes, for the parts that are legal or financial commitments. Counsel should read the covenant definitions and payer contracts, and the accountant should confirm the accounting basis. The analysis is a management tool, and both should check it before a lender relies on it.

This week, do three things. Export twelve months of claims tagged by payer and date of service, and reconcile the total to the ledger. Write the one-page definition and get the finance lead to sign it. Then ask the group's bank and its largest payer for the payment terms in writing, and put those answers at the front of the first draft. Lenders are likely to ask for all three, and having them ready helps.

Newsletter

The Briefing

One email a week: the leaders we profiled, the ideas worth stealing, and nothing else.

Weekly, free, one click to leave. Read our privacy policy.