QuickBooks Alternative for Multiple Entities in Canada

QuickBooks is a good place to start, and it can carry a company with a second entity for a while. Eventually, though, running several companies as separate files stops being a bookkeeping detail and starts slowing down every month-end. This post covers the signs you have reached that point, how to tell whether the problem is the software or the setup, and what to look for in a QuickBooks alternative for multiple entities.

Where QuickBooks Works and Where It Stops

QuickBooks is built around one company file. For a single legal entity, classes and locations handle departments, branches, and projects, and the reporting is enough for most owners, lenders, and boards. The strain starts when the business becomes more than one legal entity: an operating company and a holding company, a second company set up for a new location or line of business, or a related company that shares costs with the first.

Each of those is its own company file, so everything that spans entities, from consolidated statements to the money one company owes another, is handled by hand or with tools bolted on.

Signs Separate Files Have Stopped Working

Most companies notice several of these at once:

• Month-end includes a consolidation step that someone rebuilds in a spreadsheet every month.
• Intercompany balances are reconciled and eliminated by hand.
• The same customers, vendors, and accounts are set up separately in each file and slowly drift apart.
• A Canadian entity and a US entity need to be reported together.
• The consolidated numbers depend on one person who understands the spreadsheet.
• A lender, auditor, or board asks for consolidated statements and they can't be produced quickly.

Consolidating Multiple QuickBooks Companies by Hand

The manual consolidation is where the time goes. Someone exports each entity's reports, lines up accounts that were named differently in each file, adds the entities together, and removes what the companies owe each other so the totals aren't overstated. The intercompany balances then have to agree on both sides, and when they don't, someone finds out why.

The work is repeatable but fragile. A spreadsheet carries the consolidated numbers, one person understands it, and a changed account or a new entity breaks it. Lenders and auditors reasonably ask where the consolidated figures come from, and "a spreadsheet" is a weak answer when the books it is built from live in separate files.

Canadian and US Entities

A Canadian company with a US subsidiary adds a second problem. QuickBooks Online does not consolidate across its regional versions, so you can't consolidate a Canadian and a US QuickBooks company in one report. Currency translation, and the exchange differences it creates, are then handled outside the software as well. For a business that expects to keep growing across the border, this is often where the manual approach stops being worth it.

Is It the Software or the Setup?

Not every company with two files has outgrown QuickBooks. Check the setup first:

• Departments, branches, and projects within one legal entity belong in classes and locations in a single file, not in separate files.
• Entities that share the same chart of accounts, with the same account names and numbers in every file, consolidate far more easily.
• Two entities with little intercompany activity and one currency can stay on a simple consolidation for a good while.

If the setup is already clean and month-end is still a rebuild, the software is the limit. The same test applies in construction, which we cover from the contractor's side in When to Upgrade From Sage 50 or QuickBooks in Construction.

What Staying on QuickBooks Can and Cannot Cover

QuickBooks Desktop Enterprise goes further than other editions. It can combine reports from several company files, and its Platinum and Diamond subscriptions add intercompany transactions. Add-on tools and a well-built spreadsheet can also pull reports from separate files into one view.

All of these approaches leave the entities in separate files. The consolidation sits on top of the books instead of inside them, so you still maintain parallel charts of accounts, and each new entity or currency adds to the work. That is workable for a small group of entities. It is a weak foundation for a group that is growing.

What a Multi-Entity System Does Differently

Multi-entity accounting software keeps the entities in one system. In Sage Intacct, you can report on a single entity or on all of them together without exporting anything. When a transaction spans entities, such as one company paying a bill for another, Intacct posts the offsetting due-to and due-from entries in each entity once the inter-entity accounts are mapped. Consolidation then eliminates those inter-entity balances automatically, translates each entity's figures at the right exchange rates, and records the exchange differences in a cumulative translation adjustment account.

That replaces the monthly rebuild with a process the system runs. Contractors running more than one company can see how this works in their industry in Sage Intacct Construction Canada: What It Gives Contractors.

What a Move Involves

A move to Intacct is a project, not an install. Each entity's chart of accounts is mapped to a common structure, open balances are brought across, and the first month-end or two are run alongside the old files so the numbers can be checked before anyone relies on them. The inter-entity accounts and consolidation rules are set up once, up front, and this is where experience matters. The risks are the usual ones for any financial software project, covered in Overcoming Financial Software Implementation Challenges.

We often say that software is only 50% of the solution. The other half is how the entities are structured in the system, how well your team is trained, and who supports you after go-live.

Learn More

If you are weighing a change, the Financial System Audit page explains what a review of your current setup produces.