Splitting of Differences in Subsequent Periods 
As described in
Elimination Rules, it is possible to separate differences resulting from elimination caused by currency translation from those caused by other factors. In this case, you should observe the following points:Exchange Rate Changes
The Carry-forward Balances program generally carries forward data you have entered and consolidation postings you have made into the new fiscal year. If the exchange rate changes in the new fiscal year, the total difference is incorrectly split in the subsequent consolidation.
The following example illustrates this point:
In fiscal year 01 accounts receivable and payable between two subsidiary companies are eliminated. The data is transferred into fiscal year 02 by the Carry-forward Balances program. The exchange rate from FRF to DEM changes from 0.4 to 0.5 in fiscal year 02.
Fiscal year 01 / Exchange rate 0.4
Item / Level |
TC |
LC |
GC |
Accounts receivable / 0 |
1,000 FRF |
300 DEM |
300 DEM |
Accounts payable / 0 |
1,200- FRF |
1,200- FRF |
480- DEM |
Breakdown of differences:
Total difference (TD) |
= |
180- |
Other Difference (OD) |
= |
80- |
Currency Translation Difference (CD) |
= |
100- |
This difference split is calculated as follows: the system reads the consolidated values in the elimination set of accounts receivable and payable and determines a difference of 180- DEM. In order to determine which amount is caused by exchange rates and which amount by other reasons, the system reads all amounts in transaction currency in the elimination set and checks these for differences. If the system finds differences in transaction currency, it reports them as Other Differences (translated into the group currency). In the above example, the system finds differences of 200- FRF. It translates this amount using the exchange rate 0.4 and reports Other Differences of 80- DEM. The balance of the total difference of 180- DEM is 100- DEM, representing the differences caused by currency translation.
Consolidation entries
Item / Level |
TC |
LC |
GC |
Accounts receivable / 2 |
1,000- FRF |
- |
300- DEM |
Accounts payable / 2 |
1,200 FRF |
- |
480 DEM |
Other Differences / 2 |
200- FRF |
- |
80- DEM |
Currency Translation Difference / 2 |
0 FRF |
- |
100- DEM |
After balances are carried forward into the new fiscal year, the values are as follows:
Fiscal year 02 / Exchange rate 0.5
Item / Level |
TC |
LC |
GC |
Accounts receivable / 0 |
1,000 FRF |
300 DEM |
300 DEM |
Accounts receivable / 2 |
1,000- FRF |
- |
300- DEM |
Accounts payable / 0 |
1,200- FRF |
1,200- FRF |
600- DEM |
Accounts payable / 2 |
1,200 FRF |
- |
480 DEM |
Other Differences / 2 |
200- FRF |
- |
80- DEM |
Currency Translation Difference / 2 |
0 FRF |
- |
100- DEM |
Breakdown of differences: (resulting from eliminating entries in fiscal year 02)
Total difference |
= |
120- DEM |
Other Difference |
= |
0 DEM |
Currency translation difference |
= |
120- DEM |
This difference split is calculated as follows: the system reads the consolidated values in the elimination set of accounts payable and receivable and determines a difference of 120- DEM. The system cannot find any differences relating to the amounts in transaction currency in the elimination set and therefore reports the difference of 120- DEM as being fully caused by currency translation.
Together with the differences from the balances carried forward from fiscal year 01, the sum totals of the differences reported are as follows:
Sum total of differences:
Total difference |
= |
300- DEM |
Other Difference |
= |
80- DEM |
Currency translation difference |
= |
220- DEM |
Splitting differences correctly:
With a exchange rate of 0.5, Other Differences of 100- DEM and currency translation differences of 200- DEM have to be reported:
You can solve the problem of incorrectly split differences as follows: in the subsequent year you reverse the corresponding IC elimination entries relating to fiscal year 01 and you then repeat the IC eliminations. To do this, you can select a document type which in the subsequent year automatically reverses entries already carried out. Also see the explanations in Document Types.
This problem not only arises when eliminating entries are carried forward into a new fiscal year. It also occurs in the following two cases:
If the exchange rate changes from the previous period, once again the differences resulting from elimination are not split correctly.
Changing Over to Splitting of Differences
When you change over from IC elimination without currency splits in one fiscal year to IC elimination with currency split in the next fiscal year, then the difference split of the previous year is run within the current year. If the elimination differences are stated on the income statement, the net income for the present year will be influenced by transactions that are causally applicable to the previous year.
The following example illustrates this:
In fiscal year 01 the accounts receivable and payable between two subsidiary companies are eliminated. The carry-forward balance program carries forward the data into fiscal year 02. The exchange rate from FRF into DEM is 0.5. In FY 02 intercompany elimination occurs with splitting of differences.
Fiscal Year 01
Item / Level |
TC |
LC |
GC |
Accounts Receivable / 0 |
200 FRF |
100 DEM | |
Accounts Payable / 0 |
100- DEM |
100- DEM | |
Accounts Receivable / 2 |
100- DEM | ||
Accounts Payable / 2 |
100 DEM |
Fiscal Year 02 (transaction currency values are accounted for)
Item / Level |
TC |
LC |
GC |
Accounts Receivable / 0 |
80 DEM |
200 FRF |
100 DEM |
Accounts Payable / 0 |
100- DEM |
100- DEM |
100- DEM |
Accounts Receivable / 2 |
100- DEM | ||
Accounts Payable / 2 |
100 DEM |
In FY 02 the system discovers a transaction currency difference of DEM -20. Since no difference in group currency exists, the system reports Other Differences of DEM -20 and Currency Translation Differences of DEM 20. These group currency values balance to 0.
Consolidation Entries
Item / Level |
TC |
LC |
GC |
Accounts Receivable / 2 |
80- DEM |
||
Accounts Payable / 2 |
100 DEM |
||
Other Difference / 2 |
20- DEM |
20- DEM | |
Currency Translation Difference / 2 |
0 DEM |
20 DEM |
These differences would have been reported for fiscal year 01, if splitting of differences had been set.
If the Other Difference and/or Currency Translation Difference are reported on the income statement, then the annual net income for FY 02 is manipulated by a transaction that applies to FY 01. In order to remedy this, the IC elimination for the FY 01 values must be performed once more in period 01 of FY 02 with the difference split; and the differences must be cleared against unappropriated retained earnings.

You need to perform the following steps when you change over to splitting of differences: