Start of Content Area

Function documentation Account Determination and Offsetting Entry

Use

You use this function to attain balanced financial statements not only for actual data, but also for plan data. The function for account determination enables you to post to accounts in accordance with the requirements of double-entry accounting. The function serves the clearing of debit and credit items and the clearing of assets and liabilities and owner's equity, by generating the corresponding offsetting entry in accordance with the valid chart of accounts to an account-related posting that has already been entered.

Prerequisites

In order to be able to use this function, a chart of accounts must be maintained in the system that contains the data basis for your planning. In addition you must include a characteristic in the planning level, through which you can access the accounts of the chart of accounts.

Features

When creating a planning function for generating offsetting entries, select the characteristic that determines the account. In addition to that, you can select condition fields whose values are used for calculating the respective offsetting account. In any case, you must add the generic entry "key figure name" to the list of condition fields.

In the parameter groups for the planning function, first you define your conditions under which the function offsetting entry should be generated. For this you assign concrete characteristic values to the selected condition fields. In the simplest case, you merely define the key figure for whose values you want to generate offsetting entries. You then assign a rule to each such record of conditions, in which you enter the corresponding offsetting account, for every account for which key figure values were already posted.

When executing the function with the configured parameter group, the system generates a further data record for every data record that has already been entered, that contains the particular offsetting account of the original data record. In addition in all newly generated data records, the key figure value is inverted from the original data record (reversed debit/credit sign).

The following example shows how an automatic offsetting entry is generated, to different data records that were posted in connection with achieved sales (displayed in blue in the column "to account" with the amount belonging to it). The accounts used are:

800000: net sales
110000: bank

140000: domestic receivables
142000: foreign receivables

Country

From Account

Amount

To Account

Amount

Currency

49

800000

–800.00

140000

800.00

1

800000

–400.00

142000

400.00

$

49

110000

800.00

140000

–800.00

1

110000

400.00

142000

–400.00

$

Balance:

 

0.00

 

0.00

 

The final balance row shows that the amounts add up to 0.00 on both sides.