QuickBooks for Cannabis: Multi-Entity Financial Consolidation

9 out of 10 of cannabis companies run their books on QuickBooks. Most of those companies operate at least three legal entities across multiple states. QuickBooks Online has zero native consolidated reporting. That gap - between how cannabis businesses are structured and what their accounting platform actually does - is where controllers lose entire weeks every month to manual Excel exports, mismatched charts of accounts, and consolidation workbooks that break the moment someone miscodes a transaction.

Our finance team uses a QBO add-on called JustConsolidate to run multi-entity consolidation for cannabis clients, and it eliminates the spreadsheet dependency for a fraction of what enterprise platforms cost.

The Consolidation Gap in QBO

Vertical integration across cultivation, manufacturing, distribution, and retail typically means separate licenses and often separate entities at each stage. Layer in 280E cost segregation strategy, non-plant-touching management companies for banking access, and liability isolation across verticals, and a mid-size MSO can easily hit 10-15 entities before they've expanded beyond two states.

Each of those entities lives in its own QBO file. There's no consolidated P&L, no combined balance sheet, no unified cash flow statement. The standard workaround is exporting trial balances from each entity into Excel and manually building consolidation workbooks - a process that takes half of all businesses six or more days per close cycle. For cannabis MSOs dealing with intercompany supply chains, state-specific COA variations, and 280E documentation requirements, month-end close stretches to 10-15 days versus 3-5 for a comparable traditional retail operation.

That's not a minor time sink. At loaded Finance Controller rates, it's tens of thousands of dollars annually spent on reconciliation labor rather than strategic finance work.

How JustConsolidate Works

JustConsolidate sits on top of your existing QBO ecosystem. It connects your subsidiary entities and consolidates their financials into a designated parent company - all within QuickBooks. No CSV exports. No spreadsheet reconciliation. No separate reporting platform to learn.

The setup follows four stages:

1. Connect your entities. Create a new QBO company to serve as your consolidation parent (requires QBO Plus or Advanced for the Category field used in division tracking). Then connect each subsidiary through Intuit's OAuth - a few clicks per entity, no manual data entry. Subsidiaries can be on any QBO tier since JustConsolidate only reads their data. You can set ownership percentages if you need proportional consolidation rather than the default 100% equity method.

2. Map your charts of accounts. This is the most time-intensive step, but it's a one-time effort. JustConsolidate runs three rounds of auto-matching - exact match, then 80%+, then 50%+ similarity - and surfaces remaining unmapped accounts for manual alignment. For cannabis operators with state-specific COA variations across entities, this is where you standardize everything into a single parent structure. Bulk mapping and Excel import/export options speed up the process for larger entity counts.

3. Run the consolidation. Select a fiscal month, click "Run Workflow," and JustConsolidate extracts subsidiary balances and reformats them to your parent COA in trial balance format. You can process all subsidiaries simultaneously. Review the proposed journal entries, confirm, and post — the entries land in your parent QBO company with division tags identifying each subsidiary by name and Realm ID.

4. Handle intercompany eliminations. This is optional but critical for cannabis operators running vertically integrated supply chains where product moves from cultivation to manufacturing to distribution to retail across separate entities. Designate an elimination division, select the intercompany accounts, and JustConsolidate proposes balanced elimination entries based on current-period activity. The system flags imbalances automatically - if your proposed elimination doesn't balance, it means intercompany transactions aren't recorded consistently across subsidiaries, and you know exactly where to look.

Why This Matters for Cannabis Specifically

Multi-entity consolidation isn't a nice-to-have in cannabis - it's a compliance and survival requirement. Three dynamics make it non-negotiable:

Intercompany supply chain visibility. When your cultivation entity sells to your manufacturing entity, which sells to your distribution entity, which supplies your retail locations, every link in that chain is an intercompany transaction that must be eliminated on consolidation. Miss an elimination and you're double-counting revenue. In an industry where the IRS already scrutinizes cannabis financials at rates far above other sectors, inflated consolidated revenue is an audit magnet.

280E documentation integrity. Proper COGS allocation under 280E requires entity-level precision. A consolidated view that traces cost flows across verticals, with clean elimination entries and documented intercompany pricing, gives your CPA defensible workpapers rather than a spreadsheet that took 12 days to build and contains formula errors.

Investor and lender reporting. Capital providers need consolidated financials. Delivering them two weeks after month-end from a fragile Excel workbook signals operational immaturity. Delivering them from your accounting system, with clear subsidiary breakdowns and automated eliminations, signals a finance function that scales.

The Cost Equation

JustConsolidate runs $15/month base plus $5/month per connected entity. A five-entity cannabis operation pays $40/month. A ten-entity MSO pays $65/month.

Compare that to the alternatives: Sage Intacct and NetSuite start north of $500/month with implementation costs measured in five and six figures. For operators already embedded in the QBO ecosystem who aren't ready for (or don't need) an enterprise ERP migration, JustConsolidate delivers 80% of the consolidation value at less than 10% of the cost.

Getting Started

If you're running multiple cannabis entities on QuickBooks and still consolidating in spreadsheets, JustConsolidate is available in the QuickBooks App Store.

Our finance team at HQ has implemented this for multi-entity cannabis clients and can help with the initial COA mapping, consolidation configuration, and intercompany elimination setup - the upfront work that determines whether the tool actually saves you time or just adds another system to manage.