Rounding Types

Definition

A means of formulating checking rules in the rounding function.

Use

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.

Structure

1. Rounding type: Selection 1 = 0

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

  • Item = all balance sheet items (incl. the item for the rounding difference)

Differential Accounting object

  • Item = the rounding difference

  • TType = 150

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

  • Item = all balance sheet items (incl. the item for the rounding difference)

Differential Accounting object

  • Item = the rounding difference

  • (TType is not applicable)

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-

2. Rounding type: Selection 1 + Selection 2 = 0

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.

3. Rounding type: Selection 1 = Selection 2

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.