Rounding Types A means of formulating checking rules in the rounding function.
Three rounding types are available for formulating checking rules. You can select a rounding type that is suitable to the checking rule you want to use.
This rounding type builds the total for the data records found (according to the selection) and posts the total to the differential accounting object you specify.
For example, you can check that the total assets equals the total liabilities and equity – that is, whether the total of all balance sheet items equals zero.
To do this, you define as selection 1 all balance sheet items, and you determine a differential accounting object that lies within the selection. (For more information about defining a selection, see Single Selection .)
The system builds the total and posts a result – if unequal to zero – to the differential accounting object.
Item |
Transaction Type (TType) |
Value |
Land |
100 (opening balance) |
15 |
Buildings |
100 (opening balance) |
15 |
Equity |
100 (opening balance) |
31- |
Land |
120 (additions) |
2- |
Equity |
120 (additions) |
3 |
Now you can decide whether to record a rounding difference per transaction type.
Option A: Perform rounding for all transaction types and record the difference at a different transaction type.
Selection 1 |
|
Differential Accounting object |
|
In this case, the rounding rule has been fulfilled. Hence, the system does not post anything to the differential accounting object.
Option B: Perform rounding per transaction type
Selection 1 |
|
Differential Accounting object |
|
In this case no transaction type is specified. For selection 1 this results in the following totals, depending on the transaction type:
Selection |
Transaction Type (TType) |
Total for Selection |
Selection 1 |
100 |
1- |
Selection 1 |
120 |
1 |
In this case, the rounding rule is not fulfilled and the system posts the differences with reversed signs to the differential accounting object:
Item |
Transaction Type (TType) |
Value |
Rounding Difference |
100 |
1 |
Rounding Difference |
120 |
1- |
This rounding type adds the values for the two selections and checks if the total is equal to zero.
Example 1:
This rounding type can also be used to check whether the total assets equals the total liabilities and equity.
The initial data is the same as in the previous example. You choose the selections as follows:
Selection 1 |
Item = all assets |
Selection 2 |
Item = all liabilities and equity |
Example 2:
After currency translation, you want to check if the amortization in the balance sheet matches the amortization expense in the income statement.
Initial data:
Item |
TType |
Value in Local Currency (LC) |
Value in Group Currency (GC) Value GC = .5 * Value LC |
Buildings |
220 |
5- |
3- |
Machinery & Equipment |
220 |
3- |
2- |
Amortization Expense |
-- |
8 |
4 |
As selection 1 you choose the asset items, as selection 2 you choose the amortization expense items of the income statement.
You select an expense item as the differential accounting object. This item must be outside of the selection.
The selections and the corresponding totals are illustrated here:
Selection |
Items |
Total for Selection (GC) |
Selection 1 |
Item = asset items |
5- |
Selection 2 |
Item = amortization items in the income statement |
4 |
The system posts the expense of +1 to the differential accounting object.
This rounding type checks if the two selections are equal.
You want to check if two items with different breakdowns have the same value after performing currency translation.
Initial data:
Item |
Partner |
Value in Local Currency (LC) |
Value in Group Currency (GC) Value GC = .5 * Value LC |
Receivables from Affiliates |
A |
1 |
1 |
" |
B |
1 |
1 |
" |
C |
10 |
5 |
Item |
Transaction Currency (TC) |
Value in LC |
Value in GC Value GC = .5 * Value LC |
Statistical Item for Receivables from Trading Partners |
Currency 1 |
8 |
4 |
" |
Currency 2 |
4 |
2 |
The selections and the corresponding totals are illustrated here:
Selection |
Items |
Total for Selection (GC) |
Selection 1 |
Item = Receivables from Trading Partners |
7 |
Selection 2 |
Item = Statistical Item for Receivables from Trading Partners |
6 |
For the differential accounting object you select the statistical item for accounts receivable from trading partners and, for example, transaction currency “Currency 1”. This differential accounting object must be within the selection.
The system posts the difference of 1 to the differential accounting object.