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.
|
Remember to exclude column headings from the files. |
Here's the format to use. An asterisk (*) shows which data is mandatory.
| Column > | A | B | C | D | E | 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 | J | K | L | 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 |
© 2023 Fusion5. All rights reserved.