Consolidating Multi-Entity Books Without Leaving Excel: What Vena's New Financial Consolidation Product Means for Growing Small-Business Groups

Your group close runs on a spreadsheet chain that only one person fully understands, and that person is on vacation during close week. Every month you export three trial balances, paste them into a master workbook, hand-key the intercompany eliminations, and hold your breath until the balance sheet balances. It works until the month it does not — and research keeps telling us that month comes sooner than finance teams expect: studies routinely find that the large majority of business spreadsheets used in decision-making contain errors, and half of finance teams name Excel as a top reason their close runs slow.

That is the exact pain Vena Solutions is betting its newest product on. In May 2026 the company unveiled Vena Financial Consolidation at its Excelerate Finance Fest conference, and in August it announced general availability: an Excel-native consolidation product that handles intercompany eliminations, foreign-currency translation, and ownership structures inside the spreadsheet interface finance teams refuse to leave. Vena's own 2026 FP and A Impact Report found that 90 percent of finance professionals still use Excel for modeling and reporting — so instead of asking teams to abandon the grid, Vena is putting governed consolidation inside it.

Whether or not you ever buy the product, the launch is a useful forcing function. If you run two or more entities — an operating company plus a holding company, a US parent with a foreign sub, a main business with a side venture in its own LLC — here is what real consolidation requires, where spreadsheet closes break, and what to fix in your own books now.

Why multi-entity consolidation breaks in spreadsheets​

Consolidation is simple in principle: combine every entity's trial balance, then remove everything the group merely did with itself so the statements show only dealings with the outside world. Under US GAAP that single-economic-entity view is the law — ASC 810 requires intercompany balances and transactions to be eliminated in full. The mechanics, though, are where spreadsheet closes die:

• Intercompany eliminations only work when both sides agree. The parent books a $5,000 management-fee receivable from the subsidiary; the subsidiary must book the matching $5,000 payable. If one side posts late, books a different amount, or uses a different account, the elimination nets to something other than zero and the group statements quietly overstate both revenue and expense.
• Every entity maps its own chart of accounts differently. Each company was set up at a different time, often by a different bookkeeper, so "office supplies" in one ledger is "general admin" in another. Mapping hundreds of accounts to group lines by hand every month is exactly the repetitive paste-and-match work where errors creep in.
• Currency translation adds days. A foreign subsidiary's books must be translated — typically assets and liabilities at the current rate, income-statement items at average rates — before they can combine with the parent's. Manual translation is fiddly, unaudited, and a classic source of plug figures.
• Version chaos destroys the audit trail. The master workbook gets emailed around, saved as "Consol FINAL v7 ACTUAL," and adjusted after the close with no log of who changed what. Benchmark data puts the median month-end close at 6.4 business days, with the slowest quartile past ten — and spreadsheet-chained groups cluster at the slow end.

None of this is an argument that Excel is unusable. It is an argument that the consolidation logic — the eliminations, the mappings, the translation rules — needs to live in a governed layer rather than in one person's head and one fragile workbook.

What Vena actually shipped​

Strip away the launch language and the product has three load-bearing pieces, each aimed at one of the failure modes above:

1. Structured intercompany eliminations. Intercompany sales, loans, management fees, and dividends are defined once as rules, then applied every period — so the elimination no longer depends on someone remembering to hand-key it in the master file.
2. Currency translation and ownership structures. Multi-currency subs and partial ownership (with noncontrolling interests) are handled in the same model, which matters the moment your group outgrows a single domestic parent-and-sub pair.
3. A governed, Excel-native surface. The interface stays a spreadsheet, but submissions, mappings, and adjustments carry workflow and audit history. The pitch is aimed squarely at the 90 percent who never left Excel: keep the grid, lose the "Final v7" chaos.

Vena also used the same event to push agentic AI deeper into planning workflows — a Planning Agent that drafts forecasts and a governed data layer shared with Acterys — but for a small-business group the consolidation product is the part that touches the monthly close. The honest read of the announcement is not "everyone needs this software" but "the vendor with the best view of Excel-based finance teams sees consolidation as painful enough to build a whole product around." That should tell you where to look in your own process.

The consolidation checklist for a growing group​

You do not need new software to close like a group that has it. You need the disciplines the software enforces. Work through these in order:

1. Draw the group chart first​

Before you build a single schedule, sketch every entity, who owns what percentage of whom, and which pairs trade with each other. Partial ownership changes everything downstream — a 70-percent-owned sub's outside shareholders get a noncontrolling-interest line — and groups routinely discover "oh, those two bill each other" halfway through the close. The chart takes an hour and prevents a week of rework.

2. Standardize the chart of accounts mapping​

Agree one group mapping from each entity's local accounts to consolidated lines, and write it down where the whole team can see it. New accounts get mapped when they are created, not discovered at close. This single document eliminates the largest category of spreadsheet-consolidation errors: the same expense landing on different group lines depending on who pasted it.

3. Reconcile intercompany balances before the close starts​

Set a hard rule: all intercompany activity for the period posts by an early deadline — say business day two — and every balance is confirmed by both counterparties before eliminations run. The close should consume matched balances, not discover mismatches. Common culprits when the two sides disagree: one entity recorded a transfer the other has not picked up yet, fees were booked gross on one side and net on the other, or someone posted to the wrong counterparty subaccount.

4. Eliminate in full, every period​

The standard elimination set for a small group:

• Intercompany revenue against intercompany expense (sales, management fees, rent between entities)
• Intercompany receivables against intercompany payables (including loans)
• Dividends a sub paid to its parent (a distribution inside the group, not group income)
• The parent's investment account against the sub's equity
• Unrealized profit sitting in inventory or fixed assets one entity sold to another — the elimination everyone forgets, because the profit looks real until the group sells outside

A concrete example makes the mechanics plain. Suppose Parent A bills its subsidiary $5,000 a month for shared back-office costs. Each side books its half:

2026-10-31 * "Parent A" "October management fee billed to Sub B"
  Assets:Intercompany:Receivable:Sub-B  5,000.00 USD
  Income:Management-Fees  -5,000.00 USD
 
2026-10-31 * "Sub B" "October management fee from Parent A"
  Expenses:Management-Fees  5,000.00 USD
  Liabilities:Intercompany:Payable:Parent-A  -5,000.00 USD

At consolidation, the $5,000 of income and the $5,000 of expense cancel, and the receivable cancels the payable. The group statements show nothing — correctly, because no money left the group. If Sub B had booked $4,800 by mistake, the elimination would leave a stray $200 of phantom revenue and a $200 unmatched balance: exactly the mismatch your pre-close reconciliation in step 3 exists to catch.

5. Translate foreign subs with stated rates​

Pick your rate policy — closing rate for balance-sheet items, average rate for income and expenses, with the difference parked in the currency-translation adjustment — and record which rates you used each period. A translation nobody can re-perform is a plug figure with extra steps.

6. Lock the close and log late adjustments​

Once the consolidated trial balance is final, it is final. Post-close adjustments go through a visible adjustment log with a reason, not a silent edit to last week's workbook. Auditors forgive errors with a trail far faster than they forgive clean-looking numbers with none.

Mistakes that survive every software upgrade​

Tools like Vena's automate the mechanics, but four errors are procedural and follow you into any platform:

• Netting instead of eliminating. Booking intercompany activity net (recording only the difference) instead of eliminating gross amounts hides the volume of internal trading and misstates both revenue and expense lines. Eliminate gross, always.
• Forgetting the parent's own books need to stay clean. Consolidation adjustments belong in the consolidation layer, never posted back into an entity's ledger. The moment elimination entries leak into operating books, next period's opening balances are fiction.
• Treating distributions as revenue. A dividend from your sub to your parent company is not income to the group — it is cash moving between your own pockets. Groups that book it as revenue overstate top line by the exact amount they paid themselves.
• Closing the entities on different timelines with different policies. If one entity accrues expenses and another runs cash-basis until year-end, you are consolidating two different accounting languages. Align revenue recognition, accruals, and cut-off policies across entities before you combine anything.

When Excel-native consolidation software earns its keep​

For a two-entity domestic group with modest intercompany traffic, the checklist above plus disciplined spreadsheets is genuinely enough — and free. The products start paying for themselves when at least two of these are true:

• Three or more entities, or entities in more than one currency
• Heavy intercompany volume: shared payroll, cross-entity inventory, internal loans, regular management fees
• An outside audience for the consolidated statements: a bank covenant, an investor, an audit, or a sale process that will ask how the numbers were produced
• A close that already takes more than a week and gets longer every quarter

If that is you, evaluate Excel-native consolidation tools (Vena's launch is the newest entry, not the only one) against the same checklist: governed eliminations, stated FX rules, ownership handling, and an audit trail an outsider can follow. And if it is not you yet, take the cheaper win — the checklist costs nothing, and the group that outgrows spreadsheets with clean mappings and matched intercompany balances migrates in weeks, while the group that outgrows them with "Final v7" chaos migrates in quarters.

Reconcile one intercompany balance this week​

Open last month's close and pick the single largest intercompany balance — the management fee, the working-capital loan, the shared-payroll recharge. Confirm both sides match to the dollar, in the right period, against the right counterparty. If they do, you have verified the seam where most group misstatements start, and this post was a cheap confirmation. If they do not, you have found the exact mismatch an acquirer's due diligence or your auditor would find next — fix the posting discipline now, put the matching rule on the calendar before every close, and let the software decision wait until your process deserves it.