Migrate from Quickbooks

This is a comprehensive guide to import an entire payroll creating a company and workers. This is a fully automated process with manual steps only required where data is unavailable.

Process Overview

blockdiag Collect files Import files Upload missing items Parallel run auto com pare

Automated migration process

Collect the required files

This importer requires an FPS (Full Payment Submission) file and we recommend a Worker Details file. Optionally if required, you can also import History files:

GB HMRC FPS input file specification

File

Types

Notes

FPS XML

.xml

HMRC RTI Full Payment Submission

Worker Details

.csv, .ods, .xls, .xlsx

Supplementary worker details

Payment History

.csv, .ods, .xls, .xlsx

Actual payments for the pay schedule to be selected

Holiday History

.csv, .ods, .xls, .xlsx

Holiday earnings (weekly basis)

Important

The FPS must contain all workers, including zero-paid. FPS files may include or exclude zero-paid employees. If you always pay all employees, then your FPS will include everyone. If you have any zero-paid employees, you must do one of the following:

  1. Ensure the relevant setting is set to always include zero-pay employees before submitting the FPS

  2. Pay all employees 1 penny to ensure that they appear in the submitted FPS

  3. Create an un-submitted FPS using, say a 1p payment (noting that not all payroll systems support this)

An FPS contains two important pieces of data: each worker’s year-to-date (YTD) values and the final pay run payment. paiyroll® supports three methods of FPS Import:

  • Import Submitted YTD figures, subtracting the payment with a parallel run and auto-compare of the last pay run. This is the recommended approach.

  • Import Submitted YTD figures only and disregard the payment. This approach is required if there are errors in the previous payroll system and the first pay run in paiyroll® must cumulate from the submitted figures without correction. It can also be used if there is no time for a parallel run

  • Import un-submitted YTD figures and disregard the payment. This approach is used where workers were missed in the initial import and need to be merged or as required in (3) above.

The following sections describe how to collect and/or prepare the required files from your payroll.

Full Payment Submission (FPS) file

You will need the latest submitted Full Payment Submission (FPS) RTI XML file:

  • Click Taxes

  • Click Review for the latest FPS submission

  • Click Copy text

  • Now open a simple text editor, Paste the copied FPS and be sure to save the file in Plain text (.txt) format with a .xml file extension. Here are 3 ways to do this:

    • Microsoft Word: save as Plain text (.txt) with filename FPS.xml

    • Windows: right click New Text document or Notepad Save as ‣Text dcouments (.txt)

    • Mac OSX TextEdit: (TextEdit ‣ Preferences then New Document then click Plain Text) with filename FPS.xml

    You should now have a file named something like: FPS.xml

Employer Payment Summary (EPS) file

Next you should save the latest submitted Employer Payment Summary (EPS) RTI XML file following the above steps.

Employee Contact XLSX

Finally, export an Employee Contact XLSX:

  • Click Export data

  • Click Employee

  • Be sure to include Hire date and Employee ID in the report

  • Export and save the file. You should have a file named something like: Acme+Ltd_Employee+Contact+List.xlsx which can be imported directly as the Supplementary worker details.

Note

In case this file does not import, or you wish to create the Supplementary worker details from another source, please see the detailed steps in Migrate from FPS XML.

Other files

Whilst not required for the import process, we suggest you also collect/ locate these other files to verify and complete the import. These would include all frequencies to be imported (e.g. weekly and monthly):

  • Payslip PDFs (standard employee payslips) ideally in a single file which can be quickly searched using Find Ctrl + F on a PC or Command + F on a Mac

  • Pension CSV files for member enrolment and member contributions (the files uploaded to the pension provider after each payroll)

  • Bank Payment files (BACS or Faster Payments file)

  • Previous Pay and Previous Tax for any mid year starters - ideally a spreadsheet

The following will be required after import to verify pension auto-enrolment. These are generally available from the pension providers portal:

  • Pension auto-enrolment dates for all enrolled employees plus contribution percentages

  • Pension opt-out dates for any employees who have opted-out of auto-enrolment

  • Postponed or deferred employee dates

Finally collect any statutory information to enter:

  • SMP SSP SPBP for any active Statutory absences.

  • Attachment orders for any required attachment of earnings orders.

Import the files

Click the Import button and select Run.

  1. Select the Company you wish to import to. If this is your first import, the option is empty.

  2. You must supply an XML FPS file

  3. We recommend that you provide the optional Worker details file as described above. You can skip this file for a fast import or if you wish to create a worker details template.

  4. The History files are optional.

  5. Click Upload files

On the second wizard screen:

  1. It is possible to use the content of the Worker Details file to filter a subset of FPS workers. This might be used to filter out leavers for example.

  2. Mode allows you to create a new company, delete/ re-create a company or merge new workers into an existing company.

  3. If the FPS contains multiple frequencies (e.g. weekly and monthly) you need to select each frequency as a separate import. MMultiple frequencies can also be collapsed into one frequency.

  4. You must also enter the Pay period end date. This is not the pay date - it is the last day that employees worked and were paid.

  5. If you operate Postponement (Auto enrolment deferral) then tick the box to automatically detect category and dates.

  6. Import YTD only

    Important

    You will normally leave this un-checked to import YTD values and the FPS payment to replay the last payrun (parallel run). Tick only if you want to import YTD figures only (skip the parallel run) or are importing un-submitted FPS where the Payment is to be disregarded.

    Tip

    If you intend to import YTD only figures, then Auto Enrolment migrated status cannot be auto detected. Alternatively, you may wish to run 2 imports - the first with Import YTD un-checked which will create migrated status on each Auto Enrolment Pay Item. After the first import has completed follow these steps to create a Pay Item file for later upload:

    • Employee Setup ‣ Pay Items

    • Download…

    • Open the file in Excel and filter on column B Definition for the value of AE

    • Save this file as an Excel workbook, importantly filtered as above

    • After you complete the 2nd migration (Import YTD only), then upload these AE Pay Items Home ‣ Upload Pay Items

  7. The import may take some time to complete depending upon size. Once complete, a pay run is automatically started and ready in a few seconds. You can review the payslips in My documents .

    Important

    If you have a second schedule to import, you will likely need to modify default values for certain Pay Definitions such as AE Schemes e.g. monthly and weekly. Before running a merge import take the following steps:

    1. Decide on a new appropriately named Pension scheme for the next import. Add a new pension scheme Pay Definition using the using the Pension scheme Pay Template. It is principally the new Scheme Definition name which is important and you you may wish to defer setting other scheme values.

    2. Change default AE scheme NEST Scheme on the AE Pay Definition to your new scheme above then click Update to ensure your new scheme name is applied to the merge import.

    Now repeat the above steps import the next schedule carefully ensuring you select the mode Merge workers with “Test company”.

The following are automatically created during import:

  • Company

  • Employees

  • 1 Test (Template) Employee per schedule

  • Pay schedules

  • Pay Run

  • Workflow Definitions

  • Report Definitions

  • FPS Pay Definitions and Pay Items including a basic Pay Item called Pay and NonTaxOrNICPmt for non tax or NIC payments such as expenses or deductions

  • Automatic Enrolment (AE) Pay Definitions, default Schemes and Pay Items

Note

The typical FPS import rewinds to just before the payrun was approved in your previous system with all Pay and AE. When following the steps below, you will therefore be re-running your previous pay run related to the FPS submission - this enables a parallel test run in paiyroll®.

FPS files only contain partial data. Hence the dummy values are created for all missing data like staging date etc. The following sections detail all the steps required after an import to complete an accurate and correct payroll. For example, if you did not supply a worker_details file at import, you will need to set the Email address, Mobile phone number, bank details and set a Department for each Employee

Upload missing items

The imported file(s) may still be missing higher level data for example Salary, Shifts etc.. The following steps are therefore required after an import to complete the payroll. Almost all of this data can be uploaded from spreadsheets. If you wish to perform multiple imports for Parallel runs, you will find it quicker to create spreadsheet files to upload. The easiest way is to create the data manually using the GUI first time, then download the data into spreadsheets when complete.

  1. Company Update all Company fields as the imported files only provide limited data. Now is a good time to rename the company.

  2. Pay Definitions for Pay, Pension, Holidays, Deductions and Schemes are required:

    • Scheme Pay Definitions e.g. Pensions and Holidays will need to be created before you can create the associated Pay Definitions.

    • Automatic-enrolment (AE). The import process will create AE Pay Definitions, Schemes Definitions and Pay Items. The import process uses heuristics and may not be 100% accurate. You will therefore need to verify that the AE migration is correct for each employee. The quickest way to do this is to download the Pay Items: Navigate to Pay Items, then click Download… to download a payitems.csv file. Open the file using a spreadsheet program and then filter on column B definition with AE to exclude all other Pay Items. Verify the following for each worker:

      • Worker percentage (inputs-3-value)

      • Scheme (inputs-4-value)

      • Migration category (inputs-5-value)

      • Enrol date (inputs-8-value)

      • Migration date (inputs-9-value)

      If you need to make and save changes, simply copy the filtered AE Pay Items into a new file and edit the cells. Then upload this file by navigating to Pay Items and then click Upload….

      AE migration is also described fully in Migrate Auto-Enrolment Pension data.

    • Holiday. Set up Holidays.

    • Deductions

    • If you have additional salary pay items, e.g. Directors Salary which were not specified on import, they will be imported using a Payment Pay Template instead of the Salary Pay Template. Replace these with a suitable salary Pay Definition.

    • If the Importer generated a differently named salary Pay Definition to avoid a clash with history import e.g. Salary (monthly) vs. Salary, then you can revert to the original name as follows:

      • Delete the Salary Pay Definition by confirming on the delete screen, there are no dependent Pay Items.

      • Rename the Salary (monthly) the Pay Definition to Salary

    • Reuse. Set the Reuse on each Pay Definition according to each intended usage and whether it is required to pay each pay run. There are 4 values:

      • Use indefinitely pays each pay run e.g. a recurring medical benefit that doesnt change

      • Use once, then set to zero pays once and then changes to zero e.g. a one-off bonus

      • Use once, then unset pays once and expects a new value e.g. commission that varies each month but requires a different value

      • Never prompt even if unset set manually/ infrequent e.g. annual bonus

    • Finally, delete any imported Pay Definitions that are not required which may have been created to aid the import process. For example Pay or NonTaxOrNICPmt. When deleting a Pay Definition always carefully check the descriptive text to see if there are any linked Pay Items.

  3. The imported pay schedules may not reflect your dates. Navigate to Pay Schedules and Update… the schedule. You will need to clear the Enabled checkbox to disable the schedule and click Update. Now you can update the schedule with your dates and don’t forget to click Enabled before updating the correct schedule. Once this is done you must start a new pay run using Workflow Definitions and click the Start button . Delete the old payrun from Payruns by clicking Delete and Confirm deletion.

    Important

    The pay period dates on the pay schedule must continue from the Pay period end date set on import.

  4. Employees: Add any new employees if required. Test employees or template employees are created for you to make it quicker to add the same Pay Items to similar starters. Add an employee and ensure the Test employee check box is ticked. Add any required Pay Items, e.g. Pension. The Add From… tab on the Pay Item editor allows you to add Pay Items from any existing Test employee. Upload Data Feeds can also use Test employees. If you have different types of workers or different schedules, you will want to add addiaitoanl test employees.

  5. Pay Items. Use the Pay Item Editor to review each employee and add any missing Pay Items such as salary, bonus etc. from your Pay Definitions. You can ensure they have the correct values by clicking Update which will generate a live payslip.

    If you need to add multiple Pay Items, we recommend the use of spreadsheet upload files. One easy way to start is to create a single Pay Item for an employee using the Pay Item editor . Then navigate to Pay Items and then click Download… to download a payitems.csv file. The file will include all Pay Items for all employees, so be sure to delete every Pay Item except the required one. Once you have created the Pay Items, these can easily be uploaded.

    • Previous pay and tax for in-year starters must be entered or uploaded to ensure payroll is correct.

    • Enter the annual holiday entitlement and balance for the remainder of the year for each employee. See Set up Holidays for more information.

  6. A basic set of Report Definitions are provided. You should add any required.

    • HMRC DPS. It is recommended that you add the HMRC DPS (Data Provisioning Service) to import updated coding notices from HMRC . Enter your HMRC credentials into the GB HMRC DPS report and Start the feed. Note: as the report is a feed, it can only pull data from HMRC and there is no risk of accidental submission. More info can be found here: Data Feeds GB HMRC DPS

    • HMRC RTI FPS and EPS. User ID and Password are not imported which means there is no risk of accidentally submitting data to HMRC. However, the HMRC test service is used to test each pay run together with a test receipt. When all the steps are complete, you must enter your user ID and password in FPS and EPS Report Definitions

    • Journals in Pre-approval summary2 and/or Journal files. Setup any required journals in the Pre-approval summary2 and add any journal reports e.g. Xero.

  7. Be sure to save all the data you have created in CSV files in case you need to repeat the process for each of the following views:

    • Company Setup

      • Pay Definitions

      • Report Definitions

      • Pay Schedules

      • Departments

      • Companies

    • Employee setup

      • Pay Items

      • Employees

    On each view, simply press the Download… button to create a file. The downloaded Pay Definition and Pay Item files will contain both system created Definitions/Items as well as the ones created in this guide. We recommend you delete system created rows.

Auto Compare pay run reports

When import is complete, you can use the automated compare capability to compare the generated pay run files such as:

  • Bank files

  • Pension provider files

  • Online submission files e.g. GB FPS or EPS

Any files in text, csv or XML formats will work.

Ensure you have your reference files ready from your existing payroll system.

  1. Go to Pay runs

  2. After making any changes, redo the pay run to refresh all the reports

  3. View View the required pay run

  4. Click on the Reports tab

  5. Click Compare

  6. Click Choose file and choose your reference file

  7. Click Upload files

After a few seconds your reference file wil be uploaded and automatically compared. On the left wil be your reference file and on the right is the generated file from paiyroll®. All difference are show in Red and Green. You can easily switch between Side-by-side and Line-by-line styles for the comparison.

Going Live

See Parallel runs.

Before the first live payroll, be sure to add credentials to any reports, e.g.:

  • HMRC RTI FPS

  • HMRC RTI EPS

  • Pension

P9X. If migration is at the end of a tax year, and the first pay run in paiyroll® will be in the next tax-year, you will need to create a custom pay run before running the GB PAYE tax code changer (P9X) Data Feed. This is because P9X needs to have a last approved run of a tax year before it can run.

Note

Before you approve the first payrun, you will notice that updated RTI PayIds will be sent. This switches the information held by HMRC system from pre-imported PayIds to the new paiyroll® PayIds.