---
title: "GL payment code accounts file format"
id: "gl-payment-code-accounts-file-format"
project: "EHR User Guide"
url: "https://help.cloud5.com.au/articles/ehr-user-guide/gl-payment-code-accounts-file-format"
updated: 2026-10-19T00:53:08Z
---

# 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](/resources/Storage/ehr-user-guide/ehr-user-guide/Info.png) | Remember  to exclude column headings from the files. |
| --- | --- |

### 

Here's the format to use. An asterisk (**\***) shows which data is mandatory.

| **Column &gt;** | **A** | **B** | **C** | **D** | **E** | **F** | **G** |
| --- | --- | --- | --- | --- | --- | --- | --- |
|  | Organisation | Payment Code | Sequence No. | Interface | Cost Code Rule No. | Cost Code | Category Rule No. |
| **Characters &gt;** | 4 | 4 | 6 | 1 | 13 | 16 | 13 |
|  |  | Must not already exist. |  |  |  |  |  |

| **Column &gt;** | **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 &gt;** | 8 | 8 | 8 including decimal point | 8 | 1 | 16 | 10 including decimal point | 60 |

| Next topic<br><br>[Bulk upload new employees](/articles/ehr-user-guide/bulk-upload-new-employees) |
| --- |

© 2023 Fusion5. All rights reserved.