Account Definition

1 Structure and Application

This application is used to define charts of accounts and to create or modify associated accounts. The application consists of two tables, the leading table for the charts of accounts and the dependent table for the accounts.

Charts of accounts

When the application is invoked, a table is displayed with all the charts of accounts already defined.

Accounts

The account table of each chart of accounts is opened when a chart of accounts is highlighted in the leading table and a branch is made to the dependent table either by double-clicking or by using the context menu (right mouse button) via the open icon (eye). After opening, the leading table is hidden (moved to the left edge) so that only the account table is visible. When you unhide the leading table, it appears at the top and the accounts table below it. You can close the accounts table by clicking on the close icon (cross in the quadrilateral, "Close chart of accounts") in the global toolbar. Then the leading table is displayed again.

Capture: Content is captured per table through a wizard. This opens to collect data via the 'star' icon in the upper right toolbar. Only if all the entries match (plausible) will the 'Done' button become active and the sentence can be saved.

Modify:

• In the "Charts of accounts" table you can modify it using the Tablecells editable option on the context menu or the pen icon in the global menu bar. The validity, chart of accounts type/flag, accounting type, and associated account/chart of controlling objects of the chart of accounts can only be changed if the dependent accounts table is also open.
• In the "Accounts" table you can modify it either by using the wizard (double-clicking on the account or right-clicking on the context menu) or by using the activated edit mode 'Tablecells editable'. If changes are made via the editing mode that may not match the previous entries, the sentence can be closed first. An 'Open Tasks' at the bottom of the table shows you which entries in the account do not match. In most cases, however, an indication message appears, which does not allow the change made in the case of an invalid entry. When changing entries through the wizard, closing the wizard is only possible when all the entries match (only then the 'Finish' button becomes active).

Copy: You can trigger the copy action by clicking the copy icon (two sheets) in the toolbar of the context menu of the table rows.

Delete: You can trigger the delete action by clicking on the delete icon (red cross sheet) in the toolbar of the context menu of the table rows or by pressing the Delete key after selecting table rows.

The export of the individual sections is done via the Export button in the global menu bar. The export area is determined by the Export dialog. You must mark the selection of the desired area on the right side of the export dialog. A selection is taken into account in the tables. If rows are selected in only one table, only those rows are exported. Tables without selection are only exported (complete) if no selection exists at all.

Language control: The table toolbar contains a drop-down box with entries of all active languages. The language specified in the startup data is preset. The descriptions are displayed according to the language selected there. Changing the language affects the tables directly.

Branches:

• The following application "Account categories" and "Descriptions" can be called in the "Charts of accounts" table. In addition, an existing lock on the selected record can be deleted in the context menu.
• In the "Accounts" table the applications "Position account allocations" and "Descriptions" can be called as follow-up applications via the context menu. You can also view all of the account's position plan assignments in a single window.

2 Table for Charts of Accounts

In order to make it easier for you to maintain the individual charts of accounts, IDL Konsis uses so-called chart of accounts numbers. The company charts of accounts can be used simultaneously by several companies. After a chart of accounts number has been assigned, the charts of accounts stored underneath can be used as follows:

• In the "companies" application (CODT) by assigning a company chart of accounts to one or more companies, i.e. for all domestic companies that are charged via the same FiBu system. If a chart of accounts number is assigned more than once, the corresponding chart of accounts must be maintained only once. In the company master, the chart of accounts number is mandatory.
• In the Data Types application (FCT), by mapping a group chart of accounts to one or more data types at the group chart of accounts level (chart of accounts Flag = 'K'). In the data type master, the chart of accounts number is mandatory for data types at the group chart of accounts level.
• Mapping of a chart of accounts in the startup data application (STUPDT).

The following subchapters explain the different attributes of the chart of accounts creation wizard:

2.1 Description page

• Chart of accounts: Free selectable 6-digit alphanumeric chart of accounts ID.
• Valid from/until: The valid from period is required, and the valid until period is optional. Both attributes define the period from which a chart of accounts is valid and up to which it is valid. The user-specific startup data (STUPDT) can be used to control that charts of accounts with limited validity (any specification of a valid-to period) are no longer displayed.
• Description: Mandatory information with max. 70 characters.
• Short text: Optional input with max. 10 characters. If no acronym is provided, the first 10 digits of the acronym will be used as acronym.

2.2 Properties page

• Chart of accounts/cost center type: This field controls whether the chart of accounts key assigned here is also the key for a chart of controlling objects. A distinction is made here between only chart of accounts (A) and chart of accounts + controlling objects (COB)
• Chart of accounts/cost center flag: The chart of accounts identifier defines whether the chart of accounts is a company chart of accounts (C) or a group chart of accounts (G).
• Associated chart of accounts/Cnt Plan No: This field is used to deposit the chart of accounts to be used when transferring company chart of accounts to the group chart of accounts. This is automatically offered when maintaining the allocation of company accounts to group accounts in the account master. Please note that the chart of accounts must be defined in IDL Forecast before batch transfer of company or group accounts via IMPT (interface file KPKONTEN.DSCTXT). This applies both to the chart of accounts to be transferred (e.g. GES001) and to any references to an assigned group chart of accounts (e.g. KON001). If the group financial statement of a group/sub-group has to be transferred to another group chart of accounts, this can also be controlled via the Associated group chart of accounts field in the COADFN application (e.g. real estate sub-group with its own group chart of accounts is to be transferred to group chart of accounts Total Group). The data to be transferred to the higher-level group chart of accounts is then kept on a next fact (e.g. I5).
• Accounting standard: 7 different accounting types are available to be assigned to this chart of accounts (see Selection)
• Default business unit of chart of accounts: If business units are used, there is the possibility to deposit a standard business unit for the chart of accounts. This is used whenever a business unit specification (for the Controlling object or for the account) is missing.
• Number of columns for account No.: This field can be used to control the length of the account number to be conducted in IDL Forecast. Entries of 01 to 14 are permitted here. The account length entry provides the following functionality: in the case of machine takeover of accounts, the served account number is shortened to the length according to the chart of accounts entry. The reduction is carried out on the basis of a right-justified count, i.e. a corresponding number of leading zeros is cut off.
• Fixed asset prefix: If you specify a fixed asset object prefix, fixed asset objects associated with that chart of accounts are automatically generated if necessary, the key of which is composed of the prefix and the account number entered here. The special entry "*" means that no prefix is defined. The key of the fixed asset object is then identical to the account number. It is strongly recommended that you use different prefixes for social and group charts of accounts, provided that the naming convention allows for identical account numbers.
• Length of account descriptions: The length of the account name can be specified in the field. Since 70-digit descriptions are preset on the system side, a specification of 70 to 255 characters is possible.

2.3 Descriptions (multi language) page

• For the activated languages (acc. license), corresponding descriptions can be recorded.

3 Table for Accounts

The table for accounts provides an overview of all defined accounts of the open chart of accounts. Accounts of the group chart of accounts are allocated group-wide and thus belong to the group of group-wide data (GRPSUBEX). By contrast, company accounts are defined for each individual company or for a group of individual companies.

As in the form entry save, the changes you made to the accounts table are not saved to the database immediately, but only when you explicitly press the floppy disk button on the global toolbar. When the application is terminated and the chart of accounts save is changed without first being activated, a control query appears whether the detected changes should be saved first.

The following subchapters explain each of the attributes of the wizard used to create an account:

4 Create account wizard - Description

• Account number: Mandatory specification of a freely selectable 14-digit alphanumeric account number.
• Validity from/until: The Validity from period is mandatory, and the Effective To period is optional. Both attributes define the accounting period from which values can be assigned to an account and from which it is included in reports. For asset accounts, validity constraints are inherited by all associated fixed asset objects, so that a fixed asset object cannot be longer than an asset account, and by analogy, by line account associations. The user-specific startup data (STUPDT) can be used to control that accounts with limited validity (any specification of a valid-to period) are no longer displayed.
• Description: Mandatory information with max. 255 characters
• Short text: Optional input with max. 10 characters.

5 Create account wizard - Required fields

5.1 Balance sheet/Profit & Loss code

In IDL Konsis, the following balance sheet/profit and loss code indicators are possible:

• 1 = Assets
• 2 = Liabilities and capital
• 3 = Income
• 4 = Expenses
• 5 = Statistical quantities
• 6 = Statistical assets
• 7 = Statistical liabilities and capital
• 8 = Statistical income
• 9 = Statistical expenses
• M = Metrics (Non financial numeric values)
• N = Narrative information

Balance Sheet/Profit & Loss Code identifier allows selection with regard to the different account groups and allows plausibility checks (BG identifier 1 to 4), e.g. the account BG check in the tuning block of the application "account balances" (ACBAL)

You can also use the statistic identifier "5" to represent quantities in the form of accounts in IDL Konsis. For example, the number of employees or number of branches can be managed in IDL Konsis. With the next statistic identifiers 6-9, corresponding to the BG identifiers 1 to 4, parallel information can be kept which does not appear directly in the balance sheet profit & loss or the value. Examples are revenue by region or the presentation of liability or other financial obligations.

If statistical accounts have an intercompany account identifier maintained, they can be included in automatic debt or expense/income consolidation. However, because of their better tunability, they should be assigned to a separate, individually created document group (CNSFNC), e.g. S1.

5.2 Account Flag

The account flag can be used to assign accounts to specific roles, e.g., to indicate that next details (details) are necessary, i.e., information that is relevant, e.g., for consolidation.

NRD = Aff. net result at deconsolidation:

The account identifier 'NRD' is used to classify accounts (e.g. retained earnings, IFRS reserves) that are to be included in the final consolidation result in a final consolidation. This means that in addition to the accounts with the account identifiers 'REV' and 'RE', the end-consolidation includes the accounts with the account identifier 'NRD' in the end-consolidation success.

R = Result:

The consolidation system requires an account of results at both the company and the group chart of accounts level. The system-determined annual profit or loss is deposited on this account. This allows the details of the total profit and loss position 'annual profit or loss' in the 'ACBAL' in the case of cross-company selection and serves as a basis for determining the size 'Earnings due to other shareholders' (consolidation function 'TC' - Calculation minority interests).

MIR = Minority interests on results:

The account identifier 'MIR' can be used to identify the account 'JÜ share held by other partners'. This allows for different positional mappings for the report. The assignment in the application 'POSKTO' is usually only possible between accounts and positions with related balance sheet/profit and loss identifier, e.g. '1' (assets) is allowed with '2' (liabilities), '1' with '3' (revenues) is not allowed. An exception is the result account (account identifier 'R'), which can be assigned as a liability account ('2') to an income line ('3'). A next exception of the same kind is also possible for the account 'JÜ-Share of foreign shareholders', which is to be provided with the account identifier 'F'.

GR = Group results:

The account identifier 'GR' can be used to define a group result account. This is required if the result entries for affecting net result consolidation vouchers are to be made not on the general result account (with account identifier 'R') but on a separate group result account.

CL = Clearing account:

The account identifier 'CL' indicates neutralization accounts. Only accounts marked in this way may be entered in the consolidation parameters as neutralization accounts. Neutralization accounts are allowed only in the group chart of accounts. Neutralization accounts shall not collect individual closing data and consolidation postings only if they are specified as a clearing account in the corresponding consolidation parameters. They are therefore usually not displayed in the account selection (exception: Clearing account in the consolidation parameters). Entering an account in a consolidation parameters automatically creates additional postings on the clearing account in the associated consolidation documents. These postings neutralize shifts in the results of the balance sheet or profit and loss between the two companies mentioned in the voucher. By taking the neutralization bookings into account in the Group report, it can be achieved that the company listing of the result corresponds exactly to the individual financial statements results.

RD = Rounding difference of quotal companies:

This flag can be used to identify accounts that have been specifically set up to account for rounding differences resulting from quota translation. They must be specified in the consolidation parameters 'QU' and are only given values by the Role make a posting 'Quotale equalization values'.

DF = Difference amount:

The account identifier 'DF' identifies differential accounts. Only accounts with this account identifier can be specified in the consolidation parameters as a Difference Amount account.

BU = Compensation account for business units:

If business units are used, specifying account groups in the company+business unit assignments (COBUALC), automatic compensation of the JV differences in a compensation account is additionally carried out for all business units. This balancing account will have the account identifier 'BU'. If the balancing account is a balance sheet account, then the JÜ results according to the total of the profit and loss balances, i.e. for a "balance sheet business unit" (account group 'B') to zero. Conversely, if the balancing account is a profit and loss account, the JÜ results in the sum of the balance sheet balances, i.e. for a profit and loss business unit (account group 'G') to zero.

REV = Retained earnings from vouchers:

The account identifier 'REV' indicates the account for the retained earnings of affecting net result postings at company level. There must be only one account with this flag and it can only be created in the company chart of accounts. The corresponding account at the group chart of accounts level is specified for the data types (FCT).

RE = Retained earnings:

The account flag 'RE' denotes the account for the retained earnings for both the company level (if there is no account code = 'REV') and for the group level. Only one account may be marked with this mark.

5.3 IC details

The IC details type determines which IC elevation data are maintained for this account:

P = Participations (GESGES):

To maintain shareholding transactions in related or associated companies, participation accounts must have an IC account flag of 'P'. This is a prerequisite for the Capital consolidation and calculation of minority interests. Accounts for participations to other companies do not require an IC identifier.

I = Intercompany account (ICKTOSAL):

For debt and expense/income consolidation, the pure main account balances are not sufficient. In addition, detailed information regarding the allocation of the account balance to the respective partner companies is required. These can then be compared per company pairing within the framework of the corresponding consolidation function. In IDL Forecast, you can maintain or read this list information in the IC Sub-Account Balances (ICACBAL) application for all I accounts.

S = Intercompany account stocks (ICVOR):

If IDL Forecast is used to execute the elimination of … results in the current assets with the consolidation function company "CLOSE", the basic information (stock of IC-rated, add/remove rates, etc.) must be provided in the system. The corresponding data is maintained in the application Stock Assets IC (ICVOR) for all balances on accounts marked with 'S'.

5.4 Validation of IC details

IC rip sampling specifies how the aggregate of the rip data should be sampled with the account balance:

C= Complete validation

This means that the account balance must match the elevation data, otherwise a 'red' state will be displayed.

P= Proportional validation

i.e. the account balance, which contains some IC data, must accordingly only be "torn up" in proportion by IC account balances. An example is when participations to unrelated companies are also held in an equity account. If the elevation data does not match the account balance, a 'yellow' state is displayed.

N= No validation

i.e. the account balance is not tested at all with the details data. This also means that there is no message if the sum of the IC balances is greater than the account balance or has the opposite debit/credit identifier.

5.5 Transaction Development of the Account

Mapping a transaction development to an account determines the transaction development in which that account is processed. Only one transaction development can be assigned to each account. The Transaction developments can be selected using the Transaction Development Definition (TRNDEVDFN) application.

Typically, the following types of transaction developments are used in IDL Konsis:

System level:

Asset accounts must be assigned to an asset statement so that the transactions can be maintained appropriately in the fixed asset transactions application (NLBEW). Only then can an installation level be generated with IDL Forecast. An asset statement also permits the automatic calculation of accounts and the reconciliation of the amortization current year amortization current year with appropriately marked profit and loss accounts (account identifier 'D').

Equity level:

In IDL Forecast, capital transactions (CAPTRN) have two Roles. On the one hand, they are used to describe the development of equity capital for the compilation of an EU Transaction development, on the other hand, they are a mandatory requirement for the illustration of a historical equity conversion. For capital accounts, this development can be stopped using posting keys in the capital transactions application (CAPTRN).

Reset mirror

If you intend to use IDL Forecast to create a reserve mirror, you will need to maintain the transactions for the individual reserve accounts in the system. Maintaining this development in the Accrual Movements application (RÜBEW) is only allowed for accounts that are assigned to a corresponding Transaction development. Amortization current year A reserve mirror also allows the matching of the feeds, resolutions and accounts with appropriately marked profit and loss accounts (Transaction development/profit and loss reconciliation 'Y' (resolution), 'Z' (feed) and 'D' (depreciation)).

Other Transaction developments:

The customer can define next Transaction developments without specific Role in IDL Konsis, e.g. for liability levels or Cashflow statement. For accounts associated with these Transaction developments, the transactions of the account balances can be maintained in the development transactions application (DEVTRN).

5.6 Transaction Development/P&L (SGA)

The Transaction development P/L Reconciliation flag (abbreviated 'SGA') is used to reconcile the P/L accounts with this flag and transaction development columns with the same flag.

D = Depreciation account P/L:

IDL Forecast can test the current amortization current year amortization current year profit & loss according to the system level with the ones in the Profit & loss The prerequisite for this plausibility check is that the system can identify the depreciation accounts in the period. Profit & loss For this reason, all voting-relevant accounts must be set up with 'D' in the vote. Note: A 'D' account must be a profit and loss account and must not also be an asset account.

R = Provision releases, A = Provision additions:

The Transaction development-to-income reconciliation flags 'R' and 'A' denote profit and loss accounts on which provision reversals and receipts are recorded. They are similar in character to the DPN accounts (SGA mark 'D'). If R- or A-accounts are defined in the chart of accounts, the movement of the transaction development columns for the release or supply is tested against the amounts on these accounts. Deviations shall be reported on each test, including the establishment of the reserve level.

5.7 Reposting at Carry Forward

For capital accounts, the entry 'X' in the field 'Transfer on carry forward' can be used to control that the values on this account are transferred to the retained earnings account (account identifier 'X') or an individually assigned retained earnings account (see below) at carry forward into the next period.

5.8 Account for Aggregation

By means of an entry in the field Account for aggregation, certain accounts can be pre-compressed (e.g. determination of the total balance of all Deutsche Bank accounts, determination of the payload from compression of the input tax and VAT accounts). The compression acts upon the transfer to the next fact. Without changing the chart of accounts (e.g. from I1 to I2), in the FCT application the compression identifier must be set for the target data type (I2). When changing the chart of accounts (e.g. from I1 to I4), the compaction settings are always taken into account, even if data types are skipped.

Different attributes must match between account and account for aggregation. These are automatically added to the wizard fields when you specify or change the account for aggregation.

Example 1: Compaction of accounts with the same balance sheet/profit and loss indicator

This example shows how to compress multiple bank accounts from a bank into one of these accounts. This facility is used in most cases by our customers.

Figure: Entry of an account for aggregation for accounts 112200 to 112202

Figure: Example with balances

After the change from fact I1 to fact I2, account 112200 Deutsche Bank account A contains the total balance i.H.v. 1,088,633.87H. This assumes that account 112200 on I1 has no balance. In general, however, this is possible.

The presentation and composition of the consolidation balances can be traced after passing to a 'higher fact' in the application ACBAL with the selection option VG - Selection and sorting by chart of accounts / consolidation accounts / company number / business unit. In the application ACBALO by means of the created origin list, it is also possible to show exactly how the balance on the fact I2 is composed on the account 112200.

Example 2: Consolidation of accounts with different balance sheet/P&L characteristics(fictitious)

In this example, it is shown that the active currency account foreign exchange (held in USD) with the liability account current business (held in EURO) should be consolidated. This is where assets and liabilities are netted off, as both accounts are assumed to be held at one institution. Current passive transactions are created by banks through customer receivables or loans to customers. In practice, this example is rarely used.

Example 3: compaction of Intercompany Accounts

Accounts with IC details "I" can also be compressed. This is useful in the following example:

Accounts 164600, 164610, and 164620 are intercompany accounts and have an entry in the field company IC-État. This means that a new account must be recorded if IC balances exist with respect to other companies such as 010 etc. In this case, the aforementioned accounts on the 164599 account, which is also an IC account company, are compressed, but without specifying a fixed value. If the balances are allocated to the next higher fact at which the compaction was carried out, IC balances are automatically created over the corresponding companies. These can then be taken into account in the automatic consolidation of debts.

5.9 Associated Chart of Accounts and Group Account

The accounts of the company chart of accounts are linked to the corresponding group accounts via the Allocated group account field. There, the possible group accounts from the group chart of accounts stored in the company account plan are available for selection.

Different attributes must match between company and associated group account. These are automatically transferred to the respective fields of the wizard when the group account is specified or changed.

6 create account Wizard - IC-Properties

• Intercompany / IC-business: Often, in general ledger systems, main accounts are held exactly opposite a specific subsidiary. If this is the case, the fields 'for IC-Ges' and 'for IC-GB' allow a company account to be unambiguously assigned to a specific company and, if appropriate, to a specific division of this company. Thus, when changing from a company data type to a group data type (e.g. from I2 to I3), an IC balance for the specified company/business unit is automatically generated and set in the intercompany sub-account balances (ICACBAL). A parallel details of the account balance via the application ICACBAL is possible with a corresponding setting of the facts in FCT. Company However, this may only be done in relation to the amount indicated in the account master.
• Consolidation function: This attribute specifies the sequence (CNSFNC) within which the consolidation of debs (CD), including the special treatment of IC accounts for dividends (PD) and the consolidation of expenses and income (IE), an account with the IC breakdown type "I" is eliminated. The respective tuning circuits are defined in the CNSFNC (consolidation functions) application.
• Account for reference consolidation: If the balance company in the debt or income consolidation are in contrast to a fully consolidated and a quota-consolidated balance, then also in the fully consolidated position only the quota share of the IC-shares (according to the quota of the counterparty) is directly eliminated. If a quota reference account is specified in the IC accounts account master, the remaining portion of IC balances of the fully consolidated company is transferred to the quota reference account in a next posting record and does not remain on the IC account. Accordingly, the establishment of a quota reference account is only possible in the case of an account that has an "I" as the IC details and a "C" as the Validation of IC details. It must also have the same balance sheet/profit and loss indicator and the same transaction development in order for the amount posted on this account to be reposted in a mirror-image manner. The quota reference account can have an 'I' as IC account identifier and a 'P' as Validation of IC details, but no 'I' and 'C'.

7 create account Wizard - Reference accounts

• Account if D/C changed: The entry in the Account if D/C changed field in a group account enables a correct asset/liability statement to be achieved at the group level for an account from the company chart of accounts whose balance can rotate. Accounts if D/C changed can be awarded at both company and group level. As a recommendation, compressions should take place on fact I2, accounts if D/C changed and S/H controls should be set up at group level. Mapping of accounts if D/C changed must be mutual. The associated account if D/C changed must have the opposite balance sheet /profit and loss indicator. The transaction developments should be consistent as far as possible so that transactions can be taken with them when they are transferred to the next fact. Therefore, if an account if D/C changed with a different transaction development is entered, a warning is displayed, but the selection is independent of this transaction development.

  Example of accounts if D/C changed:

  Company account	Name.	B/G	Group account	Name.	B/G	WechsKto.	Name.	B/G	Saldo GesKto
  112200	Dt.Bank Kto.A	Active	28410	Credit Memo	Active	42010	Connected. Kreditinst.	Passive	1.088.633,87 H

  Case1: Balance in credit (see above): The company account 112200 is assigned to the group account 28410 Credit institutions. For the group account 28410, the account if D/C changed is defined as the account 42010 Liabilities Credit institutions. In this constellation, credit institutions are presented in the group on the group account 42010 Liabilities, since a credit balance on an asset account (Bil/GuV conc.=1) is delivered via the company account and the standard assignment in group to an asset account (Bil/GuV conc.=1) with account if D/C changed Liabilities (Bil/GuV conc.=2) is controlled. If the debit/credit flag deviates from the default value, the account if D/C changed is addressed.

  Case 2: Balance in target (not shown): If the balance of the account 112200 is in the debit position, then the presentation in the group on the group account 28410 Credit institutions takes place, since via the company account a debit balance on an asset account (Bil/Guv conc.=1) and the standard assignment in the group is also controlled on an asset account.

• Account minority interests: This account can be additionally reported for all capital accounts (according to the Transaction development of the account) and is used in the posting of the minority interests instead of the debt accounts specified in the consolidation parameters FK. This makes it possible to achieve a next differentiation in the recording of minority interests per capital account. If this field is left blank, it will be posted normally to the accounts specified in the FK consolidation parameters. You can filter after the account by entering the account identifier 'F'.
• Account result carry forward: For each P&L account, a separate retained earnings account can be specified, on which the carry forward of affecting net result postings takes place - instead of the default to the one in the FCT fact (for group charts of accounts) or to the account with account identifier = 'REV' (for company charts of accounts). This account must be a balance sheet account. It will take precedence over the retained earnings account specified in the fact for the period carried forward. You can filter after the account by entering the account identifier 'R'.
• Account for aggregat. for planning: The planning condensing account is only evaluated in IDL Forecast. It is used to minimize the amount of accounts used for scheduling.

8 create account Wizard - Controlling

If controlling dimensions have been specified in the "Controlling Definitions" (CNTDFN) application (in order to be able to input data for controlling, a chargeable additional component for the controlling module is required in IDL Forecast), the mask contains an additional input field per controlling dimension. The fields are texted with the description of the respective dimension. The entry 'X' controls that account balances on this account are differentiated according to this controlling dimension.

9 create account Wizard - Other Properties

• Group of posting key: If you have set up accounting key groups for the Transaction development stored in the account in the Mirror Definitions application, you can use this attribute to control the assignment of the desired accounting key group. Such an association group is a classification that places constraints on the association of posting keys with accounts.
• Default business unit for account: This attribute allows an account to be permanently associated with a specific business unit. This is used when a transition is made from a fact without a business unit to a fact with business units.
• Accounting standard: On the one hand, the (neutral) values '1' (Intern) and '2' (Extern), on the other hand the common accounting types 'F' (Fair), 'H' (HGB), 'I' (IFRS), 'L' (Local GAAP) and 'U' (US-GAAP) are provided as specimens, which you can use as required. For changes to the account master (dialog or import), if an accounting type is specified in the company chart of accounts as an associated group account, only one account with the same accounting type or without specifying an accounting type is allowed. For the reporting data of this account, the selected expression must not deviate from any expression selected in the fact.
• Reposting to sequent consolidation account: For each capital account, it can be adjusted whether the difference between the equity in the company financial statement (HB2) and the equity stated at the time of Capital consolidation remains in the respective account or is transferred to a so-called capital subsequent consolidation account. With the help of this Role, the respective capital account can always be 'cleaned up' to zero from a group perspective. If this field remains blank, this means that no transfer will take place.
• Entry allowed in period: There is a journal flag for annual, quarterly, and monthly financial statements that can be used to determine in which periods data may be recorded on this account. If a journal flag is set to 'X', data can be recorded on this account in periods of this type, otherwise the entry is rejected as faulty. Therefore, accounts that are not to be released for entry will not receive entry in the respective fields.
• Plan Account: The entry 'X' in the Plan Account field specifies that this account is used only in IDL Forecast and therefore may only be populated on data types that are marked as data types for scheduling. Background:IDL Forecast requires a number of additional accounts, including statistical accounts for parameterizing rules, taking over data from upstream detailed planning, replacing the lack of possibility of mirror breaks. Sometimes there are more of these additional accounts than the accounts originally needed for consistency. Since all these accounts are in the same chart of accounts, they are offered everywhere in the Konsis selections and confuse the user and allow incorrect input.

10 create account Wizard - Descriptions (multi language)

This page allows you to maintain your descriptions in all enabled languages, as in other root applications.

11 Accounts (COADFN)

As an alternative to the chart of accounts definition (COADFN) application, the accounts (COADFN) application can be used to get an overview of all defined accounts for one or more charts of accounts. Changes to account data are possible through the single-set application 'account' (KTOE, see below).

11.1 Selection and Sorting Possibilities

In the overview, the accounts cannot only be displayed and printed, but also selected in a differentiated manner. This can be done either through the fields contained in the Selection area or through the filter function in the filter row below the table heading. In next, the 'Sort and Selection' option offers various frequently used variants of sorting and selection.

11.2 Action Menu

Right-clicking or using the action icon (gears) of the global toolbar opens the action menu. Individual actions can also be accessed directly from the table toolbar.

Explanation of individual actions:

[Create data] (asterisk symbol): The single-set account (KTOE) application can be accessed via the 'Create new data' action. There, a new account can be created as described in the following chapter.

[Edit Data] (pen icon): The single-set account (KTOE) application can be accessed via the 'Edit Data' action. The processing of accounts can be carried out there as described in the following chapter.

[Mass copy] (Two sheets of one weight): Mass copy allows selected accounts to be copied to another chart of accounts.

[Mass update] (Weight with pencil): When mass update, attributes from the single set (except the key fields highlighted in yellow) can be changed for several selected rows simultaneously.

[Position+account mappings - periodic]: Branches to the position+account Mappings Periodic summary (POSCOPE), which displays the mapping of accounts to report lines.

[Create position mapping for company accounts]: This Role is useful and very time-saving when the accounts of a company chart of accounts are already assigned to group accounts but not to reporting lines. In order to carry out this subsequent processing, the following steps are required:

• The company accounts are each assigned to a group account.
• The company chart of accounts has a group chart of accounts associated with it (for example, KON001) in the chart of accounts definition application.
• Each group account is associated with at least one position in the Line Plan Definition/Account Association application
• Before starting the application, select the appropriate chart of positions in the Assigned field. Enter the chart of positions no. and enter or enter Press Refresh.
• If a period is specified in the Selection area, only the allocations valid in the respectively specified period can be transferred to the company accounts. If no period is specified, the transfer of all existing assignments that fall within the validity of the company account will take place regardless of the validity of the existing assignments in the group account.
• The Role not only allows new line assignments to be set according to the allocation of the group accounts, but it can also update existing assignments according to a changed allocation of the group account. If allocations already exist for a company account, a message is displayed asking whether existing allocations should be deleted. If this request is confirmed, existing line assignments are deleted and new assignments are created according to the group account assignment.

[Accounting key groupings]: Branches to the Accounting Key Groupings (REPCLCDSC) application where you can view or redefine the groupings of the Transaction development associated with each account. This assignment is required if invalid combinations of the account with posting keys are to be prohibited.

[Create Group Account Assignment]: This Role can be used if the account numbers of both charts of accounts are the same. Then an account of the same name of the company chart of accounts is assigned to each account of the group chart of accounts.

[Edit Help Text/View Help Text] (Book Icons): The action 'Edit help text' allows you to save and edit detailed descriptions for each account. The 'Show help text' function allows you to view the help text.

11.3 Individual Record Application Account (KTOE)

This application maintains the account master data of a selected account from the account overview or creates new accounts. The application can be accessed via the line actions and from the accounts (COADFN) application, or via actions 're-create data' (asterisk symbol) or 'create data'. Edit data or (pen icon) on the table toolbar.

The input fields correspond to the input fields of the chart of accounts definition (COADFN) application described above