| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 687 |
| Technical Name |
cashflow_forecast_online |
| License | OPL-1 |
| Website | https://thenapkincompany.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 687 |
| Technical Name |
cashflow_forecast_online |
| License | OPL-1 |
| Website | https://thenapkincompany.com |
Cash Flow Forecast
Real-time 6-month cash projection inside Odoo Accounting — synced automatically with your bank accounts, invoices, and bills.
✓ Works on Odoo Online · Odoo.sh · On-Premise
What it does
Cash Flow Forecast adds a dedicated dashboard to Accounting → Reporting that gives you a single-screen view of the next 6 months of cash movement. All data is pulled live from your existing Odoo records — no manual exports, no spreadsheets, no third-party integrations.
Features
Live Bank Balance Sync
Reads your current account balances from all bank and cash journals in real time.
Receivables & Payables
Pulls all open customer invoices and vendor bills, sorted by due date, directly from Odoo.
Interactive Chart
Bar chart of monthly inflows/outflows + running balance line. Drill down to any day or month.
Recurring Entries
Define rent, salaries, loan payments — any fixed monthly cost — once, and they auto-project each month.
Manual One-time Entries
Add ad-hoc inflows or outflows (equipment purchase, tax payment, one-time income) to any specific date.
Cash Runway
Tells you how many days your cash lasts at current burn rate. Shows ∞ when there are no outflows.
Monthly Summary Table
Month-by-month breakdown of opening balance, total in, total out, net, and closing balance.
Multi-company Ready
Manual and recurring entries are scoped per company. Switch company in Odoo and the forecast updates automatically.
How it works
The module adds a single menu entry under Accounting → Reporting → Cash Flow Forecast. Click it to open the full-screen dashboard. No configuration required after installation — the app auto-detects all your bank and cash journals.
-
Opening balance auto-detected Sums the current balance of all your bank and cash journals in Odoo.
-
Receivables plotted by due date Every open customer invoice appears as an inflow on its due date in the 6-month window.
-
Payables plotted by due date Every open vendor bill appears as an outflow on its due date.
-
Add recurring & manual entries Supplement Odoo data with fixed monthly costs and one-off amounts — all stored in Odoo models.
-
Chart updates in real time Click "Sync Odoo" to refresh from the latest accounting data, or the chart reloads on each page open.
Installation
-
Download and install the module Upload the ZIP via Settings → Apps → Upload Module, or install directly from the App Store.
-
Update App List and install Go to Apps → Update Apps List, search "Cash Flow Forecast", click Install.
-
Open the dashboard Navigate to Accounting → Reporting → Cash Flow Forecast. The dashboard opens immediately — no further setup needed.
Requirements & Compatibility
Odoo version: 19.0
Deployment: Odoo Online (SaaS) · Odoo.sh · On-Premise
Required apps: Accounting (account)
External services: None — uses only your existing Odoo data
Browser support: All modern browsers (Chrome, Firefox, Safari, Edge)
Permissions
- Accounting User — full read/write access to the dashboard, manual entries, and recurring entries
- Accounting Manager — same access as User
FAQ
Does this modify my accounting data?
No. The module only reads your existing journal entries, invoices, bills, and bank balances. It never writes to any accounting records. Manual and recurring entries are stored in separate models used exclusively by this module.
Will my manual entries persist between sessions?
Yes. Manual and recurring entries are stored in Odoo database models (not browser localStorage), so they persist for all users of the same company.
What if I have multiple bank accounts?
The opening balance is the sum of all bank and cash journals in your company. Each journal's balance is included automatically — no configuration needed.
Can I use this for multiple companies?
Yes. Manual and recurring entries are scoped to the active company. Switch companies in Odoo and the forecast reflects that company's data.
Is the 6-month window configurable?
The current version uses a fixed 6-month rolling window starting from today. A configurable range is planned for a future release.
Cash Flow Forecast
Real-time 6-month cash projection inside Odoo Accounting, synced automatically with your bank accounts, invoices, and bills.
Installation
- Upload the module via Settings → Apps → Upload Module, or install directly from the Odoo App Store.
- Go to Apps → Update Apps List, search for Cash Flow Forecast, and click Install.
- Navigate to Accounting → Reporting → Cash Flow Forecast — the dashboard opens immediately with no additional setup required.
Configuration
No configuration is required after installation. The module automatically detects all bank and cash journals in your Odoo instance.
Multi-company: Switch the active company in Odoo and the forecast will reflect that company's data automatically.
Usage
Opening the Dashboard
Go to Accounting → Reporting → Cash Flow Forecast. The dashboard loads with:
- Starting Balance — sum of all bank and cash journal balances
- Projected Balance — estimated balance at the end of the 6-month window
- Total Receivables — open customer invoices due in the next 6 months
- Total Payables — open vendor bills due in the next 6 months
- Cash Runway — how many days your cash lasts at the current burn rate
Syncing Odoo Data
Click Sync Odoo to refresh balances, receivables, payables and journal entries from the latest accounting data. The chart and tables update immediately.
Adding Manual Entries
Use the Manual Entries form to add one-time inflows or outflows on a specific date:
- Enter a description (e.g. Tax payment, Equipment purchase)
- Select Inflow or Outflow
- Enter the amount
- Pick the date
- Click + Add
Manual entries are stored in the Odoo database and persist across sessions.
Adding Recurring Entries
Use the Recurring Entries form to define fixed monthly costs (rent, salaries, loan payments):
- Enter a description (e.g. Office rent, Payroll)
- Select Inflow or Outflow
- Enter the amount
- Enter the day of month (1–28) when the entry occurs
- Click + Add
Recurring entries automatically generate one occurrence per month in the 6-month window.
Reading the Chart
- Bars — monthly inflows (green) and outflows (amber)
- Line — running cash balance across the period
- Drill-down — click any month bar to expand to a day-by-day view showing opening balance, daily inflows/outflows, and closing balance
Monthly Summary Table
Below the chart, a table shows each month's:
- Opening Balance
- Total Inflows
- Total Outflows
- Net (Inflows − Outflows)
- Closing Balance
Receivables & Payables Tables
- Receivables — all open customer invoices with due date, customer name, and amount
- Payables — all open vendor bills with due date, vendor name, and amount
- Journal Entries — other posted entries from your bank and cash journals
Known Limitations
- The forecast window is fixed at 6 months rolling from today. A configurable range is planned for a future release.
- Only bank and cash journal balances are included in the starting balance. Other journal types (e.g. sales, purchase) are excluded.
- Recurring entries support day-of-month values from 1 to 28 to avoid February edge cases.
Support
For questions, bug reports, or feature requests, contact us at hello@thenapkincompany.com.
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module