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.

    As a result, 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.

 

Financial Statement
An account structure that can consist of child statement accounts and parent statement accounts. At the child level, the statement accounts are linked to ledger accounts and dimensions. With a financial statement, you can collect the desired financial values from the General Ledger and Budgeting modules, and use this data for internal and external financial reporting and analysis.
Selection Range
Statement Account
The account number.
Sublevel
A number that indicates the level of a ledger account or a dimension in the hierarchical structure of accounts and dimensions. A low number corresponds with a low sublevel. Ledger accounts can have sublevels 0 through 99. Dimensions can have levels 0 through 9.

Transactions can only be posted to accounts and dimensions which have a sublevel zero. All amounts and quantities on the sublevels 1 and higher are aggregated from lower sublevels.

Export
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.
Options
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.
Sorted by
Select the sort order as required.
Text Handling
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.
Handling Zero Amounts
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.

 

Show Template
Opens the XBRLFST.xlsm spreadsheet.