Article
Most MSME budgets fail because they are built as wishes, not operating controls. Revenue is entered as a monthly target, expenses are copied from last year, and cash is assumed to arrive on time. The file looks disciplined until the first customer delays payment, a vendor raises price, a team misses delivery, or a large order consumes more working capital than expected.
A useful forecast starts with drivers, not totals. For each product, service line or channel, the owner should know expected quantity, average selling price, expected gross margin, conversion probability, expected order date, delivery date, invoice date and collection date. This converts budgeting from 'we should do Rs 50 lakh this month' into 'these 22 deals can realistically produce Rs 38 lakh, with Rs 12 lakh still uncertain and Rs 9 lakh at collection risk.'
The latest macro indicators make this discipline important. March IIP showed investment-linked strength in capital goods and infrastructure or construction goods, but May flash PMI showed softer manufacturing new orders and rising input costs. That combination means some MSMEs will see demand, but not always with comfortable margin or payment timing. A forecast that tracks revenue without margin and cash timing can mislead the founder.
Build the forecast in three layers. Layer one is revenue: confirmed orders, high-probability quotes, repeat orders and new leads. Layer two is margin: current raw material quotes, freight, discounts, wastage, commission, payment gateway cost and service rework. Layer three is cash: opening balance, expected inflows, statutory outflows, vendor payments, payroll, EMI, rent, capex and minimum reserve. Review the gap weekly.
Use scenarios, but keep them simple. Base case is what is likely if the pipeline performs normally. Downside case assumes slower conversion, delayed collections and higher input costs. Upside case includes only orders that have clear buyer intent, not founder optimism. The purpose is not prediction accuracy. The purpose is earlier action: slower hiring, tighter credit, revised pricing, faster follow-up, inventory caution or selective working-capital borrowing.
The owner dashboard should show seven numbers every Monday: expected sales for the next 30 or 60 or 90 days, expected gross margin, expected cash inflow, expected cash outflow, receivables overdue, purchase commitments and minimum cash reserve. If these numbers cannot be produced quickly, the business is not forecasting; it is waiting for month-end accounting to explain what already happened.
The CFO action this week: create a 90-day rolling forecast with weekly columns. Update only what changes. Do not make it complex enough to be abandoned. A basic spreadsheet with customer, deal value, probability, margin, expected collection date and owner is enough to start. Forecasting is useful when it improves decisions before the cash problem arrives.