Treasury & Cash Mgmt
13-month rolling cash forecast, daily cash-position snapshots and quick bank reconciliation
A focused cash management add-on that turns your Accounting data into a forward-looking liquidity view. Project cash month-by-month, capture a daily cash position automatically, and reconcile incoming bank movements against open invoices in a few clicks.
Key Features
13-Month Rolling Forecast
One click generates monthly buckets from today and the next 12 months, blending unpaid invoices, the sales/purchase pipeline and manual adjustments into expected inflows, outflows, net change and a running projected balance. Pivot and graph views included.
Sales & Purchase Pipeline
Confirmed sales orders and purchase orders that are not fully invoiced yet are added to the projection, so cash you have committed but not yet billed is included. Each source can be switched on or off per forecast.
Manual Adjustments
Add one-off expected movements that no invoice or order knows about, such as a loan drawdown, a tax payment or an owner injection, each with an expected date and inflow or outflow direction.
Forecast vs Actual
Each monthly bucket compares your expected inflow and outflow against the realised cash actually booked on liquidity accounts in that period, and shows the variance so you can track forecast accuracy.
Export to Excel
Download the full rolling forecast, including expected, actual and variance columns, as a formatted .xlsx workbook for sharing or further analysis in your spreadsheet of choice.
Daily Cash Position Snapshot
A scheduled job records total cash, accounts receivable, accounts payable and net position per company every day. Plot the history in a graph view to see how liquidity evolves.
Quick Reconcile Wizard
Enter a bank-statement amount (positive for inflows, negative for outflows), optionally a partner and a tolerance. The wizard ranks matching unpaid invoices or bills and chains into the standard Register Payment wizard.
Multi-Currency Aware
Every invoice residual, order and reconciliation match is converted to the company currency through Odoo's standard rate engine (res.currency._convert), so both forecasts and the reconcile suggestions stay correct when you bill in several currencies.
Dashboard-Ready Views
List, form, pivot and graph views on forecast buckets and on the historical snapshot model, so you can drop them straight into your own dashboards or spreadsheets.
Standard Odoo Security
Reuses account.group_account_invoice and account.group_account_manager, so the same users who already manage invoices get access without extra setup.
1. Create a forecast
Enter an opening balance, a date range and your company. The current-period totals appear immediately.
2. Generate 13 months
Hit "Generate 13-Month Forecast" to build a monthly bucket table with a running projected balance.
3. Reconcile inflows
When a bank statement lands, use Quick Reconcile to suggest the matching invoice and register the payment.
Screenshots
Cash Forecasts list with opening balance, expected inflows and outflows and projected balance
Forecast form: invoice, sales/purchase pipeline and manual adjustment inflows and outflows, with the 13-month rolling bucket table
Monthly buckets: expected inflow, outflow, net change and running balance compared against actual cash booked, with the variance
Manual adjustments: one-off expected movements such as a loan drawdown, VAT payment, owner injection or equipment purchase
Rolling forecast graph and pivot views for month-by-month trend analysis
Why Choose This Module
One click generates monthly buckets from today and the next 12 months: expected inflows from unpaid customer invoices, outflows from open vendor bills, net change and a running projected balance. Pivot and graph views included.
Specifications
- Compatible: Odoo 18.0 / 19.0
- License: OPL-1
- Languages: English
- Author: Pokutsoft
- Dependencies: account, sale, purchase
- Support: support@pokutsoft.com
Update date: 2026-07-10