Show TOC

Object documentationFinancial Report Templates Window Locate this document in the navigation structure

 

Use this window to create or edit Financial Report Templates.

To open the window, choose   Financials   Financial Report Templates  .

Financial Report Templates Window
Template Details

  • Report – Specify whether to create the template for a balance sheet statement, a profit and loss statement, a trial balance statement, a cash flow report, or an Asset History Sheet.

  • Template – Specify whether to use an existing template or to define a new one.

For Germany and Austria, default templates are available for the Asset History Sheet. But default Asset History Sheet templates are not available for companies created with user-defined chart of accounts.
Show Missing Accounts

Displays accounts that are not included in the template.
G/L Account Details

Name and foreign name of the selected account.

Note Note

You can change the name and foreign name of the account for display in the report.

End of the note.
G/L Account Location

Current parent article and account location in the tree.

Note Note

You can change the location of the account.

End of the note.
Group Data

  • For Balance Sheet: Select whether to group the data from the Active side or the Passive side.

  • For Profit and Loss: Subtotal displays subtotals in the report. Select the account under which you want to locate the subtotal, select Subtotal and specify its title in the field on the right.

    • Totals Formula calculates the subtotals from a formula you specify using the Formula option on the right.

    • Automatic Summary calculates the default subtotals.

  • For FA historic report: Subtotal displays subtotals in asset history sheet reports. Automatic Summary calculates the subtotals.
Add Child Acct

Enables you to create an account on a level lower than that of the selected account.
Add Same-Level Acct

Enables you to add a new account on the same level as the selected account.
Generate Standard Chart of Accounts / Generate From Cash Flow Line Items

Generates the standard chart of accounts for the temperate.

For cash flow report templates, generate the template from cash flow line items.

For fixed asset templates, generates only the assets of the standard chart of accounts.

You can add new accounts, rearrange the accounts, or remove non-relevant accounts as required.
Mock Title

Hides the selected account in the financial report.

Not available for FA history report templates.
Hide Accounts

Hides selected accounts in the report.

Not available for FA history report templates.
Cash Flow Report Template Fields
Report

Specify a report type.
Line Item

Displays the name of a selected line item.
Parent Article

Specify the title to be assigned to the line item.
Loc. on Tree

Specify the location of the line item relative to other line items under the same title.
Line Number

Specify the line item number to be displayed in the final Cash Flow report.
Indent Characters

Specify the number of character indentations to display in the final report. The default number for Level 3 is four indentations.
Text Title

Selecting this field:

  • Defines the selected line item as a text title that cannot have any child cash flow line items or cash flow relevant G/L accounts

  • Disables the Subtotal and Reversal Sign fields
Reversal Sign

Changes the cash flow line item amount to a negative number.

To display the Financial Report Templates – Expansion window, double-click the line item.