Inside LawAccounting's Multi-Entity General Ledger: How Multi-Office Law Firms Run Consolidated P&Ls Across LLCs, PCs, and Practice Groups Without Spreadsheet Stitching in 2026
Most legal accounting platforms collapse at the second entity. A firm with one PC, one LLC, a separate captive medical-records subsidiary, and three branch offices ends up running consolidations in Excel โ fragile, slow, audit-unfriendly. Here's how LawAccounting's native multi-entity GL solves that.
Published: 2026-05-24T12:11:37.434Z ยท Category: Legal Accounting ยท 7 min read
๐ข The Mid-Market Multi-Entity Problem
The typical mid-market law firm is not a single legal entity. A 60-attorney PI firm in California might have a professional corporation (PC) for the law practice, a separate LLC for the office building it owns, a captive medical-records-retrieval subsidiary, a third LLC for marketing operations, and three branch offices each operating under the PC but with separate cost centers. The firm's leadership needs a consolidated P&L. The PC tax return needs separate books. The LLC needs its own balance sheet. The medical-records sub bills the PC for services and gets eliminated in consolidation.
QuickBooks handles this by having you run a separate company file per entity and manually consolidate in Excel. CosmoLex and Tabs3 don't really handle it. Generic legal practice management platforms with "QuickBooks integration" pass the problem through. The result: most firms with this structure spend 8โ12 days every month on consolidation work that should take 30 minutes.
โ๏ธ What "Native Multi-Entity GL" Actually Means
A native multi-entity GL means three structural things, all of which most generic platforms get wrong:
One Chart, Many Books
A single chart of accounts shared across all entities, but every transaction is tagged to its owning entity. Run a P&L for one entity, a group of entities, or all entities โ instantly.
Intercompany Auto-Posting
When the medical-records sub bills the PC for $4,000, the receivable posts to the sub's books and the payable posts to the PC's books simultaneously โ one journal entry, two-sided.
Automatic Eliminations
At consolidation, intercompany receivables, payables, and revenue/expense pairs are eliminated automatically โ no manual JE, no Excel.
Entity-Aware Trust Accounting
Each entity can hold its own IOLTA trust accounts with separate three-way reconciliation โ critical for firms operating in multiple state jurisdictions.
๐ How LawAccounting's Multi-Entity Works
LawAccounting is built on Salesforce, which means the underlying data model already supports unlimited entity hierarchies natively. When you set up a new entity, you define its tax structure (PC, LLC, S-Corp, partnership), its functional currency, its base chart-of-accounts mapping, and its relationship to parent entities. From that point forward, every billing transaction, every vendor bill, every journal entry carries the entity tag automatically โ and rolls up the hierarchy you defined.
A controller can pull a standalone P&L for the California PC, a consolidated P&L for the entire firm group, a profit-and-loss for just the medical-records subsidiary, or a P&L for "all branch offices that operate under the PC" โ without rebuilding the report each time. All four reports tie out to the underlying GL.
๐ฏ Three Real Scenarios Where This Matters
๐ Scenario 1: Multi-State Trust Compliance
A PI firm with a California PC and a Texas branch holds IOLTA accounts in both states โ California funds belong to the California bar IOLTA program, Texas funds belong to TLAP. Each set of trust funds needs its own three-way reconciliation, its own designated licensee, and its own state-specific reporting. LawAccounting handles this as two separate trust entities under one umbrella organization with consolidated visibility for partners but state-segregated audits.
๐ผ Scenario 2: Captive Subsidiary Margin Tracking
The medical-records-retrieval sub bills the PC at cost-plus-15%. Leadership wants to know the gross margin of the sub as a standalone business (would it be profitable if sold to a third party?) and also wants the consolidated firm P&L with intercompany revenue eliminated. LawAccounting produces both views from the same source data in under a minute.
๐๏ธ Scenario 3: Real Estate Entity for the Office
The firm owns its office building through a separate LLC and the PC pays rent to that LLC. The LLC has its own depreciation, property tax, and mortgage entries. The PC has rent expense. Consolidation eliminates the rent revenue/expense pair, but the LLC's depreciation and property tax remain. LawAccounting handles all of this with a pre-built elimination rule library.
โฑ๏ธ The Time-to-Close Impact
Mid-market firms that migrate from QuickBooks + Excel consolidation to LawAccounting's native multi-entity GL typically cut month-end close from 14 days to 5 days. That's not a small win for a controller โ it's the difference between leadership having current financial visibility and leadership making decisions on numbers that are six weeks old.
๐ What This Unlocks for the Firm
Once consolidation is automated, three downstream things become possible. Leadership gets near-real-time financial visibility instead of monthly retrospectives. Controllers spend their time on analysis and forecasting instead of stitching spreadsheets. And the firm's ability to evaluate strategic moves โ acquiring a smaller practice, spinning off a captive subsidiary, opening a new branch โ improves dramatically because the financial model is no longer the bottleneck.
- Most mid-market law firms operate across 2โ5 legal entities โ PC, LLC, captive subs, real estate LLC, branch offices โ and most legal accounting platforms can't handle this without Excel.
- Native multi-entity GL means one chart of accounts, entity-tagged transactions, automatic intercompany posting, and automatic eliminations at consolidation.
- LawAccounting on Salesforce supports unlimited entity hierarchies with entity-aware trust accounting for multi-state firms.
- Firms migrating from QuickBooks + Excel to native multi-entity typically cut month-end close from 14 days to 5.
- The downstream win is leadership getting near-real-time financial visibility instead of monthly retrospectives โ and faster strategic decision-making.
Stop Stitching Consolidations in Excel
See how LawAccounting handles multi-entity GL, intercompany eliminations, and consolidated P&Ls in a single Salesforce-powered platform built for law firm structures.
Schedule Your Demo โ