End of Year Reports

Definitions

P60 - Statutory form for all current employees on 05.04.20xx, the P60 includes the year to date values for the employee for tax details and shows the breakdown of the NI figures, e.g. NI'able pay up to LEL, NI'able pay over LEL and between UEL etc.

P14 - Employer's copy of a P60, this has to be completed for every employee who was active between 6.4.20xx and 5.4.20xy.

P35 - Single form for each tax registered company, which shows the total tax and NI figures payable to Inland Revenue for the year. The totals of all the P14s should add up to the total shown on the P35.

P11D - Statutory form for any employee who has received any taxable benefits throughout the year, such as Health Insurance, Life Assurance etc.

P11Db - Employer's statutory return of taxable benefits with cumulated figures from the individual P11D's.

Transaction Codes

P60, P14, P35 - Transaction code PC00_M08_CEOY

P11D and P11Db - Transaction code PC00_M08_CTXB

Notes

P60 and P14

The values held in the CNIC table in the latest payroll results are put onto the P60 and P14 NI breakdown. If these need to be adjusted, you can do so by making an entry in T5G_DTONI, assuring the payment date is correct, then re-running the payroll for the employee - these changes can be made retrospectively as they do not affect the postings. nb. - The values that need to be entered into DTONI are the delta values, for example if the NI'able pay over the UEL needs to be adjusted from £90 to £100, then a value of 10 would be put into T5G_DTONI.

The tax values on these forms come from the most recent CRT in the payroll results. The taxable pay and tax paid should be split between previous employments in the current tax year and the current employment.

The relevant wage types are:

Pay in previous employment  /505 - P45 taxable pay
Tax in previous employment  /506 - P45 tax paid
Pay in this employment           /121 - Taxable pay
Tax in this employment           /501 - Tax paid

P35

The figures on the P35 are calculated by adding up all the values of the relevant wage types in the CRT for the employees that have been active in the current tax year, which is different to the way the NI values on the P60 and P14 are calculated (these look at table CNIC), this can cause discrepancies between the forms and is something to beware of.

P11D

The data on this form comes from a mixture of master data and payroll results.

Most fields on the P11D are populated by cumulating a defined set of wage types in the CRT, i.e. in the configuration step mentioned below wage type XXXX is pointed at section A field 3 of the P11D.

IMG step:

Payroll Payroll: Great Britain End-of-Year Processing Reporting P11D Expenses and Benefits Form Maintain Wage Types for P11D Cumulation Wage Types

is where the configuration is done to point wage types at the different sections of the form. Wage types can be configured specifically for valuating the P11D form if necessary.

The two exceptions to this rule are loans and company cars.

The only section that is not populated by looking at the payroll results is section F, company car information. All the fields in this section are populated by looking at IT0442. In this infotype you can enter all the required information about a company car, including it's list price, CO2 Emissions, fuel type etc. nb. Be sure to use all three tabs on this infotype as they are all useful. By pressing the 'Show benefit calculation' button at the top of the infotype, it is possible to see what calculations are being done by SAP to calculate the cash equivalent of each car.

The loans section of the P11D is populated by looking at the wage types generated by giving an employee a loan through IT0045. These cannot be manually entered, but must be calculated by SAP, the configuration behind the loan infotype in the IMG must be complete for this to work.