Calculation of Balances 
The following provides examples for the different methods of calculating balances in Account Management.
For more information see Account Balance in the SAP Library.
Scenario
An account has the following turnovers (in EUR) between June 1, 2003 and 10.06.03:
Date |
Debit |
Credit |
Total |
01.06.2003 |
0 |
0 |
0 |
02.06.2003 |
100 |
0 |
100 |
03.06.2003 |
500 |
0 |
500 |
04.06.2003 |
0 |
0 |
0 |
05.06.2003 |
0 |
-200 |
-200 |
06.06.2003 |
0 |
-500 |
-500 |
07.06.2003 |
0 |
0 |
0 |
08.06.2003 |
200 |
0 |
200 |
09.06.2003 |
0 |
0 |
0 |
10.06.2003 |
0 |
0 |
0 |
Calculation Examples
Period balance
The period balance includes only the turnovers between June 1, 2003 and June 10, 2003.
Graphic Display
Calculation
|
Total |
Minimum |
Maximum |
Average |
Credit balance |
-200 |
0 |
-100 |
-22.22 |
Debit balance |
2000 |
0 |
600 |
211.11 |
Total balance |
1800 |
600 |
-100 |
188.89 |
Aggregated balance
The aggregated balance includes the turnovers from June 1, 2003 to June 10, 2003 as well as the carryforward balance from the previous period (-200 EUR).
Graphic display
Calculation
|
Total |
Minimum |
Maximum |
Average |
Credit balance |
-1200 |
-100 |
-300 |
-122.22 |
Debit balance |
1000 |
200 |
400 |
111.11 |
Total balance |
-200 |
400 |
-300 |
-11.11 |
Turnover
Graphic display
Calculation
|
Total |
Minimum |
Maximum |
Average |
Credit balance |
-700 |
0 |
-500 |
-133.33 |
Debit balance |
800 |
0 |
500 |
166.67 |
Total balance |
100 |
500 |
-500 |
33.33 |
Notes on Calculation
Balance category
When you select the balance category, you can choose to either calculate all or pat of the balances:
· Full balance: The system takes into account the entire diagram in the calculation.
· Credit balance: The system takes into account the credit side only for the calculation.
· Debit balance: The system takes into account the debit side only for the calculation.
Balancing Method
· Total
The system calculates the total of the balances for the required period of time. This is the same as the selected areas on the graphic.
· Minimum
The system calculates the smallest value in the graphic.
The system analyzes absolute values for the Debit Balance balance category, and calculates the smallest value.
The minimum debit or credit amount is zero if the balance was zero on at least one day, or was never a debit or credit balance.
· Maximum
The system calculates the largest value in the graphic.
The system analyzes absolute values for the Debit Balance balance category, and calculates the largest value.
The maximum debit or credit amount is zero if the balance was neither a debit nor a credit balance on any day.
· Average
The system
calculates the average value in the graphic.
You can also select the following parameters for debit or credit
balances:
¡ Period category
§ Whole period: The system takes into account all the days of the query period for the calculation.
§ Effective days: The system takes into account only the days that the balance was either a debit or credit balance for the calculation.
If you leave these two parameters out, then the average is the quotient of the balance total and the number of days in the requested time period.