Whats covered in this guide?:
How to import to/export data from Workforce Payroll
Export data
To export data:
Go to Payroll > Settings > Import Export
Click on a box of the data you would like to export
A .CSV will automatically be downloaded to your PC.
Import data
To import data:
Go to Payroll > Settings > Import/Export.
Click the box for the data you want to update, to download the current CSV.
Update the data for existing employees, or add employees by entering their Name and their System ID or Payroll ID.
Save the file as a .csv.
Scroll to the bottom of the Import/Export page and choose the Type of data.
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_joborhad_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_earningsortotal_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.
For more, see Import earnings lines to draft payslips (UK).
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.
Go to Payroll > Settings > Import/Export.
Select FPS XML Import.
Upload an XML file containing an FPS.
For more, see FPS Importer.
FAQs
Why did my import fail?
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?
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?
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?
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).


