Finance & FP&A

How to build a 13-week cash flow forecast as Fitness Studio Founders

Finance & FP&AFor Fitness Studio Founders3 apps12 steps~24 min to set up

You run a yoga studio or CrossFit box and your cash position lives in three places: a Mindbody or Wodify billing screen you refresh manually, a Plaid-connected bank account your bookkeeper checks monthly, and a Google Sheet you updated six weeks ago. When rent is due on the 1st and a new piece of equipment hits the card on the 15th, you're doing mental math — not looking at a forecast. You have no idea what your cash balance looks like in week 9. You've never built a 13-week model because the last time you tried, it took a Sunday afternoon and was stale by Wednesday.

Build this on Starch → See the apps used

Finance & FP&AFor Fitness Studio Founders3 apps12 steps~24 min to set up

Outcome

What you'll set up

A rolling 13-week cash flow forecast that pulls your real bank transactions from Plaid and real membership revenue from Stripe, so the baseline is always this week's actual numbers — not last month's

A scenario view that shows you what happens to your runway if you add a second evening Pilates block, drop a ClassPass tier, or push instructor pay increases by six weeks

A weekly spending digest that flags when your supply vendor, music licensing, or software subscriptions run higher than their usual range — before you're surprised at end of month

The Starch recipe

Apps, data, and prompts

The combination of Starch apps, the data sources they pull from, and the prompts you use to drive them.

Apps used

Runway Analysis Scenario Analysis Transaction Insights

Data sources & config

Starch syncs your Plaid bank feed and Stripe revenue data on a schedule — transactions, balances, and charges update automatically so your forecast reflects this week's actuals, not last month's close. Mindbody and Wodify don't offer open APIs to independents, so Starch pulls your attendance and billing data through browser automation — no API needed, no CSV exports. All three apps — Runway Analysis, Scenario Analysis, and Transaction Insights — draw from the same underlying synced data so your forecast, your scenarios, and your spending alerts stay consistent with each other.

Prompts to copy

Connect my Plaid bank account and Stripe account and build me a 13-week cash flow forecast. Show inflows by week — membership revenue, drop-ins, retail — and outflows by category: rent, instructor pay, software, supplies, and ClassPass settlement. Flag any week where my projected ending balance drops below $8,000.

Build me three scenarios side by side: one where I add a Friday evening class at $22 average ticket and hire one part-time instructor at $1,200/month, one where I hold current pricing and class count through summer, and one where I discount a 10-class pack by 15% to drive retention. Show runway and week-10 cash balance for each.

Pull every transaction from my Plaid account for the last 90 days and group them into: instructor pay, rent and utilities, Mindbody and software subscriptions, supplies and equipment, and marketing. Flag any vendor that charged more than 20% above their average in the last 30 days.

Run these in Starch → or paste them into your favorite agent

Walkthrough

Step-by-step

1 Connect your business checking and savings accounts through Plaid. Starch syncs your full transaction history — categorized by vendor and amount — on a schedule. This is your outflow baseline.

2 Connect Stripe. If you sell memberships, class packs, or retail through Stripe, Starch syncs charges and payouts so your inflow side of the forecast reflects actual collected revenue, not invoices.

3 Open Runway Analysis and tell Starch how your revenue categories map to your studio: 'Membership revenue is the recurring Stripe charge labeled Monthly Unlimited or 10-Class Pack. Drop-in revenue is any charge under $30. Retail is anything from our Square POS.' Starch builds the inflow rows.

4 Define your weekly outflow categories in plain language: 'Rent is the $4,200 ACH to [landlord] on the 1st. Instructor pay is any transfer to [payroll account] or check cleared to the three instructors. Mindbody is the $175 charge on the 14th. Everything else, categorize by vendor.' Starch maps your Plaid transactions to these buckets.

5 Set your cash floor alert. Tell Starch: 'Flag any week where projected ending balance drops below $8,000 and send me a Slack message.' Starch wires this to your connected Slack channel.

6 Open Scenario Analysis and build your first what-if: describe the assumption change — adding a class, hiring a coach, cutting a ClassPass tier — in plain language. Starch uses your actual Stripe and Plaid baseline and adjusts only what you specify.

7 Run a second scenario for your summer slow-down: 'Assume membership revenue drops 18% in weeks 8 through 13 based on last summer's pattern, and model what happens if I delay the equipment lease by four weeks.' Compare week-10 cash balance across both scenarios.

8 Open Transaction Insights and ask Starch to flag recurring subscriptions you might have forgotten: 'List every vendor that has charged my account at least twice in the last 60 days, sorted by total spend.' You will almost always find two or three software tools you're not actively using.

9 Set a spending anomaly alert in Transaction Insights: 'Alert me if any single vendor's charge is more than 25% higher than their trailing 60-day average.' This catches your music licensing overage or a Mindbody fee tier bump before it compounds.

10 Schedule a Monday morning summary automation: 'Every Monday at 7 a.m., pull this week's projected cash position from Runway Analysis, show me last week's three largest expense categories from Transaction Insights, and Slack me the summary.' Now your weekly cash check-in is a 30-second read instead of a spreadsheet session.

11 Revisit the forecast at the start of each month. Tell Starch: 'Refresh the 13-week model with last month's actuals and roll forward. If my month-end cash came in more than 10% above or below the forecast, flag it and tell me which category drove the variance.' Starch surfaces the explanation — usually instructor overtime or a promotional period hitting differently than expected.

12 Share a read-only version with your accountant or investor: 'Export this week's 13-week cash flow table as a PDF with the scenario comparison attached.' Starch generates it without you rebuilding anything from scratch.

See this running on Starch

Connect your tools, describe what you want, and the agent builds it. Closed beta is free.

Try it on Starch →

Worked example

March 2026 — Pilates studio, 187 active members

Sample numbers from a real run

Stripe membership revenue (weeks 1-4)	18,400
Stripe drop-in and class pack revenue (weeks 1-4)	3,200
Retail (resistance bands, blocks) via Square browser pull	640
Rent — ACH on March 1	-5,800
Instructor pay (3 instructors, bi-weekly)	-7,200
Mindbody subscription	-175
Music licensing (ASCAP)	-52
Studio supplies and cleaning	-310
Instagram and Meta ads (March campaign)	-900
ClassPass settlement — net payout week 3	1,850
Equipment lease payment (reformers)	-1,400
Projected week-13 ending cash balance	12,480

In early March, the studio owner ran the 13-week forecast and saw that week 6 — the week after spring break — was projecting a $6,200 ending cash balance, below the $8,000 floor she'd set as her comfort threshold. Starch flagged it automatically on Monday morning. Drilling in, Transaction Insights showed that the equipment lease renewal ($1,400) and a Mindbody tier upgrade ($175 to $310) were both hitting week 6, while ClassPass settlement — normally $1,850 — wasn't expected until week 7. She ran a scenario: 'What if I push the Mindbody upgrade to week 9 and move the ClassPass payout request a week earlier?' The scenario showed week-6 balance recovering to $9,100. She made the change, avoided a cash pinch, and didn't need to open a spreadsheet. The whole thing took 12 minutes on a Tuesday morning before the 8 a.m. reformer class.

Measurement

How you'll know it's working

Week-10 projected cash balance — the number that tells you whether you have room to hire a new instructor or need to pause marketing spend

Net membership revenue per week — Stripe charges actually collected, not class packs sold but not yet redeemed

Instructor payroll as a percentage of gross revenue — the ratio that kills margin at most boutique studios without owners realizing it

ClassPass net payout lag — days between class delivery and settlement hitting your bank, which matters when you're forecasting week-by-week

Recurring subscription total — the sum of all software, licensing, and platform fees that auto-renew whether or not you're paying attention

Comparison

What this replaces

The other ways teams handle this today, and how the Starch version compares.

Google Sheets built manually from Mindbody CSV exports

Free and familiar, but you're rebuilding the model every time you want current numbers — Sunday-night work that's stale by Wednesday

QuickBooks cash flow report

Good for historical actuals once your bookkeeper closes the month, but not a forward 13-week forecast and not updated daily — you're always looking backward

Float or Dryrun (dedicated cash flow tools)

Designed specifically for cash forecasting and better at multi-entity rollups, but require clean QuickBooks or Xero data and won't pull from Plaid bank feeds or automate Mindbody data through browser automation

Asking your accountant to run a monthly cash projection

You get a professional model, but it reflects last month's close and costs you $200-400 per update — not a tool for weekly operational decisions

On Starch RECOMMENDED

One platform — runway analysis, scenario planning, transaction insights all running on connected data. Setup in plain English; numbers stay current via scheduled syncs and live agent queries.

Try it on Starch →

FAQ

Frequently asked questions

Mindbody doesn't have an open API for independent studios. Can Starch actually get my data out of it?

Yes. Starch automates Mindbody through your browser — no API needed. It logs in, navigates to your billing and attendance reports, and pulls the data on a schedule. The same works for Wodify, MarianaTek, and ClassPass. If you can click through it in a browser, Starch can automate it.

I process payments through both Stripe and Square. Can the forecast include both?

Stripe syncs directly — Starch connects to your Stripe account and pulls charges and payouts on a schedule. Square is reachable from Starch's integration catalog of 3,000+ apps; the agent queries it live when your forecast runs. You'd tell Starch: 'Stripe is membership and class pack revenue; Square is retail.' It maps them accordingly.

My bookkeeper uses QuickBooks. Will this replace what she does or duplicate it?

It's parallel, not a replacement. Your bookkeeper closes the books in QuickBooks for tax and compliance purposes. This forecast runs off your live Plaid bank transactions and Stripe revenue — it's a forward-looking cash tool, not an accounting ledger. The two are complementary. If you want the QuickBooks data in the forecast too, Starch connects directly to QuickBooks and syncs invoices, bills, and payments on a schedule.

Is Starch SOC 2 certified? I'm connecting my bank account.

Not yet — Starch is not currently SOC 2 Type II certified. That's worth knowing before you connect financial accounts. The Plaid connection follows Plaid's own security model (read-only, bank-grade OAuth), but if SOC 2 certification is a hard requirement for your business, that's an honest limit to weigh.

Can the 13-week forecast automatically update, or do I have to re-run it manually?

It updates automatically. Starch syncs your Plaid transactions and Stripe data on a schedule, and you can set an automation that refreshes the forecast model and sends you a Monday morning summary to Slack. You're not re-running anything — you're reading the output.

What if my revenue is mostly cash or Venmo from members, not Stripe?

Starch can pull Plaid bank transactions, which captures deposits regardless of how the member originally paid — Venmo, Zelle, check, or cash that you deposit. The forecast won't have line-item detail on payment method, but it will reflect actual cash arriving in your account. For studios with a lot of informal payment, the bank feed is usually the more accurate inflow signal anyway.