The full names of the person to be contacted with technical queries related to this file. The full names of the business person to be contacted with queries related to this file.
Operational Update
17
Contact Person Surname
Descriptive change:
The surname of the person to be contacted with technical queries related to this file. The surname of the business person to be contacted with queries related to this file.
Operational Update
18
Business Telephone Number 1
Descriptive change:
The primary contact telephone number for business contact person.
Include country code if not South African number (e.g. 0044 for the United Kingdom).
Length:
0:150 - No condition met
9:15 – Condition met
Operational Update & ebTax already caters for this change
19
Business Telephone Number 2
Descriptive change:
A secondary contact telephone number for business contact person
Include country code if not South African number (e.g. 0044 for the United Kingdom).
Operational Update
20
Cell Phone Number
Descriptive change:
The cell phone number of the business contact person
Include country code if not South African number (e.g. 0044 for the United Kingdom).
Length:
0:150 - No condition met
9:15 – Condition met
Operational Update & ebTax already caters for this change
21
Contact Email
Descriptive change:
The email address for the business contact person
Operational Update
-
Special Characters
Alphanumeric (AN) to be split between AN and ANS:
Alphanumeric (AN) - Alphabet A until Z (Upper Case and Lower Case), AND Numbers 0 to 9 and a decimal point
Alphanumeric with Space (ANS) - Alphabet A until Z (Upper Case and Lower Case), AND Numbers 0 to 9 and a decimal point, AND a space character
ebTax already caters for this
Reports
Reconciliation File Changes
No
Field Name
Change
4
File Layout Version
Version Number must = 1 2
12
Group Total
Group Total will be defaulted to 1 as this is no longer required. SARS added a duplicate file recognition capability after the initial IT3 implementation.
52
Account Holder Date of Birth
If no data available then insert “0001-01-01”.
104
Sum of all monetary changes
The value of this field must be equal to the sum of all values entered into the following fields: Opening Balance, Closing Balance, Net Return on Investment, Interest, Dividends, Capital Gain / Loss, Other, Market Value at End of Submission Period Transaction Value.
Changes not Implemented
No
Field Name
Change
Reason for not implementing
7
Test Data Indicator
A test file with Field 7 = T will only be allowed in the test environment. A production file with Field 7 = L will only be allowed in the production environment.
The correct option must be selected by the user extracting the reconciliation file.
Submitting Entity
New Fields
The below requires operational changes to update existing Submitting Entities.
No
Field Name
Description
Required
Condition Rule
Data Type
Length Type
Length
(Min:Max)
601
Regulator Registration Number
Regulator Registration Number for Submitting Entity (e.g. Financial Sector Conduct Authority (FSCA) registration number)
O
None
FT
VAR
0:50
602
Regulator Designation
Insert the Regulator Designation e.g. FSCA
C
If Regulator Registration Number (Field 601) contains a value then this field is mandatory, else it must not be completed.
FT
VAR
0:0 – No value
1:30 – Contains a value
Changes not Implemented
No
Field Name
Change
Reason for not implementing
37
Postal Code
Field Type: ANS
ebTax already caters for this change.
27
Nature of Person
Length: 9 4:33
ebTax already caters for this change.
111
Registration number
Length:
0:15 – No condition met
1:15 – Condition met
ebTax already caters for this change.
34-36
Postal address line 2-4
Length:
0:100 – Not completed
1:100 – Completed
ebTax already caters for this change.
Account Holder Demographic Data
Field Name Update
No
Field Name
Old Value
47
Names
Account Holder First Two Names
Validation Changes
No
Field Name
New Rule
47
Account Holder Names
Allow more than two names separated by spaces.
*ebTax is yet to determine how this will impact the pre-population of demographic data across the system and how the change will be implemented.
48
Account Holder Identification Type
Mandatory
49
Account Holder Identification Number
Mandatory
If Account Holder Identification Type is set to ‘Internal identification number’ then Account Holder Identification Number must be set to “NOIDNUMBER”.
55
Account Holder Address Details - Physical: Postal Code
Allow “0000” if code is not available
61
Account Holder Postal Code
Allow “0000” if code is not available
Field Length Changes
No
Field Name
New Length
47
Account Holder Names
1:100
55
Account Holder Address Details - Physical: Unit number
Personal particulars – All the names of the individual (excluding Surname).
49
Account Holder Identification Number
Uniquely identifies the account holder. If no Identification Number is available, then include “NOIDNUMBER” in this field.
61
Account Holder Address Details - Physical: Postal Code
Indicates the postal code of the Account Holder Physical address. Use “0000” if code is not available.
67
Account Holder Postal Code
Postal code of the Account Holder.. Use “0000” if code is not available.
New Fields
No
Field Name
Description
Required
Condition Rule
Data Type
Length Type
Length
(Min:Max)
Data Validations
53
Account Holder South African resident for tax purposes indicator
Account Holder South African resident for tax purposes indicator
C
If Account Holder Nature of Person (Field 54) = INDIVIDUAL, FOREIGN_INDIVIDUAL, or INDIVIDUAL_ESTATE, then the field is mandatory; optional for all other NoP's.
A
VAR
0:1 0 – no condition met
1:1 – condition met
If one or more country of residence for tax purposes were recorded on the Account Holder record:
If RSA only then report “Y” - Yes
If RSA and other countries then report “Y” - Yes
If no RSA record then report “N” - No
If no country of residence for tax purposes was recorded for the Account Holder, then report “U” - Unknown
400
Telephone Number
Telephone number for the account holder / representative
Include country code if not South African number (e.g. 0044 for the United Kingdom).
O
None
AN
VAR
0:0 – if this field is blank
9:15 – if this field is completed
Only numeric values are allowed
No spaces are allowed
+ is not allowed
Value must not contain a decimal point
National numbers must start with 0
International numbers must start with 00
401
Cell Phone Number
Cell phone number for the account holder / representative
Include country code if not South African number (e.g. 0044 for the United Kingdom).
M
None
AN
VAR
9:15
Only numeric values are allowed
No spaces are allowed
+ is not allowed
Value must not contain a decimal point
National numbers must start with 0
International numbers must start with 00
Insert “999999999999999” if no information available.
402
Contact Email
Email for the account holder / representative.
M
None
FT
VAR
5:80
Must contain one @ sign
Must contain a domain which must be indicated with a dot (.)
Account Holder Address Details - Physical: Postal Code
Field Type: ANS
ebTax already caters for this change
67
Account Holder Postal Code
Field Type: ANS
ebTax already caters for this change
44
Account Holder FICA Status
Descriptive
ebTax already caters for this change
Account Holder Financial Data
Validation Change
No
Field Name
New Rule
74
Account Number
Mandatory
Allow “No Account Number” as Account Number.
75
Account Type
Mandatory
IF Account Number = “NO ACCOUNT NUMBER”, THEN value of Account Type must be set to 23 - “ No account type”, ELSE value 23 - “ No account type” IS NOT ALLOWED
81
Net Return on Investment
If Interest (Field 83) or Dividends (Field 85) or Capital gain / loss (Field 87) or Other (Field 802) were completed, then this field is Optional,
Else this field is Mandatory
89
Transaction Value – Total Indicator
Mandatory
Drop Down Option Changes
No
Field Name
Option changes
75
Account Type
New options:
No Account Type (23)
Help Text Update
No
Field
New Help Text
74
Account Number
Transaction account number. If no Account Number available, then insert “NO ACCOUNT NUMBER”. Provide an Account Number recognisable to the Account Holder – do not include internal identifiers.
Field Length Changes
No
Field Name
New Length
74
Account Number
1:50
Field Type Changes
No
Field Name
New Type
74
Account Number
FT
New Fields
No
Field Name
Description
Required
Condition Rule
Data Type
Length Type
Length
(Min:Max)
Data Validations
901
Sharia Indicator
Indicates if the account is classified as Sharia or not
M
None
A
FIX
1:1
“Y” – if Sharia
“N” – if not Sharia
“U” – if Unknown or not applicable
801
Other - Source Code
Other – source code for reporting period.
Used for e.g. Manufactured Dividends.
C
If Other (Field 802) contains a value, then this field is Mandatory
Else if Other (Field 802) does not contain a value then this field is NULL.
N
FIX
4:4 – if condition met
0:0 – if condition not met
Value has to be 4257
802
Other
Other value for reporting period.
Used for e.g. Manufactured Dividends
C
If Net Return on Investment (Field 81) was not completed, then this field is Mandatory.
N
VAR
4:18 – if field completed
0:0 – if field not completed
If 1.00 or greater, no leading zeros allowed. If <1.00, there must be 1 zero before the decimal
Must always have 2 values after the point to denote cent
Values could be zero (0) or more
Don’t allow negative values
Account Holder Transactional Data
*Mandatory
*one to many relationship with AHFD (Account Holder Financial Data)
This section must contain both the following record types (report R 0.00 in the Transaction Value – Field 100, if there were no transactions for the reporting period):
Transaction Type (Field 98) = 01 and Assigned Source Code (Field 99) = 4219
Transaction Type (Field 98) = 04 and Assigned Source Code = 4248
This section must contain both the following record types, if Transaction Date (Field 97) >= 2018-03-01 (report R 0.00 in the Transaction Value – Field 100, if there were no transactions for the reporting period):
Transaction Type (Field 98) = 02 and Assigned Source Code = 4246
Transaction Type (Field 98) = 03 and Assigned Source Code = 4247
Validation Change
No
Field Name
New Rule
99
Assigned Source Code
IF Transaction Type (Field 98) = 01 THEN has to be = 4219.
IF Transaction Type (Field 98) = 02 AND Transaction Date (Field 97) >= 2018-03-01 THEN has to be = 4246.
IF Transaction Type (Field 98) = 03 AND Transaction Date (Field 97) >= 2018-03-01 THEN has to be = 4247.IF Transaction Type (Field 98) = 04 THEN field has to be = 4248.
98
Transaction Type
Codes = 02 or 03 (Transfer In or Out) would only be allowed when Transaction Date (Field 97) >= 2018-03-01.
Field Length Changes
No
Field Name
New Length
95
I3S Unique Number
1:100
Source Code Changes
Code
Transaction Type
4246
Tax free investment account - transfer in
4247
Tax free investment account - transfer out
4248
Tax free investment account - withdrawal
4257
Tax free investment account - other
Changes not Implemented
No
Field Name
Change
Reason for not implementing
95
I3S Unique Number
Must be equal to a Unique Identifier where record type = AHFD
ebTax already caters for this change
97
Transaction Date
Description:
Date of the transaction.
If total values are supplied for a reporting period (i.e. non-transactional data) (or no transactions occurred) in Field 100 (Transaction Value), then this date should be last day, month and year of the applicable reporting period.
DevOps Support
Channel/Source
Field Length Changes
No
Field Name
New Length
16
Contact Person Name
1:100
17
Contact Person Surname
1:120
Changes not Implemented
No
Field Name
Change
Reason for not implementing
16
Contact Person Name
Descriptive change:
The full names of the person to be contacted with technical queries related to this file.The full names of the business person to be contacted with queries related to this file.Operational Update
17
Contact Person Surname
Descriptive change:
The surname of the person to be contacted with technical queries related to this file.The surname of the business person to be contacted with queries related to this file.Operational Update
18
Business Telephone Number 1
Descriptive change:
The primary contact telephone number for business contact person.
Include country code if not South African number (e.g. 0044 for the United Kingdom).
Length:
0:15
0- No condition met9:15 – Condition met
Operational Update & ebTax already caters for this change
19
Business Telephone Number 2
Descriptive change:
A secondary contact telephone number for business contact person
Include country code if not South African number (e.g. 0044 for the United Kingdom).
Operational Update
20
Cell Phone Number
Descriptive change:
The cell phone number of the business contact person
Include country code if not South African number (e.g. 0044 for the United Kingdom).
Length:
0:15
0- No condition met9:15 – Condition met
Operational Update & ebTax already caters for this change
21
Contact Email
Descriptive change:
The email address for the business contact person
Operational Update
Alphanumeric (AN) to be split between AN and ANS:
Reports
Reconciliation File Changes
No
Field Name
Change
4
File Layout Version
Version Number must =
1212
Group Total
Group Total will be defaulted to 1 as this is no longer required. SARS added a duplicate file recognition capability after the initial IT3 implementation.
52
Account Holder Date of Birth
If no data available then insert “0001-01-01”.
Changes not Implemented
No
Field Name
Change
Reason for not implementing
7
Test Data Indicator
A test file with Field 7 = T will only be allowed in the test environment. A production file with Field 7 = L will only be allowed in the production environment.
The correct option must be selected by the user extracting the reconciliation file.
Submitting Entity
New Fields
The below requires operational changes to update existing Submitting Entities.
No
Field Name
Description
Required
Condition Rule
Data Type
Length Type
Length
(Min:Max)
601
Regulator Registration Number
Regulator Registration Number for Submitting Entity (e.g. Financial Sector Conduct Authority (FSCA) registration number)
O
None
FT
VAR
0:50
602
Regulator Designation
Insert the Regulator Designation e.g. FSCA
C
If Regulator Registration Number (Field 601) contains a value then this field is mandatory, else it must not be completed.
FT
VAR
0:0 – No value
1:30 – Contains a value
Changes not Implemented
No
Field Name
Change
Reason for not implementing
27
Nature of Person
Length:
94:33ebTax already caters for this change.
111
Registration number
Length:
0:15 – No condition met
1:15 – Condition met
ebTax already caters for this change.
34-36
Postal address line 2-4
Length:
0:100
– Not completed1:100 – CompletedebTax already caters for this change.
Account Holder Demographic Data
Field Name Update
No
Field Name
Old Value
47
Names
Account Holder First Two Names
Validation Changes
No
Field Name
New Rule
47
Account Holder Names
Allow more than two names separated by spaces.
*ebTax is yet to determine how this will impact the pre-population of demographic data across the system and how the change will be implemented.
49
Account Holder Identification Number
55
Account Holder Address Details - Physical: Postal Code
Allow “0000” if code is not available
61
Account Holder Postal Code
Allow “0000” if code is not available
Field Length Changes
No
Field Name
New Length
47
Account Holder Names
1:100
55
Account Holder Address Details - Physical: Unit number
0:8
57
Account Holder Address Details - Physical: Street Number
0:8
58
Account Holder Address Details - Physical: Street/Name of Farm
0:27
59
Account Holder Address Details - Physical: Suburb/ District
0:36
60
Account Holder Address Details - Physical: City/Town
0:36
63-66
Account Holder Postal Address Line 1 - 4
0:100
Help Text Update
No
Field
New Help Text
47
Account Holder Names
Personal particulars – All the names of the individual (excluding Surname).
49
Account Holder Identification Number
Uniquely identifies the account holder. If no Identification Number is available, then include “NOIDNUMBER” in this field.
61
Account Holder Address Details - Physical: Postal Code
Indicates the postal code of the Account Holder Physical address. Use “0000” if code is not available.
67
Account Holder Postal Code
Postal code of the Account Holder.. Use “0000” if code is not available.
New Fields
No
Field Name
Description
Required
Condition Rule
Data Type
Length Type
Length
(Min:Max)
Data Validations
53
Account Holder South African resident for tax purposes indicator
Account Holder South African resident for tax purposes indicator
C
If Account Holder Nature of Person (Field 54) = INDIVIDUAL, FOREIGN_INDIVIDUAL, or INDIVIDUAL_ESTATE, then the field is mandatory; optional for all other NoP's.
A
VAR
0:1 0 – no condition met
1:1 – condition met
If one or more country of residence for tax purposes were recorded on the Account Holder record:
If no country of residence for tax purposes was recorded for the Account Holder, then report “U” - Unknown
400
Telephone Number
Telephone number for the account holder / representative
Include country code if not South African number (e.g. 0044 for the United Kingdom).
O
None
AN
VAR
0:0 – if this field is blank
9:15 – if this field is completed
Only numeric values are allowed
No spaces are allowed
+ is not allowed
Value must not contain a decimal point
National numbers must start with 0
International numbers must start with 00
401
Cell Phone Number
Cell phone number for the account holder / representative
Include country code if not South African number (e.g. 0044 for the United Kingdom).
M
None
AN
VAR
9:15
Only numeric values are allowed
No spaces are allowed
+ is not allowed
Value must not contain a decimal point
National numbers must start with 0
International numbers must start with 00
Insert “999999999999999” if no information available.
402
Contact Email
Email for the account holder / representative.
M
None
FT
VAR
5:80
Must contain one @ sign
Must contain a domain which must be indicated with a dot (.)
Insert “[email protected]” if no information available.
Changes not Implemented
No
Field Name
Change
Reason for not implementing
54
Account Holder Nature of person
Length:
910:33ebTax already caters for this change
Account Holder Financial Data
Validation Change
No
Field Name
New Rule
74
Account Number
If Interest (Field 83) or Dividends (Field 85) or Capital gain / loss (Field 87) or Other (Field 802) were completed, then this field is Optional,
Else this field is MandatoryDrop Down Option Changes
No
Field Name
Option changes
75
Account Type
New options:
Help Text Update
No
Field
New Help Text
Field Length Changes
No
Field Name
New Length
74
Account Number
1:50
Field Type Changes
No
Field Name
New Type
74
Account Number
FT
New Fields
No
Field Name
Description
Required
Condition Rule
Data Type
Length Type
Length
(Min:Max)
Data Validations
901
Sharia Indicator
Indicates if the account is classified as Sharia or not
M
None
A
FIX
1:1
“Y” – if Sharia
“N” – if not Sharia
“U” – if Unknown or not applicable
Other – source code for reporting period.
Used for e.g. Manufactured Dividends.
4:4 – if condition met
0:0 – if condition not metValue has to be 4257
Other value for reporting period.
Used for e.g. Manufactured Dividends4:18 – if field completed
0:0 – if field not completedIf 1.00 or greater, no leading zeros allowed. If <1.00, there must be 1 zero before the decimal
Must always have 2 values after the point to denote cent
Values could be zero (0) or more
Don’t allow negative valuesAccount Holder Transactional Data
*Mandatory
*one to many relationship with AHFD (Account Holder Financial Data)
This section must contain both the following record types (report R 0.00 in the Transaction Value – Field 100, if there were no transactions for the reporting period):
Transaction Type (Field 98) = 01 and Assigned Source Code (Field 99) = 4219
Transaction Type (Field 98) = 04 and Assigned Source Code = 4248
This section must contain both the following record types, if Transaction Date (Field 97) >= 2018-03-01 (report R 0.00 in the Transaction Value – Field 100, if there were no transactions for the reporting period):
Transaction Type (Field 98) = 02 and Assigned Source Code = 4246
Transaction Type (Field 98) = 03 and Assigned Source Code = 4247
Validation Change
No
Field Name
New Rule
99
Assigned Source Code
Field Length Changes
No
Field Name
New Length
95
I3S Unique Number
1:100
Source Code Changes
Code
Transaction Type
4246
Tax free investment account - transfer in
Changes not Implemented
No
Field Name
Change
Reason for not implementing
95
I3S Unique Number
Must be equal to a Unique Identifier where record type = AHFD
ebTax already caters for this change
Date of the transaction.
If total values are supplied for a reporting period (i.e. non-transactional data)(or no transactions occurred)in Field 100 (Transaction Value), then this date should be last day, month and year of the applicable reporting period.