Print Financial Statement Values (tffst1450m000)

Use this session to print financial statement values.

You can also use this 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.

Field Information

Financial Statement

financial statement

Statement Account

The account number.

Sublevel

sublevel

Show Template

To export financial statement values, select the appropriate option:

  • CSV file
  • Excel template (including XBRL)
Open in Spreadsheet

The name and location of the spreadsheet file.

Default value

C:\Users\user_name\Documents\XBRLFST.xlsm

Separator

The separator to be used.

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

  • Enter another separator.
  • Select Tab Delimited.

Default value

","

Tab Delimited

If selected, tabs will be used as separators.

Print Next Statement Automatically

If this check box is selected, LN prints the statement defined in the Next Statement field of the current statement.

Print Annexure Automatically

If this check box is selected, LN prints annexures.

Recalculate Statement Accounts

If this check box is selected, LN recalculates statement accounts before printing.

Variable Text for Header/Footer

Enter text to be printed at the top and the bottom of each page.

Select the sort order as required.

Print Text of Text Accounts

If this check box is selected, LN prints text linked to accounts of type Text.

Print Text of Other Accounts

If this check box is selected, LN prints text linked to accounts of types other than Text.

Show zero amounts of accounts of sublevel zero

If this check box is selected, LN prints zero amounts of accounts of sublevel zero.

Show zero amounts of parent accounts

If this check box is selected, LN prints zero amounts of parent accounts.

Show zero amounts individually

If this check box is selected, LN prints zero amounts individually.