What cash flow means for an SMB
Cash flow is the money that actually enters and leaves the business bank account during a period. It is not the invoices issued nor the expenses accrued: it is the real collections from customers and the real payments to suppliers, payroll, tax authorities, and other liabilities. For an SMB, cash flow outranks accounting profit, because you can show a positive P&L and still fail to pay rent on the first of the month.
The typical SMB crisis is not a sales shortfall; it is timing mismatch. Invoices at 60-90 days, suppliers that collect at 30, biweekly payroll, and VAT (IVA) that does not forgive. The result: a business that is profitable on paper but runs out of cash.
Cash flow vs P&L
The P&L records revenue when you invoice and expenses when the obligation accrues, regardless of when cash actually moves. Cash flow records money when it enters or leaves the bank. A customer that signed a USD 25,000 contract payable at 90 days already shows up in this month's P&L, but your bank account will not see that cash until the following quarter. Meanwhile, you paid payroll, rent, and social charges with cash that had to go out.
Net cash flow formula
Net cash flow for the period = Opening balance + Actual collections - Actual payments
Expanded by type:
Net cash flow = Operating cash flow + Investing cash flow + Financing cash flow
Numeric example. Opening bank balance: USD 10,600. Collections for the month (collected sales, not invoiced): USD 24,700. Payments for the month (suppliers USD 13,500 + payroll USD 5,600 + rent USD 1,650 + VAT/income tax USD 2,000): USD 22,750. Operating flow = USD 24,700 - USD 22,750 = +USD 1,950. With no investment and no new credit, the closing balance lands at USD 12,550. That is the number your bank will see on day 1 of the next month - not the USD 4,180 profit that appears in the P&L because a USD 8,800 sale was invoiced but will not be collected for another 45 days.
How to calculate monthly cash flow, step by step
- Define the period and the opening balance. Take the bank balance from the last day of the prior month. That is your starting point.
- List expected real collections, not invoicing. Each line should have the probable collection date, not the invoice date. Use your accounts receivable (AR) and apply a delinquency discount if your historical DSO is high.
- List fixed outflows. Rent, base payroll, insurance, subscriptions, loan installments. These do not negotiate month to month.
- List variable outflows. Suppliers (with their DPO terms), banking fees, corporate card payments, maintenance, taxes (VAT payable vs VAT creditable, income tax withholdings, employer social security contributions).
- Compute net flow for the month = collections - outflows. This number has only three possible destinations: it increases the balance, it holds it, or it reduces it.
- Add the opening balance to the net flow. The result is your projected closing balance.
- Repeat for the next 11 months, carrying the closing balance forward as the opening balance of the following month.
A 12-month projection: the real weapon against illiquidity
A single-month cash flow tells you whether you make it to month-end. A rolling 12-month projection tells you whether you survive the year - and exactly when you will run out of air. Three rules that separate a useful projection from an Excel chart no one opens:
- Model three scenarios: optimistic (collections on time, no delinquency), realistic (average DSO from the last 6 months, expected delinquency of 4-8%), and pessimistic (DSO +15 days, 12% delinquency, loss of a top-3 customer).
- Carry the balance month by month. One negative month in isolation does not break you; three consecutive negative months that deplete the reserve do. The critical data point is the minimum balance your account reaches in any month of the year.
- Early warnings. If the projected minimum balance falls below the equivalent of one month of fixed spend, you have 90 days to act: renegotiate terms, accelerate collections, secure a revolving line of credit, or factor an invoice.
Types of cash flow
Total cash flow decomposes into three sub-flows that Google and accounting standards recognize separately:
- Operating cash flow (OCF). Customer collections minus payments to suppliers, payroll, rent, and operating taxes. It is the thermometer for whether your business, on its own, generates cash.
- Investing cash flow (ICF). Purchase of equipment, assets, capitalizable software, or their sale. Typically negative for a growing company.
- Financing cash flow (FCF). New credit inflow, shareholder contributions, principal repayment (not just interest) on loans, dividends. What plugs the gaps that operations cannot cover.
A healthy SMB should have positive OCF most months. If you rely on FCF to close the month, you are financing yourself to cover current expenses - the prelude to bankruptcy.
Example: profitable auto shop nearly goes under
Auto shop in an industrial city, 11 employees, annual revenue of USD 376K, accounting net profit of USD 36.5K (9.7% margin). On paper, a solid business. In cash, a year on the edge of closing.
The problem: 70% of its billing is to corporate fleet accounts with 75-day payment terms. Parts suppliers collect at 30, payroll is biweekly, and the tax authority does not forgive. Average bank balance during 8 months of the year: below USD 2,350. In February it dropped to USD 190 after paying year-end bonuses. A fleet customer that paid 28 days late nearly forced the owner to skip a payroll cycle.
The exit: negotiate a 30% deposit on new contracts, factor three large accounts at 2.1% monthly, and open a revolving line of USD 23.5K. Accounting margin dropped to 7.8%, but the minimum balance of the year rose to USD 12.4K. It stopped being a business on the edge.
Mistakes that drain your cash
- Confusing invoiced with collected. 90% of amateur projections count monthly invoicing as monthly income. The money does not exist until it hits the bank.
- Forgetting VAT (IVA). The VAT you collect from customers is not yours: you pass it to the tax authority. If you spend it, you will pay it with working capital.
- Not separating personal and business accounts. Untracked owner draws are the biggest leak in family-run SMBs.
- Growing fixed cost without coverage. Each hire adds ~40% on gross salary in social charges. A payroll increase of USD 5,900 requires another USD 8,250 in monthly cash.
- Updating the cash flow once a year. The projection has to be rolling: each month you close the prior one with real data, add a new month at the end, and maintain a 12-month horizon.
Interactive tool vs Excel template
A downloadable Excel template - plenty of those on Google - solves the first calculation but dies in the projection. It does not model scenarios, it does not alert when the projected minimum balance crosses the threshold, and no one updates it after the first month. An interactive web tool with optimistic/realistic/pessimistic scenarios, a rolling 12-month projection, and liquidity alerts is the difference between knowing whether you survive the next year and finding out the day the bank bounces a check.