UK Payroll (Year End HMRC Return - Taxable Benefits)

[Former Member]

Hi Payroll Experts,

Please look in to below issue any ideas and solutions plz revert back to me ASAP.

On the employees expenses and benefits form P11D, section F, which is cars and fuel is not calculating right. It seems to be tided up with the amount paid by employee for private use of the car. Some the figure does not appear and others it's taking off the lump sum payments from the lease car payments, which it should not. Lump sum payment seems to calculating right under section E.

Ex:

The numbers are as follows

1111 (xxxx) Lease deduction of £490.83 not appearing in box (amount paid by employee for private use)

Therefore the cash equivalent of each car amount is wrong it should read £174.

2222 (yyyy) Lease deduction of £721.04 not appearing in box (amount paid by employee for private use)

It is showing £438.04 It seams that the lease deduction has been reduced down by the lump sum payment. (721.04-283.00 = 438.04)

Therefore the cash equivalent of each car amount is wrong it should read £1288

Thanks & Regards

Githa

Edited by: PGVani on Jun 13, 2009 11:34 AM

Edited by: PGVani on Jun 13, 2009 11:58 AM

[Former Member]

Hi,<br> What are 1111 (xxxx) and 2222 (yyyy)? Please provide IT222 informations and other info you have maintained.Provide the employee join details and other details. And are you maintaining multiple IT222? [HMRC |http://www.hmrc.gov.uk/helpsheets/hs203.pdf] Good luck<br><br> Thanks, Amosha <br><br>"Known is a drop & unknown is an ocean!"

[Former Member]

Hi,

1111 & 2222 are the Perner Numbers to whom the calculations are not getting correctly.

IT222 not maintained to the Corresponding Perner Numbers as well as IT0031 also.So there is no Multiple Emp.

Emp Join Details

01.04.2006 Emp Joined

In this Programm RPCP11G0, P11D Form the calculations showing wrongly.The following are the errors

1581 (E FEE) Lease deduction of £490.83 not appearing in box (amount paid by employee for private use)

Therefore the cash equivalent of each car amount is wrong it should read £174.

4002 (D GINNELLY) Lease deduction of £721.04 not appearing in box (amount paid by employee for private use)

It is showing £438.04 It seams that the lease deduction has been reduced down by the lump sum payment. (721.04-283.00 = 438.04)

Therefore the cash equivalent of each car amount is wrong it should read £1288

Thanks & Regards

Githa

[harishtk1]

Have you checked to see whether wagetype /134 is appearing in CRt for latest March 09 period for these two employees?

Edited by: Harish Krishnan on Jun 15, 2009 10:12 AM

[Former Member]

Hi Amosh,

Can u please provide me the Inputs on this Isuue.Iam waiting for your reply.

Thanks & Regards

Githa

[Former Member]

Hi,<br> Check the CRT for prev period and current period of the issue. Check values in WT- /134 If the amount is less than expected, then check the below for WTs to be included in /134. In order for a wage type to be included in Company Cars: Payments for Private Use, there must be an 'X' in the Cumulation table in transaction pu95, logical view 08_XX003 for the specific wage type. Cumulation class:34 for all WT applicable for "Co.car: paymts privte use" should have correctly checked. If you are using a WT to capture the amount for Comp Car Private use in IT14/15 then compare the WT with D300. And if it matches , then I would recommend to create the same test scenario with WT D300 in QA and test it. If you still continue to face the issue, please raise on OSS message. We can also continue to work in parallel. Good luck<br><br> Thanks, Amosha <br><br>"Known is a drop & unknown is an OCEAN!"

[Former Member]

Hi Hari,

In CRT table the W.T /134 Not appearing for 01.03.2009 as well as 01.04.2009 also.Could you please let me know why this W.T is not Appreaing.

Thanks

Githa

[harishtk1]

Hi Gita,

The answer is already provided by Amosha, the wagetypes relevant for Company car Pvt Use must be flagged with Cumulation Class 34., please see Amosha's answers above and verify whatever she has said.

For Amosha,

the only addition I will make to your points in this thread and elsewhere is IT 0222 is no longer used for Company car in UK, it is IT 0442,. This is FYI.

[Former Member]

Hi Amosh,

Sorry to Trouble you.Iam new to UK Payroll so feeling some Difficult to Understand.

Can you please expalin me in Detail Please

1) IT222, 225 Not maintained

2) How to find out the Comapny car Private use Wage type bcz in RT & CRT i am not able to find any W.T Which is related to Company car.

3) IT14 Not maintaiend.IT15 Maintained on W.T 8000 - /134 EOY Adjustmemt.

4 )In order for a wage type to be included in Company Cars: Payments for

Private Use, there must be an 'X' in the Cumulation table in transaction

pu95, logical view 08_XX003 for the specific wage type.

Cumulation class:34 for all WT applicable for "Co.car: paymts privte use" should have correctly checked.

Request : Please Reply with Table Names.

Thanks

Githa

[harishtk1]

HI Gita,

Let us start from the beginning.

1) Is Company Car Infotype maintained for the two employees? Company Car INfotype is 0442. It used to be 222 earlier. If you are using anything newer than 4.5 B, this is likely to be 0442 in your case?

2) If yes, is the following field maintained - "Regular Payments". This field is found in the "Price and Benefit" tab of IT 0442.

3) If the field is maintained, is this payment being processed in Payroll? If you are not the person who built this system, you must ask the person who did or refer to any documentation such as BUsiness Blueprint or Configuration Document to identify this wagtype. You can also simulate a payroll and look into the log to identify which wagetype is being used. A simple way is to glance through the RT and find a wagetype with the exact amount entered in this field. You will need to confirm by running various tests by changing the value etc.

4) If you find the wagetype, can you please check in table v_512w_d to see whether Cumulation Class 34 is flagged for this wagetype.

All the above will help find out what is wrong, but to rectify it may be slightly difficult at this stage as you have very little time before the due date for submission of P11D. Depending on what you find, it may be necessary to run a payroll to fully rectify. Do you have time to run another payroll before July 19th?