One-Click Consolidations
SumIt's one-click consolidation handles every type of consolidation your entity structure requires, including full consolidation, equity method, and net worth statement types. You can also combine different entities together, all without a single spreadsheet.
Close the books for each entity
Export them all to a separate spreadsheet tab
Manually calculate eliminations
Apply partial ownership percentages with custom formulas
Not all consolidations are the same, and SumIt doesn't treat them that way.
Full Consolidation
Simple Combine
Equity Method
Net Worth Statement
Generate each view without rebuilding anything from scratch.
Within a full consolidation, SumIt gives you precise control over how your output is structured. There are three ways to view it:
Single top-level view: Everything rolls up into one unified statement. Individual entities are not broken out — you see the consolidated whole.
Direct children only: Each entity one level below the consolidation is shown as its own consolidated column, but nothing beneath that tier is broken out separately.
Full detail view: Every entity at every level is visible alongside the consolidation, giving you both the granular breakdown and the rolled-up total in one place.
The most tedious part of any consolidation — handled automatically.
In a traditional Excel consolidation, removing inter-entity transactions is a manual nightmare. You'd have to identify every journal entry that crosses entity lines and build custom elimination columns by hand. Miss one, and your consolidated statement is wrong.
SumIt knows your entity structure natively. The moment you run a consolidation, it automatically identifies and removes inter-entity journal entries in the background.
"We’ve been able to migrate complex clients (150+ entities) and make reporting as easy as a click of a button."
Phil Boscarino
Director of Family Office Services at Mariner Ultra
One-Click Consolidations FAQ
What types of consolidations does SumIt support?
SumIt supports four consolidation types purpose-built for family offices: full consolidation, simple combine, the equity method, and the net worth statement.
How does SumIt handle inter-entity eliminations in a consolidated report?
Can SumIt consolidate entities with partial ownership structures?
How is SumIt's consolidation different from doing it in QuickBooks or Excel?
Do I need to reconfigure anything to run a different type of consolidation report?
Try SumIt Today
Modernize Your Back Office, Today.
Talk to us to learn more about SumIt and we will help you evaluate our platform. We care about your success and can help you find out quickly if SumIt can be a good fit.
