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.

Note: If a start date is entered, the made good amount is only updated for the general benefit that matches the date, type, section and code combination; if the start date is blank, the made good amount is updated for the general benefit that matches the type, section and code combination, and the made good amount can be split across multiple lines if required.

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.

Mandatory.
<SDATE>

The P11D benefit start date.

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

Optional.
<EDATE>

The P11D benefit end date.

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

Optional.
<SECCODE>

The P11D section code or section letter for the benefit.

Must exist in the P11D Report parameters.

Mandatory.
<SECTYPE>

The P11D section type.

Must exist in the P11D Report parameters.

Mandatory.
<BENCODE>

The P11D benefit code.

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

Mandatory.
<ANNCONT>

The annual made good amount for the benefit.

Format <99999999.99>.

Must be a positive amount.

Optional.
<PAYEREF>

The PAYE Reference number for the benefit

Optional
<EXCLUDE>

Indicates that the benefit has been excluded from payrolling for the employee. Exclusion date will be set to the date in the <SDATE> column.

Must be Y or N

Optional
<FORGONE>

The Amount Forgone value for the benefit

Format <9999999.99>

Optional.