---
title: "Bulk update external regular transactions"
id: "bulk-update-external-regular-transactions"
project: "EHR User Guide"
url: "https://help.cloud5.com.au/articles/ehr-user-guide/bulk-update-external-regular-transactions"
updated: 2026-10-19T00:52:38Z
---

# 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](/resources/Storage/ehr-user-guide/ehr-user-guide/Info.png) | 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 &gt;** | **A\*** | **B\*** | **C\*** | **D** | **E** | **F** | **G** |
| --- | --- | --- | --- | --- | --- | --- | --- |
|  | Employee Code | Payment Code | Amount or Percentage | From Date | Up to Date | Limit | Reference |
| **Characters &gt;** | 10 | 4 | 12 |  |  |  | 30 |
|  | Example:<br><br>000221 | Example:<br><br>4000 |  | Example:<br><br>27Aug24 | Example:<br><br>30Nov24 | Example:<br><br>500 | Example:<br><br>123456A |

| **Column &gt;** | **H** | **I** | **J** | **K\*** | **L** | **M** |
| --- | --- | --- | --- | --- | --- | --- |
|  | Cost Centre | Hours | By Employment Flag | Employment | Annual Amount | Super Flag |
| **Characters &gt;** | 16 | 9 | 1 | 1 | 9 | 1 |
|  | Example:<br><br>cc01 | Example:<br><br>7.60 | Example:<br><br>y | Example:<br><br>0 | Example:<br><br>1500 | Example:<br><br>y |

## Update external regular transactions in bulk![](/resources/Storage/ehr-user-guide/ehr-user-guide/icons/desktop%20icon.png)

To bulk update regular transaction information from a spreadsheet:

1. Go to **Tasks &gt; Employees &gt; Employee Information &gt; External Regular Trans Entry**.

![](/resources/Storage/ehr-user-guide/bulk-update-external-regular-transactions/external%20reg%20tx%20entry.png)

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<br><br>[Bulk update external regular allowances](/articles/ehr-user-guide/bulk-update-external-regular-allowances) |
| --- |

© 2023 Fusion5. All rights reserved.