Tools / Time to billable

The provider starts Monday. The billing does not.

Put your own figures in and this works out what the gap between those two dates costs you.

Worksheet · every figure is yours
The cohort

Initial appointments and enrollments, not your whole roster.

Your own median. Credentialing and payer enrollment together, end to end.

The revenue

At steady state, once they are in network. Placeholder — replace it.

The window is calendar days; only the working days inside it bill.

Below 100% because cash pay, and plans they are already in, keep billing.

What comes back, what you carry

Opens at zero so we invent nothing. Some contracts bill back to the effective date — raising this lowers the result.

Zero unless you pay a guarantee or salary before they can bill.

What the delay costs you

$1,851,429

Across the 12 providers you bring on in a year.

Working days blocked, each
64
Revenue blocked, each
$154,286
Billed back, each
$0
Carried, each
$0
Net, per provider
$154,286
Each further day of delay
$20,571
The window90 calendar days

64 working days inside it.

Nothing on this worksheet models Bip. It counts your delay and stops there.

Nothing is sent anywhere. The arithmetic runs in your browser.

The arithmetic

Seven fields, and nothing behind them.

Every quantity in the result came off the form; none of it is stored out of sight.

Working days blocked
calendar days × working days per week ÷ 7
Revenue blocked
working days blocked × daily revenue × share blocked
Recovered
revenue blocked × share billed back
Carried
calendar days × daily compensation
Cost, per provider
blocked − recovered + carried
Cost, for the year
cost per provider × providers

Limits

What this worksheet cannot tell you.

A model you can argue with is worth more than one you cannot inspect.

  1. 01

    It counts a new provider’s first week like their fiftieth

    A panel fills over months. The earliest blocked days are worth less than this gives them.

  2. 02

    It is linear

    Day ninety costs what day one cost. A queue that sits, then moves in a week, does not behave that way.

  3. 03

    It does not sequence your payers

    One plan effective while four are pending is a share of revenue here, not a date on a calendar.

  4. 04

    It says nothing about what Bip would change

    That is not a figure we get to put on your worksheet.

Questions we get

About the model.

Why is there no Bip column?
Because we would be the ones choosing the number in it. Your delay is measurable from your own records; what any vendor takes off it is not, until you have run it. Putting our own figure on your worksheet would make the whole thing worth less.
Where do the starting figures come from?
They are placeholders, chosen to be round rather than representative, and they are the first thing you should replace. Enrollment windows vary by plan, state and provider type widely enough that no single starting number would be honest.
Is this measuring credentialing or payer enrollment?
Both, because billing waits on both. The window ends at the first claim you can send, not at an approval — a plan can have said yes while the effective date and the payer-assigned ID are still missing, and nothing bills in that stretch.

The number is yours. So is the next question.

Which part of that window is the file waiting on you, and which part is it waiting on a plan?

How enrollment runsNPI lookup →