Skip to content
๐Ÿ’ธMintage Payroll

Importing data โ€‹

Typing changes one cell at a time is fine for a handful of people. For dozens or hundreds, download a template, fill it in with a spreadsheet program, and import it.

Monthly โ†’ Import: templates on the left, imports on the right (demo data)

Templates (download) โ€‹

TemplateUse it to
Import Employee TemplateAdd many new team members at once.
Import Salary Data TemplateSet salaries and pay types.
Payroll Adjustments TemplateChange this period's values. It comes pre-filled with the period's employees and their current values โ€” just edit and re-upload.
Import Bank Account TemplateLoad bank details.
Child Allowance TemplateLoad child allowance claims.

Imports (upload) โ€‹

ImportWhat it does
Import Payroll AdjustmentsApplies the adjustments sheet. A live Import Progress list shows each employee as they're updated and recalculated.
Import FastPay AdjustmentsA quicker adjustments format.
Import EmployeesCreates team members from the employee template.
Import Child AllowancesLoads child claims.

Some companies also see imports for their time-and-attendance systems (biometric clocks, scheduling tools, time-tracking apps). Those only appear where they're switched on.

Good habits โ€‹

  1. Start from a fresh download. The adjustments template reflects the current period, including column names for your company's custom fields.
  2. Change only what you need. Untouched cells are left as they are.
  3. Read the result report. Each import produces a downloadable report of what worked and what failed, and failed rows can be retried.
  4. Check the grid afterwards. Every imported employee is recalculated, so totals update straight away.

Current period only

By default you can't import into a previous payroll. Your role needs Import data from previous period to do that.

Next: When someone leaves โ†’

Built with the Invernisoft KB house.