| # Print Trial Balance for External Reporting (tfgld3412m000) Use this session to print a trial balance report. You can also use this session to export a trial balance to an Excel template that includes XBRL. To export a report to an Excel template (including XBRL) After you have defined the range and have selected options as required: Select Export to Excel Template (XBRL). 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. Accept the default separator (",") or, if commas are used in the ledger account descriptions: Enter another separator. Select Tab Delimited. Click Print. The XBRLTB.xlsm spreadsheet opens with its Dynamic Data tab filled with the reporting data imported from LN. The Messages tab allows you to translate the messages into the required language. Selection Current Company If this check box is selected, LN Reporting Currency Group In an environment with multiple financial companies, a code that defines the common home currency to be used in reporting and viewing data for those companies that are linked to that code. Financial Company A company that is used for posting financial data in Financials. You can link one or more enterprise units from multiple logistic companies to one financial company. Home Currency One of a company's base currencies in which LN registers and reports amounts. In a multicurrency system, up to three home currencies can be defined: The local currency Two reporting currencies Year/Period A separate period, or year for financial purposes. Three financial period types exist: Fiscal, in which all transactions are recorded (for example, 12 months). Reporting, for management requirements (for example, 52 weeks). Tax, for tax regulations (for example, 4 quarters). Period Type Period Type Fiscal Period Fiscal Period Ledger Account A register used to record financial transactions and to accumulate the values of the transactions for reporting and analysis. The ledger accounts classify the transactions into categories such as revenues, expenses, assets, and liabilities. 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. Account Type Select the appropriate account type. Allowed values Fiscal Reporting Accounting Scheme A scheme of accounts to which the results of certain events are posted. The accounting scheme consists of ledger accounts, structured in a parent-child hierarchy. Options Print Selection Values in Annexure If this check box is selected, the selection data is included in an annexure. Include Opening Balance If this check box is selected, the opening balance is included in the report. Print Legal Ledger Account If this check box is selected, LN only prints the legal ledger accounts, which are defined in the Chart of Accounts (tfgld0508m000) session. Include Statutory Balance If this check box is selected, LN prints the statutory balance. Include Zero Balances If this check box is selected, the report includes lines of which the balance is equal to zero. For example, the balance of a line is zero if the invoice amount is less than or equal to the credit note amount. Use Ledger Account Print Sequence Number If this check box is selected, LN prints the ledger accounts according to order of the print sequence number you define in the Chart of Accounts (tfgld0508m000) session. Export Export to Excel Template (XBRL) Select this check box if you want to export a trial balance report to Excel, using an XBRL template. Open in Spreadsheet The name and location of the spreadsheet file. Default value C:\Users\user_name\Documents\Print Trial Balance\XBRLTB.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. Show Template Opens the XBRLTB.xlsm spreadsheet. |