Variance Bridge & Waterfall Analytics
Budget-to-actual variance bridge: volume/price/mix split and P&L waterfall chart
Variance Bridge & Waterfall Analytics explains why a total moved, not just that it moved. It turns a budget-vs-actual or period-vs-period comparison into a fully-reconciled waterfall bridge that walks from a starting number to an ending number through named, quantified steps, with the underlying maths as an independently unit-tested Python engine.
Key Features
Volume / Price / Mix decomposition
The Volume/Price/Mix breakdown mode splits every unit of revenue variance into three drivers, Volume (units sold changed), Price (unit price changed) and Mix (product basket shifted), computed straight from posted journal items or a manually entered budget.
New and discontinued product handling
Products with no baseline (new) or no actual (discontinued) are detected automatically and their whole contribution is booked as pure volume, so they never distort the price/mix numbers of continuing products.
Guaranteed tie-out with rounding step
verify_waterfall_ties checks that the Volume, Price and Mix steps always sum back to the exact total variance, with any floating-point residue captured in its own Rounding / Other step.
Optional per-product detail
The detail_by_product toggle switches from one aggregate bar per driver to one waterfall bar per product for every driver that actually moved it.
P&L / revenue bridge by account
Switching to the P&L / Revenue Bridge breakdown mode builds a classic starting revenue to ending revenue waterfall where every revenue/expense account that moved becomes its own step, sorted by the size of its swing, with the smallest movers rolled into a configurable Top Movers cutoff and an Other step.
Period-vs-period or budget-vs-actual source
A bridge compares either two ranges of posted account.move.line entries (period vs period) or a set of hand-entered variance.bridge.budget.line records against one period of actuals (budget vs actual).
Ordered waterfall steps with running total
Every computed bridge materialises into variance.bridge.step records, Starting Value through the driver steps to Ending Value, each carrying a running cumulative total ready for a bar/pivot chart.
One-click compute and drill to graph/pivot
action_compute rebuilds the bridge and posts a chatter summary; action_view_steps opens the steps in a list/graph/pivot view for one-click drill-down and charting.
Use Cases
Screenshots
01 Bridge List
02 Bridge Form Computed
Why Choose This Module
Because the decomposition, aggregation and tie-out verification all live in a framework-free, independently unit-tested Python engine, the three-way variance split and the P&L bridge numbers are guaranteed to reconcile rather than approximate, and every waterfall step is a real, queryable Odoo record ready to chart, filter or pivot.
Specifications
- Compatible: Odoo 18.0 / 19.0
- License: OPL-1
- Languages: 35+
- Author: Pokutsoft
- Dependencies: account
- Support: odoo@gencbaris.com
- Update date: 2026-07-13
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 792 |
| Technical Name |
variance_bridge_waterfall_analytics |
| License | OPL-1 |
| Website | https://pokutsoft.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