---
title: "Long service leave data file format"
id: "long-service-leave-data-file-format"
project: "EHR User Guide"
url: "https://help.cloud5.com.au/articles/ehr-user-guide/long-service-leave-data-file-format"
updated: 2026-10-19T00:54:15Z
---

# Long service leave data file format

## What files do I need to prepare?

You need to create a tab-delimited (**.txt**) file for each type of 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.

### LSL (days) file format

| **Column &gt;** | **A\*** | **B\*** | **C\*** | **D\*** | **E\*** | **F\*** | **G\*** | **H\*** | **I** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | Employee Code | LSL Type | LSL Code | Accrue LSL By Hours | Ignore Prior Deferrals | Start Date | Last Accrual Date | Original Last Accrual Date | Day to Accrue On |
| **Characters &gt;** | 10 | 4 | 4 | 1 | 1 |  |  |  | 2 |
|  |  |  |  | **y** = yes<br><br>**n** = no | **y** = yes<br><br>**n** = no | Format:<br><br>ddmmyy<br><br>ddMmmyy<br><br>ddmmccyy<br><br>ddMmmccyy | Format:<br><br>ddmmyy<br><br>ddMmmyy<br><br>ddmmccyy<br><br>ddMmmccyy | Format:<br><br>ddmmyy<br><br>ddMmmyy<br><br>ddmmccyy<br><br>ddMmmccyy | Numeric characters |

| **Column &gt;** | **J** | **K** | **L\*** | **M** | **N** | **O** | **P** | **Q** | **R** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | Day and Month to Accrue | Accrual Date | Percentage Accrued | Days Accrued (Current) | Days Accrued (Non Current) | Fulltime Percentage | Number of Calendar Days | Reason Flag | Delete Flag |
| **Characters &gt;** | 5 |  | 12 | 12 | 12 | 12 | 5 | 4 | 1 |
|  | Format:<br><br>ddMmm | Format:<br><br>ddmmyy<br><br>ddMmmyy<br><br>ddmmccyy<br><br>ddMmmccyy |  |  |  |  |  |  | Must be blank. |

### LSL (hours) file format

| **Column &gt;** | **A\*** | **B\*** | **C\*** | **D\*** | **E\*** | **F\*** | **G\*** | **H\*** | **I\*** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | Employee Code | LSL Type | LSL Code | Start Date | Last Accrual Date | Original Last Accrual Date | Rule Effective Date | Accrue by Hours Worked | Hours to Accrue per Day |
| **Characters &gt;** | 10 | 4 | 4 |  |  |  |  | 1 | 12 |
|  |  |  |  | Format:<br><br>ddmmyy<br><br>ddMmmyy<br><br>ddmmccyy<br><br>ddMmmccyy | Format:<br><br>ddmmyy<br><br>ddMmmyy<br><br>ddmmccyy<br><br>ddMmmccyy | Format:<br><br>ddmmyy<br><br>ddMmmyy<br><br>ddmmccyy<br><br>ddMmmccyy | Format:<br><br>ddmmyy<br><br>ddMmmyy<br><br>ddmmccyy<br><br>ddMmmccyy | **y** = yes<br><br>n = no | If **Accrue by Hours Worked** (column H):<br><br>= **n**, enter the number of hours<br><br>**= y**, enter **0.00** |

| **Column &gt;** | **J\*** | **K\*** | **L** | **M\*** | **N** | **O** | **P** | **Q** | **R** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | Hours to Accrue per Hour | Standard Hours per Day | Accrual Date | Percent Accrued | Average FTE % | Current Balance in Hours | Non-current Balance in Hours | Days in Accrued Period | Leave Reason |
| **Characters &gt;** | 12 | 12 |  | 12 | 12 | 12 | 12 | 12 | 4 |
|  | If **Accrue by Hours Worked** (column H):<br><br>= **n**, enter **0.00**<br><br>**= y**, enter the number of hours |  | Format:<br><br>ddmmyy<br><br>ddMmmyy<br><br>ddmmccyy<br><br>ddMmmccyy |  |  |  |  |  |  |

| Next topic<br><br>[Regular transactions data file format](/articles/ehr-user-guide/regular-transactions-data-file-format) |
| --- |

© 2023 Fusion5. All rights reserved.