Business Cash Flow Spreadsheet: A 13-Week Runway

Hey folks, it's Ren here. Think about the fuel gauge on a long road trip. It does not tell you your average fuel use for the year. It tells you whether you will make the next town.

That is the question a business actually lives or dies on. Not how profitable was last quarter, but will the tank get me to the next stop.

A business cash flow spreadsheet is that fuel gauge for your bank account.

“Revenue is vanity, profit is sanity, but cash is the only thing that pays the wages.” — Ren, JRen Digital

🛣️ Why can a profit figure still leave you broke?

Profit and cash are not the same thing, and the gap between them is where good businesses get caught out.

You can invoice forty thousand dollars in March and be genuinely profitable, yet have nothing in the account in April because the client pays on sixty-day terms while your rent, wages and suppliers do not wait.

• A monthly total hides the week inside it when the balance goes negative.
• Profit counts the invoice; cash flow counts the day it actually lands.
• Big bills cluster, and an annual view never warns you they are about to.

Please do not be hard on yourself if this is you. Most accounting reports look backward, and the tank is a forward-looking question.

📊 What does a 13-week cash flow forecast show?

A business cash flow spreadsheet shows every dollar you expect to receive and pay, lined up by the week it actually moves.

Each week starts with your opening balance, adds the cash you expect in, subtracts the cash going out, and carries the closing balance to the next week. The lowest closing balance across the thirteen weeks is your runway warning light.

Here is the shift that makes a cash flow spreadsheet actually work, and it is the part most owners get wrong.

Forecast the week money lands, not the week you invoiced. If a client is on thirty-day terms, the cash goes in the row four weeks out, not the row you sent it. Do the same with what you owe: the supplier bill sits in the week you will actually pay it.

Once the timing is honest, the forecast does something a profit-and-loss report never can. It points at a specific week, say week seven, and says the balance dips to four hundred dollars there. That is enough warning to pull an invoice forward, delay a non-urgent purchase, or have the finance conversation while you still have options.

✅ How to build it in an afternoon

1. Set your week columns. Create thirteen columns, one per week, starting from this Monday, so the forecast rolls forward as time passes.
2. Enter the opening balance. Put today's actual bank balance in week one; every other week will calculate from it.
3. Forecast cash in by pay date. List expected receipts in the week each one will truly clear, allowing for client payment terms.
4. Forecast cash out by pay date. List wages, rent, suppliers and tax set-asides in the week you will actually pay them, not when they were incurred.
5. Carry the closing balance. Each week, opening plus cash in minus cash out equals closing, and that closing becomes next week's opening; the lowest figure is your runway warning.

Forecast the tank, not just the trip

The Ultimate Small Business Budget Template includes a rolling cash flow forecast alongside your income, expenses and a profit-and-loss dashboard. Trusted by over 76,000 customers.

Get the Ultimate Small Business Budget Template →

⚠️ Mistakes to sidestep

• Forecasting by month. Fix it: use weeks, because the danger always hides inside a month that nets out fine.
• Timing cash to the invoice date. Fix it: place receipts in the week they will truly clear, after payment terms.
• Leaving out tax set-asides. Fix it: treat tax as a weekly cash-out so it never ambushes you.

Cash flow tells you when the money moves; a profit and loss spreadsheet tells you whether the business is actually making money. You want both, and they answer different questions.

🎯 Your action steps this week

• Pull your real bank balance into week one of your business cash flow spreadsheet.
• List every receipt you expect in the next thirteen weeks, timed to its pay date.
• List every payment, including wages and a tax set-aside, in the week it leaves.
• Find your lowest closing balance and note which week it is.
• For the full books, pair it with the self-employed budget spreadsheet.

💬 Common situations

If your busiest month still leaves you short

This is the classic profit-versus-cash trap, and it is almost always timing. You earned the money but it has not landed yet, while the bills already have. Build the forecast by the week each receipt truly clears, and the short week will show up early enough to pull an invoice forward or delay a purchase.

If your income is lumpy and unpredictable

Forecast conservatively on the cash-in side and fully on the cash-out side. Put only receipts you are confident about in their likely week, keep a buffer line, and watch the lowest closing balance. A lumpy business needs a wider runway, and thirteen weeks gives you room to react rather than panic.

If you have never forecast cash before

Start with what you actually know: today's balance, the wages and rent you must pay, and the invoices already out. Even a rough thirteen-week sheet beats none, because it turns a vague worry into a specific week you can plan around. Refine it each Friday and it gets sharper fast.

You would never drive across the country watching only the rear-view mirror. A cash flow forecast is the windscreen and the fuel gauge, pointed at the next stop.

To your financial freedom,
Ren

This article is for general information only and is not financial advice. It does not take into account your personal situation, needs or objectives. Please consider speaking with a qualified financial adviser before making financial decisions.