Setup Import Files

Follow these steps to proceed:

1. Select the ‘Excel Type Format for SSVS’ option
2. Click on the button
3. Your file should import successfully

To ensure a successful file import, take note of the following Excel sheet requirements:

1. All column/field lengths are as follows:
   • Account Number = 13
   • Account Name = 30
   • Statement Ref = 30
   • Date = 8
   • Amount = 15
   • Hash Total Indicator = 1
   • Hash Total = 12
   • Pay Alert Type = 1
   • Pay Alert Destination = 64
   • Branch Number = 6
   • RTGS/RTC = 1



Note: A hash total is a method for ensuring the accuracy of processed data. It is a total of
several fields of data in a file, including fields not normally used in calculations,
such as account number.


Note: When capturing a mobile, telephone or fax number into the Pay Alert Destination field,
the preceding zero / zeroes (0722049935, 0027118589999 or 0118589999) will only be displayed in the cell,
when the cell’s “Number format” has been set to Text.


2. Valid values for all fields are as follows:
   • Account Number – numeric
   • Account Name – alpha numeric
   • Statement ref – alpha numeric
   • Branch Number - numeric
   • Date format – 20120908
   • Amount – The value may be uploaded with or without a decimal point.For example 100=R100. Only a comma will be acceptable as a thousand spacer
   • RTGS/RTC - N, Y or F
   • Hash Total Indicator – 1 or 2
   • Hash Total – non contra account * the amount
   • Pay Alert Type – S(SMS) or F(Fax) or E(Email)
   • Pay Alert Destination – 0722049935 or 0118589999 or test@test.com respectively

   Special Characters
   Permissible Characters	Invalid Characters
   {Space} Space	` acute accent
   $ doller sign	~ tilde
   & ampersand	! exclamation mark
   * asterisk	# number/hash sign
   ( left parenthesis	% percent sign
   ) right parenthesis	^ not sign
   - hyphen	_ underscore
   + plus sign	{ left curly brace
   = equals sign	} right curly brace
   ; semi-colon	? question mark
   ' apostrophe	¦ broken vertical bar
   , comma	\ back slash
   . period(full stop)	: colon
   / forward slash	" double quotation mark
   < less than	@ commercial at
   > greater than

   • The data captured onto the Excel spreadsheet per transaction must appear horizontally (in rows), each individual
     transaction must be captured vertically, i.e. data for transaction 1 will appear in row 1,
     data for transaction 2 will appear in row 2 and so on Row numbers are subject to whether headings are used or not.
   • If Excel cells are merged, mapping will detect the merged cells as one field.
   • Hidden rows in the Excel sheet will be picked up in the mapping process and pulled through during the file import.
   • The mapping process will only factor sheet 1 in your Excel sheet for the process.
   • When capturing a mobile, telephone or fax number into the Pay Alert Destination field, the preceding zero/zeroes
     (0722049935, 0027118589999 or 0118589999) will only be displayed in the cell, when the cell's
     "Number format" has been set to Text.