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 to | Import | Where | Right |
|---|---|---|---|
| Add one-off payments to one payroll | Bulk upload | The payroll › Others › Add Payment › Bulk upload | Payroll processor |
| Add one-off payments to several payrolls at once, by payroll name | Payroll Other Payments | Company Bulk Data | Payroll processor |
| Give employees recurring payments of their own | Profile Other Payments | Company Bulk Data, or Payroll › Settings › Other Payments › Bulk Profile Other Payments › Bulk upload | Employment info (payroll) and Payroll processor |
| Spread totals over several cutoffs for many employees | Scheduled payment plans | Payroll › Settings › Other Payments › Scheduled Payment Plans › Bulk upload | Payroll processor |
| Set which contributions apply to each employee | Profile Contributions | Company Bulk Data | Employment info (payroll) and Payroll processor |
| Record income and tax from a previous employer this year | Previous Employer | Company Bulk Data | Employment info (payroll) |
| Correct tax on payslips that already exist | Tax Adjustment | Company Bulk Data | Payroll processor |
| Load payslips from your old system | Payslips | Company Bulk Data. See Importing historical payslips | Payroll processor |
| Change the type or description of other payments after export | Import | The other payments payroll report | Payroll processor |
| Import loans or loan payments | Loans | See Importing loan data | Loan 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
- Open My Team › Settings › Bulk tools › Company Bulk Data.
- Select the import, such as Payroll Other Payments.
- Select Get a sample template, and fill it in.
- Choose Import, choose your file, and select Import.
- Wait for the notification and the Data Import email, and read the result.
- Recalculate the payrolls the data affects.
How to import one-off payments into one payroll
- Open the payroll and go to the Others tab.
- Click Add Payment, then under Bulk upload click Download Template.
- Fill EmployeeID, Description, Other Payment Type and Amount. Leave Other Payment ID blank for new payments; fill it to change an existing one.
- Click Import and choose the file.
- Recalculate the whole payroll. The payments aren't in the payslip totals until you do.
What the main templates contain
| Import | Columns |
|---|---|
| Payroll bulk upload | Other Payment ID, EmployeeID, Description, Other Payment Type, Amount |
| Payroll Other Payments | Payroll Name, EmployeeID, Description, Other Payment Type, Amount |
| Profile Other Payments | EmployeeID, Other Payment ID, Other Payment Name, Expiry Date, Other Payment Type, Payroll Period (1 to 4), Amount |
| Scheduled payment plans | Employee 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.