Most business owners can tell you last month's revenue. Far fewer can tell you whether the account clears payroll five weeks from Friday, and that second question is the one that closes businesses. A cash flow forecast answers it on one page: money in, money out, week by week, far enough ahead that problems become plans instead of emergencies.
You do not need software or a finance background. You need a spreadsheet, one honest afternoon, and the layout below. This guide walks through the whole build, row by row, and if you want the quick interactive version first, our cash flow gap calculator runs the same arithmetic in a few minutes.
What a cash flow forecast is, and what it is not
A cash flow forecast is a forward-looking map of your bank balance. It starts with the cash you hold today, adds the cash you expect to collect each week, subtracts the cash you expect to pay out each week, and shows the balance you would land on at the end of every week in the window. That is the whole machine.
It is not a budget, which is about permission to spend. It is not a profit and loss statement, which tells you whether the business model works but says nothing about timing. Profit and cash disagree constantly: a profitable month can still bounce payroll when the invoices behind that profit have not been paid yet. The forecast is the only one of the three documents that deals in dates, and dates are what the bank account runs on.
Why 13 weeks is the standard window
Thirteen weeks is one quarter, and it has become the standard forecasting window for small businesses for practical reasons. It is short enough that your estimates stay honest: you genuinely know most of what will happen in the next quarter, because the invoices are already sent, the rent is already fixed, and the season is already visible. It is long enough to catch trouble while you still have moves to make: a gap you spot ten weeks out can be closed by collections, cuts, or arranged financing, while a gap you spot ten days out can usually only be survived.
Monthly forecasts hide too much. A month that nets positive can contain a week where the account goes negative, and the bank charges you for the week, not the month. Weekly columns are the resolution at which payroll, rent, and remittance payments actually land, so weekly is the resolution that tells the truth.
Gather these five things before you start
The build goes fast when the inputs are already on the desk. Collect:
- Today's bank balance, across every operating account, minus any checks or payments already issued but not yet cleared.
- Your accounts receivable list: every unpaid invoice, its amount, and the date you honestly expect payment, not the date on the invoice.
- Three months of bank statements, to remind you what actually goes out. Memory forgets the quarterly insurance bill; statements do not.
- Your fixed payment calendar: rent, payroll dates and amounts, loan or advance remittances, insurance, subscriptions, tax deposit dates.
- A realistic sales estimate for the window, based on the last few months and the season you are heading into, not the quarter you are hoping for.
The template: one grid, three blocks
Open a blank spreadsheet. Put the next 13 weeks across the top, one column per week, labeled by the Friday that ends each week. Down the left side, build three blocks of rows.
Block one: cash in. One row per source of money: collections on existing invoices, new sales you expect to collect inside the window, and anything else real, like a tax refund with a date. Deposits only count in the week the money reaches the account, not the week you earn it. If customers pay you in 30 days, this is where that lag finally becomes visible.
Block two: cash out. One row per category of spending: payroll, rent, suppliers, loan and advance payments, insurance, utilities, software, owner draw, taxes. Put each amount in the week it actually leaves the account. Payroll lands on paydays. Rent lands on the first. A daily remittance lands in every single column.
Block three: the balance math. Three rows: total in, total out, and the running balance. The running balance for week one is today's balance plus week one's cash in, minus week one's cash out. Each following week starts from the week before. This row, the bottom row, is the entire point of the exercise.
The two numbers the finished forecast hands you
Read the bottom row and two numbers jump out. The first is the low point: the smallest balance in the row, and the week it happens. That number is your margin for error. If it is comfortably positive, you have breathing room and can think about growth. If it is thin, you know exactly which week needs attention and how much attention it needs. If it goes negative, you have just been handed the size of your funding gap and the date it opens, weeks before the bank tells you the hard way.
The second is the turn: the week the balance starts climbing again, if it does. A dip that recovers is a bridge to build, and now you know its length and depth. A line that slopes down without recovering inside the window is a different message: the business is consuming cash structurally, and the honest next step is fixing the flow itself rather than financing the slope. The cash flow gap calculator surfaces both numbers from a simplified version of this grid if you want them before the full spreadsheet exists.
Keep it alive: the 15-minute weekly update
A forecast built once and abandoned is a souvenir. The value compounds when you update it weekly, and the update is genuinely short: replace last week's estimates with what actually happened, shift any invoice that did not arrive, add the new week thirteen at the far end, and glance at the new low point.
The comparison between what you predicted and what happened is where the real education lives. If customers you booked as 30-day payers keep clearing at 45, your forecast just taught you something your gut had been rounding away, and every future week you plan is more honest for it. Within a couple of months of weekly updates, most owners can predict their low weeks within a few hundred dollars, which changes the feel of running the business more than almost anything else on this site.
The mistakes that quietly break forecasts
- Booking revenue when it is earned instead of when it is collected. The single most common error, and the most expensive. The forecast tracks the bank account, and the bank account does not care what you invoiced.
- Using invoice due dates instead of actual paying behavior. A customer who always pays two weeks late will pay two weeks late again. Forecast the behavior, not the terms.
- Forgetting the lumpy bills. Quarterly insurance, annual renewals, and tax deposits sink more forecasts than rent ever does, because rent never surprises anyone.
- Leaving out the owner. If you take money from the business to live, it is a cash outflow. A forecast that only balances when you work for free is not balanced.
- Building the optimistic version. The forecast's job is to warn you. Estimate collections a touch low and expenses a touch high, and let good news be the surprise.
What to do with what the forecast shows
If the window ahead looks solid, the forecast becomes a planning tool: it will tell you which week can absorb an equipment purchase or a new hire without strain. If it shows a dip, work the problem in order: pull collections forward, slow what can honestly be slowed, trim what is not earning, and only then price financing for whatever gap remains. Borrowing against a known, dated, bounded gap is a fundamentally different decision than borrowing against a bad feeling, and funders respond to the difference too: an owner who can say exactly how deep the gap is and when it closes presents a stronger file than one who cannot.
And if the forecast shows a slope rather than a dip, take that seriously. Financing a structural leak buys time and adds a payment, which makes the slope steeper. The honest sequence is to fix the leak first, at which point the forecast, kept weekly, will show you the repair in the bottom row. Seasonal businesses live this cycle every year, and the forecast is how they get ahead of it.
How to build a 13-week cash flow forecast
Set up the grid
Open a spreadsheet with 13 columns, one per week, labeled by each week's ending Friday. Down the left, create three blocks of rows: cash in, cash out, and balance.
Enter today's starting balance
Total every operating account and subtract payments already issued but not yet cleared. This number anchors the entire forecast, so start from the real figure, not a round one.
Fill in cash coming in
Place each unpaid invoice in the week you honestly expect the money to arrive, based on how that customer actually pays. Add expected new sales in the weeks their cash will reach the account.
Fill in cash going out
Work through three months of bank statements and put every outflow in the week it leaves the account: payroll on paydays, rent on the first, remittances in every week they run, plus the quarterly and annual bills.
Compute the running balance
For each week, take the prior week's ending balance, add that week's cash in, and subtract that week's cash out. Fill the bottom row across all 13 columns.
Mark the low point and the turn
Find the smallest number in the balance row and the week the line starts recovering. These two numbers, depth and date, are what every decision in the next quarter gets measured against.
Update it every week
Each week, replace estimates with actuals, shift any payment that moved, and add a new week at the end so the window stays 13 weeks long. The update takes about 15 minutes once the grid exists.
Frequently asked questions
How is a cash flow forecast different from a budget?
A budget sets spending intentions for a period; a forecast predicts the actual bank balance week by week. A budget can be perfectly respected while the business still runs out of cash, because budgets ignore timing. The forecast exists precisely to catch timing: which week money arrives and which week it leaves.
How accurate does a 13-week forecast need to be?
Directionally honest beats precisely wrong. The near weeks should be tight, because most of their contents are already known; the far weeks are allowed to be rough and get corrected as they approach. The weekly update is what makes the whole thing accurate over time, because every miss teaches you how your money actually behaves.
Can I use accounting software instead of a spreadsheet?
Software can help, and most accounting packages report cash historically rather than projecting it forward by week, so check what yours actually produces. Many owners run the spreadsheet alongside their accounting file: the books say what happened, the grid says what is coming. The format matters far less than the weekly habit.
What if my forecast shows a gap I cannot close?
First size it precisely: how deep, which week, and when it closes. Then work the non-borrowing levers, collections, deferrals, and cuts, which usually shrink it. If a bounded gap remains, financing it is a decision you can now price rationally, and the forecast itself becomes part of a stronger application, because it shows a funder exactly what the money is for and how it comes back.