---
title: "Tax and declaration data file format"
id: "tax-and-declaration-data-file-format"
project: "EHR User Guide"
url: "https://help.cloud5.com.au/articles/ehr-user-guide/tax-and-declaration-data-file-format"
updated: 2026-10-19T00:54:15Z
---

# Tax and declaration data file format

##  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 file. |
| --- | --- |

Here's the format to use. An asterisk (**\***) shows which data is mandatory.

| **Column &gt;** | **A\*** | **B\*** | **C\*** | **D\*** | **E** | **F\*** | **G\*** | **H\*** | **I\*** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | Employee Code | Effective Date | Payroll Code | Payer ABN | Payer ABN Branch | Pay Method Code | Payment Location | Tax File Number | Declaration Date |
| **Characters &gt;** | 10 |  | 4 | 11 | 3 | 1 | 4 | 9 |  |
|  |  | Format: <br>ddmmyy<br> <br>ddMmmyy<br> <br>ddmmccyy<br> <br>ddMmmccyy |  |  |  |  |  |  | Format: <br>ddmmyy<br> <br>ddMmmyy<br> <br>ddmmccyy<br> <br>ddMmmccyy |

| **Column &gt;** | **J** | **K** | **L** | **M\*** | **N\*** | **O\*** | **P\*** | **Q\*** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | Previous Surname | Previous Given Name 1 | Previous Given Name 2 | Basis of Employment | Rebate claimed includes FTAC1 | Savings rebate claim indicator | Payee Signature Present Ind | Tax Scale Code |
| **Characters &gt;** | 30 | 30 | 30 | 1 | 1 | 1 | 1 | 1 |
|  |  |  |  |  | Must be **y** (yes) or **n** (no) | Must be **y** (yes) or **n** (no) | Must be **y** (yes) or **n** (no) |  |

| **Column &gt;** | **R\*** | **S\*** | **T\*** | **U** | **V** | **W** | **X** | **Y** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | Generate Study and Training Support Loan Repayment | Flat Tax Rate | School Christmas Leave in Advance | Medicare Code | Number of Medicare Dependants | Tax Rebate Code | Zone Code | Dependant/ Zone Rebate |
| **Characters &gt;** | 1 | 10 | 1 |  |  | 4 | 2 | 10 |
|  |  | Enter tax rate percentage with two decimal points, or enter **0.00** | Must be **y** (yes) or **n** (no) | Leave this column blank. | Leave this column blank. |  | Zone code for Australian payrolls. Tax code flag (P or S) for Fiji. NZ leave blank. |  |

| **Column &gt;** | **Z** | **AA** | **AB** | **AC-AI ![](/resources/Storage/ehr-user-guide/Common/Info.png)** | **AJ** | **AK\*** | **AL** |
| --- | --- | --- | --- | --- | --- | --- | --- |
|  | % Variation | Tax Variation From Date | Tax Variation Upto Date |  | Tax Treatment | Income Stream | Country Code |
| **Characters &gt;** | 10 |  |  |  | 10 | 10 | 10 |
|  |  | Format: <br>ddmmyy<br> <br>ddMmmyy<br> <br>ddmmccyy<br> <br>ddMmmccyy | Format: <br>ddmmyy<br> <br>ddMmmyy<br> <br>ddmmccyy<br> <br>ddMmmccyy |  | Valid six-character code, ATO-defined values for each character. |  | Only mandatory if any of the following Income Streams are selected: <ul> <li> <span style="background-color: #ffffff;">IAA (Inbound Assignees to Australia)</span> </li> <li> <span style="background-color: #ffffff;">WHM (Working Holiday Makers)</span> </li> <li> <span style="background-color: #ffffff;">FEI (Foreign Employment)</span> </li> </ul> |

For NZ payrolls only. See table below. 

### Columns AC to AI are for NZ payrolls only 

| **Column &gt;** | **AC\*** | **AD\*** | **AE\*** | **AF\*** | **AG\*** | **AH** | **AI\*** |
| --- | --- | --- | --- | --- | --- | --- | --- |
|  | IRD number | Student loan flag | Loan rate | Extra pay rate | Non-resident flag | Voluntary withholding rate | KiwiSaver Status Flag |
| **Characters &gt;** | 9 | 1 | 8 | 8 | 1 | 8 | 2 |
|  | Must consist of 9 numeric characters | Must be y (yes) or n (no). | Numeric including decimal point (may be zero). | Numeric including decimal point (may be zero). | Must be y (yes) or n (no). | Numeric including decimal point (may be zero). | Valid values come from the hrtcode4 control table (kiwi code type). Common values include AK, CH, NK, NM, OT. |

| Next topic<br> <br>[Position and pay data file format](/articles/ehr-user-guide/position-and-pay-data-file-format) |
| --- |

© 2023 Fusion5. All rights reserved.