Financial visibility

How to Create a Simple 13-Week Cash Flow Forecast

By Biznopsy · · 3 min read

Map expected receipts and payments week by week to spot cash pressure earlier. Keep assumptions visible and update your forecast using actual movements.

Start with cash you can actually use

Record your available opening cash and the date of the snapshot. Separate money you can use from funds reserved for specific obligations. A forecast is easier to interpret when the starting balance matches your records rather than an estimate from memory.

Cash flow and profitability answer different questions. An issued invoice can be part of your sales records before the customer pays it. For this forecast, place money in the week you expect it to enter or leave the business.

Place receipts in realistic weeks

List expected customer payments, using known payment terms and recent collection experience. Separate committed receipts from possible sales. A sales target should not automatically become money available for spending in the same week.

Mark uncertain timing explicitly. If a large customer might pay later, show that possibility in a separate scenario. This helps you see which assumptions matter most without pretending that every future receipt is certain.

Map obligations and operating payments

Add supplier payments, payroll, rent, subscriptions and other known outflows to the relevant weeks. Include upcoming tax or financing obligations using your own records and professional advice where needed. Avoid treating a monthly total as if its payment dates do not matter.

Separate unavoidable commitments from spending you can choose to delay. Record the consequences of delaying a payment rather than assuming it is harmless. The purpose is to understand options before pressure becomes urgent.

Calculate the rolling balance

For each week, calculate opening cash plus receipts minus payments. Carry that closing balance into the next week. For example, an illustrative opening balance of €5,000, receipts of €2,000 and payments of €3,000 gives closing cash of €4,000.

Choose a minimum buffer based on your obligations and uncertainty, not a universal rule. Highlight the first week below that buffer. Compare a base case with a delayed-receipts case so you can see how sensitive the plan is.

Review actual movements every week

Replace forecast amounts with actual receipts and payments as each week ends. Note why the estimate differed, then update the remaining weeks and add a new final week. A forecast that is never refreshed can become misleading even when its arithmetic is correct.

Use the result to frame a specific decision: collecting an overdue invoice, revising an order size or reviewing optional spending. Biznopsy can help organise that action plan, but the forecast needs current business records and judgement appropriate to your situation.

Put it to work

  1. Confirm an opening cash balance and snapshot date.
  2. List receipts and payments for thirteen weekly columns.
  3. Calculate each closing balance and test delayed receipts.
  4. Schedule a weekly update and assign a person to maintain it.

Use the business health check to review strategy, sales, marketing, operations and financial visibility. The score reflects your self-assessment; check your priorities against real evidence.

Start your free business checkup →

For a step-by-step explanation of the free diagnostic, read the business health check guide. You can also explore our free business assessment checklist.

For ongoing task tracking and weekly reviews, explore the 30-day action plan included with Pro and Ultra.

Keep exploring

Back to all articles

Your next good idea
could start here.