Page tree
Go to start of banner

RTI Reporting – Calculation of RTI Net Deductions in Single Employment Scenario

Purpose:

The purpose of this Wiki is to understand how RTI Net deductions is calculated for a normal scenario

Overview:

To know more about this behavior, we must first review the necessary information, and then know how to reproduce it.

1. Obtaining the necessary information:

For replicating the above scenario, ensure that GBRTI payroll function in the feature GBCHG should have RTI solution active for the payroll area under which employee was hired.

2. Reproducing the behavior:

Now the employee is hired from 01.04.2013 in the payroll area G1.

Maintain the IT0009 (bank details) infotype as below  :

Main Bank

Other Bank

After this, live payroll was run for the month of April 2013 i.e. period 1 2013 in RPCALCG0 report for this employee which will create RTI table in the payroll cluster of the employee. Exit the payroll in PA03.

Please refer below screenshot from payroll cluster of the employee showing the payroll results of period 1 2013 (April 2013)

BELOW TABLE SHOWS RT TABLE VALUES

BELOW TABLE SHOWS BT TABLE VALUES

BELOW TABLE SHOWS RTI TABLE VALUES

2. How calculations take place (Formula):

Calculation of RTI Net Pay in the RTI table is as per the below formula :

RTI NET DEDUCTIONS =  /CD1 + /CD2 + /CO1 + /CO4 - /110 + payment to other bank (lower value – in case of more than 1 bank accounts) + /176 + GAYE (/178) + DPFH + /563 + /Z10

In above scenario:

/CO1 - /110 + payment to other bank (lower value – in case of more than 1 bank accounts) + GAYE (/178)

212.00 - (-100) + 1240.11 + (- 100) = 1452.11

• No labels