Using Financial Statements

ERP Cloud

Before using Financial Statements you must ensure that your administrator has granted you the following permission sets:

  • Einstein Analytics Platform Admin
  • Financial Statements Reporting

Note:

When using the Income Statement, we recommend that you organize your chart of accounts according to the best practice described in "Chart of Accounts Best Practice Structure" in the Accounting Help, to ensure your financial statements are accurate.

If you have added the Accounting Book field to your Financial Balances and Financial Transactions datasets using the configuration wizard, then by default your financial statements will only show accounting data derived from your primary accounting book. You cannot currently edit the Multi-Book filter selection.

Creating a New Financial Statement

  1. Go to the Financial Statements app.
  2. Click New.
  3. Select the type of financial statement you want to create. Available options are Income Statement and Trial Balance.
  4. Enter a name for your financial statement.
  5. [Optional] Enter a description.
  6. Click Save. Your new financial statement opens. You can now configure your financial statement.

Configuring your New Financial Statement

You can configure the rows and columns displayed by default in your financial statement, depending on what type of financial statement you select:

Financial Statement Configuration Options

Financial Statement

Financial Statement Type

Editable
Income Statement Period and YTD
 Rows
Dimensional Rows, Columns
Multi-company Rows, Columns
Trial Balance Period Open and Close N/A
Dimensional Columns
Multi-company Columns

To edit the rows or columns in your selected statement:

  1. Click Select to select the financial statement type you want to configure.
  2. Click | Edit Row or Edit Column, depending on your financial statement type.
  3. [Edit Row] Select the reporting field you want to map to your selected section using the drop-down menu. The display name for your row is non-editable. Available values are: Trial Balance 1, Trial Balance 2, Trial Balance 3, Trial Balance 4, GLA Name, GLA Type.
  4. Select the values you want to populate your selected row section. Available values reflect the Chart of Accounts your reporting values are derived from.
  5. [Edit Column] select the columns you want to display in your financial statement from the dueling picklist. If you have selected a multi-company financial statement, you can choose to display a Grand Total column.
    In order to display data in your selected company columns, you must also select the appropriate company filters.
    Note: For example, if you select Company X as a column in your multi-company statement, you must also select Company X as a filter option in your statement, in order to display data relating to this company.
  6. Click Done.

Depending on your selection, the default summary view for your financial statement contains the following columns. To display different columns in your financial statement, or add dimensions see Configuring your New Financial Statement.

  • Income Statement: Section, Trial Balance 3, General Ledger Account, Period, YTD to Period.
  • Trial Balance: General Ledger Account, Period Open, Period Debits, Period Credits, Period Net, Period Close.
  1. [Optional] To add filters click (Company, Currency Type, Year, Period From, Period To, Adjustment Period, GLA, Dimension). You can select all GLAs, search for GLA using "Begins with", or use "Select" to select a GLA from a picklist.
  2. [Optional, Income Statement only] To configure the rows displayed by default, click Edit Row, and map your own data to the available groupings of Sales Revenue, Cost of Sales and Operating Expenses. See Using Financial Statements for more information.
  3. [Optional] Click Export CSV. To view this CSV file in Excel see Viewing a Financial Statement in Excel.
  4. [Optional] Click Save to save the filter and configuration selections for your financial statement.

Using Filters in Financial Statements

You can only apply filter selections to the Summary tab in the Trial Balance and Income Statement.

[Income Statement only] You can filter by multiple period ranges. For example, selecting the period range "003" to "005" in the filter panel would display data for "Period 003 to 005" in the Period column. The YTD column would display data for periods 001 to 005.

You can select multiple companies using the Company filter. The item selected is shown underneath the selection control. Click on the company to remove it from your selection.

By default, the Company filter selects the first alphabetically-listed company from the list of available companies. You cannot delete all selected companies from the Company filter; a single company is always retained.

You can select multiple GLAs using the GLA filter. Until you select GLAs for your financial statement, GLAs for the first alphabetically-listed company from the list of available companies are displayed.

To select GLAs:

  1. Click Select. Available options are All GLAs, Begins with and Select.
  2. Click Select GLAs to specify the GLAs required for your financial statement. The item selected is shown underneath the selection control. Only GLAs that contain data are displayed as available for selection.
  3. Click on the GLA to remove it from your selection. You cannot delete all selected GLAs from the GLAs filter; a single GLA is always retained.
  4. Click Apply to confirm your selections. The number of GLAs selected is displayed below the GLAs filter in the filter panel.

You can select multiple dimensions using the Dimension filter:

  1. Click Select Dimension.
  2. Select the dimensions you require for your financial statement. The item selected is shown underneath the selection control.
  3. Click on the dimension to remove it from your selection.
  4. Click Apply to confirm your selections. The number of dimensions selected is displayed below the Dimension filter in the filter panel.
Note:

The total number of selected dimensions is displayed in the supertitle of your financial statement and is highlighted in blue. To view the names of your selected dimensions, hover over the total number. For example '10 Dimensions Selected'.

Viewing an Existing Financial Statement:

  1. Navigate to the Financial Statements app.
  2. Click the financial statement name you want to view. Financial Statements data is displayed in Summary and Detail tabs. The Summary tab displays the general ledger accounts selected for your financial statement with your filter selections applied.
    • To see whether a cell can be drilled, hover over it. You can drill into a cell if it is highlighted in blue.
    • Rows on the Income Statement are color-coded. This enables you to distinguish between the different sections and their totals and subtotals when scanning through the statement.
    • Subtotals for the subsections displayed in the Section column in the Income Statement are displayed in the Trial Balance 3 column.
    • You can drill from an available cell by double or single-clicking it. If you double-click, the Detail tab opens and displays your selected values. If you single-click and navigate to the Detail tab, then your selected values are displayed.
    • Trial Balance: Cells displayed under the Debits, Credits and Net columns are available to drill. If you have added columns with multiple dimensions to your financial statement, these are also available to drill. You cannot drill cells displayed under the Open and Close columns. If you double-click a cell and view your selected values in the Detail tab, the cell you have clicked remains highlighted in the Summary tab. The cell remains highlighted until you select another cell or change your filter selections.
    • Income Statement: Cells displayed under the Period and YTD column are available to drill. If you have added columns with multiple dimensions to your financial statement, these are also available to drill.
    • Clicking on cells displayed under Document Number in the Detail tab enables you to drill through to view details of individual documents. Clicking your selected document opens as a sub-tab in your current tab. If you want to view your selected document in a separate tab:
      1. Click the Arrow on your sub-tab.
      2. Select "Set As Workspace Tab".
    • If you select a single company, your currency type defaults to Home. If you then drill to a selected cell, Home and Dual columns are shown in the Detail tab.
    • If you select multiple companies, your currency type defaults to Dual. If you then drill to a selected cell, only the Dual column is shown in the Detail tab.
  3. [Optional] To order a column, hover over the column header and click . In the Trial Balance, you can order columns displayed in the Summary and Detail tabs. In the Income Statement, you can only order columns displayed in the Details tab.
  4. [Optional] Click Export CSV.
    Note: From Spring 2020 you can export the data displayed in the Detail tab, in addition to the Summary tab. To view your CSV file in Excel see Viewing a Financial Statement in Excel.