Bulk update external regular transactions

You can update regular transaction information in bulk from an Excel spreadsheet.  

EmpowerHR maintains a history record by end-dating the existing transactions you've updated.

What file do I need to prepare?

You need to create an xml file generated from your Excel spreadsheet containing the required data. 

Information

Remember to exclude column headings from the files.

Here's the format to use.  Each row should represent an employee and a leave type/code.  An asterisk (*) shows which data is mandatory.  

Column >
A*
B*C*DE
F
G

Employee Code
Payment CodeAmount or PercentageFrom DateUp to DateLimitReference
Characters >
10
4
12



30

Example:

000221

Example:

4000


Example:

27Aug24

Example:

30Nov24

Example:

500

Example:

123456A


Column >
H
IJK*
LM

Cost Centre
HoursBy Employment FlagEmploymentAnnual AmountSuper Flag
Characters >
16
91
1
91

Example:

cc01

Example:

7.60

Example:

y

Example:

0

Example:

1500

Example:

y

Update external regular transactions in bulk

To bulk update regular transaction information from a spreadsheet:

  1. Go to Tasks > Employees > Employee Information > External Regular Trans Entry.


  1. Click Window and select the spreadsheet file.
  2. Click Continue.
  3. EmpowerHR loads and validates the spreadsheet data.
  4. If any data fails validation, the system displays an error log.



Next topic

Bulk update external regular allowances


© 2023 Fusion5. All rights reserved.