Cash Flow Forecast Template: Build a 13-Week View
A cash flow forecast template is a structured spreadsheet that projects your cash inflows and outflows week by week, typically over 13 weeks, so you can see upcoming shortfalls before they happen. This guide gives you a ready-to-copy structure, line-item definitions, and a worked freelancer example to build yours in an afternoon.
- A 13-week cash flow forecast template tracks weekly cash in and out, not accounting profit.
- Use four core categories: operating inflows, operating outflows, financing, and investing.
- Start with your actual bank balance, then add only confirmed or highly likely cash movements.
- Update the rolling cash flow forecast every week to stay 13 weeks ahead.
- A cash flow forecast vs budget: the forecast predicts timing; the budget sets targets.
Key Takeaways
- A 13-week cash flow forecast template tracks weekly cash in and out, not accounting profit.
- Use four core categories:operating inflows.
- Start with your actual bank balance, then add only confirmed or highly likely cash movements.
- Update the rolling cash flow forecast every week to stay 13 weeks ahead.
- A cash flow forecast vs budget: the forecast predicts timing; the budget sets targets.
What a 13-Week Cash Flow Forecast Actually Tells You
A 13-week cash flow forecast is a short-term liquidity tool that shows the exact weeks when cash will dip below safe levels. Unlike an annual budget, it focuses on timing—when invoices get paid, when bills leave your account—so you can act before a shortfall becomes a crisis.
For freelancers and small teams, the 13-week horizon hits the sweet spot: long enough to cover most payment cycles, short enough to stay accurate. It answers three questions: Will I make payroll next month? Can I afford this software subscription? When can I safely take a distribution?
Because it is weekly, it catches mismatches that monthly reports hide. A client who pays on day 45 instead of day 30 can push a tight week into the red even if the quarter looks fine overall.

The Line Items Every Forecast Needs (and What to Skip)
Every cash flow forecast template needs a starting cash balance. Skip accrual items like depreciation and unpaid invoices you have not sent—they do not move cash this week.
Cash flow forecast categories
Group line items into four categories so you can see where money comes from and goes. Operating inflows include client payments, retainer fees, and product sales. Operating outflows cover contractors. Financing covers loans and owner contributions. Investing covers equipment purchases.
Within each category, list only items that will settle in cash during the 13 weeks. For a freelancer, that might be five to ten lines total. For a small team, twenty to thirty. More lines add detail but also maintenance burden—keep it lean.
Line-item definitions you can copy
| Line item | Definition | Timing rule |
|---|---|---|
| Opening cash | Bank balance at start of week | Actual cleared balance |
| Client payments | Cash received from invoices | Expected payment date, not invoice date |
| Retainers | Recurring monthly fees | Contract billing date |
| Contractor pay | Payments to subcontractors | Agreed payment terms |
| Software subscriptions | Recurring SaaS charges | Charge date on card statement |
| Taxes | Estimated or scheduled tax payments | Official due dates |
| Loan repayments | Principal and interest | Lender schedule |
| Owner draw | Cash you take out | Planned transfer date |
Skip depreciation, accounts receivable you have not invoiced, and any “maybe” income. If a payment is not confirmed, put it in a separate “pipeline” column outside the main forecast so it does not create false comfort.
Worked Example: A Freelancer’s 13-Week Forecast
Here is a simplified cash flow forecast example for a freelance designer with $8,000 in the bank, two retainer clients, and one project-based client. The forecast shows weeks 1–4 in detail; the same logic extends to week 13.
Assume the designer pays themselves $4,000 per month, has $1,200 in monthly fixed costs (software, insurance, accounting), and owes a $3,000 quarterly tax payment in week 6. One client pays 30 days after invoice; another pays 45 days.
| Week | Inflows | Outflows | Ending cash |
|---|---|---|---|
| 1 | $2,500 retainer | $1,200 fixed + $1,000 draw | $8,300 |
| 2 | $0 | $1,000 draw | $7,300 |
| 3 | $3,000 project payment | $1,000 draw | $9,300 |
| 4 | $2,500 retainer | $1,200 fixed + $1,000 draw | $9,600 |
| 6 | $0 | $3,000 tax | $5,400 (est.) |
By week 6, the tax payment drops cash to roughly $5,400—still positive but tight. Without the forecast, the designer might have booked a $2,000 equipment purchase in week 5 and risked a near-zero balance. The template makes that trade-off visible early.
For a small business cash flow forecast, add payroll and rent lines. The structure stays the same; only the number of rows grows.
Common Forecasting Mistakes That Create False Comfort
The most common mistake is forecasting revenue instead of cash. A $10,000 invoice sent in week 1 is not cash until it clears—often week 5 or later. Build your forecast on payment dates, not invoice dates.
Second, many freelancers omit taxes and owner draws. Both are real cash outflows. If you leave them out, the forecast looks healthier than reality and you may overspend.
Third, static forecasts go stale fast. A rolling cash flow forecast—updated weekly and extended one week forward—stays accurate. Set a 15-minute weekly review; it is the highest-return habit in cash management.
Finally, do not mix personal and business cash. Keep separate lines or separate templates. Mixing them hides the true burn rate of the business.
Cash flow forecast vs budget: what is the difference?
A cash flow forecast predicts when cash will move; a budget sets planned targets for income and spending. The forecast is a timing tool updated weekly; the budget is a planning tool reviewed monthly or quarterly. You need both, but they answer different questions.
How to Build Your Template in an Afternoon
Follow this step-by-step framework to go from blank sheet to working 13-week forecast in about two hours.
- Open a spreadsheet and create 13 weekly columns plus a label column.
- Enter your current bank balance in the opening cash row.
- List confirmed inflows by expected payment date.
- List fixed outflows (rent, software, insurance) on their charge dates.
- Add variable outflows (contractors, taxes, draws) on planned dates.
- Calculate ending cash for each week: opening + inflows − outflows.
- Highlight any week where ending cash falls below one month of fixed costs.
- Set a weekly reminder to update actuals and roll the forecast forward.
If spreadsheets are not your strength, a dedicated tool can automate the roll-forward and flag low-cash weeks for you.
How to Run Your Forecast in GoWithFund Smart Finance
GoWithFund Smart Finance is built for exactly this job: it turns your budgets and transactions into cash-flow reports so you can see weekly balances without rebuilding a spreadsheet each time. You can set up a 13-week view, categorize inflows and outflows, and review a rolling forecast alongside your budget.
For freelancers, the app helps separate business and personal cash, track subscription charges, and spot weeks where the balance dips. For small teams, it gives a shared view so everyone works from the same numbers.
You still need to enter confirmed payment dates—no tool can predict a late client—but Smart Finance removes the manual roll-forward and arithmetic errors. Start with the template above, then move it into the app when you want the weekly update to take five minutes instead of thirty.






