Transactions Data Entry Detail – Cons. Expenditure / Revenue

Note: Currently, you can specify transaction currency balances either on the Transactions Data Entry Detail – Cons. Expenditure / Revenue or Intercompany Matching Detail Consolidation Expenditure/Revenue page. On the Intercompany Matching Detail Consolidation Expenditure/Revenue page, click a value in theGroup Currency (currency ISO code) column for a specific account and specify the values in the displayed dialog box.

Use this page to reconcile an entity and intercompany account balances in a transaction currency. To enable reconciliation, both the entity and intercompany must use a transaction currency.

You can access this page by clicking the account balance difference on the Intercompany Matching Detail Consolidation Expenditure/Revenue page.

The data grid shows consolidation expenditure and revenue-related entity account balance and contra, intercompany account balance for the selected consolidation process and level.

An entity accountant can verify values in the entity and intercompany account sections, but they can specify values only for the entity for which they are responsible. To specify values manually, an entity accountant must select the HB I manual (Data Entry Manual) level in the context. Values in the intercompany section are read-only. The values are displayed in applicable currencies for these currency types:

  • Transaction currency
  • Group currency: Converted from transaction currency
  • Local currency
  • Group currency: Converted from local currency

To reconcile the above-the-threshold difference in the entity and intercompany account balances, an entity accountant who is responsible for the entity must specify relevant values in a transaction currency for the applicable currencies. An entity accountant who is responsible for the intercompany must do the same in the contra, intercompany account. Only then is the reconciliation process complete and finished. An entity accountant can also specify values in local currencies, but this is only for informational purposes and does not affect any data.

Transaction currency values are automatically converted into group currency values by closing rates that are maintained as standard rates. Rate types of different currency methods that are assigned to specific accounts are not considered in this conversion.

To facilitate reconciliation between the entity and intercompany, in the Currency column, entity accountants can select specific currencies and filter accounts for which to specify transaction values.

Caution: 
To delete a specified value from the database, you must press Ctrl + Del or specify #delete in an appropriate grid cell. If you specify 0 or press Del, then 0 is written back in the cube. This causes incorrect calculations of the Currency Translation Differences and Other Differences accounts.