Cash Flow Management and MIS Reporting for SMEs

“Profitable but always short of cash” is one of the most common problems in Indian small businesses. Profit is an accounting measure. Cash is what pays salaries, GST and suppliers. A business can show a healthy P&L while its cash is locked in unpaid invoices, excess stock or advances. This guide gives a simple framework for managing cash and a monthly MIS that tells you what’s really happening.

Why profit and cash diverge

Item	Effect on profit	Effect on cash
Sales on 90-day credit	Profit recorded now	Cash comes in 3 months later
Building up stock	No effect until sold	Cash goes out now
Loan principal repayment	No effect	Cash goes out
Capital expenditure (machinery, laptops)	Only depreciation	Full cash outflow now
GST and TDS	Pass-through or a tax credit	Paid monthly in cash
Advance tax	Charged at year end	Paid in instalments (June, Sept, Dec, March)

The working capital cycle

Cash conversion cycle = Debtor days + Inventory days − Creditor days

Metric	Formula	What to aim for
Debtor days	Trade receivables ÷ Credit sales × 365	As close to your agreed credit terms as possible
Inventory days	Inventory ÷ Cost of goods sold × 365	Lower is better, without stock-outs
Creditor days	Trade payables ÷ Purchases × 365	Use agreed credit, but pay MSME suppliers within 45 days (section 43B(h))

Example: debtor days 75, inventory days 60, creditor days 45 → a 90-day cycle. You need to fund three months of operations. Cutting debtor days to 50 frees up almost a month’s working capital.

The 13-week cash flow forecast

A rolling week-by-week forecast for the next quarter is the single most useful cash tool:

Opening bank balance (all accounts)
Inflows: customer collections (by customer, based on realistic dates), other receipts, loans
Outflows: suppliers, salaries, rent, GST (20th), TDS (7th), PF/ESI (15th), advance tax dates, EMIs, capex
Closing balance = opening + inflows − outflows
Update weekly, comparing actual with forecast

It shows cash gaps weeks in advance, so you can chase collections, delay non-essential spending or arrange limits in time.

Practical ways to improve cash flow

Collect faster

Invoice immediately on delivery, with clear due dates
Offer UPI or payment links on invoices
Run a weekly receivables review and escalate overdue accounts
If you are an MSME supplier, rely on the MSMED Act (15/45-day limit and interest) and register on Udyam
Consider TReDS invoice discounting for large corporate buyers

Spend smarter

Negotiate longer credit with non-MSME suppliers
Hold less stock: reorder levels, and clearance of slow-moving items
Lease rather than buy where it makes sense
Time capex to periods of surplus cash

Fund correctly

Use working capital limits (CC/OD) for working capital, and term loans for long-term assets
Keep a cash buffer of 1–2 months of fixed costs

A simple monthly MIS format

A good MIS fits on 3–5 pages and arrives by the 10th of the next month:

Section	Contents
1. Dashboard	Revenue, gross margin %, EBITDA, net profit, cash balance, debtors, creditors, stock: this month vs last month vs budget
2. P&L	Monthly and year-to-date, vs budget and last year, with variance comments
3. Balance sheet summary	Key assets and liabilities, net worth, borrowings
4. Cash flow	Actual for the month and the 13-week forecast
5. Receivables ageing	0–30, 31–60, 61–90, 90+ days, top 10 overdue customers
6. Payables ageing	Including MSME dues over 45 days
7. Compliance status	GST, TDS, PF/ESI, advance tax, ROC: done or pending
8. Key issues and actions	3–5 points for management to decide on

Financial KPIs every owner should track

KPI	Why it matters
Revenue growth (month on month, year on year)	Momentum
Gross margin %	Pricing power and cost control
EBITDA margin	Operating profitability
Cash runway (cash ÷ monthly net burn)	Startups especially: how long you can survive
Debtor days / Creditor days / Inventory days	Working capital efficiency
Current ratio (current assets ÷ current liabilities)	Short-term liquidity (banks look for about 1.33 or more)
Debt-equity ratio	Leverage
DSCR (cash available for debt service ÷ principal + interest)	Loan repayment capacity (banks usually expect 1.25 or more)
Revenue per employee	Productivity

Frequently asked questions

How often should a small business prepare MIS?
Monthly. Quarterly is too late to correct course, and weekly is useful only for the cash forecast.

Do I need special software?
No. Your accounting software (Tally or Zoho Books) plus a spreadsheet template is enough for most SMEs. The discipline matters more than the tool.

What does a bank look for when we apply for a working capital limit?
Audited financials, provisional current-year numbers, projections, stock and debtor statements, CMA data and ratios such as the current ratio and DSCR.

Want monthly MIS and a cash forecast you can actually use? Garvita Jain & Co. builds your MIS pack and 13-week cash model, reviews them with you every month, and helps you prepare for bank and investor discussions. Contact us here, or at contact@garvitajainandco.com or +91 98678 16597.

This article is general information as of November 2026 and is not professional advice.

Sources

Official

Professional / CA publications