Blog
How to Build a 13-Week Cash Flow Forecast for Your Small Business
Quick summary
- A 13-week cash flow forecast shows how much money you expect to receive and spend each week over the next three months.
- Start with available cash, estimate weekly receipts, list expected payments and calculate the closing cash balance for every week.
- Update the forecast weekly and create expected, best-case and worst-case scenarios.
- The goal is not perfect prediction. It is finding cash pressure early enough to take action.
A business can look profitable and still struggle to cover payroll, supplier bills or tax remittances. A 13-week cash flow forecast helps close that gap by showing when money is expected to arrive, when it needs to leave and where a shortage may develop.
The forecast works best when it is supported by current small business bookkeeping. If invoices, bills, loan payments or tax obligations are missing from the books, the forecast can create a false sense of security.
What is a 13-week cash flow forecast?
A 13-week cash flow forecast is a weekly projection of the money expected to enter and leave your business over the next 13 weeks. It starts with the cash currently available, adds expected receipts and subtracts planned payments to produce a projected closing balance for each week.
Thirteen weeks is useful because it provides approximately one quarter of visibility. It is close enough for estimates to remain practical but long enough to identify upcoming payroll runs, supplier obligations, tax deadlines, debt payments and seasonal pressure.
Why cash flow forecasting matters
Revenue and profit do not always show how much money is available to spend. A business may earn revenue when it issues an invoice, but the cash may not arrive for another 30, 60 or 90 days. At the same time, payroll, rent and suppliers still need to be paid.
- Customers have not paid their invoices.
- Inventory or materials must be purchased before a sale is collected.
- A large GST/HST, payroll or income-tax payment is approaching.
- Loan principal payments are using cash.
- A project requires significant upfront spending.
- Seasonal revenue has slowed.
- The business is growing faster than its working capital can support.
A forecast makes those timing differences visible. It can also support the practical cash flow decisions discussed in Agile’s bookkeeping blog, including faster invoicing, stronger collection processes and more deliberate spending.
Cash flow forecast versus profit and loss statement
| Report | What it shows | Primary question |
|---|---|---|
| Profit and loss statement | Revenue, expenses and profit over a period | Is the business earning a profit? |
| Cash flow forecast | Expected timing of cash receipts and payments | Will the business have enough cash to meet its obligations? |
For example, a $20,000 invoice may appear as revenue in August, while the customer payment does not arrive until October. The profit and loss statement and the cash flow forecast can therefore tell different stories, even when both are accurate.
How to create a 13-week cash flow forecast
1. Start with available cash
Record the cash that is available at the beginning of the first week. Include operating accounts and other funds that can realistically be used for business expenses. Do not include unapproved credit, restricted funds, personal savings or customer payments that have not been received.
2. Estimate weekly cash inflows
List the money you reasonably expect to receive each week. Use expected collection dates rather than invoice dates.
- Customer invoice payments
- Cash and card sales
- Recurring subscription revenue
- Deposits and progress draws
- Tax refunds
- Grants or subsidies
- Approved loan advances
- Owner or investor contributions
Customer behaviour matters. If a customer regularly pays 15 days late, use that history instead of assuming payment will arrive on the stated due date.
3. List weekly cash outflows
- Payroll and payroll remittances
- Supplier and subcontractor bills
- Rent and utilities
- Insurance and software
- GST/HST or PST remittances
- Income-tax instalments
- Loan principal and interest
- Credit-card payments
- Equipment purchases
- Owner withdrawals or distributions
Review bank statements, credit-card statements, open bills, recurring subscriptions and payroll schedules. Missing one significant payment can change the forecast materially.
4. Calculate each weekly closing balance
Opening cash + cash received − cash paid = closing cash
| Week | Opening cash | Cash received | Cash paid | Closing cash |
|---|---|---|---|---|
| Week 1 | $50,000 | $28,000 | $35,000 | $43,000 |
| Week 2 | $43,000 | $18,000 | $31,000 | $30,000 |
| Week 3 | $30,000 | $42,000 | $29,000 | $43,000 |
The closing balance from one week becomes the opening balance for the next. The real value is seeing which week creates pressure and which receipts or payments are responsible.
5. Set a minimum cash requirement
Decide how much cash the business should maintain as an operating buffer. Consider payroll, fixed costs, revenue predictability, customer payment timelines, access to credit, seasonality and supplier requirements. A projected balance can remain positive while still being uncomfortably low.
6. Build multiple scenarios
- Expected case: Payments and costs follow the most likely assumptions.
- Best case: Customers pay sooner, sales are stronger or selected costs are delayed.
- Worst case: Major customers pay late, revenue slows or expenses increase.
The worst-case scenario shows how much flexibility the business has and whether financing or cost changes should be discussed before the situation becomes urgent.
7. Update the forecast every week
- Replace the projected opening balance with the actual bank balance.
- Replace estimates from the prior week with actual results.
- Review expected customer-payment dates.
- Update supplier, payroll, debt and tax obligations.
- Add a new week to the end of the rolling forecast.
- Investigate material differences between the forecast and reality.
Agile’s weekly bookkeeping workflow helps keep transactions, questions and supporting documents moving throughout the month, giving owners a cleaner starting point for each forecast update.
What to do when the forecast shows a cash shortage
- Follow up on overdue invoices.
- Request deposits or progress payments.
- Adjust payment terms for future work.
- Negotiate supplier-payment timing.
- Delay discretionary spending.
- Review inventory purchasing.
- Reschedule a non-urgent investment.
- Discuss an operating line with a lender before cash becomes critical.
- Reduce spending that is not producing sufficient value.
A projected gap does not automatically mean the business is failing. It means a decision may be required. The earlier the warning appears, the more options the owner generally has.
Common cash flow forecasting mistakes
Using sales instead of expected collections
A sale does not improve the bank balance until the customer pays.
Forgetting tax obligations
GST/HST, payroll remittances and income-tax instalments can create large cash outflows.
Ignoring loan principal
Loan principal reduces cash even though it does not normally appear as an operating expense.
Assuming every invoice will be paid on time
Use actual customer-payment history rather than ideal terms.
Updating the forecast only during a crisis
The forecast is most useful as a regular management tool.
Building from outdated books
Missing invoices, uncategorized transactions and unreconciled accounts weaken the forecast.
How current bookkeeping improves cash flow forecasting
A forecast depends on knowing what customers owe, which bills are outstanding, what has already been paid, which recurring expenses are approaching and what tax or payroll obligations are accumulating.
Agile’s bookkeeping services keep the records moving weekly, reconcile accounts monthly and provide CPA-managed review and current reporting. This does not replace financial planning or advisory support. It creates the cleaner bookkeeping foundation those decisions depend on.
Frequently asked questions
What is a 13-week cash flow forecast?
A 13-week cash flow forecast is a weekly estimate of the cash expected to enter and leave a business over the next 13 weeks. It shows the projected closing cash balance for each week.
Why do businesses use a 13-week forecast?
Thirteen weeks provides roughly one quarter of visibility. It is long enough to identify upcoming payroll, supplier, tax and debt obligations while remaining practical to update every week.
How often should a cash flow forecast be updated?
A short-term cash flow forecast should generally be reviewed and updated weekly. A fast-changing or cash-constrained business may need to review it more frequently.
Is cash flow the same as profit?
No. Profit measures whether revenue exceeds expenses over a period. Cash flow measures the actual movement of money. A profitable business can still experience a cash shortage.
What should be included in a cash flow forecast?
Include expected customer payments, sales, deposits, payroll, supplier payments, tax remittances, debt payments, operating expenses, equipment purchases and other planned cash movements.
Can bookkeeping software create a cash flow forecast?
Software can organize historical information and expected activity, but the forecast still needs realistic assumptions about collection dates, future sales, upcoming expenses and unusual events.
Get clearer information before cash gets tight
Agile keeps your books current, your reconciliations moving and your reports visible so you can understand what has been collected, what is owing and what may be coming next.