Pre-built tabs for parent-child structure, intercompany elimination, and weekly variance. Built from real customer models. Drop your email and we'll send the .xlsx instantly with a 5-minute setup video.
Every tab a multi-entity CFO actually needs — and nothing they don't.
Up to 20 entities under a single holdco view. Drop in each entity's bank balances; the parent total auto-calculates. No formula edits needed.
Flag intercompany transfers with a column toggle so they net out at the consolidated level. No double-counting, no manual reconciliation.
Forecast vs actual by entity, color-coded by variance threshold (>10% red, 5–10% amber, <5% green). Spot drift before it compounds.
| 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 |
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.
A template is a great starting point — but multi-entity CFOs end up spending 6+ hours a week refreshing balances and reconciling intercompany. TreasuryFlow does that part for you.
Connect each entity's banks via Plaid. Every entity row updates daily — no copy-paste from 10 bank portals.
Set parent-child structure once. Switch between entity-level, sub-portfolio, and full-consolidated views with a click.
Wire transfers between your entities are detected and matched automatically. No manual elimination column.
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).
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.
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 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.
One workbook with 6 tabs: (1) entity setup, (2) per-entity bank balances, (3) intercompany flag column, (4) consolidated rollup, (5) 13-week forecast per entity, (6) CFO one-pager that prints landscape on letter-size paper. Plus a 5-minute setup video showing how to populate it the first time.
14 days free. No credit card. Live in 5 minutes — across every entity.