How to Build a 13-Week Cash Flow Forecast (Free Template)
A 13-week cash flow forecast shows how much cash your business expects to receive, spend, and have available at the end of each of the next 13 weeks. Unlike a profit and loss statement, it focuses on the timing of actual cash movements. That makes it one of the most useful tools for preventing a surprise payroll, tax, or vendor-payment problem.
The forecast does not need to predict every dollar perfectly. Its job is to show when cash could become tight early enough for you to act. SCORE describes a rolling four-to-13-week forecast as a living management tool that helps owners make confident decisions before a cash issue becomes urgent.
What a 13-week cash flow forecast includes
Your forecast should have one column for each week and five core sections:
- Beginning cash: the cleared bank balance available at the start of the week.
- Cash receipts: expected customer payments, card settlements, loans, owner contributions, refunds, and other deposits.
- Cash payments: payroll, vendors, rent, taxes, debt payments, inventory, software, insurance, and other outflows.
- Net cash flow: total receipts minus total payments for the week.
- Ending cash: beginning cash plus net cash flow. This becomes the next week’s beginning balance.
Core formula: Beginning cash + cash received − cash paid = ending cash.
How to build a 13-week cash flow forecast
1. Start with the real available bank balance
Use reconciled bank balances, not the number shown on an unreconciled balance sheet. Exclude restricted funds and deposits that have not cleared. Include available credit separately; a line of credit is a backup source, not operating cash.
2. Estimate customer receipts by payment date
For accounts receivable, forecast when each customer is likely to pay—not merely the invoice due date. Review past payment behavior, disputed invoices, retainers, and collection promises. For card or e-commerce sales, use expected payout dates after processor holds, fees, refunds, and chargebacks.
3. List every significant cash payment
Begin with committed payments: payroll and payroll taxes, rent, debt service, critical vendors, insurance, sales tax, and estimated income tax. Then add planned inventory purchases, marketing, equipment, owner draws, and other discretionary spending. Use your accounts-payable aging, recurring-payment list, payroll calendar, and debt schedules rather than memory.
4. Separate fixed, variable, and one-time costs
Labeling payments makes the forecast actionable. Fixed costs are difficult to change quickly. Variable costs move with sales or production. One-time costs include deposits, annual renewals, equipment, and catch-up tax payments. If a future week drops below your minimum cash reserve, this classification shows which payments can realistically move.
5. Add a minimum cash threshold
Set a cash floor based on your operating risk—for example, one full payroll plus two weeks of essential vendor payments. Highlight any week when ending cash falls below that level. The threshold converts a spreadsheet into an early-warning system.
6. Roll the forecast forward every week
At the end of each week, replace forecast amounts with actual receipts and payments, investigate large differences, remove the completed week, and add a new week 13. A forecast that is updated only once a month loses much of its value.
Simple 13-week cash flow forecast template
| Cash flow line | Week 1 | Week 2 | Week 3 |
|---|---|---|---|
| Beginning cash | $40,000 | $32,500 | $39,000 |
| Customer receipts | $25,000 | $42,000 | $31,000 |
| Other receipts | $0 | $2,500 | $0 |
| Total cash payments | ($32,500) | ($38,000) | ($44,000) |
| Ending cash | $32,500 | $39,000 | $26,000 |
Continue the same structure through week 13 and add detail beneath receipts and payments. If week 3 falls below a $30,000 minimum reserve, management now has two weeks to accelerate collections, delay a nonessential purchase, adjust inventory orders, or arrange financing.
Three scenarios worth testing
- Base case: your most likely sales, collection, and spending assumptions.
- Downside case: slower collections, weaker sales, higher refunds, or an unexpected cost.
- Growth case: stronger sales with the extra payroll, inventory, fulfillment, and marketing cash required to support them.
This matters because growth can consume cash even while profit improves. A large order may require inventory and labor weeks before the customer pays.
Common forecasting mistakes
- Starting with an unreconciled or restricted cash balance.
- Using invoice dates instead of realistic collection dates.
- Forgetting payroll taxes, sales tax, debt principal, annual renewals, or owner draws.
- Treating a profitable month as proof that cash will be available.
- Entering the same sales number every week despite seasonality.
- Failing to compare forecast amounts with actual results.
Frequently asked questions
Why use 13 weeks?
Thirteen weeks is roughly one quarter. It is long enough to expose upcoming payroll, tax, inventory, and debt pressure but short enough to estimate receipts and payments with useful detail.
Is a cash flow forecast the same as a budget?
No. A budget usually tracks revenue and expenses under accounting rules. A cash forecast tracks the timing of money entering and leaving bank accounts, including loan proceeds, debt principal, and owner distributions.
How often should the forecast be updated?
Update it weekly. Businesses with very tight cash, high transaction volume, or a turnaround situation may need daily cash monitoring alongside the weekly model.
Turn the forecast into a weekly decision tool
The forecast is only as reliable as the books behind it. Reconciled bank accounts, current receivables and payables, and accurate payroll and debt schedules create a dependable starting point. AccoTiva’s fractional CFO services combine rolling cash forecasting with KPI reporting and decision support. If the underlying records need work first, our monthly bookkeeping service can establish a consistent close.
Book a free consultation to review your cash position and build a practical 13-week forecast for your business.
Source note: See SCORE’s cash flow management guidance. This article provides general information and is not tax, legal, or lending advice.