Featured on Smol Launch
Skip to content

Stop rebuilding
the cash model
every Sunday night.

TreoCast pulls actuals from QuickBooks and your bank feeds, rolls the 13-week forecast forward every morning, and tells you which week runs short before your client asks.

QuickBooks Online and 12,000 institutions through Plaid. Fourteen day money-back guarantee. First forecast takes about fifteen minutes to stand up.

N13
=FORECAST(next 13 weeks)$54,113ending balance, week of Oct 26

The formula equals FORECAST of the next 13 weeks. Cell N13 resolves to an ending balance of $54,113 in the week of Oct 26.

13-week rolling forecastNorthbay Fixtures LLC, base case
QuickBooks synced 4h ago
0Opening 82,040-30,15154,113
Shortfall week
Oct 5, -30,151
Estimated tax of 61,000 lands on a payroll Friday.
Cash covered through
9 weeks
Current trajectory, before the revolver draw.
Week 5 variance
+1,240
Collections ran two days ahead of the aging.
C4 opening 82,040.00, operating accountC7 payroll 38,500.00, every other FridayC9 estimated tax 61,000.00, week 10

Where the numbers come from.

The same seven lines, the same week 10, in two different places.

cash_model_v7_FINAL_v2.xlsx

Local copy
A
B
C
4
Opening, week 10
71,343.00
=Sep!M11
5
AR collections
23,914.00
=AR!F18*0.92
6
Deposits, retail
8,072.00
typed 8/2
7
Payroll, biweekly
-38,500.00
typed over formula
8
Rent and insurance
-14,780.00
=Fixed!C6
9
Estimated tax, Q3
-61,000.00
=#REF!
10
Vendor run
-19,200.00
=SUM(AP!G4:G31)
11
Ending, week 10
-30,151.00
=C4+SUM(C5:C10)
Last saved by Dan, 11:48pm.Row 9 broke when the Q2 tabs were archived.Three people have a copy. Two are current.

Northbay Fixtures LLC, week 10

Synced 4h ago
Opening, week 10
Operating account, Plaid, 6:04am
Actual
71,343
AR collections
QuickBooks aging, 41 open invoices
Forecast
23,914
Deposits, retail
Categorized from the bank feed
Forecast
8,072
Payroll, biweekly
Recurring, every other Friday
Scheduled
-38,500
Rent and insurance
Fixed commitments
Scheduled
-14,780
Estimated tax, Q3
Due Oct 5, flagged on Aug 12
Scheduled
-61,000
Vendor run
AP terms, 31 bills
Forecast
-19,200
Ending, week 10
Below zero. Draw 45,000 by Oct 2.
Base case
-30,151
Recalculated 6:04amBear, base, bullVariance to actualConsolidated or by entity

What it does, in six rows.

Read it the way you would read someone else's model. Label on the left, value in the middle, the note that explains it on the right.

18
13-week rolling forecast
13 wk
Rolls forward every Monday. Week 1 closes to actuals, week 14 appears at the far end, and the opening balance comes straight off the bank.
19
QuickBooks and Plaid
6:04am
Invoices, bills and balances land overnight. No CSV export and no mapping tab to repair on Monday.
20
Bear, base and bull
3 cases
Move collection days or push a payroll and hold all three cases side by side. The week that goes short is called out in each.Assumptions live on their own sheet, so a change is one edit, not eleven.
21
Variance to actual
+1,240
Forecast against actual, week by week, drivers ranked so you can explain the miss in one sentence.
22
Multi-entity consolidation
1 roll-up
Intercompany netted out. Click any line to drop back into the entity that produced it.
23
AI categorization
on approval
A new vendor gets mapped to a forecast line and waits for you. Approve it or override it, and the override sticks.

Launch pricing, half of list.

Billed monthly, cancel from the account page. The launch rate holds for as long as you keep the subscription. Both plans include the 13-week rolling forecast and the nightly sync.

Single Entity
$49per month$99

or $399 a year

One entity. For the operator or the in-house FP&A analyst.

  • 13-week rolling forecast
  • Unlimited bank accounts
  • AI transaction categorization
  • Bear, base, bull scenarios
  • Weekly variance analysis
  • Full audit log
Multi-Entity
$99per month$199

or $799 a year

Unlimited entities. For fractional CFOs running a book of clients.

  • Everything in Single Entity
  • Unlimited business entities
  • Consolidated reporting
  • Consolidated and per-entity views
  • Bank accounts assigned per entity
  • Priority support

Fourteen day money-back guarantee. If the first forecast does not hold up against your own file, write to us and we refund it. No setup fees, and no sales call to get a number.