Prerequisites
In your enterprise, payroll takes place on a monthly basis. You have created a loan for an employee with the following data:
Loan type |
Building loan with payment by installments |
Loan amount paid out |
10,000 euro |
Loan payment |
January 10 of the current year |
Repayment start date |
May 01 of the current year |
Repayment installment |
300 euro each month |
The following values are stored in Customizing for the loan type Building loan with repayment installment:
Debit interest |
5 % |
Interest calculation frequency |
First period: 03 |
|
Interval: 03 | |
Repayment frequency |
First period: 03 |
|
Interval: 03 |
The interest for this loan is thus due in the months of March, June, September, and December.
The repayment installment for the loan type Building loan with installment repayment is also due in the months of March, June, September and December. However, the employee must only pay the first repayment installment for the loan on hand in June, as you specified May 01 as the start of repayment date. June is the first month, in which a repayment installment is due for the repayment pattern for this loan type after the start of repayment date on May 01.
Interest Calculation

Interest is calculated for each payroll period and stored in the Interest for current period wage type (/LIM). If interest is not due in the previous payroll period, it is cumulated in the Cumulated interest wage type (/LIC) until the next due date. When the interest is due, the Cumulated interest wage type (/LIC) is converted to the Interest due wage type (/LID).
In the example, the loan is paid out on January 10 of the current year. This means that only 21 days of interest accrue in this month. For the first payroll period, interest of 10,000 x 0.05 x 21 / 360 = 29.17 euro accrues (10,000 euro balance, 5% interest, 21 days interest, 360 days per year).
For the remaining periods up to the first repayment, interest of 10,000 x 0.05 x 30 / 360 = 41.67 euro accrues (10,000 euro balance, 5% interest, 30 days interest, 360 days per year).
The interest per payroll period is cumulated and due at an interval of 3 periods.
Wage Types
The following loan wage types arise for the first six payroll periods:
Period |
Wage type |
Wage type text |
Amount |
Explanation |
Period 01 |
/LIC |
Cumulated interest |
29.17 |
|
(January) |
/LIM |
Interest for current period |
29.17 |
21 days |
|
/LLB |
Loan balance |
10,000 |
||
|
/LOE |
External loan payment |
10,000 |
||
Period 02 |
/LIC |
Cumulated interest |
70.84 |
|
(February) |
/LIM |
Interest for current period |
41.67 |
|
|
/LLB |
Loan balance |
10,000 |
||
Period 03 |
/LID |
Interest due |
112.51 |
|
(March) |
/LIM |
Interest for current period |
41.67 |
|
|
/LLB |
Loan balance |
10,000 |
||
Period 04 |
/LIC |
Cumulated interest |
41.67 |
|
(April) |
/LIM |
Interest for current period |
41.67 |
|
|
/LLB |
Loan balance |
10,000 |
||
Period 05 |
/LIC |
Cumulated interest |
84.34 |
|
(May) |
/LIM |
Interest for current period |
41.67 |
|
|
/LLB |
Loan balance |
10,000 |
||
Period 06 |
/LID |
Interest due |
125.01 |
|
(June) |
/LIM |
Interest for current period |
41.67 |
|
|
/LLB |
Loan balance |
9,700 |
||
|
/LRP |
Regular repayment |
300 |