
Balances & Totals
Use
You use this function when you want to set up deductions so that a specified total amount is deducted in equal installments over several periods. You can use it, for example, to easily set up interest-free loans for your employees.
Scope of Function
To set up a deduction in the system that is valid over several payroll periods, you generally create a record in the infotype Recurring Payments/Deductions (0014). If you want the individual deductions to add up exactly to a specified total amount you must choose the validity period for this infotype record so that the sum of the partial amounts corresponds to the total amount. This procedure can not only require considerable maintenance, but is also prone to errors if, for example, one of the following occurs:
In these cases it is not established from the start how long the infotype record must be valid for in order that the total amount can be completely deducted. You can use the balances & totals function to ensure that the required total amount is deducted in full.
To do this you link three wage types in Customizing for Payroll under Deductions ® Wage Types for Deductions With Balances and Totals.
You create a record for the infotype Recurring Payments/Deductions (0014). This record contains the partial amount that is to be deducted per payroll period. The end date of this record can extend far into the future.
The balance wage type is the required total amount that is to be reached by the individual deductions in the infotype Recurring Payments/Deduction (0014). You create this wage type in the infotype Additional Payment (0015). The validity date for this record lies in the payroll period in which the payments will start. With each deduction in the individual periods the amount of this balance wage type is reduced during payroll.
The system creates the totals wage type during the payroll run. This wage type contains the total amount that has already been deducted in the previous periods, this means the total of the individual deductions in the infotype Recurring Payments/Deductions (0014) up to the current period. You can not enter this wage type using an infotype.
Deductions are withheld during payroll runs until the total amount has been reached. If necessary, the deduction is reduced in the last period to the amount that is still outstanding. In all subsequent periods nothing will be deducted, even if the record in the infotype Recurring Payments/Deductions (0014) is still valid.
All three wage types (deduction, balance and total) are stored for each period in the RT table.
Example
A total amount of USD 250 should be deducted by USD 50 per period.. The following graphic describes the interaction of the wage types during several periods:

The record of the infotype Recurring Payments/Deductions (0014) creates a deduction in each payroll period of USD 50. The balance wage type decreases from the starting amount of USD 250 by USD 50 for each deduction until it has decreased to zero in period 05. The totals wage type increases simultaneously per payroll period by USD 50 and adds up, therefore, to USD 250 in period 05. In the subsequent periods the system does not deduct anything.
See also:
Arrears Processing for Deductions
Limits for Deductions