Reconciliation with Applications Supplying Data
Features
During the changeover of local currency in the Consolidation application, data is reconciled with that of other SAP applications in the same system that supply Consolidation with data. Preparatory reconciliations are also required during the central changeover.
If you only change over reporting currencies in Consolidation (without a prior central changeover using the standard package), no specific reconciliations are required with applications that supply Consolidation with data. Any differences in the data of companies that supply data in reporting currency are only corrected during the next closing.
Reconciliation takes place if the following conditions are given:
Supplying applications have performed their own reconciliations and transferred correct carryforward values.
As a result of the above, the total value in the totals database differs from the value transferred from other systems, and therefore must be adjusted.
However, totals records are often more detailed in the Consolidation application than in the supplying applications, for example if realtime updating is used. In this case, the large majority of additional account assignments in Consolidation are retained and only the differences in comparison with the total value supplied by other applications are posted.
Reconciliation with other SAP systems does not occur at the same time as the euro changeover in your own system. Any differences in balance carryforward values must be taken into account until the next closing, when they are reversed by (cumulative) reported data.
Data in the PC offline data entry program are not reconcile. For more information, see the section Scenario when Using Offline Data Entry .
Reconciliation of the consolidation staging ledger with the general ledger and subsidiary ledgers
You need to perform this reconciliation when using periodic extracts or realtime updating. To do this, you use the program RGCEUR50 .
If you use periodic extracts, the system reconciles the carryforward balances in the consolidation staging ledger (totals table GLT3) with the following ledgers during post-processing for the central changeover:
General ledger (totals table GLT0) on account level
Subsidiary ledgers (FI-AR, FI-AP, FI-AA) at the level of transaction type and partner, if you specified this during preparation for the central changeover
Reconciliation takes place in local currency.
If you use realtime update, carryforward balances are generated in the consolidation staging ledger during post-processing of the central changeover (if you specified reconciliation at a transaction type and partner level during preparation for the central changeover).
In principle, carryforward balances are also generated as a result of the reconciliation between the consolidation staging ledger and the general and subsidiary ledgers. The balances of the general and subsidiary ledgers are determined and posted to the staging ledger as the total difference. Carryforward balances are therefore reconciled at all levels of detail with the general and subsidiary ledgers before it is written to the consolidation staging ledger.
Reconciliation with Asset Accounting (FI-AA)
Asset Accounting supplies data with company code, business area, and account information. Each account is identified as an acquisition and production cost (APC) account or accumulated depreciation account. In Customizing, you can define one transaction type for each of these accounts so that the consolidation staging ledger can be reconciled on account/transaction type level. If necessary, adjustment records are generated for the staging ledger.
If records exist in the staging ledger with transaction types other than space, APC or accumulated depreciation, the relevant account is not reconciled on transaction type level.
For more information about other account assignments in the adjustment record, see the section
Further breakdown information in the consolidation staging ledger
.
Reconciliation with open items (FI-AR, FI-AP)
For each company code, business area and account, the subsidiary ledgers supply a breakdown of the balance carryforward value by trading partner and transaction currency.
Reconciliation takes place on this level of detail, and an adjustment entry is generated for the consolidation staging ledger if required.
For more information about other account assignments in the adjustment record, see the section
Further breakdown information in the consolidation staging ledger
.
Reconciliation with general ledger (FI-GL)
General Ledger Accounting supplies balance carryforward values for each company code, business area, account, and (partially) transaction currency.
Reconciliation takes place on this level of detail, and an adjustment entry is generated for the consolidation staging ledger if required.
For more information about other account assignments in the adjustment record, see the section
Further breakdown information in the consolidation staging ledger
.
Further breakdown information in the consolidation staging ledger
In the consolidation staging ledger, some breakdown information may not be reconcilable with the general ledger and subsidiary ledgers.
Example
In General Ledger Accounting, an entry with transaction type assignments is posted against a provisions account.
In the consolidation staging ledger, the transaction types assignments in entries are posted to the account. They are not, however, posted to the general ledger, because in General Ledger Accounting they are required in documents for informational purposes only.
In this case, the breakdown information exists in the staging ledger, but cannot be reconciled with the general ledger or subsidiary ledgers.
The following is an overview of standard account assignments that are used for adjustment records in the above cases:
Breakdown |
Account assignment |
Transaction type |
Standard value (defined in changeover Customizing) |
Trading partner |
999999 |
Period of acquisition |
012 |
Year of acquisition |
Year prior to changeover |
Trading partner business area |
‘Space’ if not identical in all staging ledger records |
Note
For the purposes of documentation, adjusting entries posted by the program RGCEUR50 are saved in version EUR as well as version 001.
Reconciliation between the consolidation staging ledger and data supplied by other applications (in the case of realtime update)
You need to perform this reconciliation when using realtime updating. To do this, you use the program FICEUR20 .
Reconciliation takes place during post-processing for the changeover of the Consolidation application.
If you want to reconcile integrated data at the level of items only, and specified this during the preparation for the central changeover, the program FICEUR20 reconciles consolidation data with the general ledger on an item level.
However, if you specified reconciliation of integrated data at the level of transaction type or partner, a carryforward balance is generated in the consolidation staging ledger from the general and subsidiary ledgers during postprocessing (program RGCEUR50 mentioned above). In this case, the program FICEUR20 reconciles consolidation data with the consolidation staging ledger.
The carryforward balance of the consolidation staging ledger is compared and reconciled with the carryforward in the converted Consolidation totals database, after the following conversions have been made:
Accounts to financial statement items
Transaction types to subitems
Company codes to companies
Company codes/business areas to consolidation units
and so on
Reconciliation takes place per item, and depends on the item’s breakdown indicator:
Subitems are reconciled if both of the following apply:
You specified reconciliation on a transaction type level during the preparation for the central changeover, and the item has the appropriate breakdown indicator.
Transaction types or subitems contained in the converted extract are identical to those for consolidation totals records for the individual items.
In this case, an adjustment entry is posted for each subitem if the balance is other than 0 (zero).
If no reconciliation takes place on subitem level but instead by partner, and the item supports a breakdown by partner, reconciliation takes place for each partner unit, and transaction currency, and an adjustment entry is posted if required.
However, this procedure does not apply for those partners in the carryforward balance in the consolidation staging ledger, which are used as additional account assignments in the consolidation processing ledger records that are compared.
If a reconciliation does not take place due to the conditions mentioned above, it is automatically started for transaction currencies if the appropriate breakdown indicator is set.
If a reconciliation not take place due to the conditions mentioned above, it is automatically started for years/periods of acquisition if the appropriate breakdown indicator is set.
If a reconciliation not take place due to the conditions mentioned above, the converted value only is entered in the consolidation database.
Breakdowns not reconciled according to any of the above conditions (for example a combination of partner and transaction type breakdowns) are allocated account assignments in the adjustment entry as follows:
If a single account assignment is used for an account in Consolidation, this assignment is also posted in the adjustment entry.
In the case of multiple account assignments, the following account assignments are used:
Breakdown
Account assignment
Subitem
Standard value (defined in euro Customizing)
Partner unit
9999* (number of 9s reflects the length of the consolidation unit ID in the dimension)
Period of acquisition
012
Year of acquisition
Year prior to changeover
The differential records are allocated posting level ‘space’.
The document type
EU
is set for all adjustment records to identify them as the result of reconciliation. However, no journal entries are generated.This additional information is automatically removed after the first carryforward of balances after the changeover.