Localization Reports

Reports Available

The following reports are available:

Country Report
All countries that use the XBRL reporting standard. Trial Balance Extract for XBRL
France Balance Sheet
Income Statement
Germany E-Bilanz
Spain Balance Sheet
Income Statement

Important Considerations

When creating Localization reports there are some important considerations to be aware of.

All Countries

Data is retrieved for all companies with the same ISO country code. Use the Values field to select the company you want to see data for.

France

  • The report can include columns that do not appear in the statement generated in Financial Statements. If you export from Report Builder, ensure the columns included are appropriate for the tax regulations in your country.
  • In order to view the report correctly, with all GLAs mapped to their respective reporting categories, you must go to General Ledger Accounts in Accounting and ensure there are local balance sheet values selected for all GLAs.

Germany

If you use the eBilanz-Online tool, which requires an XLSX file format, follow the steps below:

Note: If you use alternative software, ensure you make the necessary changes required. These steps are for the eBilanz-Online tool only.
  1. Go to Report Builder and click the report name of your file.
  2. Immediately above the table click | Dimension Columns.
  3. In the Custom Label fields, ensure the dimensions are correctly translated in German.
  4. Click Save.
  5. Click | Export.
  6. In the Format field select XLSX.
  7. In the Report Details field select Data Tables Only.
  8. Deselect Add Logo Image to Exported File.
  9. Click Download.
  10. Click Save.

The XLS file is now ready to upload to your chosen E-Bilanz program. For more information, see E-Bilanz Report.

Adding Local General Ledger Accounts

When generating the E-Bilanz report, if you want to include the local general ledger accounts you can add a new dimension column to the report.

This means that if you have subsidiaries in Germany, you can benefit from this enhancement introduced in Spring 2022. Previously, this functionality was only available if you were using corporate general ledger accounts.

  1. Go to Report Builder and click the report name of your file.
  2. Above the table click Dark Lightning cog. | Dimension Columns.
  3. Click Add Columns.
  4. In the Dimension search field enter Local GLA.
  5. Click Save.

Spain

In order to view the report correctly, with all GLAs mapped to their respective reporting categories, you must go to General Ledger Accounts in Accounting and ensure there are local balance sheet values selected for all GLAs.