How to Build a Simple 13-Week Cash Flow Forecast
A rolling 13-week forecast shows when cash will be tight before it happens. Here is how to set one up in a spreadsheet and keep it current with a weekly routine.
Annual budgets are useful for big-picture planning, but they rarely tell you whether you can cover payroll three weeks from Friday. That is the job of a short-term cash flow forecast. A 13-week forecast, roughly one quarter looking forward, is a common tool among finance teams and turnaround specialists, and it works just as well for a small business with a spreadsheet. This is general guidance. An accountant can help you tailor the approach to your business.
Why thirteen weeks
Thirteen weeks is long enough to spot problems while there is still time to act, and short enough that your estimates stay reasonably accurate. Weekly detail matters because cash problems usually come from timing: a large bill landing the same week a big customer pays late. Monthly totals can hide those collisions.
Set up the spreadsheet
Create a column for each of the next thirteen weeks. Then build rows in this order:
- Beginning cash. The bank balance at the start of the week.
- Cash receipts. Customer payments you expect to collect, other income, and any loan proceeds or owner contributions.
- Cash disbursements. Payroll and payroll taxes, rent, supplier payments, loan payments, insurance, taxes, software and any planned purchases.
- Net cash flow. Receipts minus disbursements.
- Ending cash. Beginning cash plus net cash flow, which becomes next week’s beginning cash.
Add a row for your minimum comfortable balance so any week that dips below it stands out.
Fill in realistic numbers
The forecast is only as good as its assumptions. For receipts, list open invoices by customer and estimate when each will actually be paid based on that customer’s history, not the due date. Add expected new sales conservatively. For disbursements, start with fixed obligations such as payroll dates, rent and loan payments, then add variable costs. Be sure to include items that do not occur every week, such as quarterly tax payments, annual insurance premiums and software renewals.
Make it a weekly habit
A forecast gains value through repetition. Once a week, ideally on the same day:
- Replace last week’s forecast with actual results.
- Note where the forecast was wrong and why.
- Add a new week at the end so you always see thirteen weeks ahead.
- Update expectations for collections and upcoming payments.
Over time, comparing forecast to actual makes your estimates sharper and reveals patterns, such as customers who consistently pay late.
Use it to make decisions
When the forecast shows a tight week ahead, you have options that disappear if you only notice on the day. You might follow up harder on specific invoices, ask a customer for a deposit, adjust the timing of a purchase, talk to a supplier about terms or arrange a line of credit in advance. When the forecast shows extra cash, you can plan investments with confidence. If the forecast shows sustained shortfalls, talk to your accountant or financial advisor early, while you still have room to maneuver.
A Worked Example
Numbers make the idea concrete. Here is a simplified, hypothetical example for a small service business. The figures are invented for illustration only.
Suppose the business starts week one with $40,000 in the bank and wants to keep at least $15,000 on hand at all times. Payroll of $18,000 runs every other week. Rent of $4,000 is due in the first week of each month. A quarterly estimated tax payment of $9,000 falls in week six. Customers pay roughly $16,000 per week on average, but one large client, who owes $20,000, typically pays about three weeks late.
- Week one: beginning cash $40,000, receipts $16,000, payroll and rent $22,000, ending cash $34,000.
- Week two: receipts $16,000, minor expenses $3,000, ending cash $47,000.
- Week three: receipts $16,000, payroll $18,000, ending cash $45,000.
- Weeks four through six: if the large client’s payment slips past week six, the combination of payroll, rent and the tax payment could push the balance close to, or below, the $15,000 floor.
Seen week by week, the risk becomes obvious a month in advance. That gives the owner time to call the large client, ask about the payment schedule, delay a planned equipment purchase or line up short-term credit before it is needed.
Common Mistakes When Building the Forecast
- Using invoice due dates instead of real payment habits. If a customer always pays in forty-five days, forecast forty-five days, whatever the invoice says.
- Forgetting irregular expenses. Annual renewals, insurance premiums, quarterly taxes and equipment repairs are the bills most likely to cause surprises.
- Mixing profit with cash. A sale booked this month may not become cash for weeks. The forecast tracks money in the bank, not revenue on paper.
- Being optimistic about new sales. Include only deals you are confident will close, and consider a second version without them.
- Building it once and abandoning it. A forecast updated weekly becomes sharper over time. One left alone becomes fiction within a month.
Adding a Simple “What If” Version
Once the basic forecast is working, copy it into a second tab and change a few assumptions to see how sensitive your cash is. Useful scenarios include:
- Your largest customer pays four weeks later than expected.
- New sales come in at half the expected level for a month.
- A major piece of equipment needs an unplanned repair.
- A slow season starts two weeks earlier than usual.
If any scenario pushes cash below your minimum, you have learned something valuable while there is still time to plan around it.
Questions Owners Ask About Cash Forecasting
How long does this take each week?
The first version may take a few hours. After that, updating it usually takes well under an hour, especially if you keep invoices and bills organized.
Should I include my own pay?
Yes. Owner draws or salary are real cash leaving the business and belong in the disbursements section.
Do I need special software?
No. A spreadsheet works well for most small businesses. Accounting software can help by exporting open invoices and bills, but the thinking matters more than the tool.
Once you have a few months of history, add a small notes column beside each week explaining any big surprise. Those notes turn the forecast into a memory of how your business actually behaves.
Every business has its own patterns, so it is worth reviewing your first forecast with an accountant who can help you spot items you may have missed.











