
Account Balancing
Purpose
In the context of the periodic tasks, account balancing is performed at regular intervals for the purpose of account settlement. Account balancing is triggered periodically, in accordance with the entry in the account master. You can set the time periods on the account.
During account balancing, the system performs the following tasks:
Account balancing can take place in a mass run or as an individual balancing for just one account. It is possible to simulate a balancing directly on the account. To simulate balancing runs, choose Periodic Tasks ® Account Balancing ® New Run ® Single or Mass Run and in the process flow control on the next screen, choose simulation on the next date. To learn how account balancing fits in to end of day processing or the connection with other periodic tasks, refer to the
Process Flow of End of Day Processing.As an alternative to standard updating, it is also possible to make balancing postings to another account, known as the reference account. The reference account can be both in another bank area in the current account system as well as with another bank outside the current account system. On this subject, see also
Creation of a Reference Account for Balancing.Prerequisites
Before you can perform account balancing, you must have maintained the account balancing data. To find out how to do this, read
Maintaining Balancing Data.Conditions must be assigned to every account that is to be balanced. You can assign standard or individual conditions to an account. To find out how to do this, read
Assigning a Conditions Group to an Account. Assigning Individual Conditions to an AccountIn addition you need to set the required transaction types in the Implementation Guide (IMG) by choosing Account Management ® Assign Posting Categories to Transaction Types.
Postings within a balancing are made with the end date of the period to be balanced as value date and the "Posting date - balancing postings" defined in the system as posting date. (On setting the posting date, refer to
Setting the Posting Date)In the current account system we differentiate between the posting date of payment transactions and the posting date of the balancing. Once the date has been increased and the postings of payment transactions are completed, you can execute a balancing. This means that the posting date of the balancing is before the posting date of payment transactions.
Once the posting date for the balancing is set, the following possibilities result for an account:
Process flow of interest and charge calculation
1. Selection of the accounts
Accounts are selected for the calculation of interest and charges according to bank area, balancing type, balancing (interest and charges) and balancing date.
The following accounts are selected:
Example
Assuming the balancing date of an account is June 30 and this account is to be closed from July 2. The date on which closure actually takes place is July 5. Balancing up to June 30 takes place for this account as usual. For the period between June 30 and July 2, you must trigger a separate run for the account that is to be closed. If the run is to take place on July 5, the balancing for the account that is to be closed must take place explicitly as single run. If processing is not urgent, balancing can take place automatically on the next day ( in this case, July 6) per mass run.
2. Dispatching and parallel processing of the process flow
The accounts are divided into intervals and these account intervals are distributed to various processors or servers. You can set the size of the intervals in the Implementation Guide by choosing Periodic Tasks ® Parallel Processing. The account number serves as criterion for this.
3. Processing
The following processing steps in the various areas are performed for each "due" account:

In connection with the balancing date and posting date of the transactions, nine possibilities for calculating the interest and charges result.

The following table shows the possible combination of value and posting date and how they are considered during settlement. As an example, February is the period to be settled, January is the period already settled and March is the following period.
You can derive the following from the above graphic:
|
Dates |
Interest calculation |
Charge calculation |
|
1 Posting date and value date are the same, in this case Jan. 2. |
No The period is balanced and will not be adjusted. |
No The period is balanced and will not be adjusted. |
|
2 Posting date is Jan. 2 and value date is Feb. 5. (value date in the future at last settlement) |
Yes Interest occurs in the period to be settled - February |
No Charges are levied when the item is posted, in this case, January. |
|
3 Posting date is Jan. 2 and value date is Mar. 3. |
No (Reason: Interest will be calculated at the next settlement.) |
No (Reason: Charges already calculated at the last settlement.) |
|
4 Posting date is Feb. 5 and value date is Jan. 3. (Value date in the past) |
Yes The period will be recalculated. |
Yes Charges are levied when the item is posted, in this case in the period to be settled - February. |
|
5 Posting date is Feb. 5 and value date is Feb. 6. (Normal case) |
Yes |
Yes |
|
6 Posting date is Feb. 5 and value date is Mar. 4. (Value date in the future) |
No (Reason: Interest will be calculated at the next settlement.) |
Yes Item charges incur that are levied in this current period. |
|
7 Posting date is Mar. 5 and value date is Jan. 4. |
No (value dates in the past already known for the next settlement are not included, as interest calculation then dependent on time of settlement) |
No (Reason: Charges will be included at the next settlement) |
|
8 Posting date is Mar. 5. and value date is Feb. 7. |
No |
No |
|
9 Posting date is Mar. 5 and value date is Mar. 5. |
No |
No |
Interest income tax:
Calculation of the interest income tax is performed by a separate, customer-own module that is called up by means of an Event (Business Transaction Event). Calculation of interest income tax can take place both in batch and online mode. Only those accounts with credit interest and/or the indicator "Relevant for interest income tax" on the account are transferred.
If interest income tax is to be calculated for adjustment periods, the current account system transfers the total interest. In this connection, total interest means that all the interest from the adjusted period is transferred and not just the difference. In the example explained below, the total interest amounts to 12 DM. However, for further processing after calculation of the income tax by the interest income tax module, the current account system expects the amount of the difference.
Interest income tax module in online mode
The processing of the interest for interest income tax in online mode with the user-defined interest income tax module is equivalent to a processing step between different systems with no interruption. Following are details of the steps each interval passes through:
Error handling:
If an error occurs during editing in online mode, the current account system terminates the processing. Once the error has been remedied, you must restart account balancing. Choose Periodic Tasks ® Account Balancing ® Restart.
Interest income tax module in batch mode
The processing of interest in batch mode is different from online mode in as far as it takes place in systems independent of one another. Each interval passes through the following steps:
Error handling
Interest income tax and euro
After the changeover of the account, all items from balancing are posted in euro - including those for periods ending before the changeover key date (value dates in the past). For periods after the changeover key date, the amounts transferred back from the interest income tax interface are in euro currency. If, however, a period that lies before the currency changeover date is recalculated, interest income tax adjustments can be transferred back to the current account system both in euro and in DEM.

If you are using SAP FI, the interest is transferred from the current account system to the interest income tax module in local currency, too. If your interest income tax module only recognizes the local currency as currency, you can define the company code in the bank area. If the currencies do not match, the current account system converts the currencies, provided the currency involved is one participating in euro changeover. The euro is handled like a participating currency.
Adjustment postings from periods already calculated.
Value dates in the past are postings from the current settlement period whose value date lies in a period already settled. Value dates in the past can occur in any prior period. The entire period is recalculated, with the inclusion of the value dates in the past. The result is compared with the interest of the last settlement. The difference is identified in the current balancing as adjustment from value dates in the past.
If there is a value date in the past on the last day of a previous period, this amount is not posted in the balancing balance of the previous period. This day counts as the first day of a new period. Value dates on the last day of a period do not lead to the adjustment of a period, as interest is calculated for the last day in the previous period.
In the case of value dates in the past, the balancing balance of the period to be adjusted depends on the posting date of the adjustment period. We distinguish between three cases:
|
If |
Then |
|
Posting date in the adjustment period |
Adjustment posting in the balancing balance Example: January is the adjustment period. If the posting date is Jan. 23, the adjustment posting is contained in the balancing balance for January. The adjustment of the balancing balance takes place in February’s balancing. |
|
Posting date after the adjustment period but before or on the next deadline |
Adjustment posting in the next balancing Example: January is the adjustment period. If the posting date is Feb. 5, the adjustment posting is NOT contained in the balancing for January but for February. |
|
Posting date is after the next deadline |
Adjustment posting in the next but one balancing Example: January is the adjustment period. If the posting date is Mar. 17, the adjustment posting is contained neither in January nor in February. It is not contained in the balancing balance until March, as soon as this is settled. |
Example: Current period - February, adjustment period - January
Interest adjustment to a period already settled
Value dating describes the key date-related value date of an account balance or of an item on a customer account. On the value date, interest calculation starts for the changed balance resulting from an incoming or outgoing payment. If there is value dating to the past to a balanced period, the credit and debit interest and the overdraft interest for the balanced period has to be recalculated.
Value dates in the past in periods already settled lead to the following results:
|
Calculated credit interest was too high |
Minus credit interest (account is debited) |
|
Calculated credit interest was too low |
Plus credit interest (account receives credit) |
|
Calculated debit interest was too high |
Minus debit interest (account receives credit) |
|
Calculated debit interest was too low |
Plus debit interest (account is debited) |
|
Calculated overdraft interest was too high |
Minus overdraft interest (account receives credit) |
|
Calculated overdraft interest was too low |
Plus overdraft interest (account is debited) |
The value date of the adjustment posting with the newly calculated interest corresponds to the end date of the adjustment period.
Example:
Period 1 was balanced with credit interest amounting to 10 DEM. A value dating in the past results in new credit interest amounting to 12 DEM. The 2 DEM difference is not adjusted when the value date in the past is posted, but at the next balancing of period 2. This means that period 1 is recalculated in period 2 and the customer receives 2 DEM plus credit interest.
Result
If the balancing has been completed successfully, the account balancing is posted. You can take a look at the balance and also the turnovers, interest and charges on the bank statement.
The results of the balancing are transferred to the general ledger. The customer account is updated.