Bring your employees into Payroll by pasting JSON

Add the people you pay, with their pay, standing lines and what they have been paid so far this tax year, from a JSON document.

In Magpie öffnen

Employees in Payroll has Import employees in its More menu. It adds employees from a JSON document, with their pay, the lines added to every pay run, and the totals they have been paid and had withheld so far this tax year. Use it to move from another payroll app or a spreadsheet: give the export to an assistant with Copy the prompt, paste its answer into the box, and choose Preview.

The preview lists each employee and every problem it found, such as a pay schedule the team does not have or a date written the wrong way. Nothing is saved until there are no problems and you choose Import, and then every employee is added together. At most 500 employees are imported at once.

Someone already an employee, with the same email or employee number, is a problem: change them on their own page instead.

The document

{
  "employees": [
    {
      "name": "Sam Sample",
      "email": "sam@example.com",
      "employeeNumber": "E-104",
      "schedule": "Monthly",
      "startDate": "2025-04-01",
      "hoursSource": "entered",
      "pay": [ { "type": "salary", "amount": "32000", "from": "2025-04-01" } ],
      "standingLines": [
        { "item": "Income tax", "percent": "20", "from": "2025-04-01" },
        { "item": "Travel allowance", "amount": "50" }
      ],
      "openingTotals": [ { "item": "Gross pay", "amount": "16000" }, { "item": "Income tax", "amount": "3200" } ]
    }
  ]
}

Each employee needs a name and a schedule; everything else is optional. Dates are written YYYY-MM-DD and amounts in the team's payroll currency, such as 12.50.

The fields

Field Notes
name Required. Their full name.
schedule Required. The name of one of the team's pay schedules.
email, employeeNumber Each must not belong to another employee.
startDate Their first day.
hoursSource Where their hours come from: time_tracking, shifts or entered. entered when left out.
pay Each a type (hourly or salary), the amount (an hourly rate, or the salary for a year) and the date it applies from.
standingLines Each a pay item by name, with an amount or, for a deduction or a contribution, a percent of gross pay, and optionally from and until dates. from is their start date, or today, when left out.
openingTotals Each a pay item by name and the amount paid or withheld so far in the current tax year.

Pay schedules and pay items are matched by name and must already exist. Add them first in Payroll's Settings.

If an import is refused for a reason you can't work out, Support kontaktieren.

Aktualisiert am October 27, 2026

Den Magpie-Support fragen

Senden Sie dem Magpie-Team eine Frage zu allem, was dieser Artikel nicht beantwortet.

Support kontaktieren

Verwandte Artikel

Erwähnt in