Financial statements¶

Balance sheets, P&Ls and trial balances: documents whose credibility rests on the numbers adding up and the structure being legible.

What it produces¶

Multi-level grouped tables with subtotals at each level and a cross-footed total, formatted to accounting conventions.

Bring the ledger in through a SQL data source, or reshape it first with a data transformation
Place a Data Table and generate columns from the data
Open Grouping Settings and define up to three levels — for example account class, then account group
Enable Show Footer per level for subtotals, and set the aggregate per column
Use Caption tpl to label each group from its own data
Set number and currency defaults once in the Formatting section

Three grouping levels is the limit. Deeper hierarchies need either a pre-aggregated data source or subreports.
Aggregates are configured per column, not per table. A column with no aggregate simply renders blank in the footer, which is easy to mistake for a calculation error.
Weighted figures need a Weight Field. A plain average across rows of different sizes will not reconcile.
Use fixed table layout when columns must align across several statements in the same pack, rather than letting each table size itself to its content.