13-week cash flow forecast template
A cash flow forecast lists the cash the business expects to receive and pay, by date. Each week, opening cash plus receipts minus payments gives the closing cash. This free Excel template forecasts 13 weeks by the direct method, places cheques and monthly payments in their weeks and shows when late customer payments would push cash below zero.
Excel file (.xlsx), seven sheets, formulas ready for 2,000 transactions and 100 monthly payments.
We confirm your email address with a code. The file downloads and a copy arrives in your inbox.
Enter the due date and category, the week and scenario appear beside them
The table comes from the sample data in the file. When you enter your own receipts and payments in columns A–E, direction, week, scenario date and scenario amount are recalculated.
| Date (due) | Description | Counterparty | Category | Amount | Direction | Week | Scenario date | Scenario amount |
|---|---|---|---|---|---|---|---|---|
| 2026-10-30 | Sales invoice 0812 | Customer A | Customer receipts (invoices) | 145,000 | In | Overdue | ||
| 2026-11-06 | Supplier invoice 2231 | Supplier A | Supplier payments | 62,000 | Out | Overdue | ||
| 2026-11-10 | Sales invoice 0838 | Customer B | Customer receipts (invoices) | 412,000 | In | 1 | 2026-11-24 | 391,400 |
| 2026-11-12 | Supplier invoice 2240 | Supplier B | Supplier payments | 318,000 | Out | 1 | ||
| 2026-11-13 | Sales invoice 0841 | Customer C | Customer receipts (invoices) | 268,500 | In | 1 | 2026-11-27 | 255,075 |
| 2026-11-13 | Card and cash sales | Bank A | Card and cash sales | 92,000 | In | 1 | 2026-11-13 | 92,000 |
| 2026-11-18 | Sales invoice 0849 | Customer D | Customer receipts (invoices) | 534,000 | In | 2 | 2026-12-02 | 507,300 |
| 2026-11-19 | Supplier invoice 2246 | Supplier C | Supplier payments | 245,000 | Out | 2 | ||
| 2026-11-20 | Customer cheque 4412 | Customer E | Cheques and notes received | 300,000 | In | 2 | 2026-12-04 | 285,000 |
| 2026-11-25 | Sales invoice 0856 | Customer F | Customer receipts (invoices) | 389,000 | In | 3 | 2026-12-09 | 369,550 |
The sample file's 13 weeks
In the base forecast, cash drops below the minimum in week 8 (the week of 28 December): VAT, social security, salaries and the annual insurance premium land in the same week. If customer receipts arrive 14 days late and 5% never arrive, cash turns negative in week 4. The low point is in week 9, and the 500,000 credit line covers the gap.
| Week | Week start | In | Out | Closing | Status | Scenario closing |
|---|---|---|---|---|---|---|
| 1 | 2026-11-09 | 772,500 | 555,000 | 1,417,500 | 737,000 | |
| 2 | 2026-11-16 | 834,000 | 276,000 | 1,975,500 | 461,000 | |
| 3 | 2026-11-23 | 720,000 | 824,000 | 1,871,500 | 388,475 | |
| 4 | 2026-11-30 | 615,000 | 1,256,000 | 1,230,500 | -75,225 | |
| 5 | 2026-12-07 | 846,000 | 414,000 | 1,662,500 | 193,025 | |
| 6 | 2026-12-14 | 757,000 | 546,000 | 1,873,500 | 616,275 | |
| 7 | 2026-12-21 | 581,000 | 886,000 | 1,568,500 | 566,875 | |
| 8 | 2026-12-28 | 700,000 | 1,306,000 | 962,500 | Below minimum | -385,725 |
| 9 | 2027-01-04 | 698,000 | 532,000 | 1,128,500 | -397,475 | |
| 10 | 2027-01-11 | 502,000 | 300,000 | 1,330,500 | 39,525 | |
| 11 | 2027-01-18 | 1,026,000 | 305,000 | 2,051,500 | 415,025 | |
| 12 | 2027-01-25 | 468,000 | 969,000 | 1,550,500 | -145,475 | |
| 13 | 2027-02-01 | 637,000 | 1,031,000 | 1,156,500 | -200,725 |
Categories and activity groups
Every transaction belongs to a category. The category decides its row on the 13-week sheet and its activity group. Operating, investing and financing activities are also the three groups of the cash flow statement in the financial statements. The scenario delays only the receipts marked for it.
| Category | Direction | Activity group | Delayed in scenario |
|---|---|---|---|
| Customer receipts (invoices) | In | Operating | Yes |
| Cheques and notes received | In | Operating | Yes |
| Card and cash sales | In | Operating | No |
| Other operating receipts | In | Operating | No |
| Sale of assets | In | Investing | No |
| Loan drawdowns | In | Financing | No |
| Owner capital | In | Financing | No |
| Supplier payments | Out | Operating | |
| Cheques and notes issued | Out | Operating | |
| Net salaries | Out | Operating | |
| Social security contributions | Out | Operating | |
| Taxes (VAT, payroll, prepayments) | Out | Operating | |
| Rent and fixed costs | Out | Operating | |
| Other payments | Out | Operating | |
| Capital expenditure | Out | Investing | |
| Loan instalments (principal and interest) | Out | Financing | |
| Dividends and owner drawings | Out | Financing |
Direct method, minimum cash, scenario
The template puts every amount on the date the cash moves in or out of the account. An invoice goes on the day you expect the money: if a customer always pays 30-day invoices on day 45, use day 45.
- Direct method
- Each week adds up what will come into cash on hand and the bank, and separately what will go out. Opening cash plus receipts minus payments gives the closing cash.
- Minimum cash
- A week closing below this amount is flagged. Set it from your busiest payment week; the week where salaries, social security and taxes fall together is a good measure.
- Scenario
- Customer receipts and received cheques arrive late by the number of days on the Settings sheet, and the share set there never arrives. Payments stay the same. The difference shows how many weeks of delay you can absorb.
Use the template in four steps
- 1
Enter opening cash and the minimum
On the Settings sheet, enter your cash and bank balances, the minimum cash and the unused credit line. Delete the start date; the file then starts on this week's Monday.
- 2
Enter dated transactions
Delete the sample data on the Transactions sheet. Enter open customer invoices, cheques and notes received and issued, supplier payments and capital expenditure with their due dates.
- 3
Add monthly payments
Enter salaries, social security, taxes, rent and loan instalments on the Monthly payments sheet with their day of the month. Check tax and social security dates against the official calendars.
- 4
Update every Monday
Delete what has been paid or received, give overdue items a new date and reset opening cash to the bank balance. On the Forecast accuracy sheet, record last week's actual closing and this week's planned closing.
Excel file (.xlsx), seven sheets, formulas ready for 2,000 transactions and 100 monthly payments.
We confirm your email address with a code. The file downloads and a copy arrives in your inbox.
Sheets in the file
- How to use
- Setup steps, the Monday update and what each formula calculates.
- Settings
- Start date, opening cash, minimum cash, credit line, the scenario and 17 categories. You can rename categories and change their activity group and scenario setting.
- Transactions
- Dated receipts and payments: invoices, cheques and notes received and issued, capital expenditure. Direction, week, scenario date and amount are formulas.
- Monthly payments
- Salaries, social security, taxes, rent and loan instalments. Enter the day of the month and the amount; each payment lands in its week.
- 13 weeks
- Weekly receipts and payments by category, closing cash, distance to the minimum, cash including the credit line, activity groups and the scenario.
- Summary
- Lowest closing and its week, the first week below the minimum, the scenario's result, overdue items and totals by activity group.
- Forecast accuracy
- Each week's planned and actual closing. The average deviation shows how close the forecast runs.
Invoices and collections in Finance
In PureField Finance, sales and purchase invoices, expenses and payments sit in one list. Invoices awaiting collection show on the customer record. PureField Finance
Frequently asked questions
What is a cash flow forecast?
Why 13 weeks?
Why does a profitable company run out of cash?
How is the scenario calculated?
Why is the start date filled in?
Which programs open the template?
Why do you ask for an email address?

Move collections from Excel to the customer record.
No credit card needed during the trial.
