How to Build a 13-Week Cash Flow Model (Step-by-Step)
A practitioner's guide to building a 13-week cash flow forecast — the direct-method equation, driver-based receipts and payments, and a real bank-transaction roll-forward.
This is my take on the utility of the 13-week cash flow forecast — one of the most important finance and FP&A tools a business can run. It helps management and business owners assess their cash position for the next 13 weeks, and at a granular level for the next four to five weeks.
Believe me: your profit does not tell you your cash position. Many times, your cash is tied up in inventory and accounts receivable. In other cases, you may be accruing a bonus expense monthly, but the actual payout happens in one particular month. Your profit and loss statement will not accurately reflect the cash in your bank — because profit and cash simply run on different clocks.
Every organisation — whether very small or very large — should focus on cash flow projections, because this is one of the most basic and most important financial-management habits there is. Here is how I build a 13-week cash flow model that management can actually use.
How a 13-week cash flow forecast works
The equation is very simple. You take your opening cash balance, add projected cash receipts, subtract projected cash payments, and arrive at your forecasted cash balance for each of the next 13 weeks — and at a broader level, the next four to five weeks.
Opening cash + projected receipts − projected payments = forecast cash position
Repeat weekly for 13 weeks. Each week’s closing balance becomes the next week’s opening balance.
The equation is the easy part. The real challenge lies in calculating projected cash receipts and projected cash payments — and this is where most 13-week cash flow models go wrong.
Where most cash flow forecasts fail
I have seen many CFOs and CPAs build a standard template and simply take the average of the past 13 or 26 weeks to project future receipts and payments. This approach has real limitations: businesses are cyclical, and there are many receipts and payments that cannot be forecast accurately with a simple average.
I have also seen firms sit down with management at the start of the year — usually in January — identify expected expenditures, payments and receipts, create annual projections, and then simply update the template with actual bank transactions through the year. In my view, this does not provide meaningful insight, and it misses the true purpose of 13-week cash flow forecasting.
My approach is different. I break projected receipts and payments into separate, driver-based categories — because that is the only way the forecast reflects reality.
How to categorize projected cash receipts and payments
Rather than one blended “income” and “expenses” line, I build the forecast from the items that actually drive cash — each on its own tab.
Items tracked through orders and ledgers
- Accounts receivable as of the reporting date, and their expected collection dates.
- Sales orders as of the reporting date, expected shipping dates, and expected receipt dates based on customer payment terms.
- Purchase orders as of the reporting date, expected material-receipt dates, and expected payment schedules.
- Accounts payable and their expected payment dates.
Expenditures not tracked through purchase orders
- Salaries
- Rent
- Utility bills
- Employer taxes
- Professional fees
- Contractual payments
Receipts not tracked through sales orders
- Retail store sales
- Shopify sales
- E-commerce website sales
I also include expected credit card settlements — the day you sell is rarely the day the cash lands.
All of these categories are broken out into separate tabs, and we build in functionality for accountants and team members to update them every week. As a result, management and founders always have real-time visibility of expected receipts and expected payments — not a number that was frozen back in January.
Integrating actual bank transactions: the roll-forward
In addition to the forecast, we integrate actual bank transactions into the model. If we are preparing the forecast today, all bank transactions through the previous week should already be categorised. We take those actual transactions and build a robust roll-forward schedule.
Historical periods reflect actual bank activity; future periods reflect forecasted cash flows. That gives management a single tab that clearly shows:
- What has actually happened
- What is expected to happen
- The company’s projected cash position, based on real-world and real-time information
The payoff
Building a model like this takes significant effort upfront. But once it is properly designed and structured for easy weekly updates, it becomes a genuinely powerful management tool. From it you can create meaningful charts, variance analyses, trend reports and cash flow comparisons — the kind of insight that actually informs decisions. You stop reacting to cash and start running it, because a squeeze becomes something you see coming four to five weeks out instead of the morning it arrives.
That is my approach to 13-week cash flow forecasting. If you would like to start from something rather than a blank spreadsheet, grab our free 13-week cash flow template or the Weekly Cash Decision Calculator — no email wall. If you would rather talk it through, email me at anant@ease.pro. I hope you have a great day.
Frequently asked questions
What is a 13-week cash flow model?
A short-term liquidity forecast that projects your actual cash receipts and payments week by week over 13 weeks (one quarter), using the direct method — so you can see your cash position for the next 13 weeks and, at a granular level, the next four to five weeks.
How do you build a 13-week cash flow forecast?
Start with opening cash, add projected receipts and subtract projected payments each week. Build receipts and payments from their real drivers — AR and collection dates, sales orders, purchase orders, AP, payroll, rent, taxes — instead of averaging past periods, and roll forward actual bank transactions each week.
Why is averaging past weeks a poor way to forecast cash?
Because businesses are cyclical and many items are lumpy or one-off — a bonus accrued monthly but paid once, a large invoice that pays in week nine, a quarterly tax bill. Averaging the last 13 or 26 weeks smooths over exactly the timing you need to see.
How often should a 13-week cash flow model be updated?
Weekly. Replace the completed week with actual bank transactions, refresh the categories (AR, AP, sales and purchase orders), and add a new week at the end so you always look a full quarter ahead.
How is it different from an annual budget?
A budget is a longer-term, accrual-based plan for profitability. A 13-week cash flow model is a near-term, cash-based operational tool for liquidity. They answer different questions — “will we be profitable?” versus “can we meet our obligations over the next three months?” — and you need both.