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.

Field Information

Selection
Current Company

If this check box is selected, LN

Reporting Currency Group

reporting currency group

Financial Company

financial company

Home Currency

home currency

Year/Period

fiscal year

Period Type
Fiscal
Reporting
Tax
Fiscal Period
The fiscal period to which the transaction applies.
Ledger Account

ledger account

Ledger Mask

The ledger mask. The data is filtered based on the mask.

Note: 

The rules based on which the data is filtered:

  • “*” equals 0 or more consecutive characters.
  • “?” equals exactly one character.

Example If you want to print the data based on a ledger account code that starts with 1 and ends with numbers from 10 to 19, you must specify the mask as 1*1?.

Sublevel

sublevel

Account Type

Select the appropriate account type.

Allowed values

  • Fiscal
  • Reporting
Accounting Scheme

accounting scheme

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.