1. Working with Financial Consolidation and Close
  2. Working with Reports
  3. Creating Consolidation Journal Reports

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.

video iconCreating Consolidation Journal Reports

To create a Consolidation Journal report:

  1. On the Home page, click Reports.
  2. Click Consolidation Journal Reports.
  3. Click Create.
  4. From the Point of View, select the Scenario, Year, Period, Consolidation, and View members for the report.

    For Period, you can select one or more periods from the same year, or across years. If you select multiple year and period combinations, the system will generate the report for the combination that you selected. For example, if you select FY19, FY20, and Jan / Feb / Mar, the system will produce a report for FY19 Jan, FY19 Feb, FY19 Mar, FY20 Jan, FY20 Feb, FY20 Mar.

    For View, you can select FCCS_Periodic or FCCS_YTD_Input.

    The dimension members that you select will be displayed in the header section of the generated report.

    Tip:

    The Dimension names (Consolidation, and so on) are displayed by default. To hide the Dimension names and display only the members, click the Actions icon Actions icon and then select Hide Dimension Name.

  5. From Row Filter Options, select options:

    • Entity - enter an entity name, or click the Member Selector and select an entity.

    • Description - enter text to filter by description. You can use an asterisk (*) as a wildcard.

    • Account - enter an account name or click the Member Selector and select an account.

    • Label - enter text to filter by label. You can use an asterisk (*) as a wildcard.

    • Group - select a journal group, or select All.

    • Status - select one or more options: Working, Submitted, Approved, Posted, or select All.

    • Journal Type - select one or more options: Regular, Auto Reversing, Auto Reversal, or select All

    • Movement - enter a member name, or click the Member Selector and select a member.

    • Data Source - select a member.

    • Currency - select a currency.

    • Intercompany, Multi-GAAP and Custom - enter a member name, or click the Member Selector and select a member.

      Note:

      Intercompany, Multi-GAAP, and Custom are only displayed if they are enabled for the application.

    • Balance Type - select Balanced, Unbalanced, or select All. Balance Type is only available if the Unbalanced Journals application option is enabled.

  6. For Column Display Options, from the Available list, select the columns that you want to display and use the arrow keys to move them to the Selected list.
  7. To specify the order in which the columns will display, use the Up and Down arrow keys to re-order the columns as needed.
  8. The Subtotal box automatically displays the items that you selected for the Column Display. You can select items to display in the Subtotal, and the order will be based on the order in which you select the items. All remaining columns that you selected (without subtotal) will be displayed after the columns with Subtotal.
  9. From Report Type, select an option:

    • HTML

    • PDF

    • XLSX

  10. To save the report definition, click Save, enter a label and description, and then click Submit.
  11. To run the report, click Run Report and then select to open or save the report.