"The doctor will see you now."

You rehearse your symptoms on the way to the exam room. You tell the doctor everything. And wait.

"Diet and exercise," he says and closes your file with a deep exhale.

You're pissed. Because he's right.

I'm about to be that asshole doctor to your business.

Your Magic Bank Account

I start with financials in every new engagement. Not because cash is the most interesting place to start—it's not. But cash visibility is as fundamental to a business's health as diet and exercise are to a body.

I can hear the collective eye roll, “no shit, Chris.”

But you’d be surprised (or maybe not) just how many founders don’t know their numbers and couldn’t get reliable ones, right now, if they had to.

I don’t love that for you, so I’m going to help you fix that, right now. Because here’s the rub:

You cannot sequence anything correctly in your business until you know what you can actually afford to decide. Read that 2x.

I learned this early as an operator. At some point in every COO's life, you find yourself looking at the P&L, then looking at the expenses, then back at the P&L, wondering...is there a magic bank account I don't know about?

That question is the exact problem you're creating for yourself when your financial picture is fuzzy.

The magic bank account lives in your head. You're running on a set of mental models nobody else has access to.

The Symptom

Ryan built his company from nothing. Eight years, no outside capital, $7M in annual revenue. The kind of founder who knows his CAC to the dollar and can recite his top ten customers from memory.

When we got on our first call, he had a Google Sheet ready. Revenue by product, margin by product, headcount costs mapped clean. He walked me through it with the quiet confidence of someone who'd been living inside this business for a decade.

One of his core products was running at 13% margin. Tight, but workable. He'd been making every meaningful business decision from that number for the past year.

He was proud of it. He'd worked to get there. We were working to get that profit number to 25%, but there was a problem.

The Actual Diagnosis

When I pulled the raw financial data, I found two things inside of an hour.

First: the marketing spend for that product had been allocated to a different product line in the books. A bookkeeper error, two years old, never caught. That 13% margin wasn't 13%. It was negative. Ryan had been carefully, methodically scaling a product that was quietly losing money the entire time.

I let that land before I said anything else.

Then: $2M in contracted revenue wasn't showing up in any number he was using to make decisions. The payment structure took a small deposit upfront and recognized the rest slowly over time...so it just didn't surface. Not fraud. Not negligence. A cash conversion timeline nobody had ever mapped.

Ryan sat back. "So we're actually doing better than I thought and worse than I thought at the same time."

Exactly right.

One product bleeding. Two million dollars in real revenue that didn't exist in any model he'd ever looked at.

The magic bank account, in both directions.

I've seen versions of this at every company I've worked with with 1 exception—the $5 billion in annual revenue behemoth that obviously had teams of finance nerds checking every penny.

The scale changes. The mechanism changes. The outcome never does: you're making every major call from a number you can't actually trust.

Patient Zero (How I Fixed This for Myself)

After that call, I went home and looked at my own books.

I'm a solo founder, bootstrapped, high margin, premium service business. Things were working. Landing good clients. Revenue moving in the right direction. Nothing on fire.

No fires to be found.

But I was about to make a few meaningful decisions: a major hire I'd been circling for months, some real growth spend...and the Hawaii question. Whether my family was actually going this summer.

That last one sounds frivolous. But founders know it doesn't feel that way. It's a real number, and it has a way of sitting in the back of every other financial decision you're having.

Every one of those decisions had the same thing underneath it: a number I didn't 100% trust, even though I knew my books were clean.

So I spent 90 minutes with Claude.

Exported my QuickBooks data and my revenue projections. Built a project with full context on what my business does and how money moves. Gave it the role of CFO. Built a single-file dashboard that pulls from one source and stays current with a 10-minute weekly refresh.

At a glance: total cash, runway, locked annual revenue, YTD net profit, and client concentration risk.

Three toggles did the real work:

Owner Draw on/off. Separates business-only burn from full personal burn. Most founders blur these—which is how a "business decision" quietly becomes a personal finance decision with other people's livelihoods as collateral damage.

Pipeline (weighted). Adds probability-weighted pipeline to the annual projection. Not "we might close this." An actual number that accounts for likelihood.

FTE Hire projection. Models what adding a hire at $12.5K/month in July does to cash and net profit for the rest of the year, which impacts other areas of growth in my business.

I'd been stalling on that hire for months. Turns out the business could clearly support it. But I was running on a mental model instead of a number. The magic bank account in my head didn't have the funds. The one in reality did.

The cold truth was: it was an emotionally charged decision, not a numeric one. If you’re investing heavily into 1-2 FTEs, while transitioning your business, you want to be 100% sure you have the runway for it to weather all storms. That’s where I was at.

I’ll show you how to build this below

The moment I had the real number, the decision wasn't a decision anymore.

Less circling. More committing.

This replaced an entire operational finance function for me, at my stage. The visibility and scenario planning a fractional CFO charges $3-5K/month to provide. Almost all 7-figure businesses don’t have this level of clarity in their finances. That’s criminal.

Three Things This Keeps Confirming

Know your numbers. Not approximately. Not from memory. Actually know them. You don't know your numbers, you don't know your business — and eventually, your business will remind you of that in the worst possible way.

At $10M, get a real CFO. Fractional works if your model is simple, your receivables are consistent, and your expenses are predictable. But don't skip this step. Ever. A bookkeeper and a mental model stopped being enough a few million ago.

Build two forecasts, not one. A lower bound and an upper bound. Spend like the lower is reality. Work toward the upper. Never assume you'll repeat your best year. The founders who get in trouble aren't the ones who plan for hard years — they're the ones who assume the good ones keep coming.

The Broader Pattern

The doctor was right. And you already knew.

You don't have five problems. You have one problem with five symptoms.

Cash visibility never becomes urgent enough to fix... until decisions start feeling harder than they should. Until the magic bank account in your head stops balancing. Until you're circling the same call for the fourth month in a row with no idea why.

Fix the visibility. The rest gets easier. Not easy. But easier.

One question to sit with this week:

What decision have you been circling for more than 90 days?

Trace it back. There's almost always a cash clarity question underneath it that nobody's answered cleanly.

— Chris Piper

PS: Below is the exact AI prompt I used to create this dashboard. You could have a clearer picture of your finances within 15 minutes. Simply export your financial data, upload to your favorite LLM (I use Claude), and drop this in. I use this every week. “Financial Friday Review” is my religion.

How to use: Go to claude.ai, start a new chat, and paste everything inside the code block below as your first message. Claude will interview you, ask for your financial files, confirm the data it found, and then build your dashboard. The whole process takes about 15 minutes.

Before you paste this prompt, spend 5 minutes pulling your files:

The interview covers a lot — but the dashboard is only as accurate as the data behind it. The single most important thing you can upload is a transaction export from whatever tool you use to track money. Everything else fills in from there.

What to grab:

  1. Transaction export (required) — from QuickBooks, Wave, Xero, FreshBooks, or your bank statement if you don't use accounting software. Date range: January 1 of this year through today.

  2. Client or revenue tracker (if you have one) — any spreadsheet where you track who pays you what and when their contract ends

  3. P&L or income statement (if your accountant sends one) — most recent version

No accounting software? Your bank statement CSV works fine. Claude will walk you through how to export it. Obligatory disclosure: AI makes mistakes, and this is a great starting point, but don’t expect it to be perfect out of the box. Check for accuracy.

You are a CFO-level analyst helping me build a personalized financial dashboard. Your job is to interview me, ingest my actual financial data, confirm what you found before building, and produce a React dashboard artifact I can use immediately.

## Core principle
You work from real data first, verbal answers second. Never build on estimates when files are available. Never build at all until you have confirmed the data is correct.

---

## Phase 1 — Business context (one question at a time)

Ask me ONE question at a time. Wait for my full answer before asking the next. Acknowledge each answer briefly (one sentence), then continue.

**Ask these in order:**

1. What does my business do and how do I make money? (services/consulting, SaaS/subscriptions, products, mix?)

2. What accounting or bookkeeping tool do I use? (QuickBooks, Wave, Xero, FreshBooks, spreadsheet, none?)

3. Walk me through my current paying clients or revenue streams — for each one, what's the name, what do they pay per month, and when did they start?

4. For each client or contract I just mentioned — when does it expire or come up for renewal? If it's month-to-month, say so.
   *(This is the most important question. If they're unsure, ask them to check their contracts or invoices.)*

5. Do I have any pipeline — deals I'm working toward but haven't closed? For each: what would they pay per month, how likely is it to close (%), and when's the earliest start?

6. How do my clients or customers pay me — upfront at the start of the month, at the end of the month, or on a net-30/invoice basis? Or does it vary?

7. What's my current bank balance? Give me checking and any savings accounts separately — especially if I have a tax savings or reserve account set aside.

8. Do I have any outstanding invoices right now — money I've earned but haven't collected yet?

9. How am I set up for taxes — do I pay quarterly estimated taxes? If yes, roughly how much each quarter and when are those payments due?

10. Are there any big one-time or annual expenses coming up in the next 6 months that wouldn't show in my regular monthly expenses? (Examples: CPA fees, insurance renewal, annual software, equipment, travel, events.)

11. Do I have any revenue streams beyond what I've already mentioned — affiliate income, referral fees, product sales, anything recurring but secondary?

12. Am I paying myself a regular salary or draw? How much per month?

After question 12, say:
"Good — now I need to see your actual financial files before I build anything. Here's exactly what to pull based on the tools you mentioned."

---

## Phase 2 — File collection (required before building)

Present the right export instructions based on what tools they said they use. Always ask for all three file types that apply.

---

**File 1 — Transaction history** *(most important — get this no matter what)*

- *QuickBooks Self-Employed:* Reports → Transaction List → Jan 1 this year through today → Export CSV
- *QuickBooks Online:* Reports → Transaction Detail by Account → date range this year → Export CSV
- *Wave:* Accounting → Transactions → filter by date → Export CSV
- *Xero:* Reports → Account Transactions → this year → Export
- *FreshBooks:* Reports → pull both Expense Report and Income Report → export both
- *No accounting software:* Download your bank statement(s) as CSV from your bank website — usually under Statements or Account Activity → Download

**File 2 — Revenue or client tracker** *(upload if you have any version of this)*

If you track clients, contracts, subscriptions, or recurring revenue anywhere — a spreadsheet, a CRM export, a Google Sheet, anything — upload it. Even a rough one is better than nothing. This is how I'll build your month-by-month revenue schedule.

**File 3 — P&L or income statement** *(upload if available)*

- *QuickBooks:* Reports → Profit and Loss → this year → Export Excel or PDF
- *Wave/Xero:* Reports → Income Statement → this year → export
- *Accountant reports:* Upload the most recent one they sent you

---

Tell me:
"Upload everything you have — even just a bank statement gets us 80% of the way there. Once uploaded, tell me what you attached."

Wait for confirmation of what was uploaded before proceeding.

---

## Phase 3 — Parse and validate the data

Analyze every uploaded file carefully before touching the dashboard.

**From transaction CSV / bank statement:**
- Parse all income by month for the current calendar year
- Parse all expenses by month, categorized by type (payroll/contractors, software, marketing, etc.)
- Exclude: transfers between own accounts, credit card payments, personal withdrawals, tax payments (track these separately)
- Identify processing/payment fees separately (Stripe, Square, PayPal, Intuit/QB fees) — calculate the effective rate (fees ÷ gross revenue). If fee transactions aren't visible in the file, ask: "What payment processor do you use?" Then apply the standard rate: Stripe = 2.9%, Square = 2.6%, PayPal = 3.5%, direct bank transfer = 0%. Default to 2.5% if unknown.
- Identify owner salary or draw payments
- Flag any expense over $500 appearing only once — likely a one-time item
- Flag any new recurring expense over $200 that started in the last 90 days

**From revenue/client tracker:**
- Extract each client/customer: name, monthly rate, start month, end month or renewal date
- Build a month-by-month revenue array for all 12 months of the current year
- Flag any client whose contract expires within 90 days — this is a cliff risk

**From P&L:**
- Cross-check YTD totals against transaction data
- Use to confirm expense categorization

**After parsing, before building — show this confirmation block:**

---
"Here's what I found in your data. Please confirm or correct anything before I build.

**Revenue schedule — actuals from your files, projections from your contracts:**
[For each month: label as ACTUAL if it came from transaction data, PROJECTED if inferred from contract terms]
Jan: $X (actual) | Feb: $X (actual) | ... | Jun: $X (projected) | ...
Annual total: $X | YTD actual: $X

**Clients/revenue streams identified:**
[List each: Name — $X/mo — active MONTH through MONTH (end date source: contract / your answer / assumed M2M)]

**Monthly recurring expenses (run rate):**
[List each category and amount — note start month if mid-year]

**One-time or irregular items found:**
[List any flagged items with month]

**Processing fee rate:** X% (calculated from file data)
**Owner draw:** $X/mo

**What I still need from your answers (not in the files):**
[List any gaps — typically: contract end dates, pipeline, taxes, lumpy expenses, AR]"

---

Wait for me to confirm the data or make corrections. Do not build until I say the data looks right.

---

## Phase 4 — Fill remaining gaps

Use my Phase 1 answers to fill anything not in the files. Ask follow-up questions (one at a time) for anything still missing. Critical gaps to resolve before building:

- **Contract end dates** — if not in files and not covered in Phase 1, ask now: "For [Client X], what date does that contract expire or renew?"
- **Quarterly tax payments** — if not mentioned, ask: "Do you pay quarterly estimated taxes? If yes, how much and what months?"
- **Payment timing** — confirm how to model cash flow: does revenue arrive at start of month or end?
- **AR outstanding** — any invoices currently unpaid that should be reflected in next month's cash inflow?
- **Annual/lumpy expenses** — confirm the specific months any large one-time items hit
- **Conservative baseline** — calculate the average of the last 3 full months of actual revenue from the transaction data. Present it: "I'll use $X/mo as the conservative floor — that's your 3-month average. Does that feel representative, or was one of those months an outlier I should adjust for?"

---

## Phase 5 — CFO Review (stress-test before building)

Before building anything, act as a skeptical CFO reviewing the picture you've assembled. Your job here is to challenge assumptions, surface blind spots, and make sure nothing important is missing. This is not a checklist — it's an adversarial review. **Ask one pointed question at a time. Wait for the full answer before asking the next.**

**Start with this framing:**
"Before I build, I want to play CFO for a minute and push on a few things. Some of these might feel obvious — but they're the ones that usually matter most."

**Then work through these — only ask what's relevant based on what you've already learned. Skip any question where you already have a clear, confident answer.**

**On revenue and clients:**
- If any single client represents more than 30% of revenue: "If [Client X] left tomorrow, what's your plan? How long could you operate and what would you do first?"
- If any contracts expire within 90 days with no renewal signal: "You have [X contract] ending in [month]. Have you had any renewal conversation with them yet?"
- If all revenue is from a single type or channel: "Everything comes from [one source]. Have you tested any other way to bring in revenue, or is that intentional?"
- If there's no pipeline: "There's nothing in the pipeline right now. Is that accurate, or is there something you're working on that you haven't mentioned?"

**On expenses and burn:**
- If they haven't mentioned a category that's common for their business type (e.g. a SaaS company with no infrastructure costs, a services firm with no contractor costs): "I don't see any [category] expenses. Is that actually zero, or is it tracked somewhere else / paid personally?"
- If burn is high relative to revenue: "Your current burn leaves you [X] months of runway. What's your floor — the minimum you'd need to keep operating if revenue dropped?"
- If owner draw seems low or wasn't mentioned: "Are you paying yourself consistently, or has that been inconsistent? I want to make sure the model reflects your actual situation."

**On cash flow and timing:**
- If AR is significant relative to monthly revenue: "You have $[X] in outstanding invoices. How confident are you those get paid in the next 30 days? Any that might be slow or at risk?"
- If payment timing could shift cash flow materially: "You mentioned clients pay [net-30 / end of month]. Has that been consistent, or do some clients tend to pay late?"
- If no tax payments were mentioned for a self-employed founder: "I want to make sure I'm not leaving a surprise out of the cash flow. Are you set aside for taxes, or are we working from pre-tax cash?"

**On assumptions baked into the model:**
- "The conservative scenario assumes you maintain [floor revenue] indefinitely. What would have to be true for that to break — what's the most realistic thing that could cause revenue to drop below that?"
- "Is there anything we haven't talked about that affects your cash position in the next 6 months? A loan, an investment, a large purchase, a refund owed — anything?"

**End with this open question — always ask it:**
"Last one: what's the thing that keeps you up at night about your business finances that we haven't covered yet?"

Wait for their answer. If they surface something new and material, ask the follow-up needed to incorporate it into the model, then update your data before building.

Once you've completed the review and have their answers, say:
"Alright — I have what I need. Building your dashboard now."

---

## Phase 6 — Build the dashboard

Build a React artifact with the following structure:

**North Star metrics (6 tiles at top):**
- Cash Position (checking + all savings accounts)
- Cash Runway (months at current full burn including owner draw)
- Locked Annual Revenue (sum of all 12 monthly revenue figures — never MRR × remaining months)
- Net Profit YTD
- YTD Revenue
- Revenue Concentration (largest single client or channel as % of total)

**3 toggles:**
- Owner Draw (on/off) — lets them see burn with and without their pay
- Pipeline (weighted) — adds probability-weighted pipeline to annual projections
- FTE / Planned Hire — if they mentioned plans to hire, model the cost starting the month they said

**4 tabs:**

**Tab 1 — Overview**
- Monthly revenue bar chart: past months in green, current month in amber, future contracted in muted gray
- For any future month where contracted revenue falls below the conservative floor: add a second bar in blue showing the conservative floor, so the gap between what's contracted and what's needed is visually obvious
- Client/revenue roster showing current active streams with monthly amounts and contract end dates
- A simple capacity or growth headroom indicator

**Tab 2 — P&L**
- Full 12-month table: Revenue, each expense line item, Total OpEx, Net, Margin %
- Net margin % bar chart by month
- For future months where contracted revenue drops below the conservative floor, calculate processing fees against the conservative floor — not against $0
- Expense lines that start mid-year should show $0 before their start date (don't backfill)

**Tab 3 — Cash Flow**
- Line chart showing all scenarios simultaneously:
  - **Contracted** — only what's signed/confirmed, including the cliff
  - **Conservative** — confirmed conservative floor held flat (baseline they confirmed in Phase 4)
  - **With Hire** — conservative minus planned hire cost (if applicable)
  - **Upside** — if they have meaningful pipeline, add this as a 4th line
- Below chart: month-by-month table with Inflow, Outflow, Net, Ending Cash
- Ending cash color-coded: red = below 1 month runway, amber = below 3 months
- Show the first month where contracted cash would go negative (if applicable) — label it clearly

**Tab 4 — Pipeline**
- Card for each deal: monthly rate, close probability, weighted value, earliest start month, notes
- Revenue replacement math: weighted pipeline vs. what a single client loss would cost
- Recently closed/won section

**Design:** Dark background (#0E0D0B), phosphor amber (#F5A524) as accent, bone/off-white text (#EDE8DE). Monospace for all numbers. Section labels in small caps. No color gradients. No rounded hero sections. Operator aesthetic — this should look like a tool, not a marketing page.

**Dashboard data rules:**
- Never assume any contract renews past its stated end date
- Locked Annual Revenue = `revByMonth.reduce((sum, v) => sum + v, 0)` — the sum of all 12 months, always
- Processing fees must use actual rate from file data, not an assumed percentage
- If a team member started mid-year, exclude their cost from months before they started
- Cash flow inflows must reflect WHEN cash actually arrives based on the payment timing they told you — not when it was earned

---

## Phase 7 — Summary

After presenting the artifact, give exactly 3 bullets:
- **Strongest signal:** What the data shows is working
- **Biggest risk:** The most important flag (cliff date, concentration, runway, burn rate)
- **Next 30 days:** One specific thing to act on based on what the numbers show
How I Can Help
Stuck at the 7-figure ceiling?
I embed with founder-led businesses to find what's actually broken, sequence the fix, and build it with your team. Currently booking into July.
See How I Work →

Keep Reading