A medical practice can have a busy schedule and substantial accounts receivable without having enough cash available for the next payroll. The missing information is often timing: which outstanding balances are likely to become usable bank deposits before payments must leave the account?
Predictive analytics for collection timing uses historical payment patterns to estimate when expected receipts will arrive. It does not require a complex AI system. A well-maintained worksheet can provide a useful starting point if its assumptions reflect the practice’s actual collection history.
The owner’s decision is specific: Can expected collections support provider and administrative payroll, vendor payments, and proposed discretionary spending by their payment dates? Answering that question requires separating activity from cash, building a collection-lag schedule, and checking predictions against actual deposits.
Separate Service Activity, Revenue, and Cash Receipts
These measures answer different questions and should not be used interchangeably.
| Measure | What it tells the owner | Why it is not a receipt prediction |
|---|---|---|
| Service activity | Services performed and associated charges | Charges may be adjusted, denied, or collected much later |
| Recognized revenue | Revenue recorded under the practice’s accounting method | Under accrual accounting, revenue can precede collection; cash-basis reporting differs |
| Cash receipts | Money received from payers and patients | Receipt posting and bank availability may occur on different dates |
For payment decisions, use a consistent definition of receipt timing. If payroll depends on bank funds, predict when deposits will be available in the relevant bank account—not simply when a remittance appears in the billing system.
Also separate timing from collectibility. An outstanding charge is not automatically an expected collection. Start with a reasonable estimate of collectible dollars after applicable adjustments and known collection issues, then estimate when those dollars may arrive.
This is a receipt-timing exercise, not a complete revenue forecast. It does not need to predict future visits, provider productivity, or the practice’s entire expense base.
Build an Aggregate Collection-Lag Schedule
Choose a consistent starting point
A collection lag measures elapsed time between a defined event and receipt. For payer collections, an accepted claim submission can be a useful starting point when that information is available. For patient balances, the first statement or another consistently recorded billing event may be more useful.
Do not combine different starting points without labeling them. A service-to-deposit lag includes claim preparation time; a submission-to-deposit lag does not. Both can be useful, but they answer different questions.
Use the same date convention when applying the schedule to current balances. If submission dates are unavailable and the practice uses service dates instead, document that choice and include the associated billing delay in the history.
Use approved financial data without patient identifiers
Have authorized staff prepare aggregate data within the practice’s approved environment. The planning worksheet generally needs categories, dates, balances, and receipt totals—not patient names, birth dates, diagnoses, or individual account details.
Useful fields include:
- Payer category or payer group.
- Submission or statement week.
- Estimated collectible amount for that weekly group, or cohort.
- Dollars received in each subsequent week.
- Remaining collectible balance.
- Entity, deposit account, and location where financially relevant.
Grouping records does not automatically make every dataset non-identifiable. Avoid small groups or combinations of fields that could reveal an individual. Keep detailed reconciliation work in approved systems and share only the approved financial summary.
HHS guidance on minimum necessary information provides context for limiting access and use where applicable. Do not place patient-identifiable information into ordinary Slack messages or general-purpose AI tools.
Group receipts by meaningful payment behavior
Begin with categories such as Medicare, commercial payers, and patient balances, then split categories only when differences justify the added work. Two commercial payers with consistently different payment patterns may need separate schedules.
Use enough completed historical cohorts to observe both prompt and slower receipts. Recent cohorts alone can create an overly optimistic picture because their late payments have not yet arrived. Keep unresolved or unusually old balances visible rather than excluding them silently.
Turn Historical Collections Into Timing Weights
For each category, group historical receipts by elapsed week after the chosen starting event. Divide receipts in each lag bucket by total receipts for the sufficiently mature cohorts being analyzed. This produces a timing distribution for collected dollars; it does not establish what percentage of gross charges will be collected.
Illustrative example only: A practice estimates that a newly accepted commercial-payer cohort will produce $40,000 in collectible receipts. Its historical timing schedule is:
| Elapsed time after accepted submission | Share of expected receipts | Receipt allocation for this illustrative cohort |
|---|---|---|
| Week 1 | 20% | $8,000 |
| Week 2 | 40% | $16,000 |
| Week 3 | 25% | $10,000 |
| Week 4 | 10% | $4,000 |
| Week 5 or later | 5% | $2,000 |
| Total | 100% | $40,000 |
These percentages are invented for explanation, not payer benchmarks. A practice should calculate its own weights.
The later bucket matters. Do not force every expected dollar into the next few weeks just to make the worksheet balance. Keep receipts beyond the planning window separate.
Age existing balances before allocating them
An existing balance should not restart at Week 1 each time the worksheet is refreshed. First subtract receipts already collected. Then apply a remaining timing pattern appropriate to that cohort’s current age.
For example, a cohort already several weeks old needs a different remaining-payment estimate from a newly accepted cohort. Review delayed or denied balances separately; do not automatically redistribute them across the next few weeks as though collection were certain.
Keep newly submitted cohorts, older outstanding balances, and anticipated future submissions separate. That prevents double-counting and makes clear which predictions depend on activity that has not happened yet.
Create a Weekly Expected-Receipts Worksheet
Set a reporting cutoff and list the next several payment weeks. Apply the category-specific timing schedules to eligible cohorts, then add the results by expected deposit week.
Include three timing scenarios:
- Base: Current best estimate using recent, representative collection patterns.
- Slower: More receipts arrive after the relevant payment deadline or outside the worksheet window.
- Faster: More receipts arrive earlier, supported by observed payment behavior.
These are planning scenarios, not statistical confidence intervals unless a qualified analysis has established that interpretation. A slower scenario should not assume uncollected dollars disappear permanently unless collectibility has also changed.
Illustrative example only: The following worksheet combines multiple cohorts. Its values are separate from the single-cohort example above. All amounts are in dollars.
| Expected deposit week | Commercial: base | Medicare: base | Patient balances: base | Total: base | Slower timing total | Faster timing total |
|---|---|---|---|---|---|---|
| Week 1 | $24,000 | $12,000 | $4,000 | $40,000 | $31,000 | $46,000 |
| Week 2 | $28,000 | $14,000 | $5,000 | $47,000 | $38,000 | $53,000 |
| Week 3 | $25,000 | $13,000 | $4,000 | $42,000 | $36,000 | $48,000 |
| Week 4 | $22,000 | $12,000 | $4,000 | $38,000 | $33,000 | $43,000 |
| Four-week total | $99,000 | $51,000 | $17,000 | $167,000 | $138,000 | $190,000 |
In this illustration, differences across the four-week totals represent receipts moving into or out of the planning window. Each scenario should reconcile to its underlying cohort schedule, including receipts expected after Week 4.
Add working columns for actual deposits, variance, explanation, and the date assumptions were updated. Keep the original prediction so later edits do not erase the basis for comparison.
Use Receipt Timing to Make Payment Decisions
Compare expected deposits with the dates funds must actually be available. A weekly total can conceal a payroll problem if the deposits are expected on Friday but payroll funding is required earlier.
A simple decision calculation is:
Available opening cash + receipts expected before the funding deadline − committed payments before that deadline = remaining cash before optional spending.
Exclude restricted or otherwise unavailable funds. For multi-entity practices, calculate availability in the entity and account responsible for payment. Cash deposited into another entity’s account is not automatically available to fund payroll elsewhere.
Illustrative example only: A practice has $20,000 in available opening cash, expects $31,000 under its slower timing scenario before a payroll funding deadline, and has $45,000 of committed payments due by then. That leaves $6,000 before an operating cushion or optional spending. A proposed $9,000 equipment purchase would not fit that scenario without another funding arrangement.
Use that result to defer discretionary spending or discuss a permitted change in vendor payment timing. Do not treat predicted receipts as cash already in the bank, or use them as a reason to miss payroll or contractual obligations.
sbb-itb-17e8ec9
Where Lucid Financials Fits
Lucid Financials provides CPA-led bookkeeping, tax, and CFO services for staffed U.S. private medical practices, combining AI-assisted financial work with a human finance and CPA team.
Clean books, catch-up bookkeeping, and location- and entity-level financial visibility provide a stronger foundation for receipt-timing analysis. Owners can discuss collection assumptions and payment decisions with their finance team, including through Slack using approved, non-patient-identifiable financial summaries.
The distinction matters: bookkeeping establishes what has happened, while a collection-timing worksheet estimates what may happen next. Neither should be mistaken for a guarantee of payer payment.
Compare Predicted Receipts With Actual Deposits
After each week closes, reconcile actual deposits before judging the prediction. The IRS business-recordkeeping guidance in Publication 583 supports maintaining complete business records and reconciling bank records.
Exclude transfers between practice accounts, loan proceeds, and owner contributions from collection receipts. Identify refunds, reversals, and other adjustments consistently so they do not create misleading comparisons.
Use actual receipts minus predicted receipts as the signed dollar variance. Review it by category and cumulatively, not just as one practice-wide number.
| Pattern in actual results | Possible explanation to investigate | Appropriate response |
|---|---|---|
| One week below prediction, followed by a catch-up week | Deposit cutoff, holiday, or batch timing | Check dates before changing the underlying schedule |
| Repeated shortfalls for one payer | Slower processing, submission issues, or changed collection expectations | Review that category and revise its remaining timing assumptions |
| Patient receipts repeatedly arrive later | Statement timing or payment-plan behavior differs from the estimate | Rebuild the patient-balance schedule separately |
| Bank deposits differ from posted receipts | Posting lag, adjustments, or reconciliation differences | Resolve the data mismatch before recalibrating |
Do not allow faster receipts from one payer to hide deterioration in another. Likewise, a timing delay is not automatically a permanent revenue loss.
Revise Assumptions When Payment Behavior Changes
When actual receipts repeatedly miss the estimate, determine whether the cause is a data problem, a temporary timing event, or a sustained change in payer behavior. Review recent cohorts alongside older ones rather than replacing the schedule after a single unusual week.
Document any change: the affected category, evidence reviewed, old and new assumptions, and effective date. If evidence is thin, widen the planning range instead of claiming greater precision.
For multi-location practices, split schedules where submission processes or payer mix materially differ. Avoid creating separate models for every location when the underlying receipt behavior is effectively the same.
The useful output is not a precise-looking number. It is a defensible estimate of which receipts are likely to be available before specific payment deadlines, with enough uncertainty visible for the owner to decide what can proceed and what should wait.