| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 934 |
| Technical Name |
gb_financial_report_builder |
| License | LGPL-3 |
| Website | https://gencbaris.com/odoo_plugins/ |
| Versions | 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 934 |
| Technical Name |
gb_financial_report_builder |
| License | LGPL-3 |
| Website | https://gencbaris.com/odoo_plugins/ |
| Versions | 18.0 19.0 |
Financial Report Builder (MIS-style)
Design polished P&L, Balance Sheet and KPI reports with drill-down, comparison, budget & variance — on Community
Build management reports that tie back to the ledger without fighting account gating or wrestling with unfriendly tools. Define report templates from rows that pull balances by account-code prefix, account type, account selection or arithmetic formula — add KPI rows, comparison periods, budgets and variance columns, then drill straight into the journal items. Ships with UK FRS-102 starter templates for P&L by nature and the Statement of Financial Position.
Key Features
Flexible Report Rows
Each row pulls balances by account-code prefix, account type, specific accounts, or an arithmetic formula referencing other rows by code — with sign control, indentation level, bold and total styling.
KPI & Ratio Rows
Compute ratios, percentages and metrics (gross margin %, current ratio and more) from other rows, displayed as proper percentage or computed KPI lines.
Period & Comparison
Run any template over a date range with an optional comparison period, generating variance and variance-% columns automatically — against posted or, optionally, draft journal items.
Budgets & Variance
Attach a budget per template and period; the report shows budgeted amount and budget variance line by line, so actuals-vs-budget reporting comes built in.
Drill-Down to Ledger
Every account-based line exposes the underlying account move lines — one click takes you from the report figure to the transactions behind it.
Excel Export & FRS-102
Export the rendered report to XLSX with indentation, bold totals and KPI rows preserved, and start from FRS-102 P&L and Statement of Financial Position templates.
How It Works
- Build a template — or start from an FRS-102 starter layout.
- Define rows — account prefixes, types, formulas, KPIs and totals.
- Run a period — with optional comparison and a budget.
- Review — variance columns, KPI rows and drill-down to the ledger.
- Export — a styled Excel workbook for stakeholders.
Why This Module
- Polished MIS-style reporting with a friendly builder UI.
- Figures always tie back to posted journal items.
- Comparison, budget and variance built in — not bolted on.
- UK FRS-102 starter templates out of the box.
Who It's For
- Finance managers and controllers building monthly packs.
- Accountants preparing FRS-102 management accounts.
- SMEs needing actuals-vs-budget reporting on Community.
- Anyone who wants drill-down from report to ledger.
Screenshots
Generated financial reports
P&L / balance sheet report with KPI rows and drill-down
Report templates library
Drag-and-drop report template builder
Compatibility: Odoo 18.0 & 19.0 · Community & Enterprise
Support: support@gencbaris.com · https://gencbaris.com/odoo_plugins/
Please log in to comment on this module