Playbook: Don’t run out of cash

My free Excel tool inside.

🔍️ Browse my library of small business playbooks — sales & marketing, people ops, finance, and operations.

Brought to you by Scalepath - the community for small business leaders.

Hi folks!

Every week, I’m sharing a practical, hands-on guide on one way to run your small business better. 

(It’s what we do every day in Scalepath, my community for SMB CEOs — discussions, calls, playbooks, cohorts, and more. Join us!)

Today’s topic: using a cash flow forecast to keep your business afloat

I gave some tips recently on how much cash to keep in your business

But no matter how well you plan things, you’re bound to run into a cash crisis sooner or later.

When that happens, you have three essential jobs as CEO.

  1. Fix the problem that got you into this mess. 

It could be anything. (Have you got a specific problem? Write me and maybe I’ll do an issue about it!)

  1. Get hands-on with your balance sheet.

Use this template to build a 13-week rolling cash flow forecast. (Walkthrough below.)

  1. Stretch your cash.

Now that you’ve gotten intimate with your finances, find yourself some wiggle room.

- Delay payments
- Renegotiate w/ vendors
- Expand borrowing
- Raise cash
- Get paid early
- Etc.

This is how you buy time to fix the problem.

How to use the template

Here’s the Excel file again (it’s a spreadsheet, so not great for mobile).

Using it is pretty simple. Fill in the numbers in blue. Everything in black is calculated automatically. 

  1. Enter this Monday’s date at the “1”.

  2. Fill in your current starting cash on hand, and what’s coming in this week.

  3. List your expenses for the week from operations — rent, salaries, fees, loan payments, the works. 

  4. See your weekly cash increase/decrease at the bottom.

  5. Add any new invoices and estimated collections for that week. These are often on terms (like net 30) so forecast when they’ll be paid.

That’s it! Do this at the top of each week to stay in touch with the numbers that matter.

Why 13 weeks?

If your business is in trouble, monthly or quarterly cash flow projections are too general.

13 weeks is short enough to be precise. Your estimates will be accurate enough to be useful. And it’s long enough to see your problems while you still have time to fix them.

Can’t my accounting software do this?

Probably. But a lot of accounting tools have either dirty or incomplete data.

Plus, there’s something visceral about entering these numbers yourself. Touching your data is touching your business. 

Try it and you’ll know what I mean.

That’s it!

Have a great week,

Michael

P.S. Every business leader needs people to confide in. But only other leaders really “get it.” 

That’s why we launched Scalepath’s Peer Advisory Group, where you’ll find support and motivation from CEOs solving the same problems you are. Apply today!

100+ Active Members | 4,000+ Discussion Threads | 150+ Tailored Resources

When I joined a peer group, my business growth exploded. It was the highest-impact decision I ever made. 

But most of them are designed for big businesses — so I made my own. 

Scalepath is exclusively for CEOs and leaders at businesses making $500K+ in annual income.

Not subscribed? Sign up here! 

MORE WAYS I CAN HELP YOUR BUSINESS

💡 Go from idea to profitable business The Low-Risk Business (ebook)
Get the 5-step framework I've used to build multiple businesses from scratch. 40 pages of hands-on, practical guidance.

📈 Group for small business leaders → join Scalepath
Connect, learn, and grow your business with expert guidance, vetted community, detailed playbooks, and other resources. For businesses making $500K+ in revenue.

🌎 Hire incredible talent → talk to Near
Meet your hiring needs with top-tier Latin American talent for 70% less than US staff. My team at Near takes care of all the headaches. Get in touch today.