SAP RTI HMRCreconciliation report RPURCNGH - not balancing

[former_member219272]

Hi All,

in our production system, HMRC reconciliation report RPURCNGH is not balancing for many EEs each month they are showing as out of balance.

please through some light

Regards

Rahul

[Former Member]

Hi,

Just wondering if you can help me with unbalanced issue for HMRC report. I have this one wage type that is causing for the report to be not balanced.

WT is a repayment WT

set up as

/101 – Total Gross

/117 – Qualifying Earnings

/121 – Taxable Pay

/131 – NIable Pay

/132 – Regular  NIable Pay

Was informed that WT is a pre-tax deduction

Thanks,

Kam

[former_member104696]

HI Kamylle,

It would be beneficial if you could please attach the screen shot of RT, Reconciliation report (with not balancing) and could you please also clarify if the WT is pre-tax deduction why cumulation class 21 is ticked (taxable pay). Could you please also share t512w_0 table screen shot for this wagetype.

it would be great if you could create a new thread in line with SCN rules for new queires.

KR

Sid

[Former Member]

Was informed that the WT is a gross deduction loan and should still be subject to tax.

Thanks,

Kam

[Former Member]

Hi,

Just wanted to up this post if you can help me with this issue.

Thanks,

Kam

[former_member219272]

please can you give the full requirement of this wagetype only?

why this wagetype's validity is from 01.06.2016 ?

[Former Member]

Hi Vijay,

The customer only wishes to use this RTI WT beginning June 2016.

[former_member219272]

please can you give the full requirement of this wagetype only?

[Former Member]

This WT is supposed to be a gross deduction loan and still be subject to tax.

[former_member219272]

i am not sure whether am confused or else you are confusing me

in the 1st reply you said

Just wondering if you can help me with unbalanced issue for HMRC report. I have this one wage type that is causing for the report to be not balanced.

WT is a repayment WT

set up as

/101 – Total Gross

/117 – Qualifying Earnings

/121 – Taxable Pay

/131 – NIable Pay

/132 – Regular  NIable Pay

Was informed that WT is a pre-tax deduction

now you are saying - This WT is supposed to be a gross deduction loan and still be subject to tax

please can you give the full requirement of this wagetype so that others can help

[antoine_foucault]

Hi Rahul:

It means something is unbalanced between RTI and payroll customizing

(most likely RTI since if it was payroll related you would already have had quiet a few employees at the personal administration door knocking kind of hard).

Balance should be payroll net payment or claim (RT table entries /559 ; /558 ; /561 ; /557 ) equal RTI table Net pay - Net deductions - Benefits taxed via the payroll + Net Additions.

Look at this which I have deduced back when configuring RTI early 2013 thanks to an iProcon paper I could manage to hold on aka and his fellow colleagues... (hopefully it has not change much since then)...

	WAGETYPE BEHAVIOR					RTI CONFIGURATION
	Working net pay	Non-taxable pay	Taxable pay	NIable pay	Irregular NIable pay	Net Additions	Ben Payroll	Ben Tax NI	Ben Tax	RTI NI only	Pre Tax Dedutions
WT model	/105	/113	/121	/131	/133	/171	/172	/173	/174	/175	/178
A080	X	X				X
A081	X			X	X					X
A082			X				X		X
A083			X	X	X		X	X
A084				X	X		X	X		X	X

You can review your V_T512W_D entries with this information and sort out why you have unbalanced information between payroll and RTI.

Regards,

Antoine

[former_member219272]

Hi Antoine,

thanks for the info,

raise a OSS message

the issue is when the RTI was configured the wagetype configuration were wrong

e.g cumulation class 10 (net deduction/benefits) and cumulation class 71 (Net additions) are configured for the same wagetype which is the issue.

it has been like since we have gone like 2 years ago & now there are many EEs in the HMRC Reconciliation report

RPURCNGH - being out of balance have left the company,

the problem is we cannot change which has gone wrong & only we can correct going forward.

Regards

Rahul

[antoine_foucault]

Rahul:

better that than wrong customizing honestly...! anyhow /110 - /171 is missing in the matrix I gave you... did you get in touch with IR - just to know if you are aware of any consequences or impact this might have on the business... although not sure it can have any... thank you for the feedback! do you already have an oss note number for this issue?

Best regards,

Antoine

[former_member219272]

Hi Antoine,

we came to know about this only in the last 2 weeks,

i have already updated the business regarding the same, they will inform HMRC accordingly.

irrespective whether it has got an impact or not its better we intimate HMRC in advance

i have raised a OSS message & we told them saying that the processing call 10 & 71 are there for many wagetypes & they told it cannot be like that.

Regards

Rahul

[former_member219272]

Hi Antoine,

after the HRSP update i having more EEs in HMRC reconciliation report RPURCNGH more than 400 EEs being out of balance totally it is more than 800 EEs

but after the HRSP more EEs are being out of balance i am not able to find the head & tail of it,

any suggestions please

Regards

Rahul

[former_member219272]

Hi All,

Have sorted out most of the wagetypes for the HMRC reconciliation report RPURCNGH but one wagetype is driving me nuts

that wagetype is configured as

processing class

10 - Net dedns/benefits

11 - EE's Pensionable pay

21 - Taxable pay

31 - NIable pay

when i ran payroll for an EE whom i have hired in my dev client, exactly this wagetype is causing issues. i have tried all the processing class but it is not working as expected if i change the processing class in payroll

how did i sorted out the issues with other wgatypes?

1. hired a new EE in my dev client

2. added only one wagetype at a time

3. ran payroll in live

4. executed the HMRC reconciliation report RPURCNGH to see that particular wagetype is balancing or not, if it is not balanced then i will check the SAP RTI user guide.

Regards

Rahul

[former_member219272]

raised an OSS message

then they told me that the wagetype which is causing issue is from IT0011 external transfer which is not support for RTI

the problem is when it is going to previous tax year it bring the wagetype /Z10 which makes the RTI report to go out of balance

even IT0057 is also not supported

so they suggested us to use IT0014 for any union payment deductions

[former_member219272]

waiting for someone to say if they have IT0011 configured & HMRC reconciliation report RPURCNGH is balancing for them

this happens only the wagetype is a net deduction only cumulation class 10