Processing and printing of financial statements

Printing directly from LN vs. using an external reporting tool

To be able to print financial data according to the setup in Financial Statements, LN needs to calculate the values of all statement accounts. This processing of financial data is done differently for statements used for direct printing from LN or for statements that use an external reporting tool.

To process financial data to be used by an external reporting tool, refer to Process financial data for external reporting tool.

Processing and printing of financial statements from LN

  1. From the LN menu, start the Process Financial Statement Values (tffst1249m000) session. Alternatively, you can start this session through the appropriate menu in the Financial Statements (tffst1500m000) session or the Financial Statements (tffst1600m000) session.
  2. Select the appropriate financial statement.
    • If, in the selected statement, periods were set up as Variable, you must also specify a range of years and periods.
    • To print a consolidated statement, make sure the financial statements that are linked were already processed for the same year and period.
  3. If you entered adjustment transactions for the selected financial statement and you want to take these into account, select Post Adjustment Transactions to Statement. For more information, refer to Adjustment and elimination transactions - procedure .
  4. If you linked a financial statement in the Next Statement field for the selected statement in the Financial Statements (tffst1500m000) session and you want to process that statement as well, select Process Next Statements.
  5. Select all required fields depending on your setup in the Financial Statements (tffst1500m000) session.

  6. If you set up fixed amounts in the selected statement and these values are modifiable, to update these values, click one of these buttons:

    • Acc/Column Spec
    • Column/Acc Spec
  7. Click Process.

  8. If you set up ratios in the selected financial statement, complete these additional steps:

    1. Click Select Ratio Values.
    2. In the Select Ratio Values (tffst6205m000) session, select the ratios that must be calculated, and then specify the period in which these values must be stored.
    3. Click Select.
    4. To add the calculated ratios to the financial statement values, in the Process Financial Statement Values (tffst1249m000) session, click Process again.

  9. To print the financial statement, click Print.

    The Print Financial Statement Values (tffst1450m000) session is started. For more information, refer to the next section.

To process financial data to be used by an external reporting tool, refer to Processing financial data for external reporting tool.

Printing financial statement values from LN

  1. From the LN menu, start the Print Financial Statement Values (tffst1450m000) session. Alternatively, you can start this session through the appropriate menu in the Financial Statements (tffst1500m000) session, or by using the Print button in the Process Financial Statement Values (tffst1249m000) session.
  2. Specify a range of financial statement accounts and sublevels.
  3. Select options as required.
  4. Click Print.

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.