---
title: "Bulk upload school increment & formula earnings data"
id: "bulk-upload-school-increment-formula-earnings-data"
project: "EHR User Guide"
url: "https://help.cloud5.com.au/articles/ehr-user-guide/bulk-upload-school-increment-formula-earnings-data"
updated: 2026-10-19T00:52:44Z
---

# Bulk upload school increment & formula earnings data

Where your organisation needs to take on both increment data and term/non term earnings data in bulk, your Fusion5 consultant organises this for you. It involves collecting the necessary data and running scripts to complete the upload.

Fusion5 provides a spreadsheet template for you to complete with the necessary data and this topic shows how to complete the spreadsheet.

| ![Information](/resources/Storage/ehr-user-guide/ehr-user-guide/Info.png) | If you need further assistance, contact us by logging an [iHelp request](https://infusion.fusion5.com/). |
| --- | --- |

Here's the format to use. An asterisk (**\***) shows which data is mandatory.

| ![Information](/resources/Storage/ehr-user-guide/ehr-user-guide/Info.png) | Remember  to exclude column headings, and save the file as a tab-delimited (**.txt**) file. |
| --- | --- |

| **Column &gt;** | **A\*** | **B\*** | **C** | **D** | **E** | **F** | **G** | **H** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | Employee Code | Employee Number | Increment Date At Take-On | Classification Code At Take-On | Classification Level At Take-On | Date of Take-On | Working Days At Take-On | Casual Days At Take-On |
| **Characters &gt;** | 10 | 2 |  | 8 | 2 |  | 8 | 8 |
|  |  | 0 = single employment<br><br>1 = second employment<br><br>...and so on | 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 | Part time employees - provide FTE days<br><br>Exclude:<br><ul><li><span style="font-size: 8pt;">LWOP days</span></li><li><span style="font-size: 8pt;">extra days taken on LSL at less than 100%</span></li></ul> |  |

| ![Information](/resources/Storage/ehr-user-guide/ehr-user-guide/Info.png) | While columns **C** to **H** are not mandatory, we recommend at least one of these columns contains data. If they are all blank, the data will not upload into the school take-on table. |
| --- | --- |

| **Column &gt;** | **I** | **J** | **K** | **L** | **M** | **N** |
| --- | --- | --- | --- | --- | --- | --- |
|  | Gross pay dollars | Dollars paid for non term days | Casual pay dollars | LWOP days since start of school year | Term days balance since start of school year | Non term days balance since start of school year |
| **Characters** **&gt;** | 8 | 8 | 8 | 8 | 8 | 8 |
|  | Gross pay accumulated since start of school year | Non-term pay accumulated since start of school year | Casual pay accumulated since start of school year | Where an employee has a break in service before employment position start date is uploaded to EmpowerHR, include break in service term days in this value | Work days elapsed since start of school year (or employee start date)<br><br>Exclude:<br><ul><li><span style="font-size: 8pt;">LWOP &gt; 20 days </span></li><li><span style="font-size: 8pt;">parental leave &gt; 20 days </span></li></ul> | Non-term days elapsed since start of school year (or employee start date)<br><br>Exclude:<br><ul><li><span style="font-size: 8pt;">LWOP &gt; 20 days </span></li><li><span style="font-size: 8pt;">parental leave &gt; 20 days</span></li></ul> |

| **Column &gt;** | **O** | **P** | **Q** |
| --- | --- | --- | --- |
|  | Normal leave affecting Christmas pay has been taken | FTE change | Acted more than 10 days |
| **Characters &gt;** | 1 | 1 | 1 |
|  | Enter:<br><ul><li><span style="font-size: 8pt;"><b>y</b> - if employee has taken normal leave (that affects Christmas pay) since start of school year, <i>or else</i></span></li><li><b><span style="font-size: 8pt;">n</span></b></li></ul> | Enter:<br><ul><li><span style="font-size: 8pt;"><b>y</b> - if employee has changed FTE% since start of school year, <i>or else</i></span></li><li><span style="font-size: 8pt;"><b>n</b><br></span></li></ul> | **Enter:**<br><ul><li><span style="font-size: 8pt;"><b>y</b> if employee has acted in promotional position for more than a 10-day period&#160;since start of school year, <i>or else</i></span></li><li><span style="font-size: 8pt;"><b>n</b><br></span></li></ul> |

### 

| Next topic<br><br>[Create your own reports](/articles/ehr-user-guide/create-your-own-reports) |
| --- |

© 2023 Fusion5. All rights reserved.