Reconciling Collections Across Multiple Bank Accounts: The Multi-Location Problem
At one location with one bank account, a deposit either matches or it does not. At twelve locations across four accounts with transfers between them, "does it match" stops being a simple question.
Why banking gets complicated as a group grows
A single practice usually has one operating account, and reconciliation is a straightforward comparison: what the practice management system says was collected against what landed in that account. The question has a yes or no answer.
Groups almost never look like that. As locations are added, especially through acquisition, the banking structure accumulates layers. An acquired practice arrives with its own bank and its own account, and it may keep it for months or years. Some groups run a separate account per location. Others sweep everything into a central account. Many do both at once, with a mix of location accounts, a shared operating account, and regular transfers between them. Payer remittances may land in one place while patient card deposits land in another.
None of this is wrong. It is the natural result of growth. But it quietly breaks the assumption that reconciliation depends on, which is that a deposit can be cleanly attributed to the location that earned it.
How commingled banking hides gaps
The specific failure is attribution. When money from several locations flows into shared accounts, or moves between accounts through transfers, it becomes hard to say which deposit belongs to which office. And once attribution is uncertain, a gap at one location can be absorbed by another location's normal activity without anyone noticing.
Picture a location that is short on a given day, whether from a posting error or something worse. In a single-account practice, that shortfall is visible against that day's expected deposit. In a group with commingled banking, it arrives alongside deposits from other locations, transfers in and out, and batch timing differences, and the total for the account may look entirely reasonable. The location-level signal disappears into the group-level noise.
This is the same reason we warn against summary-level monthly reconciliation in our DSO revenue integrity guide: netting locations against each other buries exactly the findings you are looking for. Mixed banking does the netting for you, automatically, whether you intended it or not.
The three banking patterns and what each requires
Most groups fall into one of three structures, and each needs a slightly different reconciliation approach.
One account per location is the cleanest, because attribution is built in. Each location's collections are compared against its own account and the picture stays sharp. The cost is administrative, more accounts to manage, and it tends not to survive as groups centralize.
A single central account for all locations is the hardest. Every location's money lands in one place, and attribution has to be reconstructed from deposit detail, payer remittance data, and the practice management system's own record of which location generated each payment. It is workable, but only with transaction-level matching that ties each deposit line back to a location rather than comparing totals.
The hybrid, which is where most groups actually live, is the most error-prone, because it combines the attribution problems of the central account with the added complication of inter-account transfers. A transfer from a location account to the central account is not revenue, but it appears as a deposit in the receiving account and a withdrawal in the sending one. If reconciliation does not recognize and exclude transfers, it double-counts them on one side and misses them on the other, and the resulting gaps look like real discrepancies when they are just money moving between the group's own pockets.
What correct attribution looks like
Solving this comes down to a few principles applied consistently.
Reconcile at the location level regardless of the banking structure. Even if all money lands in one account, each location's expected collections should be matched against the deposits attributable to it, not against the account total.
Identify and exclude inter-account transfers before matching, so that money moving within the group is never mistaken for revenue arriving or leaving.
Match at the transaction level, not the summary level, so that a deposit line is tied to the specific payments it contains and the location that generated them. Payer remittances help here because they carry the detail needed to attribute a bundled deposit to the right claims and offices. Our guide to reading a dental ERA file covers what that remittance detail contains.
And anchor everything to the bank as ground truth. The practice management system reports what each location says it collected. The bank reports what actually arrived. Attribution is the work of connecting the two at the location level, and the bank side is the one that cannot be edited from inside any office.
Why acquisitions make this urgent
Groups that grow by acquisition face this problem in its sharpest form, because every acquired practice adds another account, another banking habit, and another set of accumulated posting quirks to the mix. The integration period is when attribution is hardest and when gaps hide most easily, since every anomaly gets attributed to the transition. We cover that window in our guide to reconciling acquired practices during integration.
The groups that handle this well treat banking structure as a reconciliation design question, not just a treasury one. Before consolidating an acquired location's account, they establish location-level reconciliation on it. Before centralizing, they confirm that attribution will survive the move. The alternative is discovering, months later, that consolidating the banking also consolidated away the ability to see any single location clearly.
What auditors and buyers expect
Any auditor or acquirer examining a group will want collections tied to deposits by location, and they will not accept a group-level total as proof. If the banking structure makes location attribution impossible, that inability itself becomes a finding, because it means the group cannot demonstrate that each location's reported revenue is real. Groups that can produce a clean, location-attributed reconciliation across mixed banking earn confidence and smoother diligence. Groups that cannot invite exactly the scrutiny they hoped the consolidated number would deflect. Our guide to the revenue-to-cash waterfall covers what that drillable, bank-anchored presentation looks like.
Frequently Asked Questions
Why is reconciliation harder for a dental group with multiple bank accounts?
Because deposits can no longer be cleanly attributed to the location that earned them. Money from several locations flowing into shared accounts, plus transfers between accounts, makes it hard to tell which deposit belongs to which office, so a gap at one location gets absorbed by another's normal activity.
What is the biggest mistake groups make with mixed banking?
Failing to identify and exclude inter-account transfers before reconciling. A transfer between the group's own accounts appears as a deposit on one side and a withdrawal on the other, and if it is not recognized as a transfer it creates phantom discrepancies in both places.
Should each dental location have its own bank account?
It is the cleanest structure for reconciliation because attribution is built in, but many groups centralize for administrative reasons. Either approach can work, as long as reconciliation happens at the location level and transaction level regardless of where the money physically lands.
How do you attribute a deposit to the right location in a central account?
By matching at the transaction level, tying each deposit line to the specific payments it contains using payer remittance detail and the practice management system's record of which location generated each payment, rather than comparing account totals.
How do acquisitions affect group banking reconciliation?
Each acquired practice adds another account and another set of banking habits. The integration period is when attribution is hardest and gaps hide most easily, so location-level reconciliation should be established on an acquired location before its banking is consolidated.
Zeldent reconciles at the location level across any banking structure, attributing every deposit to the office that earned it, recognizing inter-account transfers so they are never mistaken for revenue, and anchoring the whole picture to the bank. It is built for mixed banking and mixed practice management systems, which is what makes it work across a fleet. Book a demo to see your locations reconciled individually.
