Sponsored by
Are You Ready to Actually Retire?
Knowing when to retire is harder than knowing how much to save. The timing depends on what your retirement actually looks like: how long your money needs to last, what you'll spend, and where your income comes from.
When to Retire: A Quick and Easy Planning Guide is built for investors with $1,000,000 or more who are ready to move from saving to planning. Download your free guide and start working through the details.
I have a confession. For the first eight months of running Wealth Grid, I managed cash flow the way most founders do: a combination of checking my bank balance, gut instinct, and mild ongoing anxiety.
That's not a system. That's a prayer.
The irony of a guy who spent ten years building automated financial systems for hedge funds running his own business off vibes is not lost on me. But that's how it goes when you're heads-down building something new. You know better, and you still don't do better. At least for a while.
The shift happened when I built my first personal cash flow dashboard. Not a complicated one. Not something that required a team of analysts to maintain. Just a clean, real-time view of money in, money out, what was coming, and what the runway looked like.
Within 30 days of having that dashboard running, I made three decisions I wouldn't have made without it: I killed a recurring software expense I had forgotten about, I accelerated an invoice collection that was sitting 45 days out, and I moved a tax reserve earlier than planned because the projection showed a Q2 gap. Those three decisions were worth more than $14,000 combined.
Today I'm going to show you exactly how to build this for your own business. No finance degree required. No expensive software. Just a clear framework and a weekend of focused work.
What the Dashboard Actually Needs to Show
Before we talk tools, let's talk about what matters. Most cash flow dashboards fail because they try to show everything. More data is not better data. You want four things, and only four things, on your primary view:
Current Cash Position: What's in the bank right now, across all accounts.
30/60/90-Day Receivables: What's owed to you and when you expect to collect it.
30/60/90-Day Payables: What you owe and when it hits.
Net Cash Projection: What the runway looks like given those numbers.
That's it. If you have those four things accurate and up to date, you can make almost every financial decision your business requires with confidence. Everything else is detail you can drill into when you need it.
The Tool Stack (Free to Low Cost)
Here's what I recommend for a business doing under $5M in annual revenue:
Layer 1: The Data Source
If you're on QuickBooks, Xero, or FreshBooks, you already have most of the raw data you need. Connect your bank accounts and credit cards if you haven't. This is non-negotiable. Manual entry kills dashboards because people stop doing it.
Layer 2: The Dashboard Engine
Google Sheets is genuinely underrated for this. It's free, it connects to your accounting software via Zapier or Make, and it's flexible enough to build anything you need without being so flexible that you spend three weeks tweaking instead of using. For most businesses, Sheets is the right answer.
If you want something more visual out of the box, Notion databases with linked rollup formulas work well too. But start simple.
Layer 3: The Automation Layer
This is where Make.com earns its keep. Build a workflow that pulls your bank balance and recent transactions on a daily schedule and populates your dashboard automatically. You shouldn't be manually updating this thing. The entire point is that it updates itself and you just look at it.
Building the Core Spreadsheet
Here's the structure that works. Set up five tabs in your Google Sheet:
Tab 1 - Dashboard: The summary view. Only the four metrics listed above, plus a simple 90-day chart.
Tab 2 - Receivables: Every open invoice, client name, amount, due date, and status.
Tab 3 - Payables: Every recurring expense and one-time payment due, amount, and date.
Tab 4 - Bank Feed: The raw transaction pull from your automation. Don't touch this tab manually.
Tab 5 - Scenarios: What happens if your biggest client pays late? What if you land that deal next month? Run three scenarios: base, optimistic, conservative.
The Dashboard tab pulls from the others via formulas. Nothing on the Dashboard tab gets typed in directly. It all flows from the source tabs.
For the 90-day projection chart, your formula logic is simple: starting balance plus expected receivables collected minus expected payables due, rolling forward week by week. If that line dips below your minimum cash threshold (which you should define, typically one to three months of operating expenses), the cell turns red. That's your alert system.
The Weekly 15-Minute Cash Review
The dashboard is only valuable if you use it. Build this habit into your week: every Monday morning, before you check email, open the dashboard and spend 15 minutes with it. Answer four questions:
Is the current cash position where I expected it to be?
Are there any receivables that need a follow-up nudge this week?
Are there any payables coming that I need to account for in my spending?
Does the 90-day projection show anything that requires a decision now?
That's 15 minutes. That's the whole meeting. Then you close it and go run your business with actual clarity instead of vague financial anxiety.
The founders who make good financial decisions don't have more information than you. They have better systems for seeing the information they already have.
The Upgrade: AI-Powered Variance Analysis
Once the base dashboard is running, here's the upgrade that takes it from useful to genuinely powerful. Add a monthly variance report that compares what you projected last month against what actually happened, with a plain-English summary written by AI.
The workflow: at the end of each month, your Make automation pulls the actuals from your bank feed, compares them to last month's projections, calculates the variances, and sends the raw numbers to Claude or GPT with a prompt that says: explain what happened this month versus what we expected, flag the three biggest variances, and suggest what to watch next month.
You get a two-paragraph email summary every month that would have taken a finance manager two hours to write. That's the kind of leverage that changes how you operate.
If you want the exact Make workflow blueprint for automating this variance report, reply with the word CASHFLOW. I'll send you the full setup guide.
Dan Kaufman
Wealth Architect, The Wealth Grid