Cash Flow Forecasting for SMBs: A Practical Guide

Cash flow forecasting is the discipline that separates SMBs that survive a hard quarter from SMBs that do not. Here is the uncomfortable pattern accountants in Egypt and Libya see every year: a company with a healthy income statement, growing sales, and real profit on paper suddenly cannot pay salaries in week three of the month. The business was profitable. It just ran out of cash.

Profit and cash are different animals. Profit is an accounting opinion about a period; cash is what is actually in the bank when payroll is due. A sale invoiced today might be collected in 90 days, while the goods you sold were paid for last month and the salaries that produced them are due this Thursday. If you only watch the profit and loss statement, you are driving while looking at last month's road.

This guide covers how to build a practical 30/60/90-day cash flow forecast for a small or medium business, how to get receivables under control, and how software can generate the forecast automatically from data you already have.

Why profitable companies run out of cash

Four mechanics do most of the damage:

• The collection gap. You recognize revenue when you invoice, but B2B customers in our markets routinely pay in 60 to 120 days. Every month of growth widens the gap between booked revenue and collected cash.
• Inventory swallowing cash. Stock sitting in the warehouse is profit's raw material and cash's grave. Companies that buy aggressively ahead of price increases often win on margin and lose on liquidity.
• Fixed obligations on a fixed calendar. Salaries, rent, loan installments, and tax payments do not wait for your customers to pay. The mismatch between flexible income and rigid outflows is the classic SMB killer.
• Currency timing. If you import in dollars and sell in local currency, a devaluation between purchase and collection quietly converts your paper profit into a real cash loss.

None of these show up clearly on a monthly P&L. All of them show up in a cash flow forecast.

How to build a 30/60/90-day cash flow forecast

A useful forecast is a simple table: opening bank balance, expected cash in, expected cash out, closing balance, repeated week by week for the next 13 weeks. Here is the practical method.

Step 1: Start from actual bank balances

List every bank account, cash box, and wallet, and total today's real position. Not the ledger balance including uncleared items: the money you can actually spend.

Step 2: Map cash inflows by week, realistically

Take your open invoices and assign each to the week you honestly expect collection, based on that customer's actual payment history, not the due date on the invoice. A customer who has paid at 75 days for two years will pay at 75 days again. Add expected cash sales at a conservative run rate. Do not include revenue you have not yet won.

Step 3: Map cash outflows by week

Fixed items first because they are certain: payroll, rent, loan installments, subscriptions, tax dates. Then supplier payments by their due dates, then variable spend from recent averages. Mark which payments are movable and which are not; that distinction is your steering wheel in a tight week.

Step 4: Roll the balance forward and find the low point

Closing balance of each week becomes the opening of the next. The number that matters most is the lowest projected balance in the 90 days. If it goes negative in week seven, you now know the problem, its size, and its date, which means you can act six weeks before it happens: accelerate collections, delay a movable payment, or arrange financing while you still have leverage.

Step 5: Update weekly, not quarterly

A forecast is only as good as its refresh rate. Every week, replace assumptions with actuals and roll the horizon forward. This is exactly the step where manual Excel forecasts die, because it takes hours, and it is exactly the step that ILORA's Financial Forecasting module automates: it reads your live invoices, receivables, payables, and recurring obligations, and rebuilds the cash projection and your runway (how many months your cash lasts at current burn) continuously from actual data.

Receivables: where SMB cash goes to hide

For most B2B companies, the single fastest source of cash is not new sales; it is money already earned and not yet collected. Three habits change the game:

• Run an AR aging report weekly. Group receivables into 0-30, 31-60, 61-90, and 90+ days. The 90+ bucket is not "revenue", it is a rescue operation. A finance system with live reports produces this in one click instead of a half-day Excel exercise.
• Make follow-up systematic, not personal. A reminder at due date, a call at +7 days, escalation at +30, and a stop on new credit at +60. When the sequence is standard, collectors stop feeling awkward and customers stop testing you.
• Price your payment terms. A customer who pays in 120 days costs you financing. Offer early-payment discounts where margin allows, and require deposits on custom work.

Watch one number monthly: DSO (days sales outstanding), your average collection period. Cutting DSO from 90 to 60 days on steady sales releases a full month of revenue into your bank account, once, permanently, for free.

From spreadsheet to system: what automation actually changes

You can absolutely run the method above in a spreadsheet, and if you do nothing else after reading this, start that spreadsheet today. But the honest failure mode is known: the file is accurate for three weeks, then a busy month happens, the file goes stale, and stale forecasts are worse than none because they feel like control.

An integrated platform changes the economics of staying current:

• Invoices, collections, supplier bills, and payroll already live in the system, so the forecast updates itself when the underlying documents change.
• Runway and cash projections are recalculated from actuals, so the "week seven problem" surfaces as an early warning instead of a Thursday surprise. ILORA's forecasting produces cash and runway projections automatically from your real transactions.
• Receivables aging, customer payment behavior, and collection follow-ups sit in the same place as the forecast, so cause and cure are one screen apart. Dashboards in ILORA Intelligence put the cash position, aging, and forecast in front of the founder daily, not monthly.
• Multi-currency balances are revalued properly, so dollar obligations against pound or dinar income stop hiding in the averages.

Because unlimited free viewer seats are included on all ILORA plans, your accountant, your partner, and your bank relationship manager can all watch the same live numbers without extra license cost.

Frequently asked questions

What is the difference between profit and cash flow?

Profit is revenue minus expenses for a period, recognized when earned, regardless of when money moves. Cash flow is the actual movement of money in and out of your accounts. A company can be profitable while cash-starved when collections lag sales, or cash-rich while unprofitable when it delays paying suppliers.

How far ahead should a small business forecast cash flow?

Ninety days by week is the working standard: near enough to be accurate, far enough to act on problems. Many SMBs add a rougher 12-month monthly view for planning investments and financing. The weekly 13-week forecast, refreshed every week, is the one that prevents payroll emergencies.

What is cash runway and why does it matter for SMBs?

Runway is how many months your current cash lasts at your current net burn rate. It matters because it converts anxiety into a number: a nine-month runway supports calm decisions, a six-week runway demands immediate action. ILORA computes runway automatically from your actual balances and spending patterns.

Can accounting software really forecast my cash flow automatically?

Yes, if the same system holds your invoices, receivables, payables, and payroll. It projects collections from real customer payment behavior and schedules known obligations, producing a rolling forecast without manual data entry. You review assumptions instead of building spreadsheets, which is why the forecast actually stays current.

Start before you need it

The best time to build a cash flow forecast is when cash feels comfortable, because every option (negotiating terms, arranging credit lines, chasing receivables) works better without a deadline burning behind you. Companies that fail rarely lack profit; they lack six weeks of warning.

If you would rather have the forecast build itself from your real data, book a demo of ILORA and see your own cash projection and runway on screen. Every plan comes with a 30-day money-back guarantee.