Reconciliation accounts page
User
Processes tile > select process > Contributor > Detail summary tab or Step tab > (Actions) Other Edit windows > Edit Reconciliation accounts
Processes tile > select process > Consolidator > Overview tab or Step tab > (Actions) Other Edit windows > Edit Reconciliation accounts
Navigation panel > Processes > select process > Contributor > Detail summary tab or Step tab > (Actions) Other Edit windows > Edit Reconciliation accounts
Navigation panel > Processes > select process > Consolidator > Overview tab or Step tab > (Actions) Other Edit windows > Edit Reconciliation accounts
Purpose of the page¶
This page allows you to manage the reconciliation accounts of the selected entities. If nodes are selected, it shows the reconciliation accounts of all the entities belonging to those nodes, going down recursively to the last level.
The page may show a subset of accounts according to the specific filters set in the page (
).
Entries inserted manually have “INPUT_WEB” indicated as their Origin.
Note: you can configure CCH Tagetik so that entries with different origins are different colours. See Colours by origin option in the .
Icons on this page
| Element | Description |
|---|---|
| Reconciliation accounts cannot be edited. The reason for the lock is reported. | |
| Reconciliation accounts on data that are no longer consistent. For example, the reconciliation account relates to an account or an entity that no longer belongs to the process. The reason for the inconsistency is reported and the reconciliation account can be deleted. |
Page fields
The Additional fields tab is only shown if the Enable additional fields on IC option is not set to “No” in the process’s gross and IC amount rules.
Note: these fields contain information that is necessary for the automatic document relationship procedure, which relates an entity’s IC declarations to a counterparty’s declarations based on information related to the invoice.
| Element | Description |
|---|---|
| General | |
| Scenario | Scenario to which the reconciliation account belongs. You can choose an active original scenario, which you can edit and for which there exists at least one unblocked period belonging to the selected process. |
| Period | Period to which the reconciliation account belongs. You can choose a different period, provided that it is not locked and is linked to the selected scenario. |
| Entity | Entity to which the reconciliation account belongs. You can choose a different entity from the one proposed, provided that it meets the following requirements: - Editable for the user. - Belong to the selected process. - Belong to the selected scenario/period and, on that scenario/period, cannot be an “Only CTP” entity. - Start date and end date, if defined, must be between the start date and end date of the selected scenario/period. |
| IC matching logic | Matching logic in which the reconciliation account is inserted. The chosen logic must belong to the matching logic filters defined on the IC cockpits associated with the selected process. See . |
| Category | Reconciliation account category. The chosen category must meet the following requirements: - Editable by the user. - Belong to the selected process. - Belong to the categories for reconciliation accounts defined on the IC cockpits associated with the selected process. - If the page is opened from the Contributor cockpit, the category type must be “contributor amount” or “contributor entity journal”. - If the page is opened from the Consolidation cockpit, the category type must be “contributor amount”, “consolidator amount”, “contributor entity journal” or “consolidator entity journal”. |
| Account | Account on which the necessary value is inserted to match the two declarations. The chosen account must meet the following requirements: - Enabled for IC management. - Editable for the user. - Linked to the data model process associated with the selected entity. - Start date and end date, if defined, must be between the start date and end date of the selected scenario/period. - Belong to the selected IC matching logic. |
| Custom dimension | For every managed custom dimension, if enabled in the process’s gross and IC amount rules, you can select an element of the custom dimension which meets the following requirements: - Editable for the user. - Visible from the selected entity. - Visible from the selected account. If no value is selected, CCH Tagetik will choose the custom dimension to be the entity’s default custom dimension or the custom dimension with the lowest code from among those which meet the above requirements. The custom dimension 2 is managed even if it is not enabled in the process’s gross and IC amount rules, but the process’s relationship type is “entity - custom dimension 2” or “entity - synthetic custom dimension 2”. |
| CTP entity | An entity can be chosen, provided it meets the following requirements: - Belong to the selected process. - Must belong to the selected scenario/period. - Start date and end date, if present, must be between the start date and end date of the selected scenario/period. You can define a list of most frequently used counterparty entities, see . To use only a subset of entities as counterparties, it may be useful to create a group of counterparties (Dynamic counterparty groups). You can also declare IC data in the context of the same entity (and therefore use the same code for both the entity and the counterparty). This is only possible if the Allow intercompany declarations towards same Declaring entity option is active (Amount & Intercompany rules page). For example, this is useful for eliminating dividends received from group companies towards profits carried forward, or for eliminating self-invoicing results. |
| CTP custom dimension 2 override type | Only present under the following conditions: - Custom dimension 2 is managed. - The process’ relationship type is “entity - custom dimension 2” or “entity - synthetic custom dimension 2”. - The Spreading - Show CTP custom dimension 2 override type option is active in the process’s gross and IC amount rules. - The user’s role contains function 0002274. It can be set as follows: - To allocate - None - Override |
| CTP Custom dimension 2 | Only present under the following conditions: - Custom dimension 2 is managed. - The process’ relationship type is “entity - custom dimension 2” or “entity - synthetic custom dimension 2”. It is only mandatory under the following conditions: - A CTP entity has been specified. The field is only editable if the Spreading - Display CTP custom dimension 2 override type option is active in the process’s gross and IC amount rules, or if that option is active and: - The user’s role contains function 0002274. - CTP custom dimension 2 override type is not “To allocate” If the field is editable, it is defined as the CTP entity’s default custom dimension 2 or, if the Spreading - Show CTP custom dimension 2 override type and Show CTP custom dimension 2 with entity’s default element options are not active in the process’s gross and IC amount rules, the field is defined as the default custom dimension 2 element specified in the custom dimension 2 settings. |
| Row | Indicates the IC cockpit row on which the reconciliation account is shown and must be set according to the following criteria: |
| Company currency | Currency assigned to the entity in the process. Defined automatically and non-editable. |
| Entity currency amount | Amount expressed in the entity currency. Field not editable because it is defined based on the transaction currency amount. If the transaction currency has not been entered or is the same as the entity currency, it is defined as the transaction currency amount. Otherwise, it is defined automatically based on the account’s conversion type. |
| Transaction currency | Transaction currency; if not entered, it is defined as the entity currency. |
| Transaction currency amount | Amount expressed in the transaction currency. Regardless of the number of decimals inserted, amounts are shown with a number of decimals that is consistent with those assigned to the currency in which they are expressed, with the exception of “Other stocks” and “Other variations” accounts where the Manage maximum number of decimals option is active (see ). For these accounts, it is possible to insert up to 9 decimals. |
| Notes | Any explanatory notes. Mandatory if the Mandatory notes when inserting reconciliation accounts option is selected in the process’s gross and IC amount rules. |
| Additional fields | |
| Relationship | Any information on the relationship between an entity’s IC declarations and the counterparty declarations. |
| Invoice number | Document identifier. Used by the automatic document relationship procedure if it has been requested to relate documents which have the same document number. |
| Invoice date | Document date. Used by the automatic document relationship procedure if it has been requested to relate documents which have the same document date. |
| Document Type | Document type: - Document - Bill - Accrual |
| Accounting date | Date on which the document was booked. |
| Sent/received | Indicates whether the document has been sent or received. |
| Invoice matching number | Identifier of the relationship created between an entity’s IC declarations and a counterparty’s declarations. It is generated by the automatic invoices relationship procedure. In some cases, it is not possible to automatically create relationships between IC declarations, for example, if an entity has entered the booking date instead of the invoice date. However, you can relate the IC declaration manually by setting the Invoice matching number field with the same number used in the counterparty entity’s IC declaration. You can also edit an automatic relationship number that has been generated by the system. Note: for the manual relationship, do not use a code that starts with $, as this symbol is used by the system to automatic relationships. |
You can also view certain additional information in the list of reconciliation accounts (
):
| Field | Description |
|---|---|
| Account nature | Nature of the account, which may be: Balance Sheet, Profit & Loss, Order, Other Variation, Other Stocks. |
| Account type | The account type may be: Normal, Variation, Detail. |
| Account attributes | Only if enabled in the Account list settings. Custom attributes that are useful in the reporting step to view information that cannot be managed using the attributes provided in the list. |