How to Forecast Cash Flow — A Simple Method Every Small Business Owner Can Use

Most small business owners manage cash flow reactively — they look at the bank balance and decide what to do. This works until it does not. The month a large payment is delayed, an unexpected expense arrives, and the account goes into crisis — it is already too late to plan. A cash flow forecast gives you visibility before the crisis arrives.

You do not need accounting software or a financial degree to build one. You need a spreadsheet, your bank statements, and 90 minutes.

The 13-week rolling forecast — the standard that works

A 13-week (3-month) rolling forecast is the most practical tool for small business cash flow management. It shows, week by week, what money is expected to come in, what money is expected to go out, and what the net bank balance will be at the end of each week.

Step 1

List all expected inflows Sales collections (based on your invoice due dates), advance payments, loan disbursements, any other income. Be conservative — use 80–90% of expected amounts to account for delays.

Step 2

List all expected outflows Salaries, rent, vendor payments, EMIs, utility bills, GST payments, tax instalments, loan repayments. These are usually more predictable than inflows.

Step 3

Calculate the net weekly position Inflows minus outflows each week. A negative number in any week is a warning signal — you need to either accelerate collections or arrange cover before that week arrives.

Step 4

Roll it forward every week Each Monday, add the next 13th week and update actual figures for the week just passed. The forecast evolves continuously rather than going stale.

The single most important rule in cash flow forecasting

Do not confuse revenue with cash. An invoice raised is not cash received. A purchase order confirmed is not cash in the account. Your forecast must track actual cash movement — not accounting entries. Only money that hits your bank account is real cash flow.