If you manage more than one entity (subsidiaries, store locations, rental LLCs, or brands), bank reconciliation multiplies fast. Each entity has its own bank accounts, its own feed, and its own month-end. In per-entity tools, that means logging in and out of a separate file for every set of books, with no single place to see whether the whole group is reconciled or what your combined cash actually is.
The Short Answer
To reconcile bank accounts across multiple entities without it consuming your month-end:
- Connect every entity’s accounts to a bank feed under one login, so nothing waits on a manual upload.
- Confirm smart matches rather than keying transactions; the matching improves as you use it.
- Write per-entity rules so recurring vendors, payouts, and fees categorize themselves.
- Record inter-entity transfers once, so both sides post together and reconcile on each feed.
- Work from a per-entity status view, so you chase the two entities that are behind instead of opening all twelve.
- Lock each period once reconciled, so a closed month cannot quietly change.
The rest of this guide is the detail behind those six, plus what changes when the account count reaches 40.
The Multi-Login Reconciliation Problem
QuickBooks and Xero are built around one company per file. To reconcile five entities you log into five files, reconcile each separately, and then, if you want a group cash position, export and combine in a spreadsheet. The pain compounds:
- Context switching: log out, log in, repeat for every entity.
- No group status: nothing tells you “Entity C still has 12 unmatched transactions.”
- No combined cash view: total liquidity across entities is a manual spreadsheet.
- Inter-entity transfers: a transfer between two of your companies shows up on both feeds and has to be matched on each side by hand.
The cost is not the reconciliation. It is the switching, the absence of a group view, and the fact that nothing tells you where the problem is until you go looking.
Which Systems Reconcile Across Multiple Accounts?
Worth separating two things that sound the same. Reconciling multiple accounts is table stakes: nearly every accounting platform handles several bank accounts, credit cards, and merchant accounts inside one company file. Reconciling across multiple entities is the harder requirement, and the field narrows quickly.
| Approach | Multiple accounts per entity | Multiple entities in one system | Cross-entity status view | Pricing model |
|---|---|---|---|---|
| QuickBooks Online | Yes | No, one file per company | No | Subscription per entity |
| Xero | Yes | No, one organisation per file | No | Subscription per entity |
| Spreadsheet on top of either | Yes | Manual | Manual, and stale | Your time |
| Mid-market ERP | Yes | Yes | Yes | Enterprise contract |
| Multi-entity platform (EmLedger) | Yes, unlimited per entity | Yes | Yes | Tier-based, not per entity |
If your group is two entities, the per-entity approach is survivable. Somewhere between three and five it stops being a preference and starts being the reason month-end takes a week.
Step 1: Connect Every Entity’s Bank Accounts (One Login)
With multi-entity software, you connect bank accounts for each entity under a single login. Automated bank feeds import transactions daily for every entity, with CSV and PDF bank statement import available as a fallback. There’s no per-entity logout; you switch entities in one click.
Two things to get right at setup, because they are painful to fix later: connect every account, including the dormant ones and the credit cards, since an unconnected account is the one that silently falls behind; and name accounts consistently across entities so a status view reads at a glance.
Step 2: Confirm Smart Matches
Imported transactions are matched against entries already in each entity’s books using pattern-based matching that learns from your past decisions. You confirm or override each match with one click. Because the matching model improves as you use it, the volume of manual matching drops over time, across every entity, not just one.
Step 3: Auto-Categorize With Per-Entity Rules
Set rules per entity to categorize recurring transactions automatically. For example, “Stripe” always posts to Sales Revenue, or a specific vendor always maps to the right expense account. A single transaction can be split across multiple accounts when needed. Per-entity rules keep categorization consistent without forcing every entity to share the same vendors.
This is where most of the automation payoff lives. In a typical portfolio entity, a large share of monthly transactions are the same handful of counterparties: the lender, the utility, the processor, the management fee. Rules clear those on arrival, and a review queue holds back anything that does not match a rule so it gets a decision rather than a default.
Step 4: Track Reconciliation Status Across Entities
This is the step the multi-login approach can’t do. Instead of opening each entity to check whether it’s reconciled, a single status view shows reconciliation state per entity: which are fully reconciled, which have unmatched transactions, and which are behind.
Step 5: See Your Cross-Entity Cash Position
Once each entity’s accounts are reconciled, a cross-entity cash position report rolls up real-time balances across all entities, so you know total group liquidity at a glance instead of adding up balances from separate logins.
Reconciling Transfers Between Your Own Entities
When you move money between entities you own, it’s an inter-company transaction: it leaves one entity’s bank account and lands in another’s. Record it once so both sides post together, then it reconciles cleanly on each feed, and it’s eliminated automatically in consolidated reports. (For how that elimination works, see inter-company eliminations explained.)
Recorded as two independent transactions instead, the pair has to be matched by hand on both feeds every time, and any timing difference between the send and the receipt looks like an unexplained item on two sets of books at once.
Scaling to 40+ Bank Accounts
Past roughly 30 accounts, the constraint changes. Reconciling one account is not harder than it was; knowing which accounts need you is. A group with 40 accounts across a dozen entities has a handful that move daily, a long tail that see a few transactions a month, and one or two that will quietly go stale for a quarter if nothing surfaces them.
What holds up at that scale:
- Feeds on everything, including low-volume accounts. Manual upload is where the tail falls behind.
- A status view sorted by exception, not alphabetically. You want the three accounts with unmatched items, not a list of 40.
- Rules maintained per entity, so a new recurring vendor in one entity does not require touching every other entity’s rules.
- A fixed close order: operating entities first, then the entities that receive their transfers, then the holding company. Reconciling the parent before its subsidiaries means reconciling it twice.
- Period locking after each close, so a reconciled month cannot drift when someone backdates an entry.
- Historical reconciliation available for the accounts you inherit mid-year, so a new entity can be brought current without a separate cleanup project.
Side by Side
| Per-entity tools (QuickBooks, Xero) | Multi-entity software | |
|---|---|---|
| Logins to reconcile 5 entities | 5 separate files | 1 |
| Bank feeds | Per file | Per entity, one dashboard |
| Reconciliation status across entities | Open each file to check | Single status view |
| Cross-entity cash position | Spreadsheet | Built-in report |
| Inter-entity transfers | Match on both files by hand | Record once, both sides reconcile |
| Cost of adding an entity | Another full subscription | Included until the next tier |
Bottom Line
Multi-entity reconciliation isn’t harder accounting. It’s the same reconciliation done many times, and the cost is the switching and the lack of a group view. Connect every entity under one login, let smart matching and per-entity rules do the repetitive work, and use a per-entity status view plus a cross-entity cash position to manage the whole group from one screen.
See how it fits the bigger picture in how to consolidate financial statements across subsidiaries, or explore EmLedger for holding companies.