Financial statement

Select the identification of the financial statement.

Description

Enter a short description of the financial statement.

Main focus

Select the main focus for the financial statement.

Secondary focus

Select the secondary focus for the financial statement.

Page break per main focus

Select this check box if you want to print a separate financial statement for each main focus, with the lines printed based on the secondary focus.

If the check box is cleared, the main focus is presented as a line in one single financial statement, and the secondary focus is presented as detailed information.

This check box can only be selected if a secondary focus is selected.

Row definition for main focus

Select the main focus row structure that you want to use in the financial statement.

Row definition for secondary focus

Select the secondary focus row structure that you want to use in the financial statement.

Main focus 100 pct.

Select a main focus that contains 100 percent. Specify which column the percentage should be calculated for in the Percentage columnfield on the Calculationtab.

Use this field only if the definition in the financial statement contains columns of the 100% type. When you specify a 100% account, the individual account's share of this is calculated as a percentage.

Ledger account 100 percent. can be useful when you present turnover in the financial statement. Account 100 percent then is the summary account for total turnover.

Print range

Select this check box if you want to print a range description before the financial statement.

Cover page

Select this check box if you want to introduce the financial statement with a cover page.

Skip zero

Select this check box if you want to skip accounts or dimensions when the balance is zero.

Header line

Select this check box to print header rows or header account when an account comprises the focus.

Transaction line

Select this check box to print details, elements, rows, or account numbers for transaction account lines when an account comprises the focus.

Total line

Select this check box to print total rows or account numbers for total accounts when an account comprises the focus.

Column

View the current column number. The number increases by one for each created column. The numbering determines the column layout of the financial statement and can be changed by clicking the Upand Downbuttons.

Name

Specify a name for the column. The name is used as a header for the column.

Column type

View the type of contents in the individual column. Select one of the following column types:

• Main focus code– Identification of the main focus (account number, dimension, or combination).

• Main focus definition name– The name of the main focus identification.

• Secondary focus code– Identification of the secondary focus (account number, dimension, or combination).

• Secondary focus name– The name of the secondary focus identification.

• Current– Current realized figures that are converted to default currency independently of the original currency.

• Current quantity– Current realized figures, in the form of quantities, that are registered in the transactions.

• Current currency– Current realized figures in original currency, for the currency that is selected in the Currencyfield on the Setuptab.

• Current currency– Current realized figures that are converted to the default currency, for the currency that is selected in the Currencyfield on the Setuptab.

• Budget– Budgeted figures that are converted to the default currency independently of the currency entered.

• Budget quantity– Budgeted figures, in the form of quantities, that are registered in the transactions.

• Budget currency– Budgeted figures in the original currency, for the currency that is selected in the Currencyfield on the Setuptab.

• Budget default currency– Budgeted figures that are converted to the default currency, for the currency that is selected in the Currencyfield on the Setuptab.

• 100%– Calculation of the account's share of the 100 percent account in the Percentage columnfield on the Calculationtab. This calculation is useful when printing the statement of earnings, where the 100 % account displays the total revenue.

• Calculation– A column whose value is calculated on the basis of other columns. The current calculation is specified in the Calculation expressionfield.

• Cash flow forecast– Calculated cash flow forecast figures that are converted to default currency and are independent of the original currency. By adding this column, you can summarize the realized figures and the calculated cash flow forecast for a period in the future.

• Cash flow forecast currency– The calculated cash flow forecast figures that are converted to the default currency, for the currency that is selected in the Currencyfield on the Setuptab.

• Cash flow forecast default currency– Calculated cash flow forecast figures that are converted to default currency, for the currency that is selected in the Currencyfield on the Setuptab.

• Secondary currency– Current realized figures that are converted to secondary currency and are independent of the original currency.

Print

Select this check box to print the column in the financial statement.

Clear the check box if the column should not be printed.

Number of columns

Specify the number of columns that you want to print for a logical column, such as 2 for a debit and a credit column, or for displacement of totals.

Date interval code

Select the code, if any, for date intervals for the current column. The date interval is proposed when you print the financial statement from General ledger> Reports> Transactions> Periodic, but you can overwrite it.

From date

If you left the Date interval codefield blank, you can enter a date in the From datefield. The date is proposed when you print the financial statement.

To date

If you left the Date interval codefield blank, you can enter a date in the To datefield. The date is proposed when you print the financial statement.

Currency

View or select the currency for the column. For example, for the Current, column type, the field is unavailable, but for Current currency, it is open for selection.

Factor

Select from the drop-down list if the column should print the amounts as-is or in other units of the currency.

Calculation expression

The formula that is used for calculating columns of the type Calculation. Any operators recognized by X++ are accepted. During calculation, #1, #2, and #5 will be replaced by the currently specified columns 1, 2, and 5.

Examples:

• #1-#2 – The difference between column 1 and 2.

• #1+#2 – The sum of column 1 and 2.

• #1*#2 – The product of column1 and 2.

• #1/#2 – The ratio of column 1 and 2.

• #1/#2 % – The ratio of column 1 and 2, expressed as a percentage.

• (#1-#2)/#2 % – The difference between column 1 and 2, expressed as a percentage of column 2.

• (#1-#2)/#1 % – The difference between column 1 and 2, expressed as a percentage of column 1.

• (#5 + #6) / #3 – Add column 5 and 6 and then divide the result by column 3.

Percentage column

The column for which you want to calculate a percentage if you select the column type 100%. The field is unavailable for all other column types.

Use factor

Select the check box to multiply by a factor that is entered in the Calculation expressionfield.The field.can be used through calculation columns, if it is necessary, by building the columns, clearing the Printfield, and applying the factor.

Decimal separator

Select the sign that you want to use as a decimal separator.

Thousands separator

Select the sign that you want to use as a thousands separator.

Show zero

Select how to show the figure zero if the value is zero.

Invert sign

Select whether the sign should be inverted when printing.

Sign

Select how to display a sign for negative figures.

Decimals

Specify the number of decimals.

Negative adjustment

Enter the number of positions that negative figures should be moved to the left, typically in a column with debit and credit amounts.

Length

Enter the maximum number of positions that the column may use on print.

Company accounts

Select company accounts for the transactions in the selected column.

Include opening

Select the check box if opening transactions is included in the financial statement.

Include normal

Select the check box if normal transactions are included in the financial statement.

Include closing

Select the check box if closing transactions are included in the financial statement.

Posting layer

Specify how the posting layers should be included for the selected column:

• Current– The column will only contain transactions which are marked as Current.

• Operations– The column will only contain transactions that are marked as Currentor Operations.

• Tax– The column will only contain transactions that are marked as Currentor Tax.

• Operations minus tax– The column will only contain transactions that are marked as Operationsminus Tax.

• Only operations– The column will only contain transactions that are marked as Operations.

• Only tax– The column will only contain transactions that are marked as Tax.

• Only tax– The column will contain transactions that are marked as Operationsor Tax.

• Total– The column will contain transactions that are marked as Current, Operations, or Tax.

The drop-down list is not available when printing the financial statement.

Note
If you want to print Currentfor account 11005 and Taxfor account 11010 on the same financial statement, you must select Totalhere. Then, in the Posting layerdrop-down list in the Structure designerform, select Currentfor account 11005 and Only taxfor account 11010.

Debit/Credit

Indicates whether the column should print only debit balances, only credit balances, or both. This is useful for reverse entry, where all transactions can be posted on the same side but with a negative sign.

Budget model

Select a budget model if you want to sum up the budget amounts for a specific model in the financial statement. The selection is proposed when you print the financial statement, but can be overwritten.

By default, if you do not select a budget model, all budget transactions in the selected date interval are included.

Include submodel

Select the check box to include submodels of the specified budget model in the calculation. The selection is proposed when you print the financial statement, but you can overwrite it.