Cash Flow Gap CalculatorLate Payment Impact Tool for Indian SMBs

Month 1 → Invoice raised: ₹5,00,000 (Net-60 terms)

Month 1 → Expenses due: ₹3,00,000 (salaries, rent, vendor payments)

Month 1 → Cash received: ₹0 (invoice not yet due)

Month 1 → Cash gap: ₹3,00,000 must come from reserves or debt

Month 3 → Invoice paid: ₹5,00,000 arrives

P&L shows: ₹2,00,000 profit ✅ — Cash account shows: stress 🚨

1 month of sales locked

One month of credit sales locked. Manageable with a 30–45 day cash reserve.

1.5 months of sales locked

45 days of credit sales tied up. Requires careful expense planning and a 45-day cash buffer.

2 months of sales locked

Two months of sales stuck in receivables. Most SMBs begin missing expenses at this level without external credit.

3 months of sales locked

Three months of revenue locked. Requires significant working capital financing or invoice factoring to survive.

You often have revenue on paper but no cash in bank

You delay paying vendors or salaries until client payments arrive

You have taken overdraft or short-term loans to cover monthly expenses

Most of your clients are on Net-60 or Net-90 terms

More than 60% of your revenue goes out as credit invoices

Your cash reserve covers less than 30 days of operating expenses

Locked Cash (Receivables Outstanding)

This is the amount permanently tied up in outstanding invoices. For ₹5L monthly credit sales on Net-60, you always have ₹10L locked — even in a perfect month.

Monthly Cash Gap

Immediate cash inflows = revenue collected as cash (non-credit). If this number is negative, you cannot cover expenses from current month's actual cash receipts.

Working Capital Needed

This is the minimum cash buffer you need to keep operating during the receivables collection period. It grows linearly with longer payment terms.

Opportunity Loss

This is the return you forgo by having capital sitting in receivables instead of being reinvested. At 12% return and ₹10L locked for 60 days, you lose ₹19,726 — invisible but real.

Under Section 15 of the MSME Development Act, buyers must pay MSME suppliers within 45 days of delivery. If payment is delayed beyond this, the buyer owes compound interest at 3× the RBI bank rate.

The RBI-mandated Trade Receivables Discounting System (TReDS) allows MSME suppliers to sell outstanding invoices to banks or NBFCs at a small discount and receive immediate payment — eliminating the cash gap.

For businesses doing over ₹5 crore annual turnover, e-invoicing mandates create a digital trail that makes it easier to enforce payment terms and access invoice financing from lenders.

What is a cash flow gap?

A cash flow gap is the difference between when your business earns money (invoices clients) and when you actually receive that money in your bank account. If you invoice ₹5 lakh in a month but clients pay on Net-60 terms, that ₹5 lakh is not available to cover your expenses for two months. The gap is the period where your expenses are due but your revenue has not yet arrived. This is distinct from profitability — a profitable business can still face a cash flow gap and be unable to pay rent or salaries.

How much cash does Net-60 payment terms actually lock up?

With Net-60 payment terms, you have approximately two months of credit sales locked in receivables at any given time. For example, if your monthly revenue is ₹5 lakh and 70% is on credit, that is ₹3.5 lakh per month on credit. At Net-60, you have ₹7 lakh (two months of credit sales) permanently locked in outstanding invoices — even in a stable month. This locked cash cannot be used to pay expenses, service debt, or invest in growth.

What is working capital and how much do I need?

Working capital is the cash you need to keep your business running during the period between spending money (paying expenses) and collecting money (receiving payment from clients). The formula is: Working Capital Needed = Total Monthly Expenses × (Payment Terms in Days ÷ 30). If your monthly expenses are ₹2 lakh and clients pay on Net-60, you need ₹4 lakh in working capital just to break even month to month. Most SMBs underestimate this and run into cash crunch despite being profitable on paper.

What is the opportunity cost of delayed payments?

The opportunity cost of delayed payments is the return you could have earned if your stuck receivables were available as cash. For example, if ₹10 lakh is locked in Net-90 receivables and the alternative is a 12% annual return (business investment or FD), the opportunity cost is ₹10 lakh × 12% × (90/365) = approximately ₹29,589 every 90 days — or ₹1.2 lakh per year. Across many clients and transactions, this compounds into a significant invisible loss that never appears on a P&L statement.

How can I reduce my cash flow gap without losing clients?

The most effective methods to reduce cash flow gap without damaging client relationships include: (1) Switching to 50% advance + 50% on delivery — eliminates the gap for new work without asking clients to change existing habits; (2) Early payment discounts of 1–2% for payment within 10 days — the cost is usually less than opportunity loss and financing costs; (3) Automated invoice reminders sent at Day 1, Day 7, and Day 14 before due date — this alone reduces average collection time by 20–30% without confrontation; (4) Moving from Net-60 to Net-45 for new clients while grandfather existing ones in at Net-60; (5) Invoice factoring or receivables financing where a bank or NBFC advances 80–90% of invoice value immediately for a small fee.

What is DSO (Days Sales Outstanding) and why does it matter?

Days Sales Outstanding (DSO) measures how many days on average it takes your business to collect payment after an invoice is issued. DSO = (Accounts Receivable ÷ Total Credit Sales) × Number of Days. A DSO of 45 means you wait 45 days on average to get paid. The lower the DSO, the healthier your cash flow. For Indian SMBs, average DSO is typically 60–90 days, which is significantly higher than global benchmarks of 30–45 days. Reducing DSO by even 15 days on ₹50 lakh monthly revenue frees up approximately ₹25 lakh in working capital annually.

Can a profitable business have a cash flow problem?

Yes — and this is the most common financial misunderstanding in Indian SMBs. A business is profitable when revenue exceeds expenses on paper. But cash flow is about timing: when does cash actually enter and leave your account. A business can show a ₹10 lakh profit on its P&L while being unable to pay next month's salaries because that profit is sitting in 90-day receivables. According to studies, over 80% of small businesses that fail do so due to cash flow problems — not lack of profit. This is why cash flow gap analysis is separate from and equally important to profitability analysis.

How does this cash flow gap calculator work?

The calculator uses four core formulas: (1) Locked Cash = Monthly Credit Sales × (Payment Terms Days ÷ 30) — this is the amount permanently tied up in outstanding invoices at any given time; (2) Monthly Cash Gap = Total Monthly Expenses − Immediate Cash Inflows (non-credit revenue) — shows whether you can cover expenses from current month's immediate inflows; (3) Working Capital Needed = Total Monthly Expenses × (Payment Terms Days ÷ 30) — the minimum cash buffer required to operate during the payment collection period; (4) Opportunity Loss = Locked Cash × Annual Return Rate × (Payment Terms ÷ 365) — what that capital could have earned if it were available.