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.
|
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* | D | E | F | G |
| Employee Code | Payment Code | Amount or Percentage | From Date | Up to Date | Limit | Reference | |
| Characters > | 10 | 4 | 12 | 30 | |||
Example: 000221 | Example: 4000 | Example: 27Aug24 | Example: 30Nov24 | Example: 500 | Example: 123456A |
| Column > | H | I | J | K* | L | M |
| Cost Centre | Hours | By Employment Flag | Employment | Annual Amount | Super Flag | |
| Characters > | 16 | 9 | 1 | 1 | 9 | 1 |
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:
- Go to Tasks > Employees > Employee Information > External Regular Trans Entry.

- Click Window and select the spreadsheet file.
- Click Continue.
- EmpowerHR loads and validates the spreadsheet data.
- If any data fails validation, the system displays an error log.
© 2023 Fusion5. All rights reserved.