Payroll bulk imports

Payroll bulk imports

Payroll bulk imports load payroll data for many employees from a spreadsheet instead of typing it one by one: one-off payments for a payroll, employees' recurring allowances, scheduled payment plans, contributions, previous-employer income, tax adjustments and historical payslips. This article lists every payroll import, where to find it, and how to import without surprises.

Where: each import sits next to the data it loads. Most are on My Team › Settings › Bulk tools › Company Bulk Data. The table below gives the place for each.

You need: the right shown in the table for each import, plus the Bulk Profile Data right for Company Bulk Data.

Which import, when

You want toImportWhereRight
Add one-off payments to one payrollBulk uploadThe payroll › Others › Add Payment › Bulk uploadPayroll processor
Add one-off payments to several payrolls at once, by payroll namePayroll Other PaymentsCompany Bulk DataPayroll processor
Give employees recurring payments of their ownProfile Other PaymentsCompany Bulk Data, or Payroll › Settings › Other Payments › Bulk Profile Other Payments › Bulk uploadEmployment info (payroll) and Payroll processor
Spread totals over several cutoffs for many employeesScheduled payment plansPayroll › Settings › Other Payments › Scheduled Payment Plans › Bulk uploadPayroll processor
Set which contributions apply to each employeeProfile ContributionsCompany Bulk DataEmployment info (payroll) and Payroll processor
Record income and tax from a previous employer this yearPrevious EmployerCompany Bulk DataEmployment info (payroll)
Correct tax on payslips that already existTax AdjustmentCompany Bulk DataPayroll processor
Load payslips from your old systemPayslipsCompany Bulk Data. See Importing historical payslipsPayroll processor
Change the type or description of other payments after exportImportThe other payments payroll reportPayroll processor
Import loans or loan paymentsLoansSee Importing loan dataLoan manager

The same amount every cutoff for a whole group? Don't import it each time. Set up a group other payment.

Before you start

  • One bad row stops the whole file. If any row has an error, nothing is imported. The result lists the rows to fix.
  • Use the template. Download it from the same place you import, and keep its column headings.
  • Use Employee IDs, not names. Every import matches people by EmployeeID.
  • Type names exactly as KAMI shows them, such as other payment types ("Fixed Allowances") and batch cycle names.
  • Know whether it adds or replaces. Most payroll imports append: blank cells don't delete anything. Profile Contributions and Payslips overwrite: blank cells clear data and overlapping payslips are replaced.

How to import on Company Bulk Data

  1. Open My Team › Settings › Bulk tools › Company Bulk Data.
  2. Select the import, such as Payroll Other Payments.
  3. Select Get a sample template, and fill it in.
  4. Choose Import, choose your file, and select Import.
  5. Wait for the notification and the Data Import email, and read the result.
  6. Recalculate the payrolls the data affects.

How to import one-off payments into one payroll

  1. Open the payroll and go to the Others tab.
  2. Click Add Payment, then under Bulk upload click Download Template.
  3. Fill EmployeeID, Description, Other Payment Type and Amount. Leave Other Payment ID blank for new payments; fill it to change an existing one.
  4. Click Import and choose the file.
  5. Recalculate the whole payroll. The payments aren't in the payslip totals until you do.

What the main templates contain

ImportColumns
Payroll bulk uploadOther Payment ID, EmployeeID, Description, Other Payment Type, Amount
Payroll Other PaymentsPayroll Name, EmployeeID, Description, Other Payment Type, Amount
Profile Other PaymentsEmployeeID, Other Payment ID, Other Payment Name, Expiry Date, Other Payment Type, Payroll Period (1 to 4), Amount
Scheduled payment plansEmployee ID, plan name, other payment type, direction, amount mode, total or instalment amount, number of instalments, batch cycle name, start period date

A negative amount is a deduction.

What happens next

  • Imports run in the background. You get a notification and, for Company Bulk Data, a Data Import email. Import History on that page shows every import and its status.
  • Payslips change only when recalculated. For recurring profile payments on a payroll already calculated, recalculate with Refresh Other Payments switched on.
  • Previous-employer income changes the year's tax estimate, so it affects every remaining payslip that year.
  • The other payment report import changes only the type and description, and doesn't recalculate the payslip.
  • There is no undo. Correct a bad import by importing the right values, or by editing the records.

Tips

  • Import ten rows first. A date format or type-name problem shows on ten rows before it affects four hundred.
  • Export before an overwrite. It is the nearest thing to a backup.
  • Import previous-employer income before a joiner's first payroll, or their tax is wrong from the start.
  • Keep the file you imported, with the date. It is the only record of where the values came from.
  • Check one employee you know well after every import.

Frequently asked questions

My import failed and nothing changed. That is by design. One row with an error stops the whole file. Fix the rows in the result and import the whole file again.

The import worked but the payslips didn't change. Recalculate the payroll. For recurring payments, switch on Refresh Other Payments.

It says the other payment name already exists. An employee can't have two recurring payments with the same name. Use a different name, or include the Other Payment ID to update the existing one.

Which identifier should I use? The EmployeeID on each employee's profile.

Related articles