| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 862 |
| Technical Name |
aos_cash_forecast |
| License | OPL-1 |
| Website | http://www.alphasoft.co.id |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 862 |
| Technical Name |
aos_cash_forecast |
| License | OPL-1 |
| Website | http://www.alphasoft.co.id |
13-Week Cash Flow Forecast
Rolling 13-week cash projection for Odoo 18 Community.
Auto-populate from open AR + AP, add manual entries, run
multi-scenario, compare to actual as weeks elapse.
The #1 ask from finance directors. Finally a real tool.
Weeks rolling window —
start any date you choose
Line types —
AR / AP / salary / tax / rent…
Scenarios —
Base / Best / Worst
Forecasts, scenarios —
flat license
Three-step workflow
Step 1 Create forecast
Set the start date, opening cash balance, and scenario (Base / Best / Worst). End date auto-fills 91 days out.
- Multi-scenario support
- Per-company forecasts
- Status workflow (draft → confirmed → closed)
Step 2 Populate & refine
One click pulls every open invoice & bill into the right week. Add manual entries for salary, rent, taxes, capex.
- Auto-populate from open AR (collection by due date)
- Auto-populate from open AP (payment by due date)
- Manual entries: salary, tax, rent, loan, capex, other
- Overdue cushion (configurable)
Step 3 Track variance
As each week elapses, the line tracks actual cash movement on the source invoice / bill and shows the variance.
- Auto-compute actual from
amount_residual - Per-line variance (Actual − Forecast)
- Week-elapsed flag for quick filtering
- PDF export with weekly grid
The weekly summary, live
Every change to a forecast line updates the 13-week summary instantly. Cash in, cash out, net, running balance per week — rendered as an HTML widget directly in the form view.
| Week | Range | Cash In | Cash Out | Net | Running |
|---|---|---|---|---|---|
| W1 | 01 Jan → 07 Jan | $48,000 | -$22,000 | $26,000 | $446,000 |
| W2 | 08 Jan → 14 Jan | $62,000 | -$18,000 | $44,000 | $490,000 |
| W3 | 15 Jan → 21 Jan | $28,000 | -$54,000 | -$26,000 | $464,000 |
| … weeks 4–13 continue here … | |||||
Why finance directors ask for this
The problem
Every CFO and finance director wants to know: what will my cash position look like in 13 weeks? The accounting team can pull AR aging, AP aging, and bank balance. Reconciling those into a single forward-looking projection is a weekly Excel ritual.
Community edition gives you the source data but no tool to synthesize the forecast. Enterprise's cash flow tools are limited and locked behind the license.
The fix
One screen, one PDF, two SQL queries (AR + AP), a couple of clicks. Update once, share with leadership. Repeat next week as positions shift.
Manual lines for everything not in Odoo (salary cycle, rent due date, tax deadline). Multi-scenario lets you model best / base / worst cases without touching Excel.
Frequently asked
Does it need Enterprise?
No. Odoo 18 Community + the standard account module.
How are weeks bucketed?
From date_start + 7-day increments. W1 = day 0-6, W2 = day 7-13, etc., up to W13. AR/AP populate uses invoice_date_due to assign each invoice to a week.
How does the auto-population handle overdue invoices?
The wizard has a min_overdue_days setting (default -7) that says how far in the past to start scanning. Overdue invoices land in W1 by default.
Can I model multiple scenarios?
Yes — create three forecasts (Base, Best, Worst) for the same period. Compare them side-by-side in the list view.
What's the actual computation?
For AR/AP-linked lines: actual = abs(forecast_amount) - abs(source_move.amount_residual). As the invoice gets paid, residual drops, actual rises. Manual lines have no auto-actual (manual update only).
Source code included?
Yes — OPL-1, full source. Customize freely.
Installation — 2 minutes
- Purchase & download the module.
- Extract into your Odoo addons path.
- Open Apps → Update Apps List.
- Search 13-Week Cash Forecast → Install.
- Navigate to Accounting → Cash Management → 13-Week Cash Forecast.
- Create a forecast, set the start date + opening balance, click Populate from AR / AP.
Dependencies: account (Community).
Pricing
13-Week Cash Forecast
USD 249
one-time license · all features
- ✓ 13-week rolling forecast
- ✓ Auto-populate from AR + AP
- ✓ Manual entries (10 line types)
- ✓ Multi-scenario (Base / Best / Worst)
- ✓ Variance vs actual (auto-tracked)
- ✓ PDF report
- ✓ Source code (OPL-1)
Cash Forecast + Budget + Reports
Ask for bundle quote
combined invoice · combined support
- ✓ 13-Week Cash Forecast (this module)
- ✓ Budget vs Actual
- ✓ Financial Reports + Dashboard
- ✓ Email info@alphasoft.co.id
Need help?
We respond within 1 business day.
- info@alphasoft.co.id
- www.alphasoft.co.id
Part of the Alphasoft Apps Store finance suite — Financial Reports, Financial Dashboard, Budget vs Actual, and now 13-Week Cash Forecast.
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