Supporting Document – P11D

Please Note: Labels marked in Red in this document indicate mandatory fields and should be completed (filled in) in the spreadsheet.

Important: There are few fields in the spreadsheet form which contains the drop down options. In case you are filling data in more than one row, please copy the cells containing the drop down option to the succeeding rows so that you can use this option in each row.

G1 Title: (Optional) Enter here the title of the employee. E.g.: Mr, Mrs, Miss, Ms.

Please note that no 'spaces' are allowed between any characters and the length should not exceed more than 4 characters.

G2 First Forename: (Mandatory) Enter here the employee's first name.

This field is mandatory.

You should only use characters defined in the Schema i.e, A-Z upper or lower case, hyphen or apostrophe.

Please note that 'spaces' are not allowed between the characters and the length should not exceed more than 35 characters.

Please note, the special characters listed below must not be used when you enter the employee's Forename.

` This is not an apostrophe, this is a grave accent. Please do not use this special character instead of an apostrophe.

. full stop

, comma

_ underscore

( ) opening and closing parenthesis

/ Forward slash

0 zero (in place of alphabet O)

1 2 3 numbers

* asterisk

? question mark

G3 Second Forename: (Optional) Enter here the employee's Second forename.

You should only use the characters defined in the Schema i.e, A-Z upper or lower case, hyphen or apostrophe.

Please note that 'spaces' are not allowed between the characters and the length should not exceed more than 35 characters.

Please note, the special characters listed below must not be used when you enter the employee's Forenames.

` This is not an apostrophe, this is a grave accent. Please do not use this special character instead of an apostrophe.

. full stop

, comma

_ underscore

( ) opening and closing paranthesis

/ Forward slash

0 zero (in place of alphabet O)

1 2 3 numbers

* asterisk

? question mark.

G4 Surname: (Mandatory) Enter here the employee's Surname.

This field is mandatory.

You should only use the characters defined in the Schema i.e. A-Z upper or lower case, digits 0-9, comma, full stop, forward slash, ampersand, hyphen, space, apostrophe and brackets.

The length should not exceed more than 35 characters.

Please note that the special characters listed below must not be used when you enter the employee's Surname

Please do not include leading or trailing spaces when you enter the Surname. For example if the Surname is O'Connor, do not include space before O'Connor or after O'Connor

` This is not an apostrophe. This is a grave accent. Please do not use this special character instead of an apostrophe. For example in a surname the apostrophe must be entered as O'Connor, not as O`Connor

leading spaces.

* asterisk

0 zero (in place of the alphabet O) - the first character must be alpha.

G5 Works Number: (Optional) Enter here the employee's Works Number. Please note that the employee's works number or payroll number can be alphanumeric and should not exceed more than 20 characters in length.

G6 Date of Birth (YYYY-MM-DD): (Optional) Enter here the date of birth of the employee.

Please note, the following when you enter the date of birth

Must be completed if the National Insurance number is not known.

Must be a valid calendar date. The date should be in a YYYY-MM-DD format.

Must be today or earlier.

G7 Gender: (Mandatory) Enter here the employee's gender.

Please note, the following when you enter the employee's gender.

Must be completed if the National Insurance number is not known.

Must be entered as 'Male' or 'M' or 'Female' or 'F'.

G8 NI Number: (Mandatory) Enter here the employee’s National Insurance number (NINo). This field is mandatory.

Please note, the NINO must follow the acceptable format as shown in the EOY schema i.e.

Two alpha (AA) six digits (123456) one alpha (A, B, C, D or space) e.g. "AA123456A" or "BB123456 " (the suffixes M, F and P will not be allowable after 2004/05).

Other reasons for failure are listed below:

Use of invalid prefixes not in accordance with the published list given in Appendix 3 of the 2004-05 PAYE End-of-Year Business Rules.

Temporary (TN)NI numbers e.g. TN111111F are not valid

Temporary Tax Office numbers e.g. 12J3456 are not valid

Fields longer or shorter than 9 characters are not valid

NOTKNOWN or NOT KNOWN are not valid entries

G9 Employee Indicator: (Optional) From the drop down list, select the appropriate option to indicate whether the employee is a director or an employee earning more than £8500 annually.

G10 Benefit Type: (Mandatory) From the drop down list, select the type of benefit provided to the employee. This field is mandatory.

Please note, when you select a certain benefit type for an employee, you should enter only the details pertaining to that benefit type in a single row. If that employee has availed more than one benefit of the same type or different type, then use separate rows to enter the details of each benefit. For e.g. If the employee is provided with benefit A 'assets' as well as benefit F 'Car', enter the asset benefit details in one row and the car benefit details in another row.

G11 Benefit Category: (Mandatory) Enter here the benefit category for the benefit type you have selected.

G12 Description: (Optional) Enter here the description of the benefit type which you have selected.

G13 Gross Annual Amount: (Mandatory) Enter here the total benefit value for the current tax year. This field is mandatory.

G14 Amount Made good: (Mandatory) Enter here the amount paid by the employee towards the availed benefit in the current tax year. This field is mandatory.

G15 Total Cash Eqvlnt: (Mandatory) Enter here the total cash equivalent amount of the benefit. This is the Gross annual amount of the benefit minus the amount made good by the employee towards the benefit. This field is mandatory.

Please note, in case of Benefit F, i.e. The car benefit, you need to enter the sum of the car cash equivalent and the fuel cash equivalent.

G16 Van Cash Equiv: (Mandatory) Enter here the total cash equivalent amount of the van benefit. This field is mandatory.

G17 Van Fuel Cash Equiv: (Optional) Enter here the total cash equivalent amount of the Van fuel. Please note, this should not include the cash equivalent for the Van Cash Equivalent.

G18 Car Make: (Mandatory) If car is provided as a benefit, enter here the make of the car. This field is mandatory.

The length should not exceed more than 35 characters.

G19 Car Model: (Mandatory) If car is provided as a benefit, enter here the model of the car. This field is mandatory.

The length should not exceed more than 35 characters.

G20 Car Registration Date (YYYY-MM-DD): (Mandatory) If car is provided as a benefit, enter here the date when the car was first registered. This field is mandatory.

Please note that the date should be entered as YYYY-MM-DD. This is because the XML Schema Stipulation only accepts YYYY-MM-DD as the date format. DD-MM-YYYY will not be accepted.

E.g.: If the car was first registered on 20th November 2000, the date should be entered as 2000-11-20.

G21 Car Registration No.: (Mandatory) If car is provided as a benefit, enter here the registration number of the car. This field is mandatory.

G22 Car Price: (Mandatory) If car is provided as a benefit, enter here the list price of the car. This field is mandatory. It should include the price of the accessories, that were added in the car before it was given to this employee as a benefit. A minimum of £1000 is considered.

G23 Car Accessory Added After: (Optional) If car is provided as a benefit, enter here the price of the car accessories which were added, after the car was provided as a benefit to this employee.

G24 Car Capital Contribution: (Optional) If car is provided as a benefit, enter here the capital contribution made by the employee towards this car. A maximum contribution of £5000 is allowed.

G25 Car CO2: (Optional) If the car was registered on or after 1 Jan 1998, enter here the carbon dioxide emission figure of the car in grams per kilometer.

G26 Car Engine CC: (Optional) If car is provided as a benefit, enter here the engine size of the car. This must not be present if 'Fuel Type' is E.

G27 Car Fuel Type: (Mandatory) From the drop down list select the type of fuel used in the car. This field is mandatory.

Acceptable values are:

‘P’ for Petrol

‘D’ for Diesel (not Euro lV)

‘L’ for Euro lV emissions standard diesel

‘H’ for Hybrid electric

‘B’ for gas only or Bi-fuel with approved gas CO2 figure

‘C’ for conversion or older Bi-fuel

Must be present if car registered on or after 1 Jan 1998.

‘E’ for electricity only

Can only be present if car registered on or after 1 Jan 1998, the No Approved CO2 figure indicator is present and no CO2 emissions figure is present.

G28 Car Facilitated: (Mandatory) Enter here whether the car facilitated to the employee was the first car, second / further car or a replacement car. This field is mandatory.

G29 Car Avail From (YYYY-MM-DD): (Mandatory) Enter here the date from which the car benefit was availed by this employee. This field is mandatory.

Please note that the date should be entered as YYYY-MM-DD. This is because the XML Schema Stipulation only accepts YYYY-MM-DD as the date format. DD-MM-YYYY will not be accepted.

G30 Car Avail To (YYYY-MM-DD): (Optional) Enter here the date up to which the car benefit was availed by this employee.

Please note that the date should be entered as YYYY-MM-DD. This is because the XML Schema Stipulation only accepts YYYY-MM-DD as the date format. DD-MM-YYYY will not be accepted.

G31 Car Unavailable days: (Optional) Enter here the number of days, the car was not available to the employee during the benefit period.

G32 Car Private Use Payment: (Optional) Enter here the amount paid by the employee for the private use of this car.

G33 Car Payment Frequency: (Optional) From the drop down list, select how frequently the car payment was made by the employee for private use.

G34 Fuel Usage Purpose: (Optional) If fuel was provided to this employee, then enter here the purpose for which the fuel was provided.

G35 Fuel Avail From (YYYY-MM-DD): (Optional) Enter here the date from which the fuel was provided to the employee in the current tax year.

Please note that the date should be entered as YYYY-MM-DD. This is because the XML Schema Stipulation only accepts YYYY-MM-DD as the date format. DD-MM-YYYY will not be accepted.

G36 Fuel Withdrawn (yes/no): (Optional) State whether the fuel supply was withdrawn from the employee or not.

G37 Fuel Withdrawn Date: (Optional) If the fuel was withdrawn, enter here the date when the fuel supply was withdrawn from the employee.

Please note that the date should be entered as YYYY-MM-DD. This is because the XML Schema Stipulation only accepts YYYY-MM-DD as the date format. DD-MM-YYYY will not be accepted.

G38 Fuel Reinstated (yes/no): (Optional) State whether the fuel was reinstated in the current tax year or not.

G39 Fuel Fully Paid (yes/no): (Optional) Enter 'Yes', if the employee has fully paid for the private or private/business usage of the fuel in the current tax year.

G40 Car Cash Equiv: (Mandatory) Enter here the total cash equivalent amount of the car benefit. This field is mandatory.

G41 Fuel Cash Equiv: (Optional) Enter here the total cash equivalent amount of the fuel. Please note, this should not include the cash equivalent for the car benefit.

G42 Loan Availed Date: (Mandatory) Enter here tha date when the loan was availed by the employee. This field is mandatory.

Please note that the date should be entered as YYYY-MM-DD. This is because the XML Schema Stipulation only accepts YYYY-MM-DD as the date format. DD-MM-YYYY will not be accepted.

G43 Loan Joint Borrowers: (Optional) Enter here the number of people who have jointly borrowed the loan.

G44 Loan Initial OS Amt: (Mandatory) Enter here the amount of loan that was outstanding either at the beginning of the tax year or on the date when it was first made (if it was first made in this tax year). This field is mandatory.

G45 Loan Max OS Amt: (Mandatory) Enter here the maximum amount of loan that was outstanding at any time during the year. This field is mandatory.

G46 Loan Interest Payment Date (YYYY-MM-DD): (Optional) Enter here the date when the loan payment was made to the employee, if the loan payment was made in the current tax year.

Please note that the date should be entered as YYYY-MM-DD. This is because the XML Schema Stipulation only accepts YYYY-MM-DD as the date format. DD-MM-YYYY will not be accepted.

G47 Loan Interest Paid: (Optional) Enter here the amount of interest paid by the employee in the current tax year.

G48 Loan Discharge Date (YYYY-MM-DD): (Optional) Enter here the date when the loan was discharged for the employee, if it was discharged in the current tax year.

Please note that the date should be entered as YYYY-MM-DD. This is because the XML Schema Stipulation only accepts YYYY-MM-DD as the date format. DD-MM-YYYY will not be accepted.

G49 Address Line 1: (Mandatory) If you have provided Benefit D-Living Accommodation, to the employee, enter here the address line 1 of the accommodation provided. This field is mandatory.

G50 Address Line 2: (Optional) If you have provided Benefit D-Living Accommodation, to the employee, enter here the address line 2 of the accommodation provided.

G51 Address Line 3: (Optional) If you have provided Benefit D-Living Accommodation, to the employee, enter here the address line 3 of the accommodation provided.

G52 State/Province: (Optional) If you have provided Benefit D-Living Accommodation, to the employee, enter here the state/province relating to the address of the accommodation provided.

G53 Post Code: (Mandatory) If you have provided Benefit D-Living Accommodation, to the employee, enter here the post code relating to the address of the accommodation provided. This field is mandatory.

G54 Country: (Optional) If you have provided Benefit D-Living Accommodation, to the employee, enter here the country relating to the address of the accommodation provided.

Suchitra

2005-10-21T15:35:59

Arun Prasad