A higher bank balance does not necessarily mean a medical practice collected more from patients and payers. Loan proceeds can increase cash, a transfer can make one account look stronger, and an owner distribution can reduce cash without appearing as an operating expense.

Useful cash visuals keep those differences visible. For a staffed private medical practice, three views answer distinct questions:

Owner’s question Best visual What to look for
What changed our cash balance? Cash bridge, also called a waterfall chart Collections, operating payments, equipment purchases, borrowing and owner distributions shown separately
When did receipts and obligations cluster? Receipts-and-disbursements timeline Whether collections and payment dates lined up within the period
Which receipts or payments differed from our plan? Actual-versus-planned cash chart When a difference began, its cause and whether it later reversed

These are interpretation tools, not proof of profitability or predictions of future cash. The goal is to help an owner ask a precise question and connect the answer to reconciled records.

Start With a Defined Cash View

Before choosing a chart, agree on what “cash” includes. A useful title might read: Practice entity A — operating and reserve bank accounts — four-week management period — USD. Add the period-end date and reconciliation status.

For a single entity, include all bank accounts intended to be in the view. For several entities, show entity-level balances before presenting a consolidated total. Cash in one entity should not automatically be presented as available to another.

Use a consistent date basis. For example, a reconciled book-cash view uses recorded receipt and payment dates, with outstanding checks and deposits in transit explained through the bank reconciliation. A bank-posted view uses bank posting dates. Do not switch between those bases when comparing actual and planned cash.

The IRS guidance on business recordkeeping supports maintaining complete records, separate business accounts and bank reconciliations. A chart should summarize those records, not substitute for them.

Keep transfers and accounting allocations out of collections

A transfer between two included accounts changes neither total practice cash nor operating receipts. Show it only when explaining an individual account’s movement, and label the matching transfer out.

Similarly, allocating shared administrative costs across locations does not create a new cash payment. A payment made centrally should appear once in the entity’s cash view. Location allocations belong in a separately labeled management analysis.

An Illustrative Practice Dataset

Every amount in the following dataset and charts is synthetic and illustrative, not a practice benchmark or case study. Values are in thousands of dollars. The example covers four management weeks, begins with $100,000 of cash and includes no internal transfers or debt repayments.

The practice has provider and administrative payroll, payer deposits and patient collections. It also receives a loan, purchases equipment and makes an owner distribution.

Cash movement, $000 Week 1 Week 2 Week 3 Week 4 Total
Payer receipts 45 35 50 60 190
Patient receipts 10 10 12 8 40
Provider/admin payroll and related cash payments 0 (65) 0 (65) (130)
Rent and occupancy (20) 0 0 0 (20)
Supplies (5) (5) (10) (5) (25)
Other operating payments (5) (5) (5) (5) (20)
Loan proceeds 0 30 0 0 30
Equipment purchase 0 0 (20) 0 (20)
Owner distribution 0 0 0 (25) (25)
Net cash change 25 0 27 (32) 20
Closing cash 125 125 152 120 120 at period end

Payroll is grouped for readability here. In an actual practice, wages, payroll taxes and benefit payments may clear on different dates and should be separated when that timing matters.

1. Use a Cash Bridge to Explain the Balance Change

A cash bridge starts with opening cash, adds receipts, subtracts payments and ends at closing cash. In a waterfall chart, opening and closing balances are anchored to zero; intermediate bars float from the previous running balance.

Illustrative cash bridge: $100,000 to $120,000

The table below is the bridge in reading order. The running balance is the endpoint of each waterfall step.

Bridge step Cash movement, $000 Running cash, $000
Opening cash Starting balance 100
Payer receipts +190 290
Patient receipts +40 330
Provider/admin payroll and related payments (130) 200
Rent and occupancy (20) 180
Supplies (25) 155
Other operating payments (20) 135
Loan proceeds +30 165
Equipment purchase (20) 145
Owner distribution (25) 120
Closing cash Net increase: 20 120

Important label: These intermediate balances explain categories, not the order in which transactions occurred. The practice did not necessarily have $330,000 available at any point.

What the owner can conclude

The example’s operating receipts were $230,000 and its operating payments were $195,000, producing a $35,000 operating cash surplus in this simplified management view. Borrowing added $30,000; equipment and the owner distribution used $45,000. Together, those movements explain the $20,000 increase in cash.

That does not establish $35,000 of profit. Cash collections may relate to earlier services, while unpaid bills or noncash expenses may affect the P&L differently.

Keep loan proceeds separate from patient and payer receipts. Likewise, do not combine owner distributions with staff payroll. If debt payments are present, separate principal from interest using the accounting records rather than treating the entire payment as an operating expense.

Owner’s next question: “How much of the balance change came from collections and routine payments, and how much came from borrowing or owner activity?”

2. Use a Timeline to Reveal Payment Clusters

A bridge explains the total change but hides timing. A receipts-and-disbursements timeline places cash movements in chronological order, making payroll weeks and other payment concentrations visible.

Illustrative weekly receipts-and-disbursements timeline

Bars below show operating receipts and operating payments only. Each block represents approximately $10,000; exact amounts are printed beside the bars. Payments are displayed as positive magnitudes for comparison, not as inflows.

Week Operating receipts Operating payments Other cash movements, $000 Closing cash, $000
1 █████▌ 55 ███ 30 None 125
2 ████▌ 45 ███████▌ 75 Loan proceeds +30 125
3 ██████ 62 █▌ 15 Equipment (20) 152
4 ███████ 68 ███████▌ 75 Owner distribution (25) 120

A plotted version should use paired columns on the same dollar scale, with separate annotations for borrowing, equipment and owner activity. Do not hide loan proceeds inside the receipts column.

Read the dates, not just the weekly totals

In the example, operating payments cluster in Weeks 2 and 4 because payroll occurs then. Week 2’s unchanged closing balance masks two offsetting facts: operating payments exceeded operating receipts by $30,000, and loan proceeds supplied $30,000.

Weekly totals still cannot establish whether funds were available on each payment date. If payroll left the account before payer deposits arrived, a daily view could tell a different story. Use daily detail around a questioned payment cluster rather than interpreting a weekly closing balance as the week’s minimum balance.

For actual receipts, use payment or deposit records—not service dates or claim submission dates. A service rendered in one week can generate cash in another.

Owner’s next question: “Which exact receipt and payment dates explain this cluster?” That question can guide a review of payment scheduling without implying that obligations can simply be delayed.

3. Compare Actual Cash With the Original Plan

An actual-versus-planned chart helps explain deviations from an earlier expectation. Preserve the dated plan instead of replacing it with actual results; otherwise, the variance disappears.

In this illustrative scenario, the plan expected $55,000 of payer receipts in Week 2 and $40,000 in Week 4. Actual receipts were $35,000 and $60,000, respectively. All other planned movements matched actual movements. Supporting remittance and deposit records are assumed to confirm that the same $20,000 receipt arrived in Week 4 rather than Week 2.

Illustrative actual-versus-planned closing cash

The paired bars use a common scale of approximately $10,000 per block. Printed values are exact; bar lengths are rounded. In a line-chart version, use a solid actual line and a dashed planned line on the same axis.

Period end Planned cash, $000 Actual cash, $000 Actual minus plan, $000
Opening ██████████ 100 ██████████ 100 0
Week 1 ████████████▌ 125 ████████████▌ 125 0
Week 2 ██████████████▌ 145 ████████████▌ 125 (20)
Week 3 █████████████████ 172 ███████████████ 152 (20)
Week 4 ████████████ 120 ████████████ 120 0

Explain the variance before judging performance

The Week 2 and Week 3 shortfalls reflect receipt timing in this example, not a demonstrated reduction in services or total collections. The difference reverses in Week 4.

In real records, a matching later deposit alone is not enough to prove that a specific delayed receipt arrived. Ask the billing or collections team to connect the variance to appropriate remittance and deposit support.

If a gap remains, distinguish among:

  • A receipt still outstanding after its expected payment date.
  • A difference in the amount collected, such as a partial payment or adjustment.
  • An expectation that was not supported by collection history or payment information.
  • A posting, cutoff or reconciliation error.

A cash chart identifies where to investigate. It does not establish why a payer paid late or whether a patient balance will be collected. Use aggregated payer and patient-balance categories for owner reporting; keep patient-identifiable information out of ordinary Slack messages and general-purpose AI tools.

Labels and Reconciliation Checks to Require

Before relying on any of these visuals, ask the preparer to confirm the following:

Required check What the owner should see
Scope Named entity, included accounts, period and currency units
Date basis Book dates or bank-posting dates, applied consistently
Opening and closing balances Agreement to the selected reconciled cash records
Arithmetic Opening cash + receipts − payments = closing cash
Category totals The bridge and timeline use the same underlying transactions
Transfers Matching internal movements excluded from combined-account totals
Nonoperating movements Borrowing, equipment and owner activity labeled separately
Plan integrity Original plan date, assumptions and unchanged comparison version
Exceptions Unreconciled items, missing records and uncertain classifications disclosed

For multi-location practices, require the preparer to distinguish a location allocation from an actual bank payment. For multi-entity practices, identify intercompany movements and eliminate matching internal movements only within a clearly defined consolidated scope.

Avoid misleading chart design

Start magnitude bars at zero. Use the same dollar scale for actual and planned balances, and avoid dual axes that make unrelated movements appear to track each other. If a line chart uses a shortened axis to show small differences, disclose that clearly and include the actual balances.

Label values directly, show negative signs or parentheses consistently, and do not rely on red and green alone. Avoid smoothed lines that suggest unobserved movements between weekly endpoints. A period-end balance is a point-in-time observation, not a record of every intervening balance.

Turn the Visual Into a Focused Owner Review

Review the bridge first, the timeline second and the actual-versus-planned comparison third. This sequence separates the source of the balance change from its timing and from the original expectation.

End with a specific follow-up: confirm a deposit, reconcile a transfer, explain a payroll payment date or correct an unsupported plan assumption. Do not let a rising cash line stand in for a review of the P&L.

Lucid Financials provides CPA-led bookkeeping, tax and CFO services for staffed US private medical practices, combining AI-assisted financial work with a human finance team. Clean books, catch-up bookkeeping and location/entity financial visibility provide a foundation for these discussions. Owners can use Slack support to discuss aggregate financial questions without sharing patient-identifiable details.

FAQs

Which cash chart should a medical practice owner review first?

Start with a cash bridge when the question is why the balance changed. Use a timeline when the question concerns payment dates or clusters. Use actual-versus-planned cash when you need to explain a difference from a previously documented expectation.

Can a cash chart show whether the practice is profitable?

Not by itself. Loans increase cash without creating operating revenue, and owner distributions reduce cash without being operating expenses. Collection and payment timing also differ from when revenue and expenses may be recognized. Review the P&L alongside cash movements rather than treating either as a substitute for the other.

How can a chart identify delayed payer receipts?

Compare actual receipts with the dated plan by period and payer category, then investigate the differences using remittance and deposit records. A later increase may reflect delayed collections, but the chart alone cannot prove that connection. Keep receipt timing separate from service dates and claim submission dates.

Should transfers between practice accounts appear as receipts?

Not in a combined view that includes both accounts. They move existing cash rather than generate new cash. An individual-account chart can show the transfer, but it should be labeled as a transfer—not a payer receipt, patient collection or operating expense.