NI values in RT and RTINI table are not matching

[Former Member]

Hi all,

We have recently went live with RTI.  It is observed that for few employees, the value in RT for /301 and /302 are not matching with RTINI table and hence with FPS also.

in our further observation, it is found that we have some mid month leavers of previous period and in few cases, it is change in NI category with effective april 2013 from A to C.

we have checked the online answers for this kind of scenarios and they suggest to correct the NI values through DTONI table.  But the above said scenarios are so generic and might appear every month. 

Is there any way that we can values of RT /301 and /302 matches with RTINI values? this will allow the FPS report to appear right values when compared to RT/ Payslip/WTR?.

Thanks in advance

Veena.

[jayantvenkata]

Hello Veena

Can you please check incase the values in NIC/CNIC tables match with that of the RTINI for the Niable pay this period, Niable pay YTD, ee/er nic tp,and EE/ER NIC YTD.

For this period values in RTINI, please check them with NIC tables, and for YTD values please check them with   CNIC tables.

For the difference as being observed, with RT, please check if there exists any NI arrears/refund existing in the NIRA table, and if the difference is matching to these values.

Please provide update based on the above inputs , incase the issue still remains.

Thanks and Kind Regards

Ramana

[Former Member]

Hi Ramana,

Yes, the values of RTINI are matching with NIC/ CNIC values.

We do see some arrears/ refund in NIRA table.

It is because the employee left in June but was made leaver in SAP in July.  Hence the NI deducted for the days employee not active in June is getting refunded?

In July also we have some NIable amount being paid to employee.  When the NI being calculated in July and the amount showing in /301 and /302(RT) is not matching with TP values in NIC table.

We expect to see /301 and /302 value and TP values in NIC table in the month of july to be same.  That's not happening though.

Thanks and Regards

Veena

[jayantvenkata]

Hi Veena

The value reported in table RTINI is the amount of Employee and Employer NICs DUE this period and not the amounts actually deducted.
In these exmaples, there is an amount in table NIRA which is taken into account in table RT and reflected in the wagetypes /301 and /302

The amount of the arrears for RTI purposes is added to the Net deduction field 58B as required by HMRC.

Hope this helps

Thanks and Kind Regards

Ramana

[Former Member]

Hi Veena,

there where quite a few notes recently dealing with "special" cases in RTI like retroactive leavers, mid month changes etc.. make sure you've got the July support package in.

However, before you start changing any data by force, do make sure you are not comparing in-period sums with for-period results.

When you run FPS (test with ALV is ok - no xml file needed), the numbers would usually reflect in-period values incl retros. So, you need to consider retros for your comparison. If unsure, what should really be included in a fueld, demand a clear answer from HMRC. They like taking the easy way out andvtell you to ask your software provider, but in the end of the day, it's only their interpretation of their own rules, which counts.

kind regards

Sven