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.