Import employees - Import FPS file
Description

If you've used another payroll software to pay your employees, It's likely you'll have submitted an FPS to HMRC.

The FPS includes a record of your employee details. You can import this information into Sage Payroll. It creates your employee records, saving you time on manually inputting the data.

 NOTE: You can also complete this process after setting up the payroll 

For help getting the FPS read our guide on exporting the FPS file.

Cause
Resolution

When importing employees from an FPS file, use the most recent file available. This is to ensure your employee information is as up-to-date as possible.

Information not included in an FPS file:

  • Your company's auto-enrolment staging date
  • Your pension scheme information
  • Your employee's auto-enrolment status information

 NOTE: The FPS file needs to be in an .xml format and must be no bigger than 25MB. 

If you'd prefer to watch a video on the process, select play below.

▼Import the FPS file after you have set up your payroll

If you have already chosen a different option when setting up your payroll, you can still import and FPS file from the Settings menu.

  1. Select Settings from the menu bar.
  2. Select Import FPS file.
  3. Select Next.
  4. Either select the heading Drop file here or click to upload, or drag and drop the FPS file on the screen.
  5. Select the FPS file that you’ve exported and select Open.
  6. Select Next
     NOTE: If the Next button isn’t active, you’ll see a red exclamation mark and an error message along the bottom of the screen.   
  7. You’ll see two options:
    Select either Personal and financial data, or personal data only.
  8. After selecting the required option, select Next.
  9. Select all employees you wish to import by ticking the check box next to their name.
     NOTE: You may see warning messages at this point. Ensure to read them before continuing. 
▼Import leavers

An FPS only includes active employees. This means it doesn’t include employees who have left earlier in the year.

It's not a requirement to add leavers to the payroll. If you want to add them as part of your reconciliation, do an FPS import for each one. You would need a previous FPS file that the employee was in, and only select those employees when given the option, to avoid duplications.

  1. Select Settings from the menu bar.
  2. Select Import FPS file.
  3. Select Next.
  4. Either select the heading Drop file here or click to upload, or drag and drop the FPS file on the screen.
  5. Select the FPS file that you’ve exported and select Open.
  6. Select Next
     NOTE: If the Next button isn’t active, you’ll see a red exclamation mark and an error message along the bottom of the screen.   
  7. You’ll see two options:
    Choose to import either personal and financial data or personal data only.
  8. After selecting the required option, select Next.
  9. Select all employees you wish to import by ticking the check box next to their name.
     NOTE: You may see warning message at this point. ensure to read them before continuing. 
  10. Select Confirm.
  11. On the confirmation message, select Import and Update.

Next step - Check and update your employee information

The final stage of the FPS import process is to review the employees and add any information not included in the import.

To help you do this, we've created a checklist which details the effected areas of Sage Payroll.

Read Import employees - Check and update employees.

Steps to duplicate
Related Solutions