The auto-enrolment solution for Northern Ireland
If you have received an error message indicating that your .csv file is invalid, the message should state the cell which is not accepted. Please ensure that you have provided all data in columns A-F of your file, and that the file does not include any of the following:
If you have received the error message “This is not a .csv file” your file is in the incorrect file format.
You should re-save the file as the following type:
CSV (Comma Delimited).
National Insurance Number
If the National Insurance Number in the upload file is not recognised, an error message will be shown. You will either need to correct the National Insurance number or add the employee if they have not already been added to your account.
If an employee has been marked as leaving you can still upload contributions for dates prior to their leaving date but you may not be able to view and edit their record.
If the contribution dates do not match the payment frequency for the employee, you will need to decide between these options:
Contribution dates relate to a previous month – this will result in a warning message so you can confirm that this was intentional
Format of date is incorrect – format should be dd/mm/yyyy
Overlap in contribution dates – contributions cannot overlap, so any overlap must be corrected
Contributions already uploaded for this date – see section on How do I amend contributions?
The validation for the contribution value is based on:
If any of these are recorded incorrectly, they can be updated by selecting the Edit option at the end of each row on the data grid.
The system will confirm if the contribution value is higher or lower than expected.
If you are sure that the contribution value is correct, even though an error is given and all these variables are recorded correctly, you can confirm that the contribution values are correct by selecting the dropdown Reason for Difference for that contribution. This may be due to SMP, SPP, SAP, SSP or leaver calculations.
Group Life Assurance
If a member is registered for Group Life Assurance then a premium value must be uploaded with each contribution. The value of this must be a multiple of the value set up for this employee.
If the member is not registered for Group Life Assurance then a value must not be entered in this field.