Creating Consolidation Journal Reports
You can create Consolidation Journal reports to view journal activity that has occurred in the system, check the status of journals and review journal adjustments. You can select the POV, row, column, subtotal display options, and report format type.
Selecting Columns for the Report
When you select to display the Currency column on a Journal report, the system displays the name of the currency for which the journal is created. For example, if the journal is created against the Entity Currency, it will display as Entity Currency (USD), where USD is the currency of the selected entity. If the journal is created against a Parent Currency, it will display as Parent Currency (EUR), where EUR is the currency of the parent entity.
If an application has been enabled for Unbalanced Journals, the Variance column will be displayed. This amount will only populate when an entire journal is selected for the report and displays only on the total line for the journal. If the Variance column is enabled, it will be displayed for all journals, whether they are Balanced or Unbalanced.
You can include group by subtotals for the columns that you selected. The subtotal is based on the columns that you selected in the Column Displayed list. When you select items for the subtotal, they will be displayed in the order of selection. For example, if you select Label, then Account for Subtotal, Journal Label will be the first level subtotal, Account will be the second level subtotal, then the remaining columns that you selected will be displayed. A maximum of eight levels of subtotal is allowed.After you select the columns that you want to display on the report, you can re-order the columns so that the report will display the columns in the order you specify. The column selection is saved, so if you want to create another report, the system displays your last saved column selection and you do not need to re-select columns.
When you select members for the report from the Member Selector, you can select individual members, or directly select the Level 0 Descendants of a parent member. For example, for Entity, you could select the Level 0 Descendants of the Total Geography parent member, without needing to select all the entities for that parent. You can select Level 0 Descendant members for the Account, Entity, Movement, Intercompany, Multi-GAAP, and Custom dimensions.
Security Rights for Reports
If you are a Service Administrator, you can create a journal report, run a report created by any user, and update or delete reports.
If you are a User or Power User, you can create a journal report, run a report created by any user, and update or delete reports that you created.
If you have the Viewer role, you can view Posted journals and run a journal report on journals with a Posted status.
To run a journal report, users must have security rights to the data for the report. If you do not have access to any of one or more column members of a journal row, then the journal row amounts and totals are displayed as asterisks (*).
Report Format Types
For the report format type, you can select HTML, PDF or XLSX.
When you run the report and save it as an Excel report type, you can use
a Substitution Variable to automatically display the values in number format, rather
than cell text. The substitution value is called
EnableExcelNumberFormat
, and when the value is set to True,
when you save the report as an Excel report type, the values are automatically
displayed in numeric values.
Watch this video to learn more about creating Consolidation Journal reports.
To create a Consolidation Journal report: