Cash Flow Forecasting for MSMEs: A Simple Guide

Profit is not the same as cash

Many profitable small businesses run into trouble because they run out of cash. Sales may be booked, but customers pay late; stock has to be bought in advance; GST, TDS and salaries fall due on fixed dates. A cash flow forecast shows when money will come in and go out, so you can see a shortfall weeks before it happens and act calmly instead of in a crisis.

Build a 13-week forecast

A rolling 13-week (about three-month) forecast is practical for most MSMEs. List each week across the top and these lines down the side:

• Opening bank balance.
• Expected collections from customers, based on actual due dates and payment habits.
• Other receipts such as loans or asset sales.
• Payments to suppliers, salaries, rent, utilities and loan EMIs.
• Statutory payments: GST, TDS, PF, ESI and advance tax on their due dates.
• Closing balance, which becomes next week's opening balance.

Update the forecast every week with actual figures and roll it forward one more week. Over time your estimates become more accurate.

Be realistic about collections

The biggest forecasting error is assuming customers pay on the invoice due date. Use each customer's actual payment history. Follow up on overdue invoices early, and for buyers who delay beyond the legal limit, remember the protections for registered MSMEs explained in our guide to the MSME 45-day payment rule and Samadhaan.

A simple example

Imagine a small manufacturer with an opening balance that covers about two weeks of costs. In week three, salaries and the monthly GST payment fall due together, while a large customer usually pays around ten days late. On paper the business is profitable, but the forecast shows a shortfall in week three. Seeing this early, the owner can follow up with the customer in week one, ask a key supplier to accept payment a week later and keep the overdraft facility ready as a backup. No crisis, no penalties and no emergency borrowing at high cost.

This is the real value of a forecast: it turns surprises into planned decisions. Even a simple spreadsheet maintained every week gives this visibility.

• Start with the next 13 weeks only — do not try to be perfect.
• Use conservative estimates for collections and generous ones for payments.
• Compare forecast with actual every week and learn from the difference.

Plan statutory payments

GST, TDS and payroll contributions are due on fixed dates, and late payment attracts interest and penalties. Put them in the forecast first. Our guides to TDS compliance basics and the monthly bookkeeping checklist help keep these figures accurate.

What to do when you see a gap

• Speed up collections: offer small early-payment incentives or follow up more firmly.
• Negotiate supplier terms or stagger large purchases.
• Reduce excess stock and slow-moving items.
• Delay non-essential spending until the gap closes.
• Arrange working capital finance before you need it, not during a crisis.

For working capital limits, cash credit or invoice financing, ATTPL Finance can explain options; see also its working capital loan guide. Group companies managing several entities can read about treasury controls on ATTPL HOLDCO, and accounting software set-up is covered by ATTPL IT.

Early warning signs

Watch for rising overdue receivables, frequent use of the full overdraft limit, delayed supplier payments and growing stock. These signals call for a closer look at pricing, credit terms and costs. To set up a simple forecasting system for your business, contact us.

Frequently asked questions

Sources and further reading

• Ministry of Micro, Small and Medium Enterprises
• Goods and Services Tax Network