What should a 13-week cash flow forecast answer?
A 13-week cash flow forecast shows when money is expected to arrive and leave, and whether the remaining available cash covers the business's commitments. It is most useful for decisions with a specific date: paying payroll, ordering stock, funding a tax payment or deciding whether an optional purchase can wait. It should identify a shortage while there is still time to respond.
Thirteen weeks is a practical planning horizon, not a general Cyprus statutory requirement. It gives a weekly view across roughly a quarter without pretending that every receipt can be predicted precisely. A seasonal business may also need a longer monthly forecast, while a business with immediate pressure may need daily detail for the first few weeks.
This guide concerns forward-looking liquidity planning. The IAS 7 statement of cash flows reports historical cash flows and has a different purpose. Likewise, the Registrar's guidance on accounting records and annual financial statements does not turn this particular forecasting format into a statutory filing. Keep the forecast connected to those records without confusing the deliverables.
Start with cash that is actually available
Choose a start date and reconcile the opening bank balances. Include each account only once and distinguish cleared funds from expected transfers. A customer invoice is not opening cash; neither is a promise of a shareholder loan. If bookkeeping is behind, resolve the material differences using the bank reconciliation process before treating the opening position as dependable.
Identify restricted deposits, payment-provider reserves and money that belongs to another party. Show the total balance and the deduction for amounts unavailable for ordinary business use. Avoid counting transfers between the company's own accounts as both new customer receipts and additional funding. At entity level those transfers change location, not total cash.
Keep borrowing separate. An approved facility may provide potential headroom, subject to its terms, but an undrawn amount is not a bank deposit. Record current drawings, the remaining permitted amount, conditions and expected drawdown date. A requested but unapproved facility belongs in a clearly conditional scenario, not in the base forecast as certain funding.
Build an evidence-based input file
Gather a reconciled cash position, aged customer and supplier balances, payroll commitments, rental contracts, loan schedules, tax payment dates and approved purchase orders. Add known exceptional items such as equipment purchases, insurance renewals or customer refunds. The forecast will miss important payments if it relies only on costs that appear every month.
Use a working schedule with one row for each significant cash event. Record the counterparty, amount, currency, expected settlement date, source document, responsible person and confidence level. Smaller predictable items can be grouped, but retain the calculation behind the group. Label assumptions separately from signed contracts or confirmed payment dates.
Take the opening data from a consistent cut-off. Mixing last week's receivables listing with today's bank balance can count a receipt twice: once in cash and again as an unpaid invoice. The month-end close guide explains the underlying completeness controls. For a weekly forecast, update the relevant movements between that close date and the forecast start.
Forecast customer receipts by realistic payment date
Start with existing invoices and assign likely collection weeks using the contractual terms, payment history and current discussions. An invoice due tomorrow is not necessarily collectible tomorrow if the customer disputes it or requires approval. Keep disputed amounts visible and make their timing assumptions explicit rather than silently pushing them into the next week indefinitely.
Separate receipts from existing invoices from receipts expected from future sales. For future sales, allow time for delivery, invoicing and collection; a sales target does not create immediate cash. Avoid including the same order in both the open-invoice schedule and the future-sales estimate. A clear reference number makes this duplication easier to detect.
For card and platform sales, forecast the settlement actually expected after the relevant deductions or show gross settlement and fees separately, consistently. Allow for provider settlement delays, refunds and reserves. A percentage probability can help with scenario analysis, but receiving half of a large invoice is not always a realistic operational outcome. Model the full receipt delayed as a separate stress case.
The accounts receivable guide covers the collection workflow. Here, the specific output is a dated and supportable cash assumption. Record who will confirm a significant receipt and when the forecast must be revised if that confirmation does not arrive.
Schedule all payments, including those outside operating profit
List payroll, supplier payments, rent, utilities, subscriptions, insurance and other operating outflows in the weeks they are expected to leave the bank. Distinguish a contractual due date from a proposed negotiated date. Do not improve the forecast merely by moving liabilities to a later week without an agreed basis.
Add the full cash amount of loan payments, separating principal and interest in the supporting schedule. Add capital expenditure, deposits, tax settlements and any properly authorised planned owner distributions. These items help explain why a profitable company can still face a cash shortage. Depreciation, by contrast, is not itself a cash payment in the forecast.
Use actual payroll payment arrangements and relevant filing or payment calendars. Do not assume that every Cyprus business has identical VAT periods or that a general extension applies to its circumstances. Where a deadline needs confirmation, assign that task to the person responsible for the return before the cash forecast is approved.
Separate committed spending from discretionary proposals. A new laptop order already placed on binding terms is different from an optional future upgrade. This distinction lets management identify realistic responses without concealing the obligations that remain payable.
Handle VAT and currencies consistently
A straightforward direct cash forecast uses the amounts expected to pass through the bank: customer receipts and supplier payments including applicable VAT, followed by a separate line for actual VAT settlements or refunds. This is a cash-planning convention, not a determination of the correct tax treatment of an invoice. Avoid combining net sales receipts with gross supplier payments.
Do not insert a forecast VAT refund as certain cash merely because the ledger shows a debit balance. Consider eligibility, submission status, any review and the realistic payment timing. Equally, tax collected from customers should not be mistaken for permanent free cash available for distributions. Show the upcoming settlement and consider its effect on the minimum reserve.
Where payments occur in foreign currencies, maintain their original amounts and convert them into the reporting currency using stated forecast assumptions. Distinguish exchange-rate sensitivity from the timing of collection. The multicurrency bookkeeping guide addresses the accounting records; the forecast should show what happens to cash if the settlement rate differs from the planning assumption.
Use a weekly layout that can be checked
Create thirteen dated columns using one consistent week-ending convention. The first week may be shorter if the forecast begins midweek; mark that clearly. Opening cash plus receipts minus payments equals closing cash. Carry that closing amount into the following week's opening balance. Keep funding lines visible instead of hiding them in sales receipts.
| Forecast row | What belongs here | Control question |
|---|---|---|
| Opening available cash | Reconciled usable funds | Does it match the preceding closing position? |
| Operating receipts | Dated customer and other operating receipts | Are existing invoices counted once? |
| Operating payments | Suppliers, payroll and recurring commitments | Are dates supported? |
| Tax and exceptional payments | Tax settlements, equipment and other identified outflows | Has a non-monthly item been omitted? |
| Financing movements | Eligible drawdowns and cash repayments | Is proposed funding actually available? |
| Closing cash and reserve headroom | Calculated balance and comparison with the internal reserve | Which week requires action? |
Use formulas for totals and carry-forwards. Protect calculation cells against accidental replacement and test that a changed receipt flows through every subsequent week. A summary chart is useful, but reviewers must still be able to trace a low point back to its underlying transactions.
Worked example: a customer pays two weeks late
The following is an original simplified illustration, not a client result or a forecast for a particular company. All figures are cash amounts in euros; the payment totals are assumed to include every relevant outflow for these weeks. The remaining ten weeks would use the same structure.
| Cash movement | Week 1 | Week 2 | Week 3 |
|---|---|---|---|
| Opening cash | €20,000 | €18,000 | €16,000 |
| Receipts | €8,000 | €12,000 | €5,000 |
| Payments | €10,000 | €14,000 | €9,000 |
| Closing cash | €18,000 | €16,000 | €12,000 |
Now move a €7,000 customer receipt from week two to week four, leaving all other assumptions unchanged. Week two receipts become €5,000, so closing cash is €18,000 + €5,000 − €14,000 = €9,000. Week three then closes at €9,000 + €5,000 − €9,000 = €5,000. Add the delayed €7,000 in week four once, rather than deleting it from the forecast.
If management's illustrative minimum reserve is €8,000, the week-three shortfall against that policy is €3,000. Cash is still positive, but the agreed buffer has been breached. The €8,000 reserve is not a statutory Cyprus threshold. Its suitability depends on the company's commitments, uncertainty and access to reliable funding.
Choose useful scenarios and a defensible reserve
Keep a realistic base case, a slower-collection case and any other material business-specific stress scenario. A trader might test an earlier stock payment; a service company might test delayed customer approval; a business buying in foreign currency might test an adverse rate. Change named assumptions rather than reducing every receipt by an arbitrary percentage without explanation.
Set the internal reserve with reference to essential commitments, collection concentration, timing uncertainty and genuinely accessible funding. Explain whether it is a fixed amount or changes as payroll and tax dates approach. An average monthly cash balance can hide a serious shortage in one week, so review the lowest projected balance and its date.
Where timing within a week matters, add daily detail. A Friday receipt cannot pay an obligation due on Monday unless other funds cover the gap. Similarly, a positive combined balance across companies does not mean cash can be transferred immediately between them. Assess entity ownership and any restrictions before assuming that group funds are interchangeable.
Turn a forecast shortage into an action plan
For each pressure point, record the amount, latest decision date, proposed response and accountable person. Practical actions can include resolving an invoice dispute, agreeing a customer payment date, negotiating supplier terms or postponing an uncommitted purchase. Show the forecast before and after each action so its contribution is visible.
Separate actions agreed with counterparties from proposals still under discussion. Do not assume permission to postpone tax, payroll or contractual obligations. Financing discussions should start early enough to allow for approval and documentation; a favourable conversation is not a completed facility. If the company may be unable to meet obligations when due, obtain timely professional advice rather than disguising the problem by changing spreadsheet dates.
Update weekly while preserving the previous forecast
At each review, reconcile actual opening and closing cash, replace the completed week's forecast with actual movements, explain differences and add a new final week. Save the previous forecast before changing it. Without that history, repeated optimism about customer payments can disappear every time the dates are moved forward.
Classify differences as timing, amount, omission or changed assumption. A delayed receipt that arrives next week is different from an invoice that will not be collected at all. Assign follow-up actions for significant differences and update the underlying receipt or payment schedule, not just the summary total.
Compare the result with the management accounts to explain the relationship between profit and liquidity. Keep the forecast's date, owner and scenario visible on every exported version. If the records needed for this process are incomplete, agree the reconciliation and reporting scope with the accounting and bookkeeping team before relying on the forecast for a significant commitment.