ABA Practice Cash-Flow Forecast Template

Editorial approval scope: The team checked current source fidelity, scope boundaries, dates, arithmetic, reader usefulness, practical workflow, and general-information limitations.

The SBA Business Guide covers planning, finance, payroll, taxes, compliance, and growth. SBA's current financial-management guidance separates accrual and cash accounting and calls out receivables, payables, available cash, bank reconciliation, and payroll. An ABA service can be earned in one period while payer cash arrives after several payroll cycles.

Run two linked forecast horizons

Use one data model with two views. The weekly 13-week forecast drives short-term decisions and rolls forward each week. Preserve the prior version for variance review. The monthly 12-month forecast supports hiring, leases, benefit renewals, debt, capital purchases, and funding plans. Update it after each close.

Start both views with unrestricted cash that is available for forecasted obligations. Show restricted cash, undrawn credit, and funds reserved for a different purpose on separate lines. Cash reaches the forecast on the bank-available date. An electronic remittance advice (ERA) can describe adjudication, while an electronic funds transfer (EFT) orders the movement of money. CMS explains the distinction and the trace information used to associate an ERA with its EFT in its payment and remittance guidance. Reconcile both records to the deposit.

Build seven workbook tabs

Use this build-ready tab schema

Use stable row IDs so each cohort, bank debit, and variance can be traced across views.

Use weekly period keys for the 13-week view and monthly keys for the 12-month view. A separate mapping table can roll weeks into months without maintaining two versions of the same assumption.

1. Control and assumptions

Keep inputs separate from formulas. Each assumption needs a unit, scenario value, source, owner, effective date, confidence, and refresh date. Include the forecast start, bank accounts, buffer, lag curves, patient assumptions, payroll and tax calendars, financing terms, and scenario selector. Add control totals for opening cash, deposits, payments, and ending cash. Lock formulas, preserve version history, and log material changes.

2. Service volume and care-to-cash stages

Use one row for each material combination of payer product, service, provider type, location, and service-month cohort. Track units and dollars at these stages:

These labels keep an accepted claim out of deposited cash. Define every rate with a numerator, denominator, maturity window, and exclusions. Keep losses in their proper stage so each missed unit receives one reduction.

Estimate payer and patient cash separately:

expected payer cash before separately scheduled refunds = eligible units × expected payer portion per unit × payer realization rate

expected patient cash before separately scheduled refunds = valid assigned patient responsibility × patient realization rate

Derive realization rates from mature, comparable cohorts and document how adjustments, denials, appeals, refunds, credits, and write-offs enter the calculation. Choose one cash treatment for refunds and recoupments. Either use a net realization rate or reduced receipt, or schedule an explicit negative cash movement on its expected date. A known item cannot reduce the collectible estimate and appear again as an outflow. Apply the same rule to patient refunds. If the payer portion already reflects denial experience, remove any second denial haircut elsewhere.

3. Collection cohorts

Forecast receipts by the service month that created the receivable. For every payer-product cohort, calculate the share deposited in the service month, then one, two, three, and later months after service. The shares should total 100% of the expected collectible amount, rather than 100% of billed charges.

cash receipts in month t = sum(each cohort's expected collectible amount × its deposit-lag weight for month t)

Opening accounts receivable (A/R) needs its own table. Record payer, product, service period, current status, billed amount, remaining expected collectible amount, and remaining deposit curve as of the forecast date. Remove elapsed lag periods, then normalize the remaining weights to 100% of the unpaid expected collectible amount. For a 5%, 60%, 25%, 10% curve after the first 5% has arrived, use 60 ÷ 95, 25 ÷ 95, and 10 ÷ 95. Keep unrounded values in formulas; displayed weights can be 63.16%, 26.32%, and a 10.52% balancing remainder so they total 100.00%. Running old A/R through a brand-new claim's full curve delays it twice. Update the amount or timing from current claim status when that evidence is stronger than the historical curve.

Keep patient cohorts, timing, and policy separate from payer cash so teams can identify the cause of a variance.

CMS lists claim, claim-status, prior-authorization, payment, and remittance transactions separately in its adopted standards and operating rules. These standards apply to specified HIPAA covered entities and transactions and supply exchange formats. They provide no universal ABA payment-lag assumption.

4. Payroll and workforce cash

Enter workforce cash on the date each bank debit occurs. A biweekly schedule creates two pay dates in most months and three in some months, so a flat monthly average can hide a cash squeeze. Reconcile gross wages, overtime, bonuses, paid leave, training, travel, reimbursements, employer payroll taxes, benefits, retirement contributions, workers' compensation, payroll fees, and properly classified contractor payments to those debits.

Select one treatment for each payroll setup. If the payroll provider drafts one composite funding amount that includes net pay, employee tax withholding, employer taxes, and fees, forecast that debit once and retain its component breakout as memo detail. If the provider drafts net pay and tax remittances separately, forecast each exact debit on its own date. Gross wages already include amounts withheld from employee pay, so combining gross wages with a second employee-withholding outflow duplicates cash. Employer taxes are additional cash obligations, entered once through the applicable composite or separate debit.

Put employment-tax deposits and filings on their actual due dates. The 2026 IRS Publication 15 explains that federal deposit schedules depend on the applicable lookback-period tax liability, rather than payroll frequency alone, and it includes separate monthly, semiweekly, and next-day rules. State and local requirements can add other dates. Have the practice's payroll provider, CPA, or tax adviser confirm the live calendar.

5. Other cash uses and funding

List rent, insurance, software, supplies, clinical materials, professional fees, recruiting, credentialing, mileage, debt principal, interest, taxes outside the workforce debit, capital purchases, owner distributions, and other payments by exact due date. Add refunds or recoupments here only when the collections tab has not already reduced realization or receipts for the same item. Put one-time and recurring items on different rows.

Record an economic event once. If purchases enter the forecast when a credit-card bill is paid, exclude the earlier card swipe from cash outflows. If pre-opening costs are already in dated rows, leave them out of a separate liquidity add-on. Show loan or equity proceeds only when committed and expected to be available, with conditions and timing documented.

6. Cash summary and liquidity formulas

The weekly and monthly summary uses the same equations:

net cash change[t] = payer receipts + patient receipts + financing receipts − workforce cash debits − taxes outside workforce debits − other cash outflows

ending unrestricted cash[t] = opening unrestricted cash[t] + net cash change[t]

cumulative cash change[t] = sum(net cash change from period 1 through t)

peak cumulative shortfall = max(0, −minimum cumulative cash change)

required opening unrestricted cash = peak cumulative shortfall + minimum liquidity buffer

funding gap = max(0, required opening unrestricted cash − opening unrestricted cash − committed liquidity excluded from forecast receipts)

Calculate the shortfall across a horizon that reaches the expected cash trough and includes material collection tails and obligations. If cumulative cash is still falling in the final period, label the result “largest cumulative shortfall through [date]” and extend the forecast before treating it as the peak. Use the financing source either as opening committed liquidity in the funding-gap equation or as a dated forecast receipt. Using it in both places counts the same funding twice. If pre-opening uses sit outside the forecast period, add them once to required liquidity and label that exception.

7. Actual versus forecast and scenarios

Freeze the approved forecast before loading actuals. Compare every deposit and bank debit by date and amount. Explain variance through volume, payer mix, allowed amount, eligibility, claim acceptance, adjudication, patient realization, payroll, price, or timing. A favorable total can conceal a slow payer and delayed bill.

Use at least a base case and a downside case. Add a combined severe case when the practice is considering hiring, a location, or debt. SBA's business-plan guidance calls for forecast cash-flow statements and more detailed first-year projections. The forecast should show the assumptions and cash consequences behind a funding request.

Work through this synthetic six-month example

Clearview ABA is fictional. All values below are in thousands of dollars. They are teaching assumptions, not Finni results, reimbursement benchmarks, or a prediction for any practice. Clearview starts with $250,000 of unrestricted cash and no opening A/R. Expected collectible service cohorts for months 1 through 6 are $80,000, $100,000, $120,000, $140,000, $150,000, and $160,000.

Its synthetic deposit curve is 5% in the service month, 60% one month later, 25% two months later, and 10% three months later. The weights total 100%. Month 2 receipts, for example, equal 5% × $100,000 + 60% × $80,000 = $53,000.

Within the displayed six months, the base case's deepest cumulative change is negative $195,000 in month 4. It then improves through month 6, so its largest cumulative shortfall through month 6 is $195,000. Clearview's minimum liquidity buffer is $75,000.

required opening cash = $195,000 + $75,000 = $270,000

funding gap = $270,000 − $250,000 = $20,000

Its month 6 ending cash is $250,000 − $173,500 = $76,500. Cash falls to $55,000 in month 4, which breaches the $75,000 buffer by $20,000 before recovering. The $20,000 gap identifies the additional opening liquidity needed to preserve that buffer throughout the full period.

Test combined sensitivities

The following sensitivities are synthetic stress tests. The downside case reduces every receipt by 15% while holding outflows constant. The severe case reduces receipts by 25% and increases every outflow by 5%.

The base case turns upward before the display ends. The downside and severe cumulative cash lines are still falling in month 6, which means $253,225 and $341,625 are the largest observed shortfalls through month 6 and could increase later. Their $328,225 and $416,625 opening-cash figures are minimums for preserving the buffer during the displayed period, rather than complete funding requirements. Extend each live scenario until it captures the expected trough, collection tail, and material obligations.

A live model should test payer-specific delays, authorization or credentialing timing, attendance, claim corrections, recoupments, wage changes, hiring pace, and one-time spending with evidence-based ranges.

The CMS Prior Authorization API FAQ and CMS-0057-F fact sheet define impacted payers as Medicare Advantage organizations, state Medicaid and Children's Health Insurance Program (CHIP) fee-for-service programs, Medicaid managed care plans, CHIP managed care entities, and Qualified Health Plan issuers on the Federally Facilitated Exchanges. For prior authorization of medical items and services excluding drugs, the operational requirements generally began January 1, 2026. The 72-hour expedited and seven-calendar-day standard decision timeframes exclude Qualified Health Plan issuers on the Federally Facilitated Exchanges. These are decision timeframes. They do not set service delivery, claim submission, adjudication, remittance, or bank-deposit timing. Use the member's exact product, payer instructions, contract, and mature practice data for the cash model.

Put the forecast into weekly use

Assign one owner to update the workbook and named reviewers for RCM, payroll, operations, and finance. Each week:

1. Reconcile opening cash to the bank and explain outstanding transfers.
2. Replace expected deposits and payments with actual bank dates and amounts.
3. Refresh claim cohorts, opening A/R, patient balances, and lag curves using consistent maturity rules.
4. Load the current payroll, tax, benefit, vendor, debt, refund, and capital schedules.
5. Recalculate base and downside liquidity, then compare the result with the approved buffer and funding conditions.
6. Assign each material variance or risk an owner, action, due date, and next review.

Keep clinical decisions with qualified clinicians. Authorized quantity and forecast demand do not set an individual's goals, dosage, continuation, transition, or discharge. Financial actions should protect current care, staff obligations, privacy, billing accuracy, and lawful payment practices.

This ABA practice cash flow template becomes useful when every number can be traced to a dated source and every variance leads to a decision. Review it with a healthcare CPA and an ABA RCM leader before relying on it for hiring, financing, distributions, or expansion.

Related resources

• Parent topic: Finance, Funding and Business Planning
• ABA Practice Financial Model: Revenue, Costs and Break-Even
• ABA Practice KPIs: The Metrics Owners Should Track
• ABA Scheduling: Matching Clinical Needs, Staff and Authorized Hours
• ABA Payroll Checklist: Timekeeping, Travel, Training, Cancellations and Overtime

Sources

1. U.S. Small Business Administration, Business Guide
2. Centers for Medicare & Medicaid Services, Prior Authorization API FAQ
3. U.S. Small Business Administration, Manage Your Finances
4. U.S. Small Business Administration, Business Plan and Financial Projections
5. Internal Revenue Service, Publication 15 (2026), Employer's Tax Guide
6. Centers for Medicare & Medicaid Services, Adopted Standards and Operating Rules
7. Centers for Medicare & Medicaid Services, Health Care Payment, Remittance Advice, and EFT
8. Centers for Medicare & Medicaid Services, CMS-0057-F Fact Sheet