Skip to main content

Compile Payroll and Expense P11D data

Combine payroll and expense data for P11D.

H
Written by Harry Ledger
Updated over a month ago

To extract relevant P11D data from PeopleXD Payroll and PeopleXD Expense, configure the P11D and P11D(b) and map the pay codes and expense codes to the appropriate P11D sections.

Examples

Section

Benefits

Compiled from

Section A

Assets Transferred

Payroll

Section F

Cars and Car Fuel

Car Administration Centre

Section N

Expenses payments made to or on the employee's behalf.

Expense

Configure Run P11D/P11Db from Settings

To configure the P11D report to use data from both the PeopleXD Expense and PeopleXD Payroll, follow the steps in the table below:

Environment

Steps

Back office

Note: By default, this indicator is set to Both Payroll and Expense Site.

  1. Click CorePay then click Update.

  2. Click Utilities then click System Configuration.

  3. Click General.

  4. From the Run P11D/P11Db from list, select Both Payroll and Expense Site.

  5. Click Save.

Portal

Note: By default, this indicator is set to Expense Site Only.

  1. From the dashboard menu, click Payroll Dashboard.

  2. Click Settings then click System Configuration.

  3. Click General.

  4. From the Run P11D/P11Db from list, select Both Payroll and Expense Site.

  5. Click Save.

Map the P11D section

To compile P11D benefit details from PeopleXD Payroll, map the P11D section on the relevant pay codes. To do this, follow the steps below:

Environment

Steps

P11D section of pay codes – back office

  1. Click CorePay then click Reference.

  2. Click Pay Codes.

  3. In the Pay Code field, enter the relevant pay code number.

  4. Click the executeimage.png icon.

  5. In the P11D Section field, enter the P11D letter.

    • If the employer incurred the cost of the benefit, select the Cost to You.

    • If the employee incurred the cost of the benefit, select Amount Made Good.

  1. Click Save.

P11D section of pay codes – modern UI

  1. From the dashboard menu, click Payroll Dashboard.

  2. Click Settings then click Pay Codes.

  3. In the search field, search for a relevant pay code.

  4. Next to the relevant pay code, click the three dot

    image.png

    icon.

  5. Click Edit then click 2 Rules.

  6. Click Add.

  7. From the Rule drop down list, select P11D Section.

  8. From the Value drop down list, select a P11D Letter.

    • If the employer incurred the cost of the benefit, add the Cost to You rule.

    • If the employee incurred the cost of the benefit, add the Amount Made Good.

  1. Click Next then click Save.

P11D section – expense codes

  1. Click CoreExpense then click Reference.

  2. Click Reference D-L then click Expense Code.

  3. In the Expense Code field, enter the expense code.

  4. Click the execute

    image.png

    icon then enter the P11D letter.

You can now extract the expense or benefit details.

Related Articles
Payrolling benefits meaning (UK)
Generate P11D(B) XML file only (UK)
A guide to P11D (UK)
Generate and transfer P11D and P11D(B) XML file
Upload P11D CSV details
Did this answer your question?