Come, Look at This Gap: The Week Your Cash Runs Out (Before It Happens)
Profit is a theory; cash is a fact. We build a simple weekly runway sheet to spot the 'Red Week' where liquidity vanishes, long before the panic starts.
The Invisible Cliff
Come, open your banking app. Look at the balance. $45,000.
It feels safe, does it not? It is a solid, positive number. It tells you that you can pay the rent next week. It tells you that you can buy that new software license.
But this number is a lie. It is a snapshot of the past, not a map of the future. It does not know about the payroll run hitting on the 14th. It does not know that your biggest client is going to delay their payment by 15 days because their CFO is on vacation.
The Lie: We treat our current bank balance as a cushion. We assume that because we have money now, we will have money then. We rely on “Average Burn Rate,” assuming we spend money evenly.
The Truth: Cash flow is lumpy. It is jagged. It has spikes of intake and violent drops of outflow. If we average it, we smooth over the hole that will swallow us.
Finding the Red Week
We are going to build a tool that removes the blindfold. We call it the Weekly Runway.
Open a fresh sheet.
- Row 1: Dates (Week Ending 01, Week Ending 08, etc.)
- Row 2: Starting Cash (Link this to the previous week’s ending cash).
- Row 3: Confirmed Inflows (Only checks we know are clearing).
- Row 4: Committed Outflows (Rent, Payroll, Fixed Costs).
- Row 5: Ending Cash.
Now, drag this formula out for 13 weeks.
Here is the warning pattern in a weekly grid. This is an illustrative excerpt from the 13-week plan; only Week 7’s amount is specified in this example.
| Ending cash | Weeks 1–6 | Week 7 | Week 8 |
|---|---|---|---|
| Projected balance | Above $0 each week | −$2,500 | Back above $0 |
| What to notice | Positive balances | Temporary funding gap | Later receipt does not erase Week 7’s gap |
For each week, calculate Ending Cash = Starting Cash + Confirmed Inflows - Committed Outflows. Carry that ending balance into the next week’s starting cash. A later recovery does not supply cash on the earlier payment date.
staring at the Void
Do you see Week 7? That is the gap. That is the week where the line crosses zero.
In a monthly forecast, Week 7 is invisible because the big client payment in Week 8 covers it up. The monthly average says you are safe. The weekly reality says you are dead.
By visualizing this gap now—six weeks in advance—we have power. We can call the client. We can delay a vendor payment. We can bridge the gap.
Cash does not disappear; it just walks off the page when we stop looking. Project the line. Find the gap. Build the bridge before you reach the cliff.
FAQs
Why weekly? Isn't monthly enough?
No. Payroll happens on a Tuesday. Rent clears on a Friday. A monthly view hides the day you bounce a check.
My P&L says I'm profitable. Why worry?
Because you cannot pay staff with 'Net Income.' You pay them with cash. If clients pay late, profit means nothing.
What is the 'Red Week'?
It is the specific week in the future where your balance dips below zero. Once you see it, you can fix it.