WiseWage
Help CentrePayroll PlatformStart HereSet up employees and import payroll records

Start Here

Set up employees and import payroll records

Employee records are the foundation of payroll in WiseWage. Each employee should have a clear staff ID, role, payroll eligibility dates, department, location, bank details, pension details, and assigned salary components before payroll preparation.

WiseWage SupportUpdated July 20266 min readCompany Admin, Payroll AdminCore HR, Payroll, Enterprise
WiseWage employee import workflow
  1. 1Start from HR > Employees
  2. 2Review import requirements
  3. 3Import the employee file
01

Before you start

  1. 1
    Create locations, departments, grades, and salary components first.
  2. 2
    Confirm the staff ID format your company will use.
  3. 3
    Prepare bank, pension, employment date, department, and location data.
02

Add one employee manually

  1. 1
    Open HR > Employees. After the most recent payroll is marked Paid, the directory opens on the next payroll month so you can review workforce eligibility for the upcoming run.
  2. 2
    Click Add Employee.
  3. 3
    Complete personal details, pension details, bank details, and salary component sections.
  4. 4
    Save the employee and review the record in the employee directory.
03

Import employees by Excel or CSV

  1. 1
    Open HR > Employees and choose Import Employees.
  2. 2
    Download the WiseWage Excel employee import template. CSV is still supported for compatible existing files.
  3. 3
    Keep required headers such as staffId and role.
  4. 4
    Use firstName and lastName, or provide fullName.
  5. 5
    Use the Excel template for phone numbers, account numbers, BVN, NIN, and other identifier fields so leading zeros are preserved. When copying data from another workbook, use Paste Special → Values.
  6. 6
    Enter PFA Name and Pension ID for employees who will be included in pension filing. Older pensionFundAdministrator, pfaName, pfaNumber, and PFA Number headers remain accepted when importing existing files.
  7. 7
    Leave employeePensionRate and employerPensionRate blank only when no pension contribution should be calculated; WiseWage does not apply a hidden pension-rate default.
  8. 8
    If either pension-rate column contains a decimal between 0 and 1 (for example 0.08), WiseWage shows a confirmation before import and converts it to the equivalent whole percentage (8%). Review the affected rows before confirming.
  9. 9
    For Manage Current Employees General details update templates, a blank cell deliberately clears that saved field. Leave a field's column out of the file when its existing value should remain unchanged.
  10. 10
    Use salary component columns only for regular fixed or variable employee-level components. Formula components are excluded because payroll calculates them from their formula logic.
  11. 11
    Upload the completed file and review row-level errors before payroll. Payroll eligibility starts from employment date; if it is missing, WiseWage creation date is used. When an employment date predates WiseWage creation, WiseWage asks you to verify it before payroll is prepared.
  12. 12
    After payroll is prepared, reports retain the Staff ID, employee details, pay components, pension data, and calculation data captured for that run. Correct future employee records separately; historical payroll reports are not rewritten.

Was this guide helpful?

Your feedback helps us improve WiseWage documentation.

Related guides

Start HereCreate and manage salary componentsStart HerePrepare departments, grades, and locationsPay RunsRun payroll and upload variable components