Skip to main content

Import/export data (UK Payroll)

Import updates or new data to payroll or export payroll configuration to CSVs.


How to import to/export data from Workforce Payroll

Export data

To export data:

  1. Go to Payroll > Settings > Import Export

  2. Click on a box of the data you would like to export

  3. A .CSV will automatically be downloaded to your PC.

Import data

To import data:

  1. Go to Payroll > Settings > Import/Export.

  2. Click the box for the data you want to update, to download the current CSV.

  3. Update the data for existing employees, or add employees by entering their Name and their System ID or Payroll ID.

  4. Save the file as a .csv.

  5. Scroll to the bottom of the Import/Export page and choose the Type of data.

  6. Attach your CSV and click Import.

There are also import instructions at the bottom of the Import/Export page.

Every CSV includes Name, System ID and Payroll ID columns, plus the columns for that type of data (listed below).

📝 Important to note: How an import updates your data depends on the type:

  • Addresses and Tax Declarations are updated with any new details in the file.

  • Bank Accounts are replaced with the details in the file. You can include several rows per employee. A row with only the name and IDs removes all of that employee’s bank details.

  • Leave Balances are matched on the leave_type column. Create your leave types first.

  • Journal Setup (Accounts) can be created or updated, but not deleted. They’re matched by name, then by code.

  • Draft payslip lines are only added. Existing payslip lines aren’t removed.


Staff Information

Address Details

To check imported addresses, go to Workforce > Staff, select the employee, then Personal > Personal Details > Address.

Leave Balances

To check imported leave balances, go to the employee’s profile > Payroll > Payroll Details > Leave Balance.

  • leave_type: the leave type (e.g. Holiday Leave). It must match a leave type you’ve already created.

  • opening_balance: the leave balance at the start of the period.

  • hours_accrued: leave earned during the period.

  • hours_taken: leave taken during the period.

  • current_balance: the balance after accrued and taken hours.

Autopaid Earnings Templates

To check imported templates, go to the employee’s profile > Payroll > Payroll Details > Autopaid Earnings.

Autopaid earnings are added to the employee’s payslip automatically each pay run. They’re usually used for salaried staff.

  • Earnings Rate: the earnings rate to pay (e.g. Salary).

  • Primary?: whether this is the employee’s main earnings (usually True for salary).

  • Percentage: if the earnings are a percentage rather than a set amount.

  • Annual Salary: the employee’s annual salary.

  • Account: the account the earnings are linked to, if you track this.

  • Hours per Week: the employee’s weekly hours. Fill this in for salaried staff.

  • Location and Department: the employee’s location and team.

  • Extra tracking category columns may appear, depending on your tracking categories.

Example:

  • Earnings Rate: Salary

  • Primary?: True

  • Percentage: (blank)

  • Annual Salary: 30000

  • Account: Wages Expense

  • Hours per Week: 37.5

  • Location: London Office

  • Department: Sales

Tax Declarations

To check imported tax details, go to the employee’s profile > Payroll > Tax Information.

  • National Insurance number

  • Legal gender

  • student_loan: whether the employee repays a student loan (True / False).

  • uk_tax_year_status: first_job, second_job or had_previous_job.

  • uk_national_insurance_code: the employee’s NI category letter.

  • tax_code: the employee’s tax code.

  • emergency_tax_code: whether the employee is taxed on an emergency (non-cumulative) basis.

  • employment_basis and income_type

  • uk_loan_plan_1 to uk_loan_plan_5: which loans the employee repays. Plans 1, 2, 4 and 5 are student loans, and plan 3 is the Postgraduate Loan.

💡 Tip: For the exact values each column accepts, export the CSV first and copy the format used for your existing employees.

Bank Accounts

To check imported bank details, go to the employee’s profile > Payroll > Bank Accounts.

  • Sort Code

  • Account Number

  • Account Name

  • Payroll Payment Type: how pay is split between accounts (e.g. remaining_balance).

  • Payroll Payment Amount: the amount paid into this account, if the pay is split.

❗ Importing bank accounts replaces the employee’s existing bank details.

Pension Provider Memberships

To check imported memberships, go to the employee’s profile > Pension tab.

Pension contributions are also managed through this CSV. There’s no separate contributions import.

  • provider_name: the pension provider (e.g. Nest). It must match a provider set up under Payroll > Settings > Pension Setup.

  • member_number: the membership number from the provider.

  • group_name: the pension group the employee belongs to.

  • payment_source: the payment source used for contributions.

  • contribution_method: percentage or fixed amount.

  • employee_contribution_percentage / employer_contribution_percentage

  • employee_contribution_fixed_amount / employer_contribution_fixed_amount

  • currently_enrolled: TRUE or FALSE.

  • opt_out_of_pension: TRUE or FALSE.

  • opt_out_date: the date the employee opted out.

  • opt_in_without_auto_enrol: TRUE or FALSE.

  • postpone_enrolment: TRUE or FALSE.

  • auto_enrol_postpone_date: the date postponement ends.

  • enrolment_date: the date the employee was enrolled.

  • assessment_date: the date the employee was last assessed.

  • reassessment_date: the date the employee will next be assessed.

  • ae_worker_category: the employee’s auto-enrolment worker category.

For more, see Pension CSV Imports & Bulk Enrolment.

Pension Provider Contributions

Pension contribution fields are managed through the Pension Provider Memberships CSV.


Journal Configuration

Journal Setup (Accounts)

To check imported accounts, go to Payroll > Settings > Journal Setup (Accounts).

Accounts can be created or updated by import, but not deleted.


Staff Payroll Opening Balances

Opening balances are an employee’s year-to-date figures from earlier in the tax year. Use them when you start Workforce Payroll part-way through a tax year.

📝 Important to note: Opening balances you import apply to the current tax year. There’s no date column.

To check imported opening balances, go to the employee’s profile > Payroll > Opening Balances.

Opening Balances: Earnings Rates

Shown under Earnings Types.

  • Earnings type: the earnings rate (e.g. Salary, Overtime).

  • Amount: year-to-date earnings for that earnings rate this tax year.

Opening Balances: Tax

Shown under Tax Balance.

  • uk_tax_type: one of: Income Tax, Employee National Insurance Contribution, Employer National Insurance Contribution, National Insurance Earnings LEL, National Insurance Earnings from LEL to PT, National Insurance Earnings from PT to UEL, Student Loan Plan 1, 2, 4 or 5, or Postgraduate Loan.

  • Amount: the year-to-date amount.

Opening Balances: Statutory Leave

Shown under Statutory Leave.

  • uk_statutory_leave_type: the type of statutory pay (e.g. SSP or SMP).

  • Amount: the amount paid so far this tax year.

Opening Balances: Leave

  • uk_leave_type: the leave type.

  • Amount: the opening amount.

Opening Balances: Pension

Shown under Pension Balance.

  • uk_pension_type: employee or employer pension contribution.

  • tax_relief_type: the pension’s tax relief method.

  • Amount: contributions made so far this tax year.

Opening Balances: Benefits and Benefits in Kind

Shown under Benefit Balance.

  • Benefit type

  • Amount: the value of payrolled benefits so far this tax year.

For setting up benefits, see Benefits in Kind (UK).

Opening Balances: Previous Employment

Shown under Previous Employment. Only use this if the employee was paid by a different employer earlier in the same tax year.

  • balance_type: total_earnings or total_tax_paid.

  • Amount: the total from the previous employer (usually from their P45).

❗ Entering previous employment figures by mistake makes the system think the employee has extra income, which leads to higher tax.


Draft Payslip Lines

Payslip Deduction Lines

  • deduction_type: the deduction (it must already exist under Payroll > Settings > Deduction Types).

  • account and the amount.

Check the result on the employee’s draft payslip in the pay run.

Payslip Earnings Lines

  • earnings_rate, rate, units, account and location.


Import FPS XML

If you’re moving from another UK payroll provider, you can upload their FPS XML to fill in employees’ tax details and opening balances in bulk.

  1. Go to Payroll > Settings > Import/Export.

  2. Select FPS XML Import.

  3. Upload an XML file containing an FPS.

For more, see FPS Importer.


FAQs

Why did my import fail?

Check that:

  • you chose the correct Type of data for the file

  • the file is saved as .csv

  • each employee’s System ID or Payroll ID matches Workforce

  • anything the file refers to already exists, e.g. leave types, deduction types, earnings rates and pension providers

  • the column headings haven’t been changed

The fastest fix is usually to export the CSV again, update only the values, and re-import it.

Will importing remove existing data?

Only for bank accounts, which are replaced by the file. Other types update or add details. Draft payslip lines are only added.

Can I import opening balances for a previous tax year?

No. Opening balances apply to the current tax year. To correct a previous tax year, see Real-Time Information (RTI) Submissions in Workforce Payroll (UK) or contact Workforce.com support.

Can I export pension figures for my accountant?

This page exports employee payroll setup, not pay run figures. For pension amounts, use Reports > Payroll > Pension Contributions, or Payroll Costs by Location for totals by location. See Payroll Reports (UK).


Did this answer your question?