Capital

How to Do Cash Flow Forecasting for a Small Business

Build a dated view of receipts and payments that shows when cash pressure may arrive and which assumptions need attention.

By Vishal Sengar · 3 min read · For founders

Overhead desk: Indian business owner planning incoming customer payments and outgoing supplier bills against a paper calendar and laptop spreadsheet, sorting invoices into upcoming weeks with a calculator.

The short answer

What to know before you act

Start with opening available cash, add expected receipts and subtract dated payments for each period. Carry the closing balance forward. Separate committed items from assumptions, test a slower-collection case and update the forecast against actual movements. Choose a horizon and interval that fit the business; a rolling weekly view can expose near-term timing risks.

  • Forecast cash dates rather than invoice or accounting dates.
  • Label uncertain receipts and avoid double counting.
  • Use the lowest projected balance to trigger a decision early.

A cash forecast is useful before a payment problem becomes urgent. It connects the bank balance today with the dates on which customers may pay and commitments must be met.

Keep the first version simple enough to update. A precise-looking model based on stale dates is less useful than a modest forecast with visible assumptions and regular reconciliation.

What belongs in the forecast?

What belongs in the forecast?
What you seeWhat to checkNext move
Opening balanceAvailable bank cash at the startExclude restricted funds and avoid counting credit as cash.
Customer receiptsExpected collection dates and amountsDistinguish firm evidence from assumed new sales.
PaymentsPayroll, suppliers, tax, debt and investment datesUse verified obligations and appropriate accounting support.
ScenariosDelayed receipts, lower sales or a one-off costTest the consequence and prepare an action trigger.

A positive month-end balance hides a weekly shortfall

Hypothetical example · not a client case study

Imagine a business opening with ₹2,00,000. It expects ₹3,00,000 of receipts in week four and ₹2,50,000 of payments in week two. Ignoring other movements, the month ends with ₹2,50,000, but the week-two balance falls to minus ₹50,000 before the receipt arrives. The negative figure is a projected funding gap, not permission to overdraw.

A weekly forecast exposes the timing problem that a monthly total conceals. The business can investigate collection confidence and agreed payment timing before making a commitment. A downside case moves the receipt later again. No action is assumed successful until the customer, supplier or finance provider has confirmed the relevant arrangement.

  1. 01OpenVerified available cash
  2. 02DateReceipts and payments
  3. 03StressA plausible adverse case
  4. 04UpdateActuals and revised assumptions
The decision sequence

Create a forecast you can maintain

1. Build from source records

Use the bank balance, receivables, payroll schedule, supplier commitments and planned spending. Include loan principal and capital payments even when they are not operating expenses in the income statement. Record who owns each estimate and when it was last checked.

2. Separate confidence levels

Mark contracted or scheduled movements separately from estimated sales and uncertain collections. Model the cash effect of assumptions explicitly. Avoid counting an invoice in receivables and again as future sales. Use relevant professional input for tax or financing obligations rather than inventing dates.

3. Review and act regularly

Compare actual receipts and payments with the last forecast. Explain significant differences and roll the horizon forward. Set a balance threshold that prompts review based on the business’s real obligations and options. Record actions and confirmations so that the next forecast reflects evidence, not optimism.

Put it to work

Rolling cash forecast setup

Work through the four prompts using evidence from your business. These notes stay in this page, are not sent or saved, and disappear when you reload. Copy them before leaving.

Step 01

Verify opening cash

Record available cash and excluded restricted amounts.

Step 02

Date the movements

List receipts and payments with evidence and owners.

Step 03

Test a slower case

Move uncertain receipts or costs and inspect the lowest balance.

Step 04

Set the update rhythm

Choose who reconciles actuals and follows up actions.

Choose your next step

The forecast earns its value through earlier decisions. Keep assumptions visible and replace them with actual evidence as each period closes.

Further reading

British Business Bank: creating a cash-flow forecast

More on Capital