Completing the spreadsheet

How to complete the spreadsheet.

Last updated 21 April 2021

Do NOT copy and paste into the spreadsheet as this will corrupt the template.

Report information

Report information
Cell ref	Cell name	Schema XML element name	Schema XML attribute	CRS user guide page number	Notes
C2	Sending company Id number	SendingCompanyIN	-	11	Use either ABN, GIIN or TFN
C3	Warning	Warning	-	11	-
C4	Contact	Contact	-	12	Include name, email and phone number
C5	Message type indicator	MessageTypeIndic	-	12	Select the message type from the drop down list
C6	Reporting period end date	ReportingPeriod	-	13	YYYY-MM-DD e.g. 2017-12-31
C7	Unique message identifier	MessageRefID	-	12	See Unique Identifier section below
C8	Message reference	MessageRefID	-	12	See Unique Identifier section below
C10	Name	Name	-	13	-
C11	Country of residence	ResCountryCode	-	19	Must be AU
C12	Tax identification number	IN	-	19	Automatically generated
C13	Country of issue	IN	issued by	19	Automatically generated
C14	Type	AddressType	-	17	Select the address type from the drop down list
C15	Country	CountryCode	-	16	Select the country from the drop down list
C16	Country subentity	CountrySubentity	-	17	State or territory e.g. NSW, QLD, ACT
C17	Street	Street	-	17	-
C18	Building identifier	BuildingIdentifier	-	17	-
C19	Suite identifier	SuiteIdentifier	-	17	-
C20	Floor identifier	FloorIdentifier	-	17	-
C21	Post office box	POB	-	17	-
C22	Post code	PostCode	-	17	-
C23	City	City	-	17	-
C24	Document type	DocTypeIndic	-	28	Select the document type from the drop down list
C25	Unique document identifier	DocRefID	-	28	See Unique identifier section below
C26	Document reference	DocRefID	-	28	Automatically generated
C27	Corrected document reference identifier	CorrDocRefID	-	29	Only used when correcting or deleting a previously submitted report

A3:C3 Account details
Cell ref	Cell name	Schema XML element name	Schema XML attribute	CRS user guide page number	Notes
A3	Account number	AccountNumber	-	21	-
B3	Account number type	AccountNumber	AcctNumberType	22	-
C3	Closed	AccountNumber	ClosedAccount	22	-

D3:K3 Name
Cell ref	Cell name	Schema XML element name	Schema XML attribute	CRS user guide page number	Notes
D3	Name type	NamePerson_Type	xnlNameType	14	-
E3	Title	Title	-	15	-
F3	First name	FirstName	xnlNameType	15	-
G3	Middle name	MiddleName	xnlNameType	15	-
H3	Last name	LastName	xnlNameType	16	-
I3	Generation identifier	GenerationIdentifier	-	16	Name suffix e.g. JNR
J3	Suffix	Suffix	-	16	Name suffix e.g. DR
K3	General suffix	GeneralSuffix	-	16	Name suffix e.g. PHD

L3:N3 Account holder details
Cell ref	Cell name	Schema XML element name	Schema XML attribute	CRS user guide page number	Notes
L3	Country of residence	ResCountryCode	-	14	-
M3	Tax identification number	TIN	-	14	Overseas tax identification number
N3	Country of issue	TIN	issuedBy	14	Country that issued the tax identification number

O3:Y3 Address
Cell ref	Cell name	Schema XML element name	CRS user guide page number	Notes
O3	Type	AddressType	17	-
P3	Country	CountryCode	16	-
Q3	Country subentity	CountrySubentity	17	State or territory e.g. NSW, QLD, ACT
R3	Street	Street	17	-
S3	Building identifier	BuildingIdentifier	17	-
T3	Suite identifier	SuiteIdentifier	17	-
U3	Floor identifier	FloorIdentifier	17	-
V3	District name	DistrictName	17	Not used for Australian addresses
W3	Post office box	POB	17	-
X3	Post code	PostCode	17	-
Y3	City	City	17	-

Z3 Birth details
Cell ref	Cell name	Schema XML element name	CRS user guide page number	Notes
Z3	Date	BirthDate	18	-

AA3:AJ3 Account details
Cell ref	Cell name	Schema XML element name	Schema XML attribute	CRS user guide page number
AA3	Account balance	AccountBalance	-	25
AB3	Currency	AccountBalance	currCode	25
AC2:AJ2	Payment details	-	-	-
AC3	Dividend	PaymentAmnt	-	26
AD3	Currency	PaymentAmnt	currCode	26
AE3	Interest	PaymentAmnt	-	26
AF3	Currency	PaymentAmnt	currCode	26
AG3	Gross proceeds	PaymentAmnt	-	26
AH3	Currency	PaymentAmnt	currCode	26
AI3	Other payment	PaymentAmnt	-	26
AJ3	Currency	PaymentAmnt	currCode	26

AK3:AN3 Report details
Cell ref	Cell name	Schema XML element name	CRS user guide page number	Notes
AK3	Document type	DocTypeIndic	28	Select the document type from the drop down list
AL3	Unique identifier	DocRefID	28	See Unique Identifier section below
AM3	Document reference	DocRefID	28	Automatically generated
AN3	Corrected document reference	CorrDocRefID	29	Only used when correcting or deleting a previously submitted report

A4:D4 Account
Cell ref	Cell name	Schema XML element name	Schema XML attribute	CRS user guide page number	Notes
A4	Account number	AccountNumber	-	21	-
B4	Account number type	AccountNumber	AcctNumberType	22	-
C4	Closed	AccountNumber	ClosedAccount	22	-
D4	Account holder type	AcctHolderType	-	23	-

E4:T4 Organisation details E4:F4 Name
Cell ref	Cell name	Schema XML element name	Schema XML attribute	CRS user guide page number
E4	Name type	Name	nameType	20
F4	Name	Name	-	20

E4:T4 Organisation details G4:I4 Account holder details
Cell ref	Cell name	Schema XML element name	Schema XML attribute	CRS user guide page number	Notes
G4	Country of residence	ResCountryCode	-	19	-
H4	Identification number	IN	-	19	Overseas Tax identification number
I4	Country of issue	IN	issuedBy	19	Country that issued the Tax identification number

E4:T4 Organisation details J4:T4 Address type
Cell ref	Cell name	Schema XML element name	CRS user guide page number	Notes
J4	Type	AdressType	17	-
K4	Country	CountryCode	18	-
L4	Country subentity	CountrySubentity	17	State or territory e.g. NSW, QLD, ACT
M4	Street	Street	17	-
N4	Building identifier	BuildingIdentifier	17	-
O4	Suite identifier	SuiteIdentifier	17	-
P4	Floor identifier	FloorIdentifier	17	-
Q4	District name	DistrictName	17	Not used for Australian addresses
R4	Post office box	POB	17	-
S4	Post code	PostCode	17	-
T4	City	City	17	-

Controlling person U4:AB4 Name
Cell ref	Cell name	Schema XML element name	Schema XML attribute	CRS user guide page number	Notes
U4	Name type	NamePerson_Type	NameType	14	-
V4	Title	Title		15	-
W4	First name	FirstName	xnlNameType	15	-
X4	Middle name	MiddleName	xnlNameType	15	-
Y4	Last name	LastName	xnlNameType	16	-
Z4	Generation identifier	GenerationIdentifier	-	16	Name suffix e.g. JNR
AA4	Suffix	Suffix	-	16	Name suffix e.g. DR
AB4	General suffix	GeneralSuffix	-	16	Name suffix e.g. PHD

Controlling person AC4:AF4 Controlling person details
Cell ref	Cell name	Schema XML element name	Schema XML attribute	CRS user guide page number	Notes
AC4	Type	CtrlgPersonType	-	24	-
AD4	Country of residence	ResCountryCode	-	14	-
AE4	Tax identification number	TIN	-	14	Overseas tax identification number
AF4	Country of issue	TIN	issuedBy	14	Country that issued the tax identification number

Controlling person AG4:AQ4 Address
Cell ref	Cell name	Schema XML element name	CRS user guide page number	Notes
AG4	Type	AddressType	17	-
AH4	Country	CountryCode	16	-
AI4	Country subentity	CountrySubentity	17	State or territory e.g. NSW, QLD, ACT
AJ4	Street	Street	17	-
AK4	Building identifier	BuildingIdentifier	17	-
AL4	Suite identifier	SuiteIdentifier	17	-
AM4	Floor identifier	FloorIdentifier	17	-
AN4	District name	DistrictName	17	Not used for Australian addresses
AO4	Post office box	POB	17	-
AP4	Post code	PostCode	17	-
AQ4	City	City	17	-

Controlling person AR4 Birth details
Cell ref	Cell name	Schema XML element name	CRS user guide page number	Notes
AR4	Date	BirthDate	18	-

Controlling person AS4:AT4 Account details
Cell ref	Cell name	Schema XML element name	Schema XML attribute	CRS user guide page number
AS4	Account balance	AccountBalance	-	25
AT4	Currency	AccountBalance	currCode	25

Controlling person AU4:BB4 Payment details
Cell ref	Cell name	Schema XML element name	Schema XML attribute	CRS user guide page number
AU4	Dividend	PaymentAmnt	-	26
AV4	Currency	PaymentAmnt	currCode	26
AW4	Interest	PaymentAmnt	-	26
AX4	Currency	PaymentAmnt	currCode	26
AY4	Gross proceeds	PaymentAmnt	-	26
AZ4	Currency	PaymentAmnt	currCode	26
BA4	Other payment	PaymentAmnt	-	26
BB4	Currency	PaymentAmnt	currCode	26

Controlling person BC4:BF4 Report details
Cell ref	Cell name	Schema XML element name	CRS user guide page number	Notes
BC4	Document type	DocTypeIndic	28	-
BD4	Unique document identifier	DocRefID	28	See Unique Identifier section below
BE4	Document reference	DocRefID	28	Automatically generated
BF4	Corrected document reference	CorrDocRefID	29	Only used when correcting or deleting a previously submitted report

QC55152