Guidance

Uploading RP14 forms: Common issues

Updated 7 April 2022

You might see an error message while trying to upload an RP14 or RP14a form using the Excel templates. This guidance helps you correct some common errors.

1. Check the upload guidance

Make sure you’ve followed all the steps in the upload guidance.

2. Check the file size

The file size must be less than 10MB. If your file is bigger than this, you need to separate it into smaller files so it can be uploaded.

3. Check the case reference is correct

Please check the case reference (CN) number you enter is correct. If the incorrect reference number is used the RP14A will not upload and we will not be able to pay the claim.

4. Check there’s a case reference on every line

A case reference must always be included. Please check there are no spaces before or after the case reference. The employer name and case reference must be entered on each line of the spreadsheet.

5. Check the company registration number (CRN) is correct

Check the company registration number is correct, and matches the case. If the wrong registration number is used, the RP14A will not upload and we will not be able to pay the claim.

6. Check there’s a valid National Insurance number for all entries

All entries must include a valid National Insurance number. Temporary or dummy National Insurance numbers will not be accepted and will cause the upload to fail.

7. Check there are no empty or blank rows

If there are empty or blank rows at the end of the file, the upload will fail. To remove any empty records:

  1. Highlight the blank row.
  2. Right click.
  3. Delete the row.

8. Check there are no more than 2 decimal places in each cell

No cell can have a numerical value with more than 2 decimal places. You might need to select each cell individually to make sure figures do not have more than 2 decimal places, as it’s not always visible.

This includes the following fields:

In the RP14: The share holder percentage field
In the RP14a: The basic pay per week
  The arrears of pay owed
  The number of days holiday owed

9. Check all numerical fields contain numbers only

Only numbers can be put in the numerical fields. If you include any special characters, like £, or any text, the upload will fail.

10. Check date fields are formatted correctly

Date fields should be formatted as DD/MM/YYYY. If you do not know the date and the field is not mandatory, leave it blank.

11. Check drop down boxes have not been overtyped

When entering data into a cell with a drop down box, only select one of the options provided. If you type over the options, the upload will fail.

12. Check no data is entered after the smart tag

Do not enter any data after the blue smart tag on the spreadsheet. As this will not be uploaded and will be lost.

13. If possible, use IP software

Using IP software to upload the data minimises the risk of errors occurring while uploading information.

If you follow this guidance and your document will still not upload, please email the RPS.