| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
CRM (crm)
• Invoicing (account) • Project (project) • Calendar (calendar) • Contacts (contacts) • Discuss (mail) |
| Lines of code | 2445 |
| Technical Name |
bista_cashflow_forecast |
| License | LGPL-3 |
| Website | https://www.bistasolutions.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
CRM (crm)
• Invoicing (account) • Project (project) • Calendar (calendar) • Contacts (contacts) • Discuss (mail) |
| Lines of code | 2445 |
| Technical Name |
bista_cashflow_forecast |
| License | LGPL-3 |
| Website | https://www.bistasolutions.com |
Cash Flow Forecasting
This module provides complete visibility over your future cash position by consolidating Bank Balances, Accounts Receivable, Accounts Payable, CRM Pipeline, and Recurring Obligations into a single interactive forecasting dashboard.
Why Use This Module?
✔ Real-Time Treasury Visibility
Understand future cash position day-by-day with automatic aggregation of all major inflows and outflows.
✔ Behavioral AR Forecasting
Uses partner payment history to adjust expected receipt dates and increase forecasting accuracy.
✔ Pipeline-Based Revenue Projection
Converts CRM probability into weighted cash inflow estimates.
✔ Scenario Planning
Simulate delays in receivables, accelerated payables, or conservative pipeline adjustments.
✔ Automated Snapshots
Track forecast vs actual performance with weekly auto-snapshots.
✔ Professional Excel Export
Generate 6-sheet Excel workbook with KPIs, detailed forecast, AR, AP, Pipeline, and Recurring analysis.
Interactive Forecast Dashboard
KPI Bar, Chart.js combo chart, source breakdown, volatility metrics, and Daily / Weekly / Monthly toggle with Color-coded inflows (green), outflows (red), threshold alerts, and running balance tracking.
Forecast Detail Excel
Expandable table showing daily, weekly, or monthly breakdowns includes Date, AR Inflow, Pipeline Inflow, AP Outflow, Recurring Outflow and Running Balance.
Accounts Receivable
Effective aging logic, partner reliability scoring, confidence percentage, and adjusted receipt dates.
Accounts Payable
Planned payment date, discretionary flag, and intelligent cash outflow timing.
Recurring Obligations
Manual entries for predictable outflows not yet in AP (payroll, rent, insurance, loans).Weekly, bi-weekly, monthly, quarterly, and annual frequencies with smart month-end handling.
How Cash Flow Forecasting Work
Account User — Read-only access to forecasts
Account Manager — Full access (Create, Edit, Delete)
Navigate to Cash Flow > Forecasting > Forecast Reports
Fill Report Name, Bank/Cash Journals & Minimum Balance Threshold
Click on Refresh Data — Dashboard Appears
CRM > Configuration > Stages
Select Stages Representing Active Opportunities
Click on Export to Excel. Forecast Detail Table will be downloaded as an Excel workbook.
User can create snapshot to stores a point-in-time copy of forecast data.
Please log in to comment on this module