Skip to content
PureField

Guide, Platform

How to build a 13-week cash flow forecast

Author
PureField
Published
Updated

A cash flow forecast shows the cash coming into and going out of the business, by date. You start from the cash and bank balance on day one, place receipts and payments in their weeks by due date and work out each week's closing cash. Over 13 weeks, a minimum cash level and a late-payment scenario show the tight week early.

Who needs a cash flow forecast?

Any business that sells on credit, works with cheques or notes, or pays salaries and taxes on fixed days of the month. A typical scene: an air conditioning installation and service company closes November with a profit. Most of its invoices are due in 30 to 60 days, and one customer has paid with a post-dated cheque. At the end of December, VAT, social security, salaries and the annual insurance premium fall in the same week. The income statement shows the profit; the cash flow forecast shows whether the bank account can cover that week.

The owner, the managing director or the finance lead usually keeps the forecast. Every Monday morning, invoices expected to be paid come from sales, payment days from accounting and the cheque portfolio from the bank. Its value is seeing a squeeze weeks ahead, with time to chase a collection, move a payment or talk to the bank about the credit line in good time.

How does a cash flow statement differ from a cash flow forecast?

They ask the same question about different times. The cash flow statement in the accounts reports where cash came from and went in a past period; the forecast plans what will happen over the coming weeks. Under IFRS, the statement follows IAS 7 Statement of Cash Flows; Turkish companies reporting under TFRS use its translation, TMS 7. The standard groups cash flows into operating, investing and financing activities. Operating cash flows can be shown by the direct or the indirect method, and the standard encourages the direct method.

Cash flow statement (IAS 7)Cash flow forecast for management
PeriodPast year or quarterNext 13 weeks
FrequencyAnnual or interimUpdated every week
MethodDirect or indirectDirect: each receipt and payment
SourceAccounting recordsOpen invoices, cheque portfolio, payment calendar
QuestionWhere did cash come from and go?Which week will cash run short?

The indirect method starts from net profit and adjusts for non-cash items and changes in working capital. It explains the past well and plans the next week poorly: "the customer's 412,000 payment arrives next Tuesday" only fits the direct method. This guide and the template build the forecast by the direct method and use the three activity groups of the cash flow statement in the accounts.

How do you build a 13-week cash flow forecast step by step?

Enter opening cash, then the dated receipts and payments, then the monthly payments, and let each fall into its week. The order:

  • Choose the start week: weeks run Monday to Sunday. Week 1 is the current week; week 13 is about three months out.
  • Enter opening cash: cash on hand and every bank account on the start date. Keep the unused credit line out of it, on its own row.
  • Enter receipts with their due dates: open customer invoices, cheques and notes received, the dates card sales reach the account. Use the customer's real habit; an invoice due in 30 days from a customer who always pays on day 45 goes on day 45.
  • Enter dated payments: supplier invoices, cheques and notes issued, capital expenditure, one-off costs such as an annual insurance premium.
  • Add monthly payments: net salaries, social security, VAT, payroll tax, rent, vehicle leases, loan instalments. Enter the day of the month and the amount once; each payment lands in its week.
  • Work out the closing cash: closing = opening + receipts − payments. One week's closing is the next week's opening.
  • Set a minimum cash level: a week closing below it is flagged.
  • Run the scenario: what happens to closing cash if receipts arrive two weeks late and part never arrives?
  • Update every Monday: delete what happened, give overdue items a new date, reset opening cash to the bank balance.

Keep overdue receivables out of the forecast; list them separately and give each a new expected date. Putting an overdue invoice in week 1 makes cash look better than it is, and deleting it loses track of the money.

Which items do cash forecasts usually miss?

Cheque and note due dates, tax and social security payments bunched on the same days of the month, and costs that come once a year. The table shows how each item enters the calendar.

ItemHow it enters the forecast
Cheques and notes receivedAs a receipt on the due date. If you endorse a cheque over to a supplier, remove it from receipts and remove the payment it settles; that money never touches your account.
Cheques and notes issuedAs a payment on the due date. The funds must be in the account that day; the forecast shows those weeks early.
Card salesAs a receipt on the day the bank settles them, after the holding period agreed with the bank.
VAT, payroll tax, social securityEvery month, on the last payment day. Check the days against the official tax calendar; deadlines are sometimes extended.
Tax prepaymentsQuarterly where they apply. A 13-week window usually contains one.
Loan instalments and leasesOn the instalment day, principal and interest together. The row should stop after the last instalment.
Credit card statementsOn the due date, with the statement total.
Annual and seasonal costsInsurance premiums, yearly software licences, maintenance contracts. Coming once a year, they are the items most often forgotten.
Pay risesStart the new amount from the first payday after the rise; if you pay on the 1st, a January rise lands in February. Payroll tax and social security on the new pay follow a month later.

Check payment days that fall on a weekend too: a payment moving from Saturday to Monday moves its amount into the next week.

How do you set the minimum cash level and the scenario?

The minimum is the amount cash should not fall below; your busiest payment week is a good starting point. The week where salaries, social security and taxes land together is among the heaviest of the year for most businesses. Set the minimum close to that week's payments and every flagged week becomes a real warning.

Keep the unused credit line out of closing cash and show it on its own row. "Cash is below the minimum but the line covers it" and "the line is not enough either" call for different decisions.

The scenario tests the two most common risks together: customer receipts arrive a set number of days late, and part never arrives. Take the delay and the loss rate from your own data: over the last six months, how many days after the due date were invoices paid on average, and how many cheques bounced? Keep payments fixed in the scenario; what you owe suppliers and the tax office stays due when a customer pays late.

Worked example: a service company's 13 weeks

The example comes from the fictional data in the 13-week cash flow forecast template. A small service and installation company starts on Monday 9 November 2026 with opening cash of 1,200,000. Its minimum cash is 1,000,000 and its unused credit line 500,000. The list holds 45 dated transactions and 8 monthly payments: salaries (day 1), social security (last day of the month), payroll tax (day 26), VAT (day 28), rent, a vehicle lease, utility bills and a loan instalment that ends in December. The payment days are examples, and the sample keeps weekend dates as they are.

WeekWeek startReceiptsPaymentsClosingScenario closing
12026-11-09772,500555,0001,417,500737,000
42026-11-30615,0001,256,0001,230,500−75,225
82026-12-28700,0001,306,000962,500−385,725
92027-01-04698,000532,0001,128,500−397,475
132027-02-01637,0001,031,0001,156,500−200,725

In the base forecast, cash falls below the minimum in week 8 only. That week's 1,306,000 of payments is four items: salaries 640,000, VAT 286,000, social security 235,000 and the annual insurance premium 145,000. With receipts at 700,000, closing cash drops to 962,500. The company sees this seven weeks ahead, which leaves time to pay the insurance in instalments or bring a customer payment forward.

In the scenario, customer receipts and received cheques arrive 14 days late and 5% never arrive. Cash turns negative in week 4, and the low point is −397,475 in week 9. The 500,000 credit line covers the gap; the lowest cash including the line is 102,525. The result is a decision: the line covers a two-week delay and may not cover three. Setting the delay to 21 days and reading the table again takes a minute.

Why does a profitable company run out of cash?

Because profit is booked when the invoice is issued and cash arrives when it is paid. Credit sales, stock and capital expenditure tie up cash without changing profit. Over 13 weeks the example company generates 351,500 of net cash from operating activities; the down payment on a new service van and the sale of the old one leave investing activities at minus 65,000, and loan instalments leave financing activities at minus 330,000. The total is minus 43,500, while the income statement can show a profit for the same period.

EBITDA (earnings before interest, taxes, depreciation and amortisation) is operating profit before depreciation and amortisation. Growth in receivables and stock, capital expenditure, loan principal and taxes paid sit outside it, and that is where the gap lives. A rough bridge: operating cash flow ≈ EBITDA − taxes paid − increase in working capital. In a company whose sales grow fast, receivables grow too, so cash can shrink while EBITDA rises. Banks look at EBITDA when they assess credit; salaries are paid from the bank balance. Watch both.

Which Excel formulas build a cash flow forecast?

The weekly table rests on SUMIFS by date range; no array formulas are needed. The template uses these in a form that works in Excel, Google Sheets and LibreOffice.

CalculationFormula
Start of the week (Monday)date − WEEKDAY(date, 2) + 1
A category's total in the weekSUMIFS(amount, category, "Customer receipts", date, ">="&week start, date, "<="&week end)
A monthly payment's day in the monthDATE(YEAR(week start), MONTH(week start), MIN(day, DAY(EOMONTH(week start, 0))))
Closing cashopening + total receipts − total payments
First week below the minimumMATCH(1, below-minimum row, 0), where the row holds 1 or 0 for each week

Capping the day with MIN at the month's last day matters: a social security payment set to day 31 falls on the 30th in November and the 28th in February. When a week spans two months, the formula checks both; that is how the 1 January salaries land in the week of 28 December.

How are invoices and collections tracked in PureField?

In PureField Finance, sales and purchase invoices, expenses and payments sit in one list. A sales invoice is created for a chosen customer with its line items and due date. When payment arrives it is recorded against the invoice and the customer's balance updates on their record; invoices awaiting collection show on the customer record. With the Aposkal connection, outgoing e-invoices are sent from PureField and incoming e-invoices are imported. Each receipt row on the template's Transactions sheet needs a customer, an amount and a due date, and every open invoice carries all three.

Evidence

IAS 7 Statement of Cash Flows (IFRS Foundation)
Classification of cash flows into operating, investing and financing activities; operating cash flows reported by the direct or indirect method, with the direct method encouraged. Source: ifrs.org
TMS 7 Nakit Akış Tabloları (Public Oversight Authority, Turkey)
The Turkish text of the same standard. Source: kgk.gov.tr
PureField Finance
Sales and purchase invoices, expenses and payments in one list; an invoice is created for a chosen customer with line items and a due date; payments are recorded against the invoice and the customer's balance updates on the record; outgoing and incoming e-invoices through Aposkal.
Sample data
The weeks, amounts and scenario results in the example come from the sample data in the free cash flow forecast template; the data is fictional and does not belong to a real company.

Enter your open invoices with their due dates in PureField Finance and see the ones awaiting payment on each customer record. Book a demo or try it free for 7 days.

Frequently asked questions

What is the difference between a cash flow forecast and an income statement?

The income statement books a sale when the invoice is issued and an expense when it is incurred, and shows the period's profit. A cash flow forecast books the day money enters or leaves the account. A company that sells on credit can be short of cash in a profitable month, which is why the two are read together.

Should a cash flow forecast be weekly or monthly?

Weekly for the next 13 weeks, monthly for the annual budget. A monthly table hides the squeeze inside a month where salaries, social security and taxes land in the same week; a weekly table shows that week on one row.

What is the difference between the direct and the indirect method?

The direct method adds up receipts and payments one by one: money in from customers, out to suppliers, out to staff. The indirect method starts from net profit and adjusts for non-cash items such as depreciation and for changes in receivables, stock and payables. IAS 7 allows both and encourages the direct method; a weekly forecast uses the direct method.

How do received cheques go into a cash flow forecast?

As a receipt on the due date. If you deposit the cheque for collection, use the day it clears; if you endorse it to a supplier, it never enters: remove the cheque from receipts and the supplier payment it settles from payments. Test the risk of a bounced cheque with the scenario's share never collected.

How much minimum cash should a business keep?

The level depends on the business; start from your busiest payment week. The total for the week where salaries, social security and taxes land together shows whether cash can cover that week. Keep the credit line separate from the minimum.