Loading P11D Data Extracts into Third-Party P11D Solutions

Loading the extract files into your third-party P11D solution varies according to the requirements of the solution. Refer to the documentation for your third-party P11D solution.

Here are some general guidelines:

  • Check the file formats accepted by the third-party P11D solution and convert the CSV files if necessary.

    The Global Payroll for the UK processes generate CSV files. Some applications, such as KPMG P11D Solutions 2004, accept spreadsheets.

  • Check the file naming conventions used by the third-party software and adjust filenames if necessary.

    The filenames of CSV files created by the Extract P11D Data process do not include spaces. This is a restriction of Application Engine processes. If your third-party P11D solution uses a filenaming convention that includes spaces, rename the CSV files.

  • Check if data must be loaded in a particular order.

  • Identify employees who do not require a P11D.

    The P11D data extract tool extracts data for all employees with benefits data (company cars or loans). If there are employees who are not eligible for a P11D, identify them using your third-party P11D solution.

Loading P11D Data Extracts into KPMG P11D Solutions 2004

To load the P11D data into KPMG's P11D Solutions 2004:

  1. Convert the CSV files into Excel spreadsheets.

    Open the CSV file from within Excel and save the file as an Excel spreadsheet. You can load all the CSV files into one workbook (xls) file or create a separate file for each CSV file. If you create one workbook (xls file), each extract file goes on a separate sheet with the appropriate name in the tab.

  2. Edit the worksheet names.

    When you save the CSV files as Excel spreadsheets, the worksheet name defaults to the CSV file name. Replace the underscores (_) with spaces. For example, when you import the file PAYE_References.csv, edit the worksheet name to PAYE References.

  3. Load the Excel spreadsheets in the correct order.

    KPMG P11D Solutions 2004 requires data loading in a certain order. The order is defined by the Extract ID field on the P11D Solutions page.

  4. Identify employees who do not require a P11D.

    Refer to the KPMG documentation for instructions about selecting employees who don't require a P11D.