Money · Money
13-Week Cash Flow Forecast: How to Build One Before January
A weekly view of cash in and cash out shows shortfalls before they hit. Here is how to build one in an afternoon, with a worked example.
- (Author)
- Callum Reyes
- (Published)
- (Reading)
- 7 min
- (Section)
- Money
In this guide 10 sections
A 13-week cash flow forecast lists the cash you expect to receive and pay out each week for the next quarter. Start with your bank balance, add expected customer payments, subtract known bills, payroll and taxes, and carry the running balance forward. Update it every week so surprises show up while you can still act.
Building a 13-week cash flow forecast takes one afternoon and a spreadsheet, and January is the best time to start. This guide is for owners and managers of small companies who are profitable on paper but nervous about the bank balance. Emazoo covers money from the owner's side of the desk, and this is the one report we would build first.
What Is a 13-Week Cash Flow Forecast?
A 13-week cash flow forecast is a weekly table of expected cash in, expected cash out and the closing bank balance for the next 13 weeks. It covers one quarter. It shows the date a shortfall may happen, which a monthly profit report cannot do.
The Federal Deposit Insurance Corporation (FDIC) draws a clear line in its Money Smart for Small Business cash flow module. A cash flow statement is a backward-looking record of actual cash movements. A cash flow projection is a forward-looking estimate of inflows and outflows, also called a pro-forma statement. Your 13-week forecast is a projection, and your bank statements supply the actuals that keep it honest.
Why Do Small Businesses Need One Now?
Cash timing is a common problem, and the data shows it. The Federal Reserve Banks' 2026 Report on Employer Firms, based on a survey of 6,500 firms, found that 73% cited rising costs, 54% cited trouble paying operating expenses and 50% cited uneven cash flow. Uneven cash flow includes slow collection of receivables.
January adds its own pressure. Payroll tax rates reset, insurance renewals land, and the fourth-quarter estimated tax payment is due on January 15. Our guide to fourth-quarter estimated taxes explains that payment, and our report on 2027 health insurance renewals shows why premiums deserve their own line.
Shipping and wage costs are also moving. Both belong in the forecast as soon as you know the new rate, including the changes covered in our FedEx 2027 rate increase breakdown.
How Do You Build a 13-Week Cash Flow Forecast?
You build it in six steps, and each step uses data you already have. The Small Business Administration (SBA) notes in its guide to managing your finances that cash-basis records show cash flow clearly, which makes them a good starting point for this table.
- Open a spreadsheet with 13 columns, one for each week, and label each with its start date.
- Enter your opening bank balance across all accounts in the first week.
- List expected cash in by week, using invoice due dates and your real average collection time.
- List cash out by week, including payroll, rent, suppliers, loan payments, taxes and insurance.
- Calculate the closing balance, which is opening balance plus cash in minus cash out.
- Carry each closing balance forward as the next week's opening balance.
Be strict with step three. Count a payment only in the week you expect the money to arrive. If a customer usually pays 45 days after the invoice date, use week 7 or 8, not the due date. When in doubt, push a receipt one week later.
Step four needs the same discipline. Spread monthly bills into the week they leave your account. Place annual costs, such as a software renewal or a license fee, in the exact week they renew.
What Does a Forecast Look Like With Real Numbers?
Take a small print shop with 12 staff. It opens January with $30,000 in the bank and sets a minimum buffer of $25,000, which is about one and a half weeks of average spending. Payroll runs every two weeks at $14,200. Rent is $3,800 and insurance is $2,400, both paid in the first week of the month.
| Week | Opening | Cash in | Cash out | Closing |
|---|---|---|---|---|
| Week 1 (Jan 4-10) | $30,000 | $19,500 | $25,600 | $23,900 |
| Week 2 (Jan 11-17) | $23,900 | $22,000 | $13,000 | $32,900 |
| Week 3 (Jan 18-24) | $32,900 | $9,000 | $19,400 | $22,500 |
| Week 4 (Jan 25-31) | $22,500 | $20,500 | $8,200 | $34,800 |
| Week 5 (Feb 1-7) | $34,800 | $12,000 | $25,600 | $21,200 |
| Week 6 (Feb 8-14) | $21,200 | $23,000 | $6,500 | $37,700 |
The business is healthy, yet three closing balances fall below the buffer. Week 1 carries rent, insurance and payroll together. Week 3 has payroll and a weak week of receipts. Week 5 repeats the first-week pattern. A profit report would show none of this.
The forecast also suggests actions with dates attached. The owner can ask two large customers to pay early in weeks 2 and 4. The shop can split a supplier order so $3,000 leaves in week 2 instead of week 1. A short line of credit becomes a planned backstop, not a panic call.
How Often Should You Update the Forecast?
Update it weekly, on the same day, and it will earn its keep. Replace last week's forecast numbers with the actual bank figures, then add a new week 13 at the end. The table always looks 13 weeks ahead.
Add two columns that show forecast and actual side by side. A gap of more than 10% on any major line is a signal. Perhaps customers pay more slowly than you assumed, or a supplier invoiced early. Fix the assumption, not just the number.
Keep the weekly review short. Ten minutes covers the bank balance, new invoices, bills due this week and bills due in two weeks. At Emazoo, we also recommend that one named person owns the file, so it does not stall when the owner is busy.
How Do You Stress-Test the Forecast?
Run a base case, a slow-pay case and a cost-shock case. The base case uses your best estimates. The slow-pay case moves your largest expected receipts one or two weeks later. The cost-shock case adds a surprise bill, such as a repair or a higher premium.
The print shop example shows why this matters. If the $22,000 expected in week 2 slips by one week, week 2 closes at $10,900 instead of $32,900. Week 3 recovers to $22,500, but the shop would have spent a week well under its buffer. That single test tells the owner to chase that payment before it is late.
Write down the trigger for each action. For example, "If closing cash falls below $25,000, call the top three overdue customers and delay discretionary purchases." A written rule is easier to follow on a stressful Friday than a vague plan.
Should You Use a Spreadsheet or Accounting Software?
Start with a spreadsheet, because it is free and visible. A sheet with 13 columns and about 20 rows is enough for most companies under 50 people. You can see every formula, change an assumption in seconds and share the file with a bookkeeper.
Accounting software can feed in actual bank and invoice data, which saves typing. It also adds subscription cost, so review what you pay before you rely on it. Our look at the QuickBooks Online price increase shows how to judge whether a plan earns its fee.
Whatever you choose, keep one rule. Every number should trace back to a bank statement, an invoice or a contract, so that someone else can check it in a few minutes.
Which Lines Do Owners Forget?
The most common misses are the irregular ones. The following list shows what to check before you call the forecast complete.
- Quarterly and annual tax payments, including the January 15 estimated tax date.
- Payroll tax deposits and year-end bonuses.
- Insurance renewals and premium increases.
- Software renewals billed once a year.
- Loan principal payments, which do not appear on a profit report.
- Owner draws or dividends you pay yourself.
- Equipment purchases and repairs you already planned.
Payroll deserves its own care. Our note on the 2027 minimum wage increases shows how a January 1 pay change flows into every payroll week after it.
What Mistakes Make a Forecast Useless?
The first mistake is optimism about receipts. Money owed is not money received. The second is mixing accrual profit with cash timing, so that a sale counts in the month you invoiced it even though the payment arrives much later. The third is making the file so complex that nobody updates it.
Another mistake is ignoring the buffer. A forecast that shows a closing balance of $400 is technically positive and practically unsafe. Pick a floor that covers at least a week or two of average spending, and treat any breach as a trigger for action.
Finally, avoid forecasting once and filing it away. A forecast is only valuable while it stays current. If you cannot commit to a weekly update, simplify the lines instead of dropping the habit.
Conclusion: Build Your 13-Week Cash Flow Forecast This Week
A 13-week cash flow forecast turns the question "Will we be fine?" into a dated list of the weeks that may fall short. Start with your real bank balance, enter receipts late and bills early, add the January tax and insurance dates, and set a buffer. Then update it weekly. Your next step is to open a blank sheet, label 13 columns and enter this week's opening balance.