Purpose
To automate the process for ACA to provide Tax Interface files for SARS in the required format.
The following is the process that should be followed to format the Tax Interface files.
Submit Batch Job
1. Submit Batchjob255 from the Batch Jobs option (in ACA Production):
Navigation: Infrastructure -> Batch -> Batch Jobs -> BATCHJOB255
2. After completion of the job the person whose email address is linked to the Team will receive the file created by the batch job via email.
3. Save the file from the email attachment and “un-zip” it.
Format the spreadsheet
1 Use the Format spreadsheet to format the file in either the FORMAD or FORMB format, depending on the email subject.
2 To format the records using the following steps:
a. Copy the data from the “un-zipped” file from the 2nd row of data to the 2nd last row of data. Exclude the Header and Trailer records.
b. Remove the data in the FORMAD / FORMD tab (depending on the file received).
c. Paste the data copied from the file received in the email into the Tab (from row 1).
d. Open the Formatted Tab in the spreadsheet and copy ALL the records from there.
e. Go to the File and click on NEW. Click the CREATE option and paste the data copied, (Paste Special, Paste Values (Values & Formatting) into the new spreadsheet.
f. Save the spreadsheet.
3 The newly created spreadsheet is now ready to be processed for SARS purposes.