Creating the Excel File


Excel Column	Description
Hide Row	If you want to retrieve or calculate data, but you do not want to display the intermediate results on the report, enter Yes in the Hide Row column.
Print Total After Detail	The default print layout on a report displays the balances of an analysis code at the point where the code is entered in the hierarchy. This means that, by default, the subtotals are displayed at the beginning of a detail group. If you want the total to appear at the end of the detail group rather than at the beginning, in the Print Total After Detail column, enter Yes. If you apply this option to the highest level node (Level 1), the opening node is automatically hidden. If you apply this option to other nodes, the beginning node displays the code and description, but no total amounts.
Invert Sign of Activity	On the report, some columns display balances and other columns display activity for the selected period. When activity is displayed as Debit (ActivityDR) or as Credit (ActivityCR) separately, the amount is always positive. When the total activity is printed (DR and CR together), the system calculates DR - CR. The system represents the value as a positive amount when the result is debit or as a negative amount when the result is credit. If you want to represent the activity with an inverted sign (positive becomes negative and negative becomes positive), enter Yes in this Excel column. The sign is inverted before calculations are performed and the subtotals are summed.
Invert Sign of Balance	On the report, some columns display balances and other columns display activity for the selected period. Balances (opening balances or closing balances) appear as positive when they have a debit sign and negative when they have a credit sign. On some reports, you may want to represent some balances with the inverted sign. This situation occurs frequently on income statement reports, where sales are credited and expense is debited, but you want to represent the sales as positive amounts and the expenses as negative amounts. To invert the balance sign, enter Yes in this Excel column. The inverted sign is applied before calculations take place and the column is filled.
Insert Blank Row Before	To insert a blank line on the report at the start of a new section to aid visibility, enter Yes in this Excel column. The blank line appears just before the node where you set the value to Yes.
Insert Blank Row After	To insert a blank line on the report under header text or at the end of a section to make the report more readable, enter Yes in this Excel column. The blank line appears just after the node where you set the value to Yes.
Row Style	In this column, you can format a report with bold, underlined, and highlighted text. The three keywords are bold, line, and high. Simply include the keywords you want, each separated by a comma. For example, to format a report as bold and highlighted, enter bold high in this column. This field is also available in Report Tree Maintenance.
Taxonomy	There are multiple XBRL taxonomies, including IFRS XBRL and US GAAP XBRL, each with their own specific structures and element naming conventions. Use this field to store the taxonomy to which the report analysis code belongs.
ELR	Each taxonomy can have several subdivisions, each targeting a sub-area in the reporting with its own relational structure, label structure, and so on. These subdivisions are referred to as ELRs. At its most granular level, an ELR can relate to just one report. Use this field to specify the ELR code that identifies the report structure in the taxonomy.
XBRL Element	The XML element name (tag) used in the XBRL taxonomy. For example, each balance row in the IFRS XBRL taxonomy has a unique XBRL element name as an identifier (for example, AssetsAbstract).
Comment	For report analysis codes of type T, you can enter a large amount of comment text in this field. The comment text is then printed on the report.
Show Details	Enter Yes for any leaf node for which you want to print GL transactions in detail on a report. For this option to take effect, you must choose the Selected value in the Print GL Transactions field in Report Master Create. When running the report in Financial Report Run, you must also set the Print Details report selection criteria to Yes.