9 entities. 87 workbooks. One person keeping it all straight.

August 4, 2026

‍

Welcome back to Bridging the Deficit, your go-to resource for financial planning insights—real-world advice you can actually use, not just theory.

This week we're talking about something most companies don't realize:

You didn't fail. Your multi-entity company outgrew Excel.

Especially if it's now several companies.

If you budget or forecast across more than one entity, you already know the specific hell of it.

The workbook that broke last quarter because someone changed a currency assumption in tab 14. The intercompany eliminations you still do by hand because they never look quite the same twice. The 87 tabs across 32 locations (that's a real customer, a co-op running 60+ member locations) that nobody but you can safely touch. The month-end that quietly ate a month.

Your business now has more dimensions than a two-dimensional grid can hold. Entities, funders, currencies, locations, cost centers. Excel doesn't fail on multi-entity companies. It suffocates them.

‍

In this issue:

• What actually changes with a real consolidation engine
• Recognize your shape
• What Centage does here, plainly

‍

Consolidation: What actually changes with a real consolidation engine

Three specific things:

• A pet-food-ingredient manufacturer running multiple entities across Sage Intacct and NetSuite went from a 30-day quarterly consolidation to a 1-day monthly one. Not because they hired more people. Because the eliminations, the intercompany, and the multi-currency conversions run themselves.
• A wholesale distributor rolling 7 companies across 3 countries now sees one live P&L. Their CFO checks it on a Monday morning like a dashboard.
• A regional law firm replaced 9 hand-eliminated entities with a system that does the math the same way twice.

Speed matters because of what it enables. Variance conversations before the board meeting instead of after. Forecast revisions that reflect this week's numbers instead of last month's. A finance team that spends its calendar on judgment instead of assembly.

Picture this: It's 9:47 pm on a Sunday. Your board packet goes out at 8 am.

You're staring at a consolidated P&L where entity 4's intercompany receivables ($312K) don't tie to entity 7's payables ($307K). You already see the fix. Someone updated the EUR-to-USD rate in one workbook last Wednesday and never pushed it through the linked tab.

Rebuild the tie-out (four hours). Footnote the $5K variance (twelve minutes). Wake your senior analyst (unknowable relationship cost).

If you have ever picked the footnote, this piece is for you.

‍

Diagnose it: Recognize your shape

There are three flavors of multi-entity, and the same trap sits under all three:

1. Consolidation-driven. You roll many entities into one P&L. (If you know how many days your last close took, you're this.)
2. Allocation-driven. One organization, dozens of funds and departments that need real allocation math. (Common for nonprofits: 10 departments, 30 funding sources, and rules that differ between budget and projection.)
3. Compliance-driven separate books. Multiple entities that must stay on separate compliance books and still roll up cleanly. (Housing, healthcare, franchise operators.)

Whichever you are, the workbook is the same trap. The exit is a system built to hold the shape of your business. You already know Excel can't do this. You've been holding it together on formula chains and grit.

‍

What Centage does here, plainly

• Automated multi-entity consolidation. Unlimited entities.
• Automated intercompany eliminations and reconciliations.
• Multi-currency with real-time conversion.
• Finance-owned. No IT project. 4 to 6 week implementation. $18K to $40K a year.

👉 See it in a demo

‍

About Centage

Centage delivers the complete FP&A platform—budgeting, forecasting, reporting, and scenario planning—designed to free finance teams from spreadsheet chaos.

For organizations where strategic finance matters, Centage replaces manual processes with automated workflows, real-time collaboration, and seamless integrations—so finance leaders can stop maintaining spreadsheets and start driving decisions.