^Login

Frequently Asked Questions

Authors
Category   Billing   Employee Access   Employee Management   Employee Settings   EOFY   Fingerprint Scanners   General   Glossary   Groups   HR   Jobs   Leave   Mobile App   Notification Config   Payroll   Payroll Deduction   Payroll Rules   Reports   Roster   Security   Settings   Skills Matrix   STP   Superannuation   Timesheet   Timesheets   VEVO   Xero

How do I upload bulk payments via CSV?

Author Dylan Wong@Microkeeper
Category Payroll
Last Modified 02/07/2025

Payments can be bulk uploaded via CSV through the Bulk Action area of a Payrun.

  1. Click the "Bulk Actions" button on the top of the unlocked Payrun
  2. Select "Payment"
  3. Click the "Import Payments via CSV" button
  4. Review the uploaded items and double check the total payments
  5. Click "Add Payments" to confirm adding payment items to payslips.

Prepare your CSV file formatted with columns for:

  • Employee Identifier. Accepted formats are:
    • Username. (e.g., john_smith)
    • Name. (e.g., John Smith or Smith John)
    • EID. (e.g., 1234)
    • EmployeeID. (e.g., abc123)
  • Title: The Title that appears on the employee's payslip. (e.g., "Car Allowance")
  • Job: The job allocation of the payslip item if needed.
  • Rate: The rate to be paid. (e.g., 25)
  • Hours: The number of hours to be paid. (e.g., 38)
  • Multiplier: The multiplier of the rate to be paid. (e.g., 1)
  • Classification: The classification of the payslip item. Refer to this table for more information.
  • STP Category: The STP code of the payslip item. Refer to this table for more information.


Employee Identifier
Title
Job
Rate
Hours
Multiplier
Classification
STP Category
john_smithOTE123425.0081Normal
EID123OT 1.5xJob A30.0061.5OvertimeMeals