What file do I need to prepare?
You need to create a tab-delimited (.txt) file containing the required data.
|
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:
|
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.
|
© 2023 Fusion5. All rights reserved.