Small-business cash-flow forecast: a practical template for women founders
Build a weekly cash-flow forecast for a women-owned MSME by tracking opening cash, realistic receipts, fixed and variable payments, tax dates and a low-sales scenario.
In this guide
What is a cash-flow forecast and why use one?
A cash-flow forecast estimates when money will enter and leave your business so you can see whether cash will be available for payroll, stock, rent, tax and loan payments. It is different from profit: a sale can be recorded before a customer pays, and a profitable month can still run short of cash. Start with a simple 13-week view, update it from actual bank and sales records, and label every estimate as an assumption.
Start with money available today, not expected sales
Take the opening cash from your reconciled business bank account and cashbook on a chosen date. Exclude customer promises, credit limits and owner funds that have not actually been transferred. If you include a planned loan or owner contribution, show it as a separate dated inflow and record the conditions.
Forecast the date cash will arrive
For each expected receipt, record the customer, invoice or order, amount, confidence and realistic settlement date. Account for marketplace settlement cycles, customer credit terms, refunds, payment-provider fees and a history of late payments. A confirmed purchase order is not cash in the bank.
List all cash commitments, including the less obvious ones
Include supplier deposits and balances, freight, rent, wages, software, insurance, debt instalments, GST or other tax payments, owner withdrawals, repairs and annual renewals. Mark fixed dates and amounts separately from variable costs so you can see which payments can be rescheduled and which cannot.
| Week | Opening cash | Expected receipts | Planned payments | Closing cash |
|---|---|---|---|---|
| Week 1 | ||||
| Week 2 | ||||
| Week 3 | ||||
| Week 4 | ||||
| Week 5-8 total | ||||
| Week 9-13 total |
Build the forecast step by step
Use a simple rolling equation
For each week, calculate closing cash as opening cash plus actual or expected receipts minus planned payments. The next week's opening cash is the previous week's closing cash. Keep actual amounts in a separate column from estimates so you can see where the plan differs from reality.
Example: a profitable order can still create a cash gap
Suppose you pay ₹40,000 for materials and labour this week, then invoice a ₹60,000 order whose customer is expected to pay in 30 days. The order may have a positive margin, but the ₹40,000 must leave your account before the ₹60,000 arrives. Put the payment and likely receipt in their expected weeks, then check whether rent, tax and other bills fit between them.
Make a base case and a stress case
The base case uses likely payment dates and planned costs. A stress case can delay the largest customer receipt, reduce next month's sales, add a repair or show a supplier deposit arriving earlier. Use the weaker case to choose a minimum cash buffer and decide when to pause optional spending or ask for earlier customer payment.
Turn the forecast into a weekly operating routine
Update actuals and explain variances once a week
Replace last week's estimates with bank, UPI, marketplace and cashbook actuals. For every difference, note whether the cause was a late customer, changed order, refund, extra expense or incorrect estimate. Adjust future weeks using evidence rather than carrying forward an outdated assumption.
Set trigger points before cash becomes urgent
Choose a minimum cash balance or an early-warning week when projected cash approaches that limit. Decide in advance who will contact overdue customers, negotiate supplier timing, pause discretionary purchases or speak with a lender. Do not wait until payroll, tax or an essential supplier payment is already missed.
Keep tax, borrowing and owner money visible
Set aside likely tax obligations and do not count tax collected for payment to Government as freely available working cash. Show loan disbursements and repayments separately. Record owner contributions and withdrawals so the forecast reflects what the business can actually use and the books remain explainable.
Cash-flow forecasting questions
How far ahead should a small business forecast?
A rolling 13-week forecast is a useful short-term starting point for cash timing. A monthly forecast can extend farther for seasonal planning, equipment or hiring. The right horizon depends on customer terms, stock cycles and how quickly the business can respond.
Is a cash-flow forecast the same as a profit-and-loss statement?
No. A profit-and-loss statement records income and expenses for an accounting period, while a cash forecast tracks when cash is expected to enter or leave. Customer credit, deposits, loan principal, owner contributions and asset purchases can make the two views differ.
What if I do not know exactly when a customer will pay?
Use a realistic expected date and confidence level, then include a later date in the stress case. Update the forecast when the customer confirms a payment date or when settlement history changes.
Can this forecast prove that my business will get a loan?
No. A forecast helps you understand cash needs and explain assumptions; it does not guarantee lender approval or investor interest. Startup India describes financial forecasts as projections based on sales and other assumptions, which should be made clear and reviewed against actual results.
Related practical guides
Related issue guides
Sources and publication record
Draft prepared 26 September 2026; project-team editorial review pending · Sources checked .
- Startup India: what investors assess in a startup planDepartment for Promotion of Industry and Internal Trade, Government of India
- Central GST Rules, Rule 56: maintenance of accounts by registered personsCentral Board of Indirect Taxes and Customs, Government of India