Financial Report Builder
MIS-style P&L / Balance Sheet / Cashflow builder with KPI rows, drill-down and Excel export (UK FRS-102 ready)
Odoo's standard accounting reports are hard to reshape into the management P&L, balance sheet or KPI pack a finance team actually presents, and exporting them to a board-ready spreadsheet means hours of manual rework. This Financial Report Builder lets you design report templates from rows that pull balances by account-code prefix, account type, specific accounts, or an arithmetic formula over other rows, then add KPI ratios, comparison periods, budgets and variance columns. Every account-based line ties straight back to account.move.line and drills down to the journal items behind the figure, so numbers are always defensible. Run any template over a date range, compare to the previous period or prior year, and export a styled XLSX. UK FRS-102 starter templates get you productive on day one, removing the spreadsheet rework that consumes month-end.
Key Features
Row-based report templates
A gb.frb.template holds ordered gb.frb.row lines of four types: header sections, account balances, formulas and KPI ratios. Each row carries a unique code, indent level and bold/total styling, so you design a P&L, balance sheet or cash-flow layout once and reuse it every period.
Flexible account selection per row
An account-balance row sources figures via _build_account_domain by comma-separated code prefixes (e.g. '40,41,42'), by Odoo account_type, or by a hand-picked set of account.account records. A sign control flips credit-positive lines so income and equity read naturally.
Formula and KPI rows
Formula and KPI rows evaluate arithmetic over other row codes (e.g. 'REV - COGS' or 'GP / REV') through a sandboxed _eval_formula with no builtins and graceful divide-by-zero handling. Compute gross margin %, current ratio and other metrics that reference subtotals defined above.
Ledger-tied balance engine
_balance_for_accounts reads account.move.line with a _read_group balance sum over the period, honouring company and a posted-only or all-entries target_move. Figures always reconcile to the general ledger rather than to a cached snapshot.
Comparison periods and variance
The run wizard offers previous-period, same-period-last-year or custom comparison dates and auto-fills them. Each gb.frb.report.line then computes variance and variance_pct against the comparison column so period-over-period movement is visible at a glance.
Budget vs actual
Attach a gb.frb.budget whose action_generate_lines seeds a line per non-header row code; get_budget_map feeds budgeted amounts into the report. Every line then shows budget and a stored budget_variance for actuals-versus-plan reporting out of the box.
One-click drill-down to journal items
action_drill_down on any account-based report line reopens account.move.line for exactly that row's accounts and period, grouped by account. You move from a summary figure to the underlying transactions without rebuilding the filter by hand.
Styled Excel export and FRS-102 starters
action_export_xlsx renders the computed report to XLSX with indentation, bold totals, percentage formatting and a variance column preserved. UK FRS-102 starter templates for a P&L by nature and a Statement of Financial Position ship as data so you are productive immediately.
Use Cases
Screenshots
Budgets
Reports
Run Report
Report Templates
Why Choose This Module
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.
Specifications
- Compatible: Odoo 18.0 / 19.0
- License: OPL-1
- Languages: English
- Author: Pokutsoft
- Dependencies: account
- Support: support@pokutsoft.com
Update date: 2026-07-02