Skip to content
PureField

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.

Sample data, the first 10 of 45 transactions. Start Monday 2026-11-09; in the scenario, receipts arrive 14 days late and 5% never arrive.
Date (due)DescriptionCounterpartyCategoryAmountDirectionWeekScenario dateScenario amount
2026-10-30Sales invoice 0812Customer ACustomer receipts (invoices)145,000InOverdue
2026-11-06Supplier invoice 2231Supplier ASupplier payments62,000OutOverdue
2026-11-10Sales invoice 0838Customer BCustomer receipts (invoices)412,000In12026-11-24391,400
2026-11-12Supplier invoice 2240Supplier BSupplier payments318,000Out1
2026-11-13Sales invoice 0841Customer CCustomer receipts (invoices)268,500In12026-11-27255,075
2026-11-13Card and cash salesBank ACard and cash sales92,000In12026-11-1392,000
2026-11-18Sales invoice 0849Customer DCustomer receipts (invoices)534,000In22026-12-02507,300
2026-11-19Supplier invoice 2246Supplier CSupplier payments245,000Out2
2026-11-20Customer cheque 4412Customer ECheques and notes received300,000In22026-12-04285,000
2026-11-25Sales invoice 0856Customer FCustomer receipts (invoices)389,000In32026-12-09369,550
Sample data, the first 10 of 45 transactions. Start Monday 2026-11-09; in the scenario, receipts arrive 14 days late and 5% never arrive.

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.

WeekWeek startInOutClosingStatusScenario closing
12026-11-09772,500555,0001,417,500737,000
22026-11-16834,000276,0001,975,500461,000
32026-11-23720,000824,0001,871,500388,475
42026-11-30615,0001,256,0001,230,500-75,225
52026-12-07846,000414,0001,662,500193,025
62026-12-14757,000546,0001,873,500616,275
72026-12-21581,000886,0001,568,500566,875
82026-12-28700,0001,306,000962,500Below minimum-385,725
92027-01-04698,000532,0001,128,500-397,475
102027-01-11502,000300,0001,330,50039,525
112027-01-181,026,000305,0002,051,500415,025
122027-01-25468,000969,0001,550,500-145,475
132027-02-01637,0001,031,0001,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.

CategoryDirectionActivity groupDelayed in scenario
Customer receipts (invoices)InOperatingYes
Cheques and notes receivedInOperatingYes
Card and cash salesInOperatingNo
Other operating receiptsInOperatingNo
Sale of assetsInInvestingNo
Loan drawdownsInFinancingNo
Owner capitalInFinancingNo
Supplier paymentsOutOperating
Cheques and notes issuedOutOperating
Net salariesOutOperating
Social security contributionsOutOperating
Taxes (VAT, payroll, prepayments)OutOperating
Rent and fixed costsOutOperating
Other paymentsOutOperating
Capital expenditureOutInvesting
Loan instalments (principal and interest)OutFinancing
Dividends and owner drawingsOutFinancing

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. 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. 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. 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. 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

Related articles

Frequently asked questions

What is a cash flow forecast?

A table of the cash a business expects to receive and pay, by date. Receipts are added to the opening cash and payments subtracted, which gives the cash left at the end of each period. The cash flow statement in the accounts shows the past period as operating, investing and financing activities; this template uses the same groups for the next 13 weeks.

Why 13 weeks?

13 weeks make a quarter: monthly payments such as salaries, social security, taxes and loan instalments show up three times. A weekly view shows the squeeze inside a month that a monthly table hides; salaries and taxes can fall in the same week while customer money arrives at month end.

Why does a profitable company run out of cash?

Profit is booked when the invoice is issued; cash arrives when the invoice is paid. Credit sales, stock and capital expenditure tie up cash without changing profit. That is why cash can turn negative in a payroll week even in a profitable quarter.

How is the scenario calculated?

Receipts in the categories marked for the scenario on the Settings sheet move later by the delay and shrink by the share that never arrives. In the sample, customer receipts and received cheques arrive 14 days late and 5% never arrive. Payments stay the same; the 13-week sheet shows the scenario's closing cash on its own row.

Why is the start date filled in?

The sample's weeks were calculated from Monday 2026-11-09, so the file ships with that date. When you enter your own data, delete the date on the Settings sheet; an empty cell uses this week's Monday. A date that is not a Monday moves to its week's Monday.

Which programs open the template?

The file is .xlsx. It opens in Microsoft Excel, Google Sheets and LibreOffice Calc, and the formulas and drop-down lists work in all three. Formulas are ready for 2,000 transactions and 100 monthly payment rows.

Why do you ask for an email address?

We also send the file to the address you confirm, so you do not lose it. Product news is optional. Leave the box unticked and you only get the file.

Move collections from Excel to the customer record.

No credit card needed during the trial.