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

Remember to exclude column headings from the file.

Here's the format to use.  An asterisk (*) shows which data is mandatory. 

Column >
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 >
10

4 11 3 1 4 9


Format:

ddmmyy

ddMmmyy

ddmmccyy

ddMmmccyy







Format:

ddmmyy

ddMmmyy

ddmmccyy

ddMmmccyy


Column >
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 >
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 >
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 >
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 >
Z
AA AB
AC-AI  
AJ
AK*
AL

% Variation
Tax Variation From Date
Tax Variation Upto Date

Tax Treatment
Income Stream
Country Code
Characters >
10


10
10 10


Format:

ddmmyy

ddMmmyy

ddmmccyy

ddMmmccyy

Format:

ddmmyy

ddMmmyy

ddmmccyy

ddMmmccyy


Valid six-character code, ATO-defined values for each character.

Only mandatory if any of the following Income Streams are selected:
  • IAA (Inbound Assignees to Australia)
  • WHM (Working Holiday Makers)
  • FEI (Foreign Employment)

For NZ payrolls only. See table below.


Columns AC to AI are for NZ payrolls only

Column >
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 >
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

Position and pay data file format



© 2023 Fusion5. All rights reserved.