The Revenue-to-Cash Waterfall: What Your Auditors Actually Want to See

Production is what you did. Cash is what you got. Everything a finance team is asked to explain lives in the steps between them, and a waterfall is how you show your work.

What a revenue-to-cash waterfall is

A revenue-to-cash waterfall is a step-by-step bridge from the top-line value of the dentistry a practice produced down to the actual cash that landed in the bank. Each step subtracts a category of reduction, and the point of the exercise is that every reduction is named, quantified, and defensible.

It starts at gross production, the full-fee value of the work performed. From there it steps down through contractual adjustments, other write-offs, the portion still sitting in accounts receivable, and any leakage, until it arrives at collected cash. Done properly, someone can look at the chart and understand exactly why the money that reached the bank is smaller than the dentistry that was performed, with no unexplained residual.

For a single practice this is useful. For a dental group answering to auditors, lenders, or investors, it is essential, because those parties will not accept "collections were lower than production" as a statement. They want the bridge.

Why the gap exists in the first place

The distance between production and cash is normal and expected. The question is whether it is explained.

Contractual adjustments account for the largest legitimate step. When a practice participates with a payer, it agrees to accept less than its full fee, and that difference was never real revenue. It is not a loss, but it has to be shown, because a reader cannot tell a contractual write-off from a problem without seeing it broken out. Our guide to the production versus collections gap covers this at the practice level.

Other write-offs, patient courtesies, and bad debt each take a further step down, and each deserves its own line rather than being lumped together, because their patterns mean different things.

Accounts receivable explains the timing portion: work produced this period whose cash has not yet arrived. Our accounts receivable management guide covers how that balance behaves.

And then there is the step nobody wants on the chart but everyone needs to see: unexplained variance. The money that should have arrived and did not.

The step that separates a real waterfall from a pretty one

Most waterfalls a dental group produces are built entirely from the practice management system. Production, adjustments, AR, and collections all come from the same source, which means the chart reconciles to itself by construction. It always ties out, because every number came from the same ledger.

That is exactly the problem. A waterfall built only from internal data proves that the ledger is internally consistent. It does not prove that the cash line is real.

The step that makes a waterfall trustworthy is anchoring the bottom of it to the bank. Collected cash should be the actual deposited amount, pulled from bank records, not the collections figure the practice management system reports. When you anchor the bottom to the bank and the top to production, any gap that the named steps do not explain becomes visible as a residual, and that residual is the most important number on the entire chart. It is the money that left the system unaccounted for.

A waterfall that ties out perfectly with no independent anchor has not demonstrated integrity. It has demonstrated that the ledger agrees with itself, which was never in question.

What auditors do with it

An auditor or an acquirer looking at a dental group's financials is running a version of this bridge whether the group provides it or not. Giving them a clean one changes the dynamic entirely.

They will want to tie the collections line to actual bank deposits, so build it that way from the start. They will want the variance between revenue and cash explained by category rather than asserted as a total. They will want to drill from the consolidated group number down to a single location, and ideally to a single payment type or claim, because a number that cannot be drilled into is a number they cannot trust. A group that hands over a waterfall meeting those conditions shortens diligence and strengthens its valuation. A group whose waterfall falls apart under drilling invites exactly the scrutiny it was trying to avoid. Our guide to pre-acquisition financial due diligence covers the buyer's side of that examination.

Building one for a group

At the group level, the waterfall has to work at two resolutions at once: the consolidated fleet view that leadership and investors see, and the per-location view that explains where any given step comes from.

That means the underlying reconciliation has to be location-aware from the bottom up. Each location's deposits are matched against its own ledger, its own adjustments are categorized, its own AR is tracked, and only then are the locations summed into the group view. A consolidated waterfall built from consolidated inputs cannot be drilled, which defeats its purpose the moment anyone asks a real question. The reconciliation that supports it is the same location-level, bank-anchored process covered in our DSO revenue integrity guide.

Frequently Asked Questions

What is a revenue-to-cash waterfall?

It is a step-by-step bridge from gross production down to actual collected cash, subtracting each category of reduction along the way, such as contractual adjustments, write-offs, and accounts receivable, so that the difference between what was produced and what was banked is fully explained.

Why do dental groups need a revenue-to-cash waterfall?

Auditors, lenders, and investors will not accept a bare statement that collections were lower than production. They want the gap bridged and explained by category, drillable from the group total down to a location, which is what a waterfall provides.

How is a trustworthy waterfall different from a normal one?

A trustworthy waterfall anchors its collected-cash line to actual bank deposits rather than to the collections figure from the practice management system. That independent anchor exposes any unexplained variance as a residual, which a self-referential ledger-only waterfall hides.

What is the most important number on the waterfall?

The unexplained residual, meaning the gap between production and banked cash that the named steps do not account for. It represents money that left the system unaccounted for, and it is only visible when the bottom of the waterfall is anchored to the bank.

Can a waterfall be built for multiple locations?

Yes, but the underlying reconciliation must be location-aware from the bottom up, matching each location's deposits to its own ledger before summing into a group view. A consolidated waterfall built from consolidated inputs cannot be drilled into, which defeats its purpose.

Zeldent builds the reconciliation a revenue-to-cash waterfall depends on, matching every location's actual bank deposits against its ledger and categorizing every gap, drillable from the group total down to a single claim. Book a demo to see your own production-to-cash bridge anchored to the bank.