The Excel template multi-entity CFOs use to roll up cash positions across legal entities. Pre-built tabs for parent-child structure, intercompany elimination, and weekly variance. Built from real customer models. Free.
Download the template (Excel, free)
Drop your email and we'll send you the .xlsx instantly + a 5-minute setup video.
Parent-Child Rollups
Up to 20 entities under a single holdco view. Drop in each entity's bank balances; the parent total auto-calculates.
Intercompany Elimination Tab
Flag intercompany transfers with a column toggle so they net out at the consolidated level. No double-counting.
Weekly Variance Tracker
Forecast vs actual by entity, color-coded by variance threshold (>10% red, 5–10% amber, <5% green).
Industry-Tagged Rows
Pre-built taxonomy for PE-backed roll-ups, multi-property real estate (one entity per property), family offices, multi-location franchises.
Template Preview
Entity
Operating Bank
MMF / Savings
Intercompany
Total Cash
HoldCo Parent
$450K
$8.2M
—
$8.65M
OpCo 1 (PortCo A)
$1.1M
$2.4M
($300K)
$3.2M
OpCo 2 (PortCo B)
$890K
$1.5M
$300K
$2.69M
OpCo 3 (Real Estate)
$320K
$680K
—
$1.0M
Consolidated (after eliminations)
$2.76M
$12.78M
$0
$15.54M
The actual template includes: 13-week forecast tab per entity, weekly cash actuals tab, intercompany journal staging tab, and a CFO-summary one-pager that prints to letter-size landscape.
Want this auto-updated daily without rebuilding the spreadsheet every Monday?
TreasuryFlow's Reporting Groups feature does this in the product — connect each entity's banks via Plaid, set parent-child structure, and the consolidated view updates daily. No Excel macros, no manual re-link.
No. This is a CASH consolidation template — what's the parent's cash position right now across all entities? It's the daily/weekly tool a CFO or family office controller uses to manage liquidity. GAAP/tax consolidation is its own beast (your CPA handles that).
How is "intercompany" handled?
Each transfer between entities is a wash at the consolidated level — what leaves OpCo 1 arrives at OpCo 2. The template has an "intercompany flag" column on each entity's bank tab; flagged rows zero out in the consolidated total.
Does it work for real-estate one-entity-per-property structures?
Yes. The "OpCo" rows are generic — rename them to "123 Main St LLC", "456 Oak Ave LLC", etc. Real-estate operators with 5–20 single-property LLCs use this exact structure. Multiple banks per property (operating + reserve) supported via per-entity bank sub-rows.
When does TreasuryFlow's product beat this template?
When you have more than 5 entities, when intercompany transfers happen weekly+, or when you want it auto-updated each morning. Spreadsheets are great for static models; they break down when the underlying numbers move daily across many banks.