GL payment code accounts file format

When uploading general ledger (GL) payment code accounts in bulk to EmpowerHR, you use the option called GL Payment Code Accounts Data Load from the Data Take-On Initiation screen.  Here's the file format to use. 

What file do I need to prepare?

You need to create a tab-delimited (.txt) file containing the required data.

Information

Remember to exclude column headings from the files.

Here's the format to use.  An asterisk (*) shows which data is mandatory. 

Column >
A
BCDE
F
G

Organisation
Payment Code
Sequence No.
Interface
Cost Code Rule No.
Cost Code
Category Rule No.

Characters >

4

4

6

1

13

16

13



Must not already exist.





Column >
H
I
JKL
M
N
O

Category Code
On-Cost Category
Cost %
Account No.
Debit (d) or Credit (c)
Override Mask
Hourly Rate
Narrative

Characters >

8

8

8 including decimal point

8

1

16

10 including decimal point

60




Next topic

Bulk upload new employees




© 2023 Fusion5. All rights reserved.