Language:


XBRL Reporting Elements, XBRL Reporting Settings

This page describes the two XBRL Reporting settings in the Nominal Ledger.

---

In some countries, companies need to present their official reports to the authorities in XBRL format. These reports must use an official taxonomy or structure. These two settings (XBRL Reporting Elements and XBRL Reporting Settings) allow you to map the report definitions in Standard ERP to the official taxonomy.

After configuring these settings, you can produce official reports using the following options:

  • In Estonia, use the 'XBRL Report' export function. This will create reports from every record in the XBRL Reporting Settings setting and export those reports to a single file.

  • In Finland and Germany you will usually only need to produce VAT declarations in XBRL format. Work from the VAT Declarations setting or the VAT Report to produce VAT declarations.
The two XBRL Reporting settings are described briefly below. For full details please refer to your local HansaWorld representative.

Follow these steps:

  1. Use the XBRL Reporting Elements setting to list the XML codes (taxonomy elements) that are used in the official taxonomy. Add separate records to the setting for each taxonomy element:

    Code
    Enter a unique code for each Element. You can use up to ten alphanumeric characters, and you can change the Code after saving.

    XML Element
    The XBRL taxonomy codes (tags) of each Element.

    Field Name
    If the official authority offers a web interface through which reports can be submitted, enter here the field names for each Element in that interface.

    Field Type
    Paste Special    Choices of possible entries
    Specify the type of each Element as follows:

    Monetary
    The Element should contain a calculated value or a value that is used in a report. In Estonia, every Element should be Monetary.

    Text
    The Element should contain a hard-coded text string.

    Text Formula
    The Element should contain a non-numeric value that is stored in the database or specified in a VAT Declaration record.

    Report Type
    Paste Special     Choices of possible entries
    The Report Type will determine the value that will be used as the contextRef attribute in the Element when it is included in an export file created by the 'XBRL Report' export function (used in Estonia, step 5 below). The options in the 'Paste Special' list are:

    'Paste Special' optioncontextRef attribute
    Balance SheetI_BAL
    Profit & Loss 1D_PL1
    Profit & Loss 2D_PL2
    Cash Flow 1D_CF1
    Cash Flow 2D_CF2
    VAT ReportD_VAT

    In all cases, the Code of the current Fiscal Year will be added to the contextRef as a suffix (e.g. I_BAL_2020).

  2. Use the XBRL Reporting Settings setting to map the fields listed in the XBRL Reporting Elements setting in step 1 to rows in user-defined reports (i.e. in the Balance Sheet, Profit & Loss and VAT reports). In Estonia, you should add a separate record to this setting for each user-defined report. The 'XBRL Report' export function (step 5 below) will create reports from every record in this setting and export those reports to a single file. In other countries (e.g. Finland and Germany), you should at least add a record to this setting for the VAT Report.

    Report Type
    Paste Special    Choices of possible entries
    Specify the type of report that the record represents.

    Use the matrix to list the elements in the report:

    Element
    Paste Special    XBRL Reporting Elements setting, Nominal Ledger
    Choose an XBRL Reporting Element from step 1.

    Field Name
    The Field Name of the XBRL Reporting Element will be brought in automatically.

    Field Type
    The Field Type of the XBRL Reporting Element will be brought in automatically.

    Formula
    If the Field Type is "Text Formula", the value of the report element will be calculated by a formula that you should enter in this field. The formula should be one of the following:

    CYVatNo
    Returns the VAT Reg. No. from the Company Info setting (in Finland only, returns the Reg. No. from the Company Info setting).

    ReportingPeriod
    Returns the period specified in the VAT Declaration record.

    ReportingPeriodType
    Returns "M", "Q" or "Y" depending on the duration of the period specified in the VAT Declaration record.

    ReportingPeriodTypeCode
    If the duration of the period specified in the VAT Declaration record is one month, returns the month number of the month in the period start date (e.g. returns "4" if the period begins in April).

    If the duration of the period specified in the VAT Declaration record is one quarter, returns the quarter number of the month in the period start date (e.g. returns "2" if the period begins in April, May or June).

    If the duration of the period specified in the VAT Declaration record is one year, returns blank.

    ReportingPeriodYear
    Returns the year from the start date in the period specified in the VAT Declaration record.

    User Defined Report, Report Row
    Paste Special    Choices of possible entries
    If the Field Type is "Monetary", the value of the report element will be taken from a row in the definition of a user-definable report (i.e. a Balance Sheet, Profit & Loss Report, Key Financial Ratios report or VAT Report).

    First, use the User Defined Report field to choose the report definition that the value should be taken from. Choose one of the following options from the 'Paste Special' list:

    BalRn
    Balance Sheet

    KeyRn
    Key Financial Ratios report

    ResRn
    Profit & Loss Report

    VAT2Rn
    VAT Report. You must choose "VAT2Rn" in a report that you will produce from a VAT Declaration record.

    other report name
    Any additional report definition that you may have added using the Report Settings setting (i.e. any additional Balance Sheet or Key Financial Ratios report definition).

    After specifying the report definition, use the Report Row field to specify the Id (Balance Sheet or Profit & Loss) or Code (Key Financial Ratios or VAT Report) of the row in the report definition.

    Reverse
    Paste Special    Choices of possible entries
    If the Field Type is "Monetary", use this field if you need to reverse the sign of the value of the report element (e.g. change a negative figure to positive). For example, in Estonia you should use this field to ensure that all Cost Accounts have negative balances.

    If the Report Type is Balance Sheet or Profit & Loss, the sign of the value of the report element will be subject to the specifications you have set in column 1 in the Presentation of Balances setting. If you use this field to reverse the sign, you will reverse the sign determined by the Presentation of Balances setting.

    Comment
    When you specify the User Defined Report and Report Row above, the Text or Comment from the specified report definition row will be brought in automatically. If the Field Type is "Text", this comment will become the value of the report element.

  3. In Finland and Germany, work from the VAT Declarations setting or the VAT Report to produce VAT declarations in XBRL format.

  4. In Estonia, produce an XBRL Report to check what will be included in the export file created by the 'XBRL Report' Export function. The report will contain separate sections for each record in the XBRL Reporting Settings setting.

    Period
    Paste Special    Reporting Periods setting, System module
    Specify the period to be covered by the report. This should be a fiscal year.

    Include previous Fiscal Year
    Select this option if you need figures from the previous financial year to be included to the report.

    As previously mentioned, the standard report will contain separate sections for each record in the XBRL Reporting Settings setting. If you select this option, these sections will be duplicated with the first one showing figures for the previous financial year and the second one showing figures for the specified financial year.

    Values in
    If you are using the Dual-Base system, use these options to specify whether you would like the values in the report to be expressed in Base Currency 1 or Base Currency 2.

    If you are not using the Dual-Base system, use the Base Currency 1 option to produce a report in your home Currency.

  5. In Estonia, produce an official report by running the 'XBRL Report' export function. This will create reports from every record in the XBRL Reporting Settings setting and export those reports to a single file.

    Fill in the specification window as described for the XBRL Report in step 5. Then click the [Run] button to start the export process. A dialogue box will open where you can name the export file and specify where it is to be saved. Enter a name for the file and click [Save] or press the Enter key. The export file will be created and saved. When the export finishes, you can close the 'Export' window using the close box.
---

Settings in the Nominal Ledger:

Go back to: