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:

  1. Select Export to Excel Template (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. Accept the default separator (",") or, if commas are used in the ledger account descriptions:

    • Enter another separator.
    • Select Tab Delimited.
  4. 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:

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
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.