Column level keywords define the column usage for each data row and can only follow the keyword <DEFN>. Each column keyword must only occur once, if present.

Column Keywords Description
<EMPID>

The employee number, to which subsequent data in the spreadsheet row applies.

Must be a valid employee number.

It can appear in any column of the definition row, but it is recommended it appears in the first column for spreadsheet clarity.

Mandatory.
<YEAR>

The P11D tax year to which the record is attributed.

Format YYYY.

Must be 2019 or later.

Mandatory.
<RELOCREF>

If entered, this value will be used to match to an existing record.

Optional.
<RELOCDATE>

The relocation date.

Format DD/MM/YYYY. It must not be after <SDATE>. If no value is present it will default to 6th April of the <YEAR>.

If <RELOCREF> is not entered, this value will be used to match to an existing record.

Optional.
<RELDESC>

The relocation event description.

Mandatory when creating a new relocation event.
<SDATE>

The P11D benefit start date.

Format DD/MM/YYYY which must be within the P11D tax year as defined by the <YEAR> keyword.

This defaults to the P11D year start date if it is not within the P11D tax year.

Mandatory.
<EDATE>

The P11D benefit end date.

Format DD/MM/YYYY which must be within the P11D tax year as defined by the <YEAR> keyword.

This defaults to the P11D year-end date if it is not within the P11D tax year.

Optional.
<BENCODE>

The P11D benefit code.

Must exist in the narrative category (from value of benefit type).

Mandatory.
<AMT>

The P11D benefit amount.

Format <9999999.99>.

Optional.
<MGOOD>

The P11D benefit made good amount.

Format <9999999.99>.

Optional.
<PAYEREF>

The PAYE Reference number for the benefit.

Optional
<PREVYREXEMPT>

The amount claimed against this relocation event in the previous year.

If present it must not exceed the Relocation Qualifying Sum for the previous year.

Optional.