Drop in the Excel file you already maintain: sheets, line items, formulas and all. TreasuryFlow learns your structure and auto-fills actuals from your bank every week.
| Line item | W19 May 4 |
W20 May 11 |
W21 May 18 |
W22 May 25 |
W23 Jun 1 |
W24 Jun 8 |
W25 Jun 15 |
|---|---|---|---|---|---|---|---|
| Receipts | 412,800 | 395,000 | 395,000 | 410,000 | 410,000 | 425,000 | 425,000 |
| Payroll Bi-weekly · Fri | (187,400) | – | (189,000) | – | (190,000) | – | (192,000) |
| 401k ~6% of payroll | (11,244) | – | (11,346) | – | (11,400) | – | (11,520) |
| Operating Costs 12 vendors | (94,200) | (98,000) | (98,000) | (98,000) | (100,000) | (100,000) | (100,000) |
| Net Cash Flow =SUM(B4:B7) | 119,956 | 297,000 | 96,654 | 312,000 | 108,600 | 325,000 | 121,480 |
| Ending Cash =A9+SUM(B4:B7) | 2,339,956 | 2,636,956 | 2,733,610 | 3,045,610 | 3,154,210 | 3,479,210 | 3,600,690 |
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.
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(), and lookup tables, all 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 for you.
Tab through every brand. Each carries its own variance pill. 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.
Empty cells show a soft italic suggestion based on the 13-week median and seasonal trend. Tab to accept, or type to override.
Cash, change, and alerts hit your inbox every morning. The CFO morning brief lands before your first coffee, no login required.
“Bank account consolidation, dynamic reporting, data visualization and forecasting that your bank can’t offer.”
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. CSV and .xls are on the short-term roadmap.
No. Your formulas, column ordering, conditional formatting, and merged cells stay intact. We parse a copy; the original file is never touched. Actuals fill TreasuryFlow's grid view; Push to Excel drops them into a new copy of your workbook.
We fingerprint the filename and sheet structure. If it scores 75%+ similar to a previous upload, a banner asks: "Looks like a new copy of Northwind 13-week portfolio. Reuse the existing mapping?" One click loads this week's values without re-mapping.
Yes. Each brand sheet pairs with one or more Plaid-connected accounts. We auto-suggest matches from sheet name vs. account name; 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: "Payroll" pulls every transaction where the merchant matches Gusto, ADP, or Paychex; "Operating Costs" is a 12-vendor allowlist. Once mapped, actuals compute deterministically every week. Any rule edits in seconds.
No. Your bank data flows over Plaid's read-only API, and we never train any model on your data. Our categorization engine only sees magnitude ranges, never exact amounts; features you invoke by name receive actual figures. See our Privacy Policy.
Start with our free Monday Cash Close board. It follows the same structure that BYOT-Forecast parses cleanly, so 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.
MP