Exporting financial statement values

Exporting financial statement values

You can also use the Print Financial Statement Values (tffst1450m000) session to export financial statement values to a CSV file or to an Excel template that includes XBRL.

To export statement values to a CSV file

After you have defined the range and have selected options as required:

  1. Under Export, select CSV file.

  2. Accept the default separator (",") or, if commas are used in the ledger account descriptions:

    • Enter another separator.
    • Select Tab Delimited.

  3. Click Print.

    The XBRFSTTB.xlsm spreadsheet opens with the statement values imported from LN.

To export statement values to an Excel template (including XBRL)

After you have defined the range and have selected options as required:

  1. Under Export, select Excel template (including XBRL).
  2. Click Show Template.

    Next, LN:

    • Copies the XBRL template of the additional files to your computer.
    • Defaults the name and location in the Open in Spreadsheet field.
    • Opens the Excel spreadsheet, so you can already maintain the XBRL mapping.
  3. Save and close the spreadsheet.

  4. Accept the default separator (",") or, if commas are used in the ledger account descriptions:

    • Enter another separator.
    • Select Tab Delimited.

  5. Click Print.

    The XBRLFST.xlsm spreadsheet opens with its Dynamic Data tab filled with the statement values imported from LN.

    The Messages tab allows you to translate the messages into the required language.