What files do I need to prepare?
You need to create a tab-delimited (.txt) file for each type of required data.
![]() |
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 > | 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 > | 10 | 4 | 4 | 1 | 1 | 2 | |||
y = yes n = no | y = yes n = no | Format: ddmmyy ddMmmyy ddmmccyy ddMmmccyy | Format: ddmmyy ddMmmyy ddmmccyy ddMmmccyy | Format: ddmmyy ddMmmyy ddmmccyy ddMmmccyy | Numeric characters |
| Column > | 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 > | 5 | 12 | 12 | 12 | 12 | 5 | 4 | 1 | |
Format: ddMmm | Format: ddmmyy ddMmmyy ddmmccyy ddMmmccyy | Must be blank. |
LSL (hours) file format
| Column > | 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 > | 10 | 4 | 4 | 1 | 12 | ||||
Format: ddmmyy ddMmmyy ddmmccyy ddMmmccyy | Format: ddmmyy ddMmmyy ddmmccyy ddMmmccyy | Format: ddmmyy ddMmmyy ddmmccyy ddMmmccyy | Format: ddmmyy ddMmmyy ddmmccyy ddMmmccyy | y = yes n = no | If Accrue by Hours Worked (column H): = n, enter the number of hours = y, enter 0.00 |
| Column > | 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 > | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 4 | |
If Accrue by Hours Worked (column H): = n, enter 0.00 = y, enter the number of hours | Format: ddmmyy ddMmmyy ddmmccyy ddMmmccyy |
© 2023 Fusion5. All rights reserved.
