Summarizing Data Using a Reporting Filter Mapping
There is a particular property of rows 91 to 99 that allows you to create a detailed report with some rows being presented as a summary.
Some of the balance sheet templates contain an example of this. See the standard Balance Sheet Detailed report (TFA030RBAF1021DGL) where Historical Profit Not Brought Forward and Current Year Profit and Loss are both summarized whereas the values in the remaining rows are listed in detail by general ledger account.
Reporting Filter Mapping | Type/Template Key | Reporting Filter |
---|---|---|
Historical Profit Not Brought Forward | ROWS91 | RBA Non-Retained Earnings (P&L Previous Years) GLA (reporting balances for income statement general ledger accounts up to period 000 of the current year) |
Current Year Profit and Loss | ROWS92 | RBA Profit & Loss (From Current Year) GLA (reporting balances for income statement general ledger accounts from period 001 of the current year onwards) |