Drop in the same Excel file you already maintain — sheets, line items, formulas, and all. TreasuryFlow learns your structure, then auto-fills actuals from your bank every week. No new tool to learn. No copy-paste from portals.
We parse a copy. The original .xlsx in your file system is never touched.
Your formulas, formatting, and layout stay exactly as you built them. We fill cells — we don't redesign.
Map sheets to brands, confirm rows, done. Re-uploads next week reuse the mapping automatically.
Most cash-forecasting tools ship you their template and ask you to bend. TreasuryFlow bends to your template — the exact one your bank, board, and lender already know.
One file. Up to 10 MB. Sheets, named ranges, weekly columns, formulas — we read what's there. Nothing leaves your account.
2026 Cash Forecast - Week of 05.04.26.xlsx
Brand sheets, line items, weekly columns, header dates. The parser proposes a mapping; you tweak in seconds.
Each brand sheet gets paired with its Plaid-connected accounts. We suggest matches; you confirm or override.
Every week, your actuals appear in the actual cells — pulled from real bank data. Your forecast cells stay yours.
A clear contract: every formula, every layout decision, every column header is yours. We just make sure the actual cells are right every weekday morning.
=SUM(), =B12+SUM(), lookup tables — preserved exactly
If you run finance for a roll-up, a multi-property real estate company, a family office, or a portfolio of operating brands — this is the page you've been waiting for.
Tab through Bonney, Peter Levi, Gallagher's, Big Air. Each carries its own variance pill so you see at a glance which brand is off-plan. The portfolio rollup nets out intercompany transfers and gives you the holdco view your owner asks for.
Drop next week's copy and we recognize the file. Same mapping, this week's values. Zero re-work.
When the board needs the workbook, click Push to Excel and download a .xlsx with our actuals dropped into your existing file — all formulas intact, all formatting preserved.
Empty cells show a soft italic suggestion based on the 13-week median and seasonal trend. Tab to accept, or type to override. You're never staring at a blank grid.
Cash, change, and alerts hit your inbox every morning. The CFO morning brief lands before your first coffee — no login required.
“TreasuryFlow is a powerful solution that provides bank account consolidation, dynamic reporting, data visualization and forecasting that your bank can’t offer. Any finance professional responsible for cash flow management would benefit from it.”
Microsoft Excel .xlsx with up to 30 sheets, 500 rows per sheet, 80 columns per sheet, and 10 MB file size. That covers virtually every cash forecast we've seen — including 4-brand × 52-week portfolios. CSV / .xls support is on the short-term roadmap.
No. Your formulas stay intact. Your column ordering stays intact. Your conditional formatting and merged cells stay intact. We parse a copy — the original file on your file system is never touched. The only thing we do is fill the actual cells in TreasuryFlow's grid view, and when you Push to Excel we drop those actuals into a new copy of your workbook.
We fingerprint the filename and sheet structure. If it scores 75%+ similar to a previous upload, we surface a banner: "Looks like a new copy of Bonney 13-week portfolio. Reuse the existing mapping?" One click and we load this week's values without re-mapping anything. The auto-match is silent if the file is brand new.
Yes — that's the whole point. After upload, each brand sheet gets paired with one or more Plaid-connected accounts. We auto-suggest matches based on sheet name vs. account name (Bonney sheet → "Bonney Operating · Chase"); you confirm or override. Actuals for that brand pull from the matched accounts only — no commingling.
You map line items to category rules during onboarding (e.g., "Payroll" pulls all transactions where merchant matches Gusto / ADP / Paychex; "Operating Costs" is a 12-vendor allowlist). Once mapped, actuals compute deterministically every week. You can edit any rule in seconds.
No. Your bank data flows over Plaid's read-only API directly into your TreasuryFlow account. Transaction amounts are bucketed before any AI categorization (Micro / Small / Medium / Large / XLarge) so nothing precise crosses an AI boundary. Exact values appear only in your own browser and your own Excel exports.
Start with our free 13-week cash forecast template or free multi-entity consolidation template. Both follow the same structure that BYOT-Forecast parses cleanly — you'll be live in minutes.
Upload your existing cash forecast. Map sheets to brands once. From next week on, actuals fill themselves — in your file, with your formulas, on your timetable.