How to Build a 13-Week Cash Flow Forecast (With a Simple Template)
The 13-week cash flow forecast is the tool turnaround specialists reach for first when a company is in trouble, and the tool healthy businesses use to stay out of it. It takes an afternoon to build and 30 minutes a week to maintain. Here is the full method, with a template you can copy into any spreadsheet.
Key takeaways
- A 13-week forecast tracks expected cash in and cash out, week by week, for one quarter ahead. It shows the exact week a shortfall will hit.
- It is built on cash timing, not accounting rules. Record money in the week it actually arrives or leaves the bank.
- Update it every week: replace last week's forecast with actuals, add a new week 13, and review the variances.
- The first version will be wrong. Accuracy comes from the weekly update, not from the initial build.
Most small business cash problems are not surprises. The tax payment was always due in April. The big client always pays 60 days late. The seasonal dip happens every year. What is missing is a document that puts all of those dates on one page, so the owner can see three months ahead instead of three days.
That document is the 13-week cash flow forecast. The 13-week horizon is not arbitrary: it is one quarter, long enough to see the next major payments coming and short enough that weekly estimates remain reasonably accurate. Restructuring advisers use it because it forces honesty about timing. You should use it for the same reason.
Why weekly, and why 13 weeks
A monthly cash forecast can hide a crisis. A month that shows $10,000 of net cash inflow can still contain a week where payroll is due on Friday and the big customer payment lands the following Tuesday. Weekly granularity shows that gap. Thirteen weeks gives you time to act: to chase invoices, delay a purchase, arrange a line of credit or talk to a supplier before the shortfall arrives rather than the morning it does.
A study by the JPMorgan Chase Institute found that the median small business held only about 27 days of cash buffer, meaning it could cover its outflows for less than a month if inflows stopped. With a margin that thin, knowing the exact week of a shortfall is the difference between a managed problem and an emergency.
The template layout
Open a blank spreadsheet. Across the top, put 13 columns labeled with the Friday (or whichever day you choose) of each week, starting with the current week. Add a fourteenth column for the 13-week total. Down the side, build these sections.
| Section | Typical rows | Source of the numbers |
|---|---|---|
| Opening cash balance | One row | Reconciled bank balance for week 1; prior week's closing balance after that |
| Cash receipts | Customer collections, card and cash sales, other income, loan or owner funds | Aged receivables report, sales history, known agreements |
| Operating payments | Payroll, payroll taxes, rent, suppliers, utilities, insurance, software, marketing, owner draws | Aged payables, payroll calendar, recurring bills |
| Non-operating payments | Sales tax or VAT, income tax, loan principal and interest, equipment purchases | Tax calendar, loan schedules, capital plan |
| Net cash flow | One row | Total receipts minus total payments |
| Closing cash balance | One row | Opening balance plus net cash flow |
| Minimum cash target | One row | The floor you have decided never to go below |
Keep the rows to the 15 or 20 that matter. If a category is small and predictable, lump it into "other operating payments." The forecast is a decision tool, not a ledger.
Building the forecast step by step
- Start with today's reconciled bank balance. Not the balance on the banking app, which may exclude checks that have not cleared or card payments in transit. Use the reconciled figure from your accounting software. This is week 1's opening balance.
- Forecast collections from existing invoices. Print your aged receivables report. For each open invoice, estimate the week it will actually be paid, based on that customer's history, not on the due date. A customer that always pays 15 days late should be forecast 15 days late. Enter each expected payment in its week.
- Forecast new sales and their collection. For cash and card sales, use last year's weekly pattern adjusted for current trends. For invoiced work, forecast when you will invoice and then apply your average collection delay. If you typically collect 40 days after invoicing, an invoice raised in week 2 lands in week 8.
- Enter fixed outflows in their exact week. Payroll on the dates it runs, rent on the first, loan payments on their due dates, insurance in the month it renews. Software and subscriptions on their billing dates. These are the easy, high-confidence rows.
- Enter supplier payments from the aged payables report. Place each bill in the week you intend to pay it. Be honest. If you will stretch a supplier to 45 days, forecast 45 days, but note it so you can see how much of your cash position depends on paying late.
- Add taxes and irregular items. Sales tax or VAT remittances, estimated income tax, annual licenses, planned equipment purchases. These are the items that most often blow up a cash position because they are large and infrequent. Check the dates against your tax calendar.
- Calculate net flow and closing balance for each week. Closing balance for week 1 becomes opening balance for week 2, and so on. Add a row showing the difference between closing balance and your minimum cash target. Any negative number in that row is the week you need to fix.
- Decide what to do about each shortfall. For every week below the minimum, list the actions available: accelerate a collection, delay a payment, draw on a credit line, reduce owner draws. Write the chosen action into a notes column. The forecast without the decision is only half the job.
A worked example
Suppose you run a small commercial cleaning company. Your opening bank balance is $32,000 and you have set a minimum cash target of $15,000. Here is a simplified view of the first six weeks.
| Week | Receipts | Payments | Net flow | Closing balance |
|---|---|---|---|---|
| 1 | $14,000 | $21,000 (payroll) | ($7,000) | $25,000 |
| 2 | $9,000 | $6,500 | $2,500 | $27,500 |
| 3 | $11,000 | $23,000 (payroll, rent) | ($12,000) | $15,500 |
| 4 | $8,000 | $12,000 (sales tax due) | ($4,000) | $11,500 |
| 5 | $26,000 (large client pays) | $21,500 (payroll) | $4,500 | $16,000 |
| 6 | $10,000 | $7,000 | $3,000 | $19,000 |
Week 4 is the problem. The closing balance of $11,500 is $3,500 below the minimum, because the sales tax payment lands a week before the largest client pays. Seeing this four weeks ahead, the owner has options. She could ask the large client whether the invoice can be paid a week early, perhaps with a small discount. She could ask the supplier of cleaning materials to move a $4,000 payment from week 4 to week 5. Or she could simply accept that the balance dips to $11,500 for one week, since the money arrives in week 5 and nothing bounces. The point is that she chooses, rather than discovering the dip when a payment fails.
Common mistake
Forecasting receipts on invoice due dates instead of actual payment behavior. If your terms are 30 days but customers pay in 45, a forecast built on due dates will show cash two weeks before it arrives, every week, and the shortfall will come as a surprise anyway. Use the real average for each major customer.
The weekly routine
The build is a one-time job. The value comes from a short weekly ritual, best done on the same day each week once the bank reconciliation is complete.
- Replace last week's forecast with actuals. Enter what actually came in and went out. The closing balance should now match the bank.
- Review the variances. Which receipts did not arrive? Which payments were higher than expected? Each variance is either a timing slip (roll it forward) or new information (update the assumption for future weeks).
- Roll the forecast forward. Drop week 1, shift everything left, and add a new week 13 at the end.
- Re-check the minimum cash row. Has any week dropped below the floor? If so, decide the action now.
- Note what you learned. If a customer paid 20 days late again, change their collection assumption permanently.
Pro tip
Add a confidence column next to each receipt: high for signed contracts and recurring payments, medium for regular customers, low for prospects and hopeful sales. Then look at your closing balance with low-confidence receipts removed. If that version is still above your minimum, you are safe. If it only works when the hopeful money arrives, you are not.
Hypothetical example
Imagine a small software consultancy that bills monthly and usually collects in 35 days. The owner builds the forecast and discovers that in week 9, a quarterly estimated tax payment of $18,000 coincides with payroll, and the only receipt that week is a medium-confidence invoice from a new client. The low-confidence version shows the balance going to minus $6,000. With nine weeks of notice, the owner opens a $25,000 line of credit with the bank, which takes three weeks to arrange, and never has to draw on it because the new client pays on time. Without the forecast, the owner would have been applying for credit in a panic the same week the payment was due, and the bank might have said no.
Spreadsheet or software?
A spreadsheet is the right tool for most small businesses. It is flexible, you own it, and a 13-week model is small enough to stay manageable. Google Sheets or Excel both work, and a simple layout with the week dates across the top, a few conditional formatting rules to highlight weeks below the minimum and a formula chain for the balances is all you need.
Cash flow forecasting tools that connect to accounting software exist and can pull in open invoices and bills automatically, which saves the weekly data entry. They are worth considering once the business has hundreds of transactions a week. Prices and features change often, so check current plans before committing. For most owners, start with the spreadsheet, learn what drives your cash, and only buy software when the manual update becomes the bottleneck.
A 13-week forecast is essential when
- Customers pay on invoice terms rather than at the point of sale
- Payroll is a large share of monthly outflows
- Revenue is seasonal or lumpy
- You carry debt with fixed repayment dates
- You are planning a hire, a purchase or an expansion
A simpler monthly view may do when
- Sales are paid immediately by card or cash
- Costs are small, stable and mostly on autopay
- You hold several months of expenses in reserve
- The business has no employees and no debt
Taxes and country differences
Tax payments are the largest irregular outflows in most forecasts, and their timing depends on where you operate. In the United States, estimated income taxes are generally paid quarterly, payroll taxes on a schedule set by the IRS based on your deposit history, and sales tax monthly, quarterly or annually depending on the state and your volume. In countries with value-added tax, VAT returns and payments are usually monthly or quarterly, and the amount can be large because it includes tax collected on behalf of the government. Put every tax date on the forecast as soon as you know it, and remember that rates, thresholds and deadlines change, so confirm them with your accountant or tax authority each year rather than copying last year's dates.
Your 13-week forecast setup checklist
- Reconcile the bank account so week 1 starts from a correct balance
- Set up 13 weekly columns plus a total, and the receipts, payments and balance sections
- Enter every open receivable in the week you realistically expect payment
- Enter payroll, rent, loan and subscription payments on their exact dates
- Add every tax payment due in the next quarter from your tax calendar
- Set a minimum cash target and add a row that flags any week below it
- Write a planned action next to every flagged week
- Put a recurring 30-minute weekly update in the calendar
Frequently asked questions
How accurate does the forecast need to be?
Weeks 1 to 4 should be close, within a few percent, because most of those movements are already known. Weeks 9 to 13 will be rougher. That is fine. The near weeks tell you what to do now; the far weeks tell you what to start preparing for.
What minimum cash target should I set?
A common starting point is one full payroll cycle plus the next tax payment, or roughly four to six weeks of fixed costs. Raise it if your receipts are unpredictable. The target is a floor for decision-making, not a legal requirement, so pick a number you would be genuinely uncomfortable going below.
Should I include owner draws?
Yes, as a payment line. Owner draws are one of the most controllable outflows, and seeing them on the same page as payroll and tax makes it easier to adjust them in a tight week rather than finding out afterward that the draw caused the shortfall.
How is this different from a budget?
A budget plans income and expenses for the year, usually by month and on an accounting basis. The 13-week forecast tracks bank movements by week. The budget tells you whether the year will be profitable; the forecast tells you whether you can pay everyone on Friday.
Related reading
The bottom line
A 13-week cash flow forecast is a spreadsheet with 13 columns, a few dozen rows and one rule: record money in the week it actually moves. Build it from the reconciled bank balance, real customer payment behavior and exact payment dates. Then update it every week, roll it forward and decide what to do about any week below your minimum. It is the cheapest insurance a small business can buy against the most common cause of failure.
