This option produces an extract of contributions to Retirement Annuity and Income Protection Policies in terms of Section 69 0f the Income Tax Act.
From the main menu on top, select Tax Extracts. A sub-menu will be displayed on the left.
Select Insurance Payment Extract from the sub-menu on the left. The Insurance Payment Extract screen will be displayed.
Define the period for the extract by capturing dates in the From Date and To Date fields and capture the email address to which notification of completion of the job must be sent. Click GENERATE REPORT.
A message will indicate that the job has been successfully submitted.
An e-mail will be sent to the address specified.
The system will extract the data for Schemes for which the value for the Scheme Group Type of Product on the Scheme Details is RETIREMENT ANNUITY and for Schemes for which the Type of Fund is PRESERVATION.
The data for each Membership for the Schemes included will be extracted as per the table below. A txt file will be created as per the file layout in the tables below.
The file will be moved to the directory defined for the Batch Parameter SARSINSPMTFILE.
Insurance Payment Extract Details Header Record layout
|
Name |
Description |
Size |
M/O |
System value / default value |
Remarks |
|
SEC-ID |
File section identifier |
1 |
M |
H |
|
|
INFO-TYPE |
Information type |
8 |
M |
INSEXTRS |
|
|
INFO-SUBTYPE |
Information subtype |
8 |
O |
Blanks |
|
|
TEST-DATA |
Test data indicator |
1 |
M |
N |
|
|
FILE-SERIES-CTL |
File series control field |
1 |
M |
S |
|
|
EXT-SYS |
External system identification |
8 |
M |
Description on Batch Parameter EXT SYSTEM ID |
Allocated by SARS after registration of the Source System. Blank padded. Left justified. |
|
VER-NO |
Interface version number |
8 |
M |
Description on Batch Parameter INSPMTFILEVERNO |
Provided by SARS. Increases when there is a change to the file layout. Blank padded. Right justified. |
|
OWN-FILE-ID |
Unique file identifier |
14 |
O |
Administrator Code |
Alphanumeric. Blank padded. Right justified. |
|
GEN-TIME |
Date and time of the creation |
14 |
M |
|
CCYYMMDDhhmmss |
Insurance Extract Personal/Registered Details Data Record layout
|
Name |
Description |
Size |
M/O |
System value / value |
Remarks |
|
SEC-ID |
File section identifier |
1 |
M |
P |
|
|
CLIENT-NO |
Client number |
25 |
M |
Scheme Code and Reference Number |
Alphanumeric |
|
IT-REF-NO |
Income Tax reference number |
10 |
O |
Blanks |
|
|
CLIENT-ID |
Clients South African ID number |
13 |
O |
Identity Number on Natural Person where Identity TP is SA ID |
Blank padded. Left justified. |
|
CLIENT-OTHER-ID |
Clients other ID number |
10 |
O |
Identity Number on Natural Person where Identity TP is OTHER |
Blank padded. Left justified. |
|
CLIENT-SURNAME |
Client surname |
120 |
M |
Surname on Natural Person |
Blank padded. Left justified. |
|
CLIENT-INITS |
Client initials |
5 |
O |
Initials on Natural Person |
Blank padded. Left justified. |
|
CLIENT-FIRSTNAMES |
Client first names |
90 |
O |
First Name 1, First Name 2 and First Name 3 on Natural Person |
Blank padded. Left justified. |
|
CLIENT-DOB |
Client date of birth |
8 |
O |
DOB on Natural Person |
CCYYMMDD |
|
CLIENT-POST-ADDR |
Client postal address lines |
35 |
M |
Line 1, Line 2, Line 3, Line 4, Line 5 on latest Client Address linked to Natural Person and with Postal Address Indicator = Y |
Blank padded. Left justified. |
|
CLIENT-POST-CODE |
Client postal code |
10 |
M |
Postal Code on latest Client Address linked to Natural Person and with Postal Address Indicator = Y |
Blank padded. Left justified. |
|
CLIENT-PHY-ADDR |
Client physical address lines |
35 |
O |
Line 1, Line 2, Line 3, Line 4, Line 5 on latest Client Address linked to Natural Person and with Residential Address Indicator = Y |
Blank padded. Left justified. |
|
CLIENT-PHY-CODE |
Client physical postal code |
10 |
O |
Postal Code on latest Client Address linked to Natural Person and with Residential Address Indicator = Y |
Blank padded. Left justified. |
|
ADDR-CHANGE-DATE |
Last date the address was changed on the system |
8 |
O |
Date portion of Timestamp on latest Client Address record linked to Natural Person |
CCYYMMDD |
Insurance Extract Details Data Record layout
|
Name |
Description |
Size |
M/O |
System value / value |
Remarks |
|
SEC-ID |
File section identifier |
1 |
M |
D |
|
|
CLIENT-NO |
Insurance unique number |
25 |
M |
Scheme Code and Reference Number |
Alphanumeric |
|
SOURCE-CODE |
The source code indicating the nature of the deduction of the Insurance’s Client |
4 |
M |
4006 |
4006 – Current Retirement Annuity Fund 4007 – Arrears Retirement Annuity Fund 4018 – Income Protection Contributions |
|
YEAR |
Tax Year |
4 |
M |
Month and year of the To Date for which the extract is scheduled. |
CCYY |
|
POLICY-MEMBERSHIP-NO |
Clients unique number to the fund |
20 |
M |
Membership Reference Number |
Blank padded. Left justified. |
|
FUND-NAME |
Registered Fund Name |
120 |
M |
Registered Name on Fund |
Blank padded. Left justified. |
|
APPROVED-FUND-NO |
Unique number for the Fund issued by SARS (starts with 18/20/4) |
20 |
M |
Registration Number on Fund Registration for which the Description on the associated Required Registration is Registrar of Pension Funds |
Blank padded. Left justified. |
|
CURRENT-AMT |
|
15 |
M |
Total of all transactions in the Member’s CONTRIBUTION account with a Transaction Date Greater than or equal to the extract From Date and less than or equal to the extract To Date. |
Right justified and zero padded. Rounded to nearest Rand e.g. 1395.82 = 1396 and 7834.25 = 7834. |
|
ARREAR-AMT |
|
15 |
O |
Zeroes |
Right justified and zero padded. Rounded to nearest Rand |
|
POLICY-COMMENCE-DATE |
Date member joined the fund |
8 |
M |
CAR Start Date |
CCYYMMDD |
Insurance Payment Extract Details Trailer Record layout
|
Name |
Description |
Size |
M/O |
System value / value |
Remarks |
|
SEC-ID |
File section identifier |
1 |
M |
T |
|
|
REC-NO |
Number of data records in this file (excluding the header and trailer record) |
8 |
M |
Number of data records in this file (excluding the header and trailer record) |
Right justified and zero padded |
|
CURRENT-AMT-CONTROL-TOT |
Control total of all Current amounts
|
15 |
M |
Control total of all CURRENT-AMT values in Insurance Extract Details Data Record file |
Right justified and zero padded |