Skip to content

Short-Term Cashflow Forecasting: A Practical Step-by-Step Guide

Why short-term cashflow forecasting matters

Short-term cashflow forecasting shows you how much cash will be available over the next 1–13 weeks. It helps you avoid missed payroll, late bills, and surprise overdrafts. You don’t need fancy software—just consistent steps you do every week.

Overview: The 7-step weekly routine

  1. Gather bank and sales data for the last 4 weeks.
  2. List expected cash inflows for each day/week ahead (receipts, customer payments).
  3. List expected cash outflows for each day/week ahead (payroll, bills, rent, supplier payments).
  4. Calculate weekly net cash (inflows minus outflows).
  5. Adjust for timing issues (deposits, payment delays).
  6. Run decision rules and trigger actions if shortfalls appear.
  7. Record what you learned and update next week.

Step 1 — Collect simple inputs (30–60 minutes)

What to gather: bank balance, last 4 weeks of sales/receipts, upcoming invoices due, recurring bills, payroll dates, supplier invoices, credit card payments, and any one-off expected cash items (taxes, equipment).

  • Tip: Export bank and sales CSVs if you can. If not, print or screenshot recent statements.

Step 2 — Build a 13-week cash grid (15 minutes to set up)

Create a table with 13 columns (one for each week) and rows for categories: opening balance, inflows, outflows (broken into payroll, rent, suppliers, taxes, credit cards), and closing balance.

Example headers: Week 1 (Mon–Sun), Week 2, ... Week 13.

Step 3 — Forecast inflows

Actions:

  • Mark confirmed payments: payments you’ve already received or have proof of (paid invoices, scheduled bank transfers).
  • Estimate likely payments: unpaid invoices, expected walk-in sales, recurring customer payments. Use conservative timing: assume payments take the longest reasonable time to arrive.
  • For uncertain sales, include only 50–75% of expected amounts unless you have a signed order.

Example: Invoice for $10,000 sent with 30-day terms. If day 0 is this week, place $0 in Weeks 1–4 and $10,000 in Week 5 (use the week it will actually hit the bank).

Step 4 — Forecast outflows

Actions:

  • List fixed costs at their due weeks (rent, loan payments, subscriptions).
  • List payroll by paydate; include taxes and benefits withheld.
  • List supplier payments by agreed terms. If you usually pay on delivery, forecast the week of delivery.
  • Include a small contingency line (1–3% of weekly outflows) for unexpected items.

Step 5 — Calculate weekly and cumulative balances

Formula: Closing balance this week = Opening balance + Inflows − Outflows. Next week’s opening balance = this closing balance.

Action: Highlight any week where closing balance < 0 or drops below your minimum cash cushion.

Step 6 — Simple decision rules and actions

Use these clear rules to act fast:

  • If any week’s closing balance < 0: take immediate action (see actions list).
  • If closing balance < 10% of monthly payroll: treat as medium risk and trigger at least two actions.
  • If you have 2 consecutive weeks negative: escalate—contact bank or lenders now.

Immediate actions checklist (pick 1–3 quickly):

  • Delay nonessential supplier payments by contacting suppliers and asking for 7–14 day terms.
  • Accelerate receivables: email clients, offer 1–2% discount for 7-day payment, or call big overdue accounts.
  • Move discretionary spending: pause marketing spend or freeze hiring.
  • Use short-term financing: overdraft, business card, or a 30-day line—only if costs are clear.
  • Split payroll: ask employees if paydate can shift 1–2 days (in writing).

Step 7 — Weekly review and continuous improvement

Every week, spend 20–60 minutes to:

  • Update actuals versus forecast.
  • Note which estimates were wrong and why.
  • Adjust your assumptions (e.g., payment terms, seasonality).
  • File the week’s grid with a short note: issues found, actions taken, results.

Simple examples

Example A — Retail shop (conservative)

  • Opening cash: $8,000. Payroll weekly: $3,500. Rent monthly: $2,000 (allocate $500/week). Expected sales this week: $4,000 (50% in cash now, 50% card paid next day).
  • Result: Week inflows $3,000, outflows $4,000 (payroll+rent+suppliers) → closing = $7,000.
  • Decision: OK this week; watch Week 3 when a big supplier bill is due—set aside $4,500 next week.

Example B — Service business with slow pay

  • Opening cash: $5,000. Two large invoices: $12,000 expected in 3–5 weeks, but only $2,000 likely in Week 2.
  • Payables include payroll $6,000 weekly. Forecast shows Week 1 closing −$1,000.
  • Actions: contact bank for short-term line and ask suppliers for 14-day terms. Offer key client 2% discount to pay in 7 days and secure $6,000 in Week 1.

Quick checklist to get started now

  • Set up a 13-week grid (Excel, Google Sheets, or paper).
  • Collect last 4 weeks of bank and sales data.
  • Enter confirmed inflows and fixed outflows for Week 1.
  • Flag any week with closing balance < 0 or below your cushion.
  • If flagged, call 1 supplier and 1 customer today; consider a short-term finance option.

Notes on tools and accuracy

You can do this in a spreadsheet easily. Accuracy improves with practice: tracking actuals each week will make your forecasts better fast. Focus on timing (when cash hits the account) more than on perfect revenue numbers.

How to know when your forecast is 'good enough'

  • It catches negative weeks at least two weeks in advance.
  • It leads to clear actions you can take before a bill is missed.
  • Weekly updates change the plan when reality differs.

Final quick rules to remember

  • Be conservative on inflows; realistic on outflows.
  • Focus on weeks, not months, for short-term survival.
  • Act early: one phone call or a small discount often fixes a cash gap faster than a loan application.