Account elements table
Dimensions > Account > List
Attributes tab
Please find below the most important fields.
| Field | Description | Values |
|---|---|---|
| Alternative description | Account description used in the reports. | - |
| Nature | Nature of the account | Balance Sheet Profit & Loss Memorandum Other variations Other stocks |
| Account type | Account type | Normal: main accounts, neither variation accounts nor detail accounts. Variation: the account is part of a variation. Details: the account collects detail values. |
| Conversion | FX rate to be applied when converting into the consolidation currency. | P&L FX rate : The P&L conversion method is defined in the conversion rule. It is possible to override, for the individual process, the settings of the default conversion rule and replace them with the chosen FX rate (average FX rate/period average FX rate/year-end FX rate). Used for the P&L, detail accounts and other variation accounts. Average FX rate: This converts the cumulative amounts to the average FX rate present in the FX rates table. Period average FX rate: This converts the amount for the period to the period average FX rate present in the FX rates table and then adds it to the converted data of the previous period. Final FX rate: This converts cumulative amounts to the final FX rate present in the FX rate table. Used for the balance sheet, detail accounts and ‘other stock’ accounts. Equity accounts are excluded, as these are normally converted at the historical FX rate. Historical FX rate: This stratifies the conversion based on the period FX rate. There is no FX rate numeric value. In order to obtain the final converted value, the system adds the converted variations to the initial balance, each based on the type of FX rate indicated in the relative table. Used for equity accounts. Prev. P&L FX rate: Applied to the reserve variations that receive the distribution of profit and the balance sheet net result for the previous year. Only used for variation accounts and detail accounts. Prev. Final FX rate: Applied to the accounts representing the initial balances. However, these accounts are actually calculated on the basis of the carryforward processing operations, and are not the result of conversions. Only used for variation accounts and detail accounts. Initial balance FX rate: this converts incoming area variations or percentage variations in the case of a decrease of accounts converted at the historical FX rate, when the entry or reduction occur at the start of the period, or when the amount refers to carrying forward. Only used for variation accounts. With this kind of FX rate, it is useful to specify the Reference account for Initial balance/Year-to-date average FX rate which allows you to calculate the conversion coefficient. Only if the conversion type is “Initial balance FX rates” or “Year-to-date average FX rate”. Must be a "Normal" or "Detail" Balance Sheet account. If not present, the system will use the parent account of the control group to which the account being converted belongs as the account. Year-to-date average FX rate: this converts outgoing area variations or the percentage variance in the case of a decrease of accounts converted at the historical FX rate, i.e. when the exit or reduction occur during the period and other operations alter the value of the account. Only used for variation accounts. With this kind of FX rate, it is necessary to specify the conversion coefficient in Reference account for Initial balance/Year-to-date average FX rate. None: This is applied to accounts that are not subject to currency conversion. This is used for ‘other variation’, ‘stock’ and ‘initial balance variation’ accounts. |
| Reference account for Initial balance/Year-to-date average FX rate | Account used to calculate the conversion coefficient. | Only Normal or Detail Balance Sheet accounts. If not specified, the parent account of the control group to which the account belongs is used. |
| Validity | Account validity period | - |
| Class | Account class to which the account belongs. This defines the sign for the amounts in the forms. | - |
| Manage transaction currency | This defines if the account allows for transaction currency or only company currency. | - |
| IC management | The account may receive intercompany values. | - |
| Manage maximum number of decimals | This allows for 9 decimals to be used also for 'other stock’ and ‘other variations’ accounts. | - |
| Documentation link | This opens a page that is external to Tagetik with additional information. | - |
tab Relationships
This tab allows you to create relationships between accounts, hierarchies and nodes.
Rules tab
Please find below the most important fields.
| Field | Description |
|---|---|
| Gross amount equal to the IC sum | The gross amount for the account is automatically calculated by summing the IC declarations for said account. |
| Accrual | |
| Debit accrual | The account used to generate the counterpart entry for the P&L rows inserted manually (if a debit sign). |
| Credit accrual | The account used to generate the counterpart entry for the P&L rows inserted manually (if a credit sign). |
| Consolidated | |
| Use account for set-up | Use the account to set up the financial investments or equity of the ownership structure register. |
| Exclude from proportional calculation | Account not to be calculated proportionally, in the presence of proportional companies. Mandatory for ‘other variations’ or ‘other stock’ accounts. |
| Validation checks | |
| Standard sign check | Sign that may be used to insert amounts. Used by diagnostic checks to detect any violations of the configured standard. This check can be set as blocking. |
| FX rates check | This indicates whether the IC FX rate diagnostic check is run on the account. |
| Notes check | This indicates whether the diagnostic check into the presence of notes regarding amounts is run on the account. Notes can be set as mandatory and the check can be blocking for data submission. |
| IC capacity check | Diagnostic check on the capacity between IC amounts and gross amounts. |
| IC sign check | Diagnostic check on the sign of IC entries. The sign must be consistent with the gross amount. Mandatory for accounts that allow IC. |
Restrictions tab
This tab allows you to set the custom dimensions accepted by the account.
Please find below the most important fields.
| Field | Description |
|---|---|
| Restrictions for the specific custom dimension. | |
| CTP restriction | This uses rules to define the counterparties accepted by the account for the IC. |
It is possible to set these restrictions for each enabled custom dimension (cost centers, products, employees etc.).
| Restriction | Description |
|---|---|
| None | All custom dimensions are accepted. |
| Restricted | It is possible to define the accepted custom dimensions. |
| Restricted on the company's default custom dimension | The account inherits the restrictions on the associated company’s custom dimensions. |
| Restricted based on the account/classifiers relationships | The possible custom dimensions are automatically generated depending on the relationships between the custom dimension accounts and classifiers inserted in the table. |
Cash Flow Planning tab
This tab allows you to set the data for financial planning.
Please find below the most important fields.
| Field | Description |
|---|---|
| Variation | |
| Debit | Variation account to be used to define the accounting models. This is normally used on balance sheet accounts to specify the variation account with which to perform the initial disinvestment, or, for accounts linked to asset-type objects, to specify the variation accounts linked to events. It must be a variation account. |
| Credit | |
| Receivable/Payable | |
| Debit | Variation account to be used to define the accounting models. This is usually used on P&L accounts to specify the variation account of adjusted credits or debits. It must be a variation account. |
| Credit | |
| Liquidity | |
| Debit | Bank account variation account that records cash flow account entries (payment or collection) for the account. To be used to define the accounting models. It must be a variation account. |
| Credit | |
| Accrual | |
| Debit | The account used to generate the counterpart entry for the P&L rows inserted manually. |
| Credit | |
| Others | |
| Debit | Additional account to define the accounting models. |
| Credit | |
| Additional debit accrual account | The account to generate a balance sheet counterpart entry for accounts that have no entries; or to generate the reference entry of a cost/revenue in the case of deferred invoicing. |
| Additional credit accrual account | |
| Revaluation/Write-down | |
| Enable | Specifies whether or not the valuation at the period-end FX rate is performed for that account at the end of each period. Only mandatory for balance sheet accounts. |
| Debit | The account to which the FX rate difference relating to the period-end FX rate valuation is booked. It must be a P&L account. If not defined, the account present in the configuration will be used. |
| Credit |
tab Banking data
This tab allows you to set the characteristics of the data collected for banking supervision purposes. In particular, it relates accounts to specific supervisory items.
Please find below the most important fields.
| Field | Description |
|---|---|
| Bankit reporting M sub-item | Supervisory sub-item that the account will feed for statistical reporting. |
| Bankit reporting M sub-item - IC Group | Supervisory sub-item to be fed by the financial statement accounts of 36381 for direct production (IC relationships between entities of the banking group). |
| Bankit reporting 1 sub-item | Supervisory sub-item that the account will feed for the common reporting framework. |
| Bankit reporting EP sub-item | Supervisory sub-item that the account will feed for Bankit EP reporting. |
| EBA reporting sub-item | Supervisory sub-item that the account will feed for Bankit EBA reporting. |
| Bankit reporting M sub-item (OLD) | Supervisory sub-item that the account will feed for statistical reporting. |
| IC sub-item (OLD) | Supervisory sub-item to be fed by the financial statement accounts of 36381 for direct production (IC relationships between entities of the banking group) up until 30/06/2009. |
Monthly splitting rules tab
This tab allows you to set the criteria based on which data are registered within a period.
| Field | Description | Value |
|---|---|---|
| Monthly splitting type | Monthly splitting type to be allocated to the account | No: no monthly splitting (default) Flat: the value of the account is allocated in equal parts to each defined period. Coefficient 445: the value of the account is allocated based on the 4+4+5 progression of weeks in the months. Considering that a year is made up of 52 weeks and that each quarter has 13 weeks, for the 445 coefficient, the "weights" of the weeks in the quarter will be 4/52, 8/52, 13/52, 17/52, ... 47/52, 52/52. This is only applicable in the case of 12 periods. Coefficient 454: the value of the account is allocated based on the 4+5+4 progression of weeks in the months. The "weights" of the weeks in the quarter will be 4/52, 9/52, 13/52, 17/, .... 48/52, 52/52. This is only applicable in the case of 12 periods. Coefficient 544: the value of the account is allocated based on the 5+4+4 progression of weeks in the months. The "weights" of the weeks in the quarter will be 5/52, 9/52, 13/52, 18/52, .... 48/52, 52/52. This is only applicable in the case of 12 periods. Advanced Management:Monthly splitting is defined using a specific driver. This enables the subsequent reference fields. |
| Reference | ||
| Reference account | Account used to calculate the monthly splitting driver. If this is not specified, the system uses the account defined in the elements table. In the case of monthly splitting with Advanced Management, it must be a P&L account, ‘other variations’ account or a variation account. | |
| Reference account hierarchy | The hierarchy of accounts used to calculate the monthly splitting driver. Only for monthly splitting with Advanced Management. | |
| Reference scenario | Reference scenario used to calculate the monthly splitting driver, obtained by defining a time sequence to apply to the data processing scenario. Only for monthly splitting with Advanced Management. | |
| Filter custom dimension 1 | This specifies whether the driver is filtered on the custom dimension. Only for monthly splitting with Advanced Management. | Do not filter: No partialization applied to the driver. Filter on lowest level element: Data are monthly split with a driver filtered on the same elements of the target custom dimension. |
| Filter custom dimension 2 | ||
| Filter custom dimension 3 | ||
| Filter custom dimension 4 | ||
| Filter custom dimension 5 | ||
| Filter category | This specifies whether or not the driver is filtered on the category based on the data to handle. | |
| Filter CTP company | This specifies whether or not the driver is filtered on the CTP company based on the data to handle. | |
| Filter CTP custom dimension2 | This specifies whether or not the driver is filtered on the CTP custom dimension 2 based on the data to be handled |