Cash Flow Forecast
Cash Flow Forecast shows the money you expect to come in and go out over the next 13 weeks or 6 months, and the balance you will be left with.
Why and when you use it
Profitable businesses still run short of cash when customers pay late and salaries fall due. This screen uses your open invoices and bills, salaries and planned items to project your bank and cash balance, and warns you before it drops too low. The owner uses it to plan big purchases, loans or collections drives.
Before you start
- Invoices and bills with due dates entered
- Payroll set up if you want salaries included
Step by step
- Open Cash Flow ForecastOpen 🏢 Stockivio ERP and choose 🌊 Cash Flow Forecast.
- Set up forecast settingsUnder Forecast settings, enter Cash + bank balance today (₹), Warn me if balance goes below (₹), Salary paid on day, and Customers pay after (days) and We pay suppliers after (days) for documents without a due date.
- Choose what to includeTick Overdue invoices and bills, Include monthly salaries (from Payroll) and Include recurring invoices / bills as needed. Press Save settings.
- Add planned itemsUnder Planned payments and receipts, enter What, Money (in or out), Amount (₹), How often, First date and Last date (optional). Press Save item.
- Pick the viewPress Next 13 weeks or Next 6 months, then Refresh.
- Read the chart and tableMoney in, money out and balance shows the trend. In the Forecast table, click a row to see the entries behind it.
- Act earlyIf the balance falls below your warning level, plan collections, delay a purchase or arrange funds in advance.
Worked example
Patel Engineering Works has ₹7,80,000 in cash and bank on 1 Nov 2026. Salaries of ₹3,40,000 are paid on the 1st, and a ₹6,00,000 machine instalment is due on 15 Dec 2026.
- Forecast settings: Cash + bank balance today ₹7,80,000; Warn me if balance goes below ₹2,00,000; Salary paid on day 1; Customers pay after 45 days. Save settings.
- Add item: What 'Machine instalment', Money out, ₹6,00,000, How often once, First date 15 Dec 2026. Save item.
- Press Next 13 weeks and Refresh.
- The week of 14 Dec 2026 shows a balance of ₹1,10,000, below the warning.
Result: The owner sees the shortfall six weeks early, starts a collections drive on overdue customers and moves one raw material purchase to January.
💡 Tips
- Update Cash + bank balance today each week for accuracy.
- Use real payment habits for Customers pay after (days), not your credit terms.
- Add GST, rent and loan EMIs as planned items.
⚠️ Common mistakes
- Leaving out salaries. Tick Include monthly salaries (from Payroll) or add them as a planned item.
- Treating the forecast as fact. It is only as good as due dates and planned items; review it weekly.
🎬 Video walkthrough (script — recording coming soon)
- Scene 1: Open Cash Flow Forecast.
- Scene 2: Fill Forecast settings and Save settings.
- Scene 3: Add a planned payment and Save item.
- Scene 4: Next 13 weeks and Refresh.
- Scene 5: Click a forecast row to see entries.
- Scene 6: Show the low-balance warning.