QuickBooks HelpQuickBooksHelpIntuit

Import data into QuickBooks Online Advanced Payroll and QuickBooks Bureau Payroll

by Intuit Updated 4 months ago

One of the great features of QuickBooks Online Advanced Payroll and QuickBooks Bureau Payroll is that your can import FPS (Full Payment Submission) and Excel files from most payroll softwares.

The steps you need to follow will depend on the type of file you're importing. Select the relevant heading to show the steps.

With most payroll solutions, you'll get your latest FPS. QuickBooks lets you to import all the HMRC and employee details from the FPS, including some of the opening balances.

If you are importing IRIS Payroll Professional (formally known as Star Payroll) data, your FPS will include employee details and opening balances only.

Step 1. Export the data from your previous payroll provider

You'll need to download the latest FPS sent to HMRC. Make sure you save the file as an .xml file.

Refer to your previous payroll provider for help exporting and saving the last FPS you sent to HMRC in an XML format.

From IRIS Bureau you can save an FPS .xml file and import directly.

  1. In IRIS payroll go to Online Services, then select Send FPS Submission
  2. The Submission Type should be changed to File Only, then select Next
  3. On the next screen select Create File
  4. Finally take a note of the location the file has been saved and move to Step 2 below

Moneysoft saves an FPS .xml file locally.

  1. Locate the latest FPS file in C:\ Users\ \ Documents\ Payroll\ Online Filing XML Files. 
  2. Take a note of the file path and move to Step 2 below

When moving from Brighpay you will need to create a .xml file by copying the latest submission from Brightpay, then paste the text into an application like Microsoft Windows Notepad and then saving it as an .xml file.

  1. In Brightpay go to the RTI tab
  2. Select the latest submission and then Submission XML if using Brightpay Online, or if using Brightpay Desktop select XML tab
  3. Next highlight and copy all the .xml text
  4. Finally paste into notepad and save as a .xml file
  5. Take a note of the location the file has been saved and move to Step 2 below

Step 2. Import your FPS payroll data into QuickBooks

  1. In QuickBooks, go to Payroll.
  2. Select the Employee tab.
  3. Next to Add employee, select the ▼dropdown arrow.
  4. Select Import Employees.
  5. For the File type, select FPS file upload from the dropdown options.
  6. Then, Select file... and then navigate and choose your saved FPS file.
  7. Select Confirm upload?.

When you import FPS and Excel files into Advanced Payroll, you'll still need to fill in some employee information manually. This is because the FPS and Excel files don't contain all of the data needed to set up an employee fully.

You can find the missing data by completing certain parts of the employee setup wizard. Simply select the employee's name which will take you to their profile where you can finish setting up the employee. You'll need to provide the following info:

  • Email address
  • Employee start date
  • Pay rate
  • Hours worked
  • Employee bank details
  • Pension details
  • After you have successfully set up the employee, you can repeat these steps to set up the rest of your employees.

Using the Sage50 payroll import will allow you to import the following data:

  • Company pension details
  • Employee details
  • Opening balances

Step 1. Exporting from Sage50

First, you will need to export the data you require from Sage50.

  1. In Sage50, go to Wizards, choose Data Export, then Payroll Data Export.
  2. Within the wizard, you'll be able to choose your template.The 3 templates supported by the QuickBooks Advanced Payroll are:
    • Company Pension Schemes
    • Employee Details
    • Employee Year to Date Figures
  3. Within the Sage50 wizard, you'll also be asked where you want to save your exported data. At this point you need to tick the Create a CSV file with Payroll fields as column headings? box.

Now that you're ready to import your data into the system, the order of importing the data needs to be:

  1. Company pension scheme
  2. Employee details
  3. Opening balances

Step 2. Importing Sage50 data into QuickBooks

Import your Sage50 payroll data using these steps:

  1. In QuickBooks, go to Payroll.
  2. Select the Employees tab.
  3. Next to Add Employee, select the ▼dropdown arrow and select Import Employees.
  4. For the Import Employees from section, select Sage50 File Import.
  5. Choose the File Type you would like to import, making sure you do this in the correct order:
    1. For Sage50 Company Pension Scheme CSV file, select Pensions.
    2. For Sage50 Employee Details CSV file, select EmployeeImport.
    3. For Sage50 Opening Balances CSV file, select OpeningBalances.
  6. Next, choose Select File and navigate to where you saved your Sage50 CSV files to select the file you need.
  7. Select Confirm upload?.

Using the Xero payroll import will import the data below. To include year to date figures use the FPS export import method above.

  1. Employee details
  2. Leave Categories
  3. Pay Categories
  4. If an external Id is used that has been used before you won't be able to save it if the 'unique external Id' setting is switched on. This setting is located on the Payroll settings > Advanced settings page. See here for more information. 

NOTE: When using any Xero integration features, you need to have at least Standard + Payroll Admin access.

You can import your Xero payroll data by following these steps:

  1. Go to the 'Add Employee' menu and click on 'Import Employees'
  2. Under the 'Employee Import' section, select 'Xero' from the 'Import Employees From' the drop down menu.
  3. Click the 'Connect to Xero' link. You will then be redirected to Xero where you will be required to select the Xero file you want to import payroll data for.
  4. When you are returned to the payroll software, you should see the 'Import payroll data from Xero' button. Click that button and your payroll data will start importing.
QuickBooks Online Payroll Advanced

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this