setup procedures for eft processing south african - … procedures for eft processing . south...

Setup procedures for EFT Processing

South African Banks

V5.4 to V2014

Last updated V1.74 07/09/2012

EFT Processing Setup of South African Banks _____________________________________________________________________

EFT Options ................................................................................................................. 4

A/P Options ................................................................................................................ 4 A/R Options ............................................................................................................... 4 E-mail ......................................................................................................................... 5 Options ....................................................................................................................... 6 South African First National Bank – CAMS Domestic Services .............................. 7 South African First National Bank ACB Format. ...................................................... 8 South African ABSA Bolero XML Format ............................................................... 8 South African ABSA Local Format ........................................................................... 8 South African ACB Finance Format.......................................................................... 9 South African Standard Bank (Domestic) Format ..................................................... 9 South African NetBank Business............................................................................... 9 South African NetBank Business CSV format ....................................................... 10 South African Standard Bank – Business Online Domestic Banking (Value Dated – 8 digit date import)................................................................................................... 10 South African Standard Bank – Business Online International Banking ................ 10 South African Standard Bank – Business Online Domestic Banking SSVS PRE-FORMAT ................................................................................................................. 11 South African ABSA Bank – Cashfocus ................................................................. 11 South Africa – First National Bank BANKSERV (ACB) ....................................... 12 South Africa – First National Bank Direct Debit ..................................................... 12 National Bank of Kenya........................................................................................... 12

Setup your bank, customers and vendors ................................................................ 13 EFT Setup procedure for South African First National Bank – CAMS Domestic Services .................................................................................................................... 14

EFT Banks ........................................................................................................... 14 EFT Vendors ........................................................................................................ 15 EFT Customers .................................................................................................... 16

EFT Setup procedure for South African First National Bank ACB Format ............ 17 EFT Banks ........................................................................................................... 17 EFT Vendors – with a standard bank account no. ............................................... 18 EFT Vendors – non standard bank account no. ................................................... 19 EFT Customers – with a standard bank account no. ............................................ 20 EFT Customers – non standard bank account no................................................. 21

EFT Setup procedure for South ABSA Bolero XML Format ................................. 22 EFT Banks ........................................................................................................... 22 EFT Vendors ........................................................................................................ 23 EFT Customers .................................................................................................... 24

EFT Setup procedure for South ABSA Local Format ............................................. 25 EFT Banks ........................................................................................................... 25 EFT Vendors ........................................................................................................ 26 EFT Customers .................................................................................................... 28

EFT Setup procedure for ACB Finance Format ...................................................... 30 EFT Banks ........................................................................................................... 30 EFT Vendors ........................................................................................................ 31 EFT Customers .................................................................................................... 32 EFT Banks ........................................................................................................... 34 EFT Vendors ........................................................................................................ 35 EFT Customers .................................................................................................... 36

Prepared by : Orchid Systems of 65


EFT Setup procedure for NetBankBusiness CSV ................................................... 38 EFT Banks ........................................................................................................... 38

EFT Setup procedure for NetBankBusiness ............................................................ 39 EFT Banks ........................................................................................................... 39 EFT Vendors ........................................................................................................ 40

EFT Setup procedure for Standard Bank – Business Online Domestic Banking (Value Dated – 8 digit date import) ......................................................................... 44

EFT Banks ........................................................................................................... 44 EFT Vendors ........................................................................................................ 45

EFT Setup procedure for Standard Bank – Business Online International Banking.................................................................................................................................. 46


EFT Setup procedure for South Africa Standard Bank Business Online Domestic Banking SSVS PRE-FORMAT ............................................................................... 48


EFT Setup procedure for South ABSA Cashfocus format ...................................... 50 EFT Banks ........................................................................................................... 50 EFT Vendors ........................................................................................................ 51 EFT Customers .................................................................................................... 53

EFT Setup procedure for South Africa - First National Bank BANKSERV (ACB).................................................................................................................................. 54

EFT Banks ........................................................................................................... 54 EFT Vendors ........................................................................................................ 55 EFT Customers .................................................................................................... 56

EFT Setup procedure for National Bank of Kenya .................................................. 58 EFT Banks ........................................................................................................... 58 EFT Vendors ........................................................................................................ 59

EFT Setup procedure for South Africa - First National Bank Direct Debit (CSV) . 60 EFT Banks ........................................................................................................... 60 EFT Vendors ........................................................................................................ 61 EFT Customers .................................................................................................... 62

Creating an EFT File ................................................................................................. 63 South African First National Bank – CAMS Domestic Services ............................ 64 South African ABSA Bolero XML Format ............................................................. 64 South African Standard Bank (Domestic) Format ................................................... 64

Creating a Receipt Batch in EFT Processing V5.5 ................................................. 65



EFT Options

A/P Options • Select if users are allowed to enter a range of batches or one individual batch • Select if users are allowed to select unposted batches or posted batches only • Select if Vendors not defined in EFT Vendors causes an error (stop the export)

or skip the vendor payment and continue the export • Select if the users are allowed to select individual payment from a batch

A/R Options • Select if users are allowed to enter a range of batches or one individual batch • Select if users are allowed to select unposted batches or posted batches only • Select if Customers not defined in EFT Customers causes an error (stop the

export) or skip the vendor payment and continue the export • Select if the users are allowed to select individual payment from a batch



E-mail

This tab lets you:

• Define your e-mail Server. If you leave this field blank, then the Sage Accpac ERP default way of sending e-mails using your Microsoft Outlook client will be used.

• If you define the e-mail server, then SMTP will be used to send e-mails and the following parameters will be required:

• E-mail Server • The User • The E-mail Password • The E-mail Comes from

Notes :

Check your email server to see if it requires a username/password. Some require it to be blank, for some it does not matter. You will need to try each combination until you find which is correct for your server.



Some email servers will allow you to log on as a certain user and send email as anyone, others will only allow you to send email as the logged on user. So if you log on as "Joe", but try to send as admin@testdomain, some email servers won't allow it.

In your email program, find out what settings are there for your account and enter those same settings into Process Scheduler. With those settings, you should be able to send an email.

You can use the "Send Test Email..." to check your e-mail settings. You will be prompted to enter an e-mail address to send the test e-mail to.

Options • Select the bank or primary bank. Selecting a bank enables the EFT Screen

labels to be tailored to the bank •



South African First National Bank – CAMS Domestic Services Select ZA_FNBCAMS as the primary bank :



South African First National Bank ACB Format. Select ZA_FNBACB as the primary bank :

South African ABSA Bolero XML Format Select ZA_ABSAXML as the primary bank :

South African ABSA Local Format Select ZA_ABSALOCAL as the primary bank :



South African ACB Finance Format Select ZA_ACB as the primary bank :

South African Standard Bank (Domestic) Format Select ZA_STDDOM as the primary bank:

South African NetBank Business Select ZA_NetBankBusiness as the primary bank:



South African NetBank Business CSV format Select ZA_NetBankBus_CSV as the primary bank:

South African Standard Bank – Business Online Domestic Banking (Value Dated – 8 digit date import) Select ZA_STDBODOM the primary bank:

South African Standard Bank – Business Online International Banking Select ZA_STDBOIB the primary bank:



South African Standard Bank – Business Online Domestic Banking SSVS PRE-FORMAT Select ZA_STD_BODBSSVS_PRE the primary bank:

South African ABSA Bank – Cashfocus Select ZA_ABSACASHFOCUS the primary bank:



South Africa – First National Bank BANKSERV (ACB) Select ZA_FNBBANKSERVACB the primary bank:

South Africa – First National Bank Direct Debit Select ZA_FNBDD as the primary bank:

National Bank of Kenya Select KENYA as the primary bank:



Setup your bank, customers and vendors



EFT Setup procedure for South African First National Bank – CAMS Domestic Services

EFT Banks

1 Bank code CCB (select from existing EFT Banks using the finder, or Common Services Banks using the up arrow) 2 Bank Name First National Bank 3 Branch 6 digit number (e.g. 111333) 4 Account Number Your account number with your bank (e.g. 999888777) 5 Account Name eg Sample Company LTD 6 A/P EFT File batch Enter or browse to find the file path for AP files 7 A/P EFT File Extension The file extension required by the bank (e.g. .fnb) 8 A/P EFT File Type ZA_FNBCAMS for First National Bank CAMS layout 9 A/P Payment Reference Can be left blank eg 0102060878 10 A/R EFT File batch Enter or browse to find the file path for AR files 11 A/R EFT File Extension The file extension required by the bank (e.g. .fnb) 12 A/R EFT File Type ZA_FNBCAMS for First National Bank CAMS layout 13 A/R Payment Reference Can be left blank eg 0102060878 14 Select the file numbering option either Batch number or File Sequence Number



EFT Vendors

1 Vendor ID Enter or select the vendor id (e.g. 1200). Use the finder to select from existing EFT Vendors, the up arrow to select from AP Vendors 2 Bank Name The Vendor Bank (e.g. NAB Online) 3 Branch The Vendor Branch (e.g. 333222) 4 Account Number The Vendor Account number (e.g. 3321114666) 5 Account Name The Vendor Bank Account Name (e.g. Intercontinental Electronics) 6 Payment Reference This payment reference can be sent in the bank file if the option “Use Reference From Vendor Master Record” is selected when you create the EFT file for the bank 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group



EFT Customers

1 Customer ID Enter or select the Customer id (e.g. 1200) 2 Bank Name The Customer Bank (e.g. ANZ Online) 3 Branch The Customer Bank Branch (e.g.666888) 4 Account Number The Customer Account number (e.g. 0398462222) 5 Account Name The Customer Bank Account Name (e.g. Mr Ronald Black) 6 Payment Reference This payment reference can be sent in the bank file if the option “Use Reference From Customer Master Record” is selected when you create the EFT file for the bank 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group



EFT Setup procedure for South African First National Bank ACB Format

EFT Banks

1 Bank code CCB (select from existing EFT Banks using the finder, or Common Services Banks using the up arrow) 2 Bank Name CCB Bank 3 Branch 6 digit number (e.g. 123456) 4 Account Number Your account number with your bank (e.g12345678901) 5 Ext Acc Number/Name eg Sample Company Inc 6 A/P EFT File batch Enter or browse to find the file path for AP files 7 A/P EFT File Extension The file extension required by the bank (e.g. .txt) 8 A/P EFT File Type ZA_FNBACB for South African First National Bank ACB Format 9 A/P Payment Reference Not Used so can be left blank 10 A/R EFT File batch Enter or browse to find the file path for AR files 11 A/R EFT File Extension The file extension required by the bank (e.g. .txt) 12 A/R EFT File Type ZA_FNBACB for South African First National Bank ACB Format 13 A/R Payment Reference Not Used so can be left blank 14 Select the file numbering option either Batch number or File Sequence Number 15 If using File Sequence Number, you can can set the next file number



EFT Vendors – with a standard bank account no.

Note: In the vendor setup you either enter an 11 digit account number (up to an 11 digit account number) or enter a 20 digit non standard account no (up to 20 digits). This is used for example for Credit Cards or Bond Accounts. 1 Vendor ID Enter or select the vendor id (e.g. 1200). Use the finder to select from existing EFT Vendors, the up arrow to select from AP Vendors 2 Bank Name The Vendor Bank (e.g. Standard Chartered Bank) 3 Branch Code The Vendor Branch (6 digits e.g. 123456) 4 Account Number The Vendor Account number (11 Digits if it is a standard account e.g. 12345678901) 5 Account Name The Vendor Bank Account Name (e.g. Chloride Systems) 6 Non Std Acct No If you have entered a Branch Code then this will be blank 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group 8 The account types:

1 = DDA Accounts 0 = Global Accounts



EFT Vendors – non standard bank account no.

1 Vendor ID Enter or select the vendor id (e.g. 1200). Use the finder to select from existing EFT Vendors, the up arrow to select from AP Vendors 2 Bank Name The Vendor Bank (e.g. Standard Chartered Bank) 3 Branch Code The Vendor Branch (6 digits e.g. 123456) 4 Account Number If you have a non standard account no. this will be blank 5 Account Name The Vendor Bank Account Name (e.g. Chloride Systems) 6 Non Std Acct No Enter a 20 digit non standard account no. (up to 20 digits). This is used for example for Credit Cards or Bond Accounts. 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group 8 The account types:

1 = DDA Accounts 0 = Global Accounts



EFT Customers – with a standard bank account no.

Note: In the customer setup you either enter an 11 digit account number (up to an 11 digit account number) or enter a 20 digit non standard account no (up to 20 digits). This is used for example for Credit Cards or Bond Accounts. 1 Customer ID Enter or select the Customer id (e.g. 1100). Use the finder to select from existing EFT Customers, the up arrow to select from AP Customers 2 Bank Name The Customer Bank (e.g. Commonwealth Bank) 3 Branch Code The Customer Branch (6 digits e.g. 123456) 4 Account Number The Customer Account number (11 Digits if it is a standard account e.g. 12345678901) 5 Account Name The Customer Bank Account Name (e.g. Mr Ronald Black) 6 Non Std Acct No If you have entered a Branch Code then this will be blank 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group



EFT Customers – non standard bank account no.

1 Customer ID Enter or select the Customer id (e.g. 1100). Use the finder to select from existing EFT Customers, the up arrow to select from AP Customers 2 Bank Name The Customer Bank (e.g. Commonwealth Bank) 3 Branch Code The Customer Branch (6 digits e.g. 123456) 4 Account Number If you have a non standard account no. this will be blank 5 Account Name The Customer Bank Account Name (e.g. Mr Ronald Black) 6 Non Std Acct No Enter a 20 digit non standard account no. (up to 20 digits). This is used for example for Credit Cards or Bond Accounts 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group



EFT Setup procedure for South ABSA Bolero XML Format

EFT Banks

1 Bank code CCB (select from existing EFT Banks using the finder, or Common Services Banks using the up arrow) 2 Bank Name CCB Bank 3 Branch 6 digit number (e.g. 123456) 4 Account Number Your account number with your bank (e.g123456789) 5 Ext Acc Number/Name eg Sample Company Inc 6 Bank Address 1 eg Bank Address 1 7 Bank State/Province eg Bank state province 8 Bank Country eg Bank Country 9 A/P EFT File batch Enter or browse to find the file path for AP files 10 A/P EFT File Extension The file extension required by the bank (e.g. .fnb) 11 A/P EFT File Type ZA_ABSAXMLfor ABSA Bolero XML Format 12 A/P Payment Reference Can be left blank eg not used 13 A/R EFT File batch Enter or browse to find the file path for AR files 14 A/R EFT File Extension The file extension required by the bank (e.g. .fnb) 15 A/R EFT File Type ZA_ABSAXMLfor ABSA Bolero XML Format 16 A/R Payment Reference Can be left blank eg not used 17 Select the file numbering option either Batch number or File Sequence Number 18 If using File Sequence Number, you can can set the next file number



EFT Vendors

1 Vendor ID Enter or select the vendor id (e.g. 1200). Use the finder to select from existing EFT Vendors, the up arrow to select from AP Vendors 2 Bank Name The Vendor Bank (e.g. Barclay Bank) 3 Branch The Vendor Branch (e.g. 111222333) 4 Account Number The Vendor Account number (e.g. 012 3456 7800 9) 5 Extd. Acc. Number/Name Enter the extended or full account number. This is the value which is exported to the file. (eg CHZ012 012 3456 7800 9) 6 Payment Reference Fill in the Bank’s reference 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group 8 Bank Charges (SHA/BEN) Enter how the bank charges are to be paid. Consult the bank documentation for valid abbreviations 9 Bank charges Code eg 102 Enter a valid bank charges code. Consult the bank documentation for valid abbreviations ** Note, the vendor’s bank details (name and address) are transmitted in the ABSA XLL file. These details need to be stored in the Vendor’s remit to address – and the appropriate vendor remit to code must be selected when payments are made.



EFT Customers

1 Customer ID Enter or select the Customer id (e.g. 1100). Use the finder to select from existing EFT Customers, the up arrow to select from AP Customers 2 Bank Name The Customer Bank (e.g. Commonwealth Bank) 3 Branch The Customer Branch (e.g. 645987888) 4 Account Number The Customer Account number (e.g. 123456789) 5 Account Name The Customer Bank Account Name (e.g. Bargain Mart – San Diago) 6 Payment Reference Fill in the Bank’s reference 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group 8 Bank Charges (SHA/BEN) Enter how the bank charges are to be paid. Consult the bank documentation for valid abbreviations 9 Bank charges Code eg 102 Enter a valid bank charges code. Consult the bank documentation for valid abbreviations



EFT Setup procedure for South ABSA Local Format

EFT Banks

1 Bank code CCB (select from existing EFT Banks using the finder, or Common Services Banks using the up arrow) 2 Bank Name CCB Bank 3 Branch 6 digit number (e.g. 123456) 4 Account Number Your account number with your bank (e.g123456789) 5 Account Name eg Sample Company Inc 6 A/P EFT File batch Enter or browse to find the file path for AP files 7 A/P EFT File Extension The file extension required by the bank (e.g. .abl) 8 A/P EFT File Type ZA_ABSALOCAL for ABSA Local format 9 A/P Payment Reference Can be left blank eg not used 10 A/R EFT File batch Enter or browse to find the file path for AR files 11 A/R EFT File Extension The file extension required by the bank (e.g. .abl) 12 A/R EFT File Type ZA_ABSAXMLfor ABSA Bolero XML Format 13 A/R Payment Reference Can be left blank eg not used 14 Select the file numbering option either Batch number or File Sequence Number



EFT Vendors

1 Vendor ID Enter or select the vendor id (e.g. 1200). Use the finder to select from existing EFT Vendors, the up arrow to select from AP Vendors 2 Bank Name The Vendor Bank (e.g. Barclay Bank) 3 Branch The Vendor Branch (e.g. 323111) 4 Account Number The Vendor Account number (e.g. 123456789) 5 Account Name The Vendor Bank Account Name (e.g. Chloride Systems Account) 6 Payment Reference Fill in the Bank’s reference. Not used, can be left blank 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Note : when creating an EFT File, the “reference” chosen on the Create EFT File screen is transmitted to the bank, so

a) a description should be entered for the batch b) Description should be selected.



EFT Customers

1 Customer ID Enter or select the Customer id (e.g. 1100). Use the finder to select from existing EFT Customers, the up arrow to select from AR Customers 2 Bank Name The Customer Bank (e.g. Commonwealth Bank) 3 Branch The Customer Branch (e.g. 654331) 4 Account Number The Customer Account number (e.g. 123456789) 5 Account Name The Customer Bank Account Name (e.g. Bargain Mart – San Diago) 6 Payment Reference Fill in the Bank’s reference 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Note : when creating an EFT File, the “reference” chosen on the Create EFT File screen is transmitted to the bank, so




EFT Setup procedure for ACB Finance Format

EFT Banks

1 Bank code CCB (select from existing EFT Banks using the finder, or Common Services Banks using the up arrow) 2 Bank Name City Commercial Bank 3 Branch 6 digit number (e.g. 123456) 4 Account Number Your account number with your bank (e.g123456789) 5 Account Name eg Sample Company Inc 6 A/P EFT File batch Enter or browse to find the file path for AP files 7 A/P EFT File Extension The file extension required by the bank (e.g. acb) 8 A/P EFT File Type ZA_ACB for ACB Finance 9 A/P Payment Reference Statement Reference Number 10 A/R EFT File batch Enter or browse to find the file path for AR files 11 A/R EFT File Extension The file extension required by the bank (e.g. acb) 12 A/R EFT File Type ZA_ACB for ACB Finance 13 A/R Payment Reference Statement Reference Number 14 Select the file numbering option either Batch number or File Sequence Number



EFT Vendors

1 Vendor ID Enter or select the vendor id (e.g. 1200). Use the finder to select from existing EFT Vendors, the up arrow to select from AP Vendors 2 Bank Name The Vendor Bank (e.g. Barclay Bank) 3 BSB Number The Vendor Branch (e.g. 323111) 4 Account Number The Vendor Account number (e.g. 123456789) 5 Account Name The Vendor Bank Account Name (e.g. Chloride Systems Account) 6 Payment Reference Fill in the Bank’s reference 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group 8 Account Type Account Type can be:

1=current 2=savings 3=transmission

Note : when creating an EFT File, the “reference” chosen on the Create EFT File screen is transmitted to the bank, so a description should be entered for the batch The reference on the detail line per vendor will be as selected in the Reference field. IE if you require the cheque number to be sent, select “Use Cheque Number”. If you require The AP Reference on the vendor, use “Use Reference from the vendor master record” etc



EFT Customers

1 Customer ID Enter or select the Customer id (e.g. 1200). Use the finder to select from existing EFT Customers, the up arrow to select from AR Customers 2 Bank Name The Customer Bank (e.g. HSBC Bank) 3 BSB Number The Customer Branch (e.g. 123456) 4 Account Number The Customer Account number (e.g. 123456789) 5 Account Name The Customer Bank Account Name (e.g. Mr Ronald Black) 6 Payment Reference Fill in the Statement Reference 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group 8 Account Type Account Type can be:

1=current 2=savings 3=transmission



Note : when creating an EFT File, the “reference” chosen on the Create EFT File screen is transmitted to the bank, so




EFT Setup procedure for South African Standard Bank (Domestic)

EFT Banks

1 Bank code CCB (select from existing EFT Banks using the finder, or Common Services Banks using the up arrow) 2 Bank Name CCB Bank 3 Branch 6 digit number (e.g. 123456) 4 Account Number Your account number with your bank (e.g123456789) 5 Account Name eg Sample Company Inc 6 A/P EFT File batch Enter or browse to find the file path for AP files 7 A/P EFT File Extension The file extension required by the bank (e.g. .std) 8 A/P EFT File Type ZA_ ZA_STDDOM for Standard Bank (Domestic) 9 A/P Payment Reference Statement Reference Number 10 A/R EFT File batch Enter or browse to find the file path for AR files 11 A/R EFT File Extension The file extension required by the bank (e.g. .std) 12 A/R EFT File Type ZA_ ZA_STDDOM for Standard Bank (Domestic) 13 A/R Payment Reference Statement Reference Number 14 Select the file numbering option either Batch number or File Sequence Number



EFT Vendors

1 Vendor ID Enter or select the vendor id (e.g. 1200). Use the finder to select from existing EFT Vendors, the up arrow to select from AP Vendors 2 Bank Name The Vendor Bank (e.g. Barclay Bank) 3 Branch The Vendor Branch (e.g. 323111) 4 Account Number The Vendor Account number (e.g. 123456789) 5 Account Name The Vendor Bank Account Name (e.g. Chloride Systems Account) 6 Payment Reference Fill in the Bank’s reference 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Note : when creating an EFT File, the “reference” chosen on the Create EFT File screen is transmitted to the bank, so

a) a description should be entered for the batch b) The reference on the detail line per vendor will be as selected in the Reference

field. IE if you require the cheque number to be sent, select “Use Cheque Number”. If you require The AP Reference on the vendor, use “Use Reference from the vendor master record” etc.



EFT Customers

1 Customer ID Enter or select the Customer id (e.g. 1100). Use the finder to select from existing EFT Customers, the up arrow to select from AR Customers 2 Bank Name The Customer Bank (e.g. Commonwealth Bank) 3 Branch The Customer Branch (e.g. 654331) 4 Account Number The Customer Account number (e.g. 123456789) 5 Account Name The Customer Bank Account Name (e.g. Bargain Mart – San Diago) 6 Payment Reference Fill in the Statement Reference 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Note : when creating an EFT File, the “reference” chosen on the Create EFT File screen is transmitted to the bank, so




EFT Setup procedure for NetBankBusiness CSV

EFT Banks

1 Bank code CCB (select from existing EFT Banks using the finder, or Common Services Banks using the up arrow) 2 Bank Name e.g. City Commercial Bank 3 Branch Enter the branch transit number 4 Account Number Your account number with your bank 5 Account Name Enter the Company’s Account Name 6 A/P Payment Reference Enter an AP reference (Optional) 7 A/P EFT File batch Enter or browse to find the file path for AP files 8 A/P EFT File Extension This needs to be CSV 9 A/P EFT File Type ZA_ NETBANKBUS_CSV 10 Statement Reference Statement Reference details



EFT Setup procedure for NetBankBusiness

EFT Banks

1 Bank code CCB (select from existing EFT Banks using the finder, or Common Services Banks using the up arrow) 2 Bank Name eg City Commercial Bank 3 Branch Enter the branch number (e.g. 123456) 4 Account Number Your account number with your bank (e.g. 999888777) 5 Account Name eg Sample Company Inc 6 Seed Enter the 32 digit seed from the bank used in the hash calculation 7 A/P EFT File batch Enter or browse to find the file path for AP files 8 A/P EFT File Extension The file extension required by the bank (e.g. .zan) 9 A/P EFT File Type ZA_ NETBANKBUSINESS 10 Statement Reference Statement Reference details 11 A/R EFT File batch Enter or browse to find the file path for AR files 12 A/R EFT File Extension The file extension required by the bank (e.g. .std) 13 A/R EFT File Type ZA_ NETBANKBUSINESS 14 Statement Reference Statement Reference details



15 Select the file numbering option either Batch number or File Sequence Number

EFT Vendors

1 Vendor ID Enter or select the vendor id (e.g. 1200). Use the finder to select from existing EFT Vendors, the up arrow to select from AP Vendors 2 Bank Name The Vendor Bank (e.g. Barclay Bank) 3 Branch The Vendor Branch (e.g. 222666661) 4 Account Number The Vendor Account number (e.g. 123456789012) 5 Account Name The Vendor Bank Account Name (e.g. Chloride Systems Account) 6 Sub Account Number Fill in the sub account number if appropirate 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group 8 Statement Reference Enter the required statement reference 9 Proof of payment Enter true or false if the proof of payment is required Note : when creating an EFT File, the “reference” chosen on the Create EFT File screen is transmitted to the bank, so




EFT Customers

1 Customer ID Enter or select the Customer id (e.g. 1100). Use the finder to select from existing EFT Customers, the up arrow to select from AR Customers 2 Bank Name The Customer Bank (e.g. Commonwealth Bank) 3 Branch The Customer Branch (e.g. 654331) 4 Account Number The Customer Account number (e.g. 123456789) 5 Account Name The Customer Bank Account Name (e.g. Bargain Mart – San Diego) 6 Payment Reference Fill in the Statement Reference 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group 8 Statement Reference Enter the required statement reference 9 Proof of payment Enter true or false if the proof of payment is required Note : when creating an EFT File, the “reference” chosen on the Create EFT File screen is transmitted to the bank, so




EFT Setup procedure for Standard Bank – Business Online Domestic Banking (Value Dated – 8 digit date import)

EFT Banks

1 Bank code CCB (select from existing EFT Banks using the finder, or Common Services Banks using the up arrow) 2 Bank Name eg Standard Bank 3 Branch Enter the branch number (e.g. 123456) 4 Account Number Your account number with your bank (e.g. 1234567890) 5 Account Name eg Sample Company Inc 6 Company Code Enter the 4 digit Company Code provided by the bank 7 A/P EFT File batch Enter or browse to find the file path for AP files 8 A/P EFT File Extension The file extension required by the bank (e.g. std) 9 A/P EFT File Type ZA_ STDBODOM 10 A/P Payment Reference Not used in this format 11 A/R EFT File batch Enter or browse to find the file path for AR files 12 A/R EFT File Extension The file extension required by the bank (e.g. .std) 13 A/R EFT File Type ZA_ STDBODOM 14 A/R Payment Reference Not used in this format 15 Select the file numbering option either Batch number or File Sequence Number. If file sequence number selected, you can enter the first file number.



EFT Vendors

1 Vendor ID Enter or select the vendor id (e.g. 1200). Use the finder to select from existing EFT Vendors, the up arrow to select from AP Vendors 2 Bank Name The Vendor Bank (e.g. Barclay Bank) 3 Branch The Vendor Branch (e.g. 253305) 4 Account Number The Vendor Account number (e.g. 50371779248) 5 Account Name The Vendor Bank Account Name (e.g. Chloride Bank Savings Account) 6 Payment Reference Fill the statement reference for this vendor 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Note : when creating an EFT File, the “reference” chosen on the Create EFT File screen is transmitted to the bank, so

a) a description should be entered for the batch – this is the header reference b) In the Reference field, select Description/Vendor Master/Cheque/Invoice for

the reference for each vendor payment as required



EFT Setup procedure for Standard Bank – Business Online International Banking

EFT Banks

1 Bank code CCB (select from existing EFT Banks using the finder, or Common Services Banks using the up arrow) 2 Bank Name e.g. City Commercial Bank 3 Branch Enter the branch number 4 Account Number Your account number with your bank 5 Account Name e.g. Sample Company Inc 6 A/P EFT File batch Enter or browse to find the file path for AP files 7 A/P EFT File Extension The file extension required by the bank 8 A/P EFT File Type ZA_ STDBOIB 9 A/P Payment Reference Enter an AP reference if applicable 10 Select the file numbering option either Batch number or File Sequence Number. If file sequence number selected, you can enter the first file number. 11 A/R EFT File batch Enter or browse to find the file path for AR files 12 A/R EFT File Extension The file extension required by the bank (e.g. .std) 13 A/R EFT File Type ZA_ STDBOIB 14 A/R Payment Reference Not used in this format 15 Select the file numbering option either Batch number or File Sequence Number or same as AP. If file sequence number selected, you can enter the first file number.



EFT Vendors

In EFT55 SP4 the following options have been added:

• Option to have more than 1 bank file type for a vendor or customer • You can now record different vendor bank details for each Remit-To location

1 Vendor ID Enter or select the vendor id (e.g. 1200) 2 Remit To This field is optional The Remit To gives you the option to record different vendor bank details for each Remit To location that has been setup in A/P Remit To Location. If you leave this field blank, then EFT will use the vendor bank account details for all A/P Remit to locations. If you fill this field in, then EFT will use the vendor / remit to location EFT details for a payment made to a specific remit to location. 3 File Type This field is optional. Select a file type to record different bank details for each bank layout. If you leave this field blank, then EFT will use the file type that has been assigned in EFT Options > Bank Setup

4 Bank Name The Vendor Bank name 5 Branch Code Enter the Vendor’s Branch Code 6 Account Number Enter the Vendor Account number 7 The Vendor Bank Account Name (e.g. Chloride Systems) 8 Payment Reference Fill in the Bank’s reference This payment reference can be sent in the bank file if the option “Use Reference From Vendor Master Record” is selected when you create the EFT file for the bank 9 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group 10 Enter the Location Country Code (2 digits)



EFT Setup procedure for South Africa Standard Bank Business Online Domestic Banking SSVS PRE-FORMAT

EFT Banks

1 Bank code CCB (select from existing EFT Banks using the finder, or Common Services Banks using the up arrow) 2 Bank Name CCB Bank 3 Branch 6 digit number 4 Account Number Your account number with your bank 5 Account Name eg Sample Company Inc 6 File Naming Select the file numbering option either Batch number or File Sequence Number 7 A/P EFT File batch Enter or browse to find the file path for AP files 8 A/P EFT File Extension The file extension required by the bank (e.g. .abs) 9 A/P EFT File Type ZA_STD_BODBSSVS_PRE for SA Standard Bank Business Online Domestic Banking SSVS PRE-FORMAT 10 A/P Payment Reference Optional



EFT Vendors



1 Vendor ID Enter or select the vendor id (e.g. 1200) Remit To This field is optional The Remit To gives you the option to record different vendor bank details for each Remit To location that has been setup in A/P Remit To Location. If you leave this field blank, then EFT will use the vendor bank account details for all A/P Remit to locations. If you fill this field in, then EFT will use the vendor / remit to location EFT details for a payment made to a specific remit to location. 2 File Type This field is optional. Select a file type to record different bank details for each bank layout. If you leave this field blank, then EFT will use the file type that has been assigned in EFT Options > Bank Setup

3 Bank Name The Vendor Bank name 4 Enter the Vendor’s Bank and Branch Code 5 Account Number The Vendor Account number 6 The Vendor Bank Account Name 7 Payment Reference This payment reference can be sent in the bank file if the option “Use Reference From Vendor Master Record” is selected when you create the EFT file for the bank 8 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group



EFT Setup procedure for South ABSA Cashfocus format

EFT Banks

1 Bank code CCB (select from existing EFT Banks using the finder, or Common Services Banks using the up arrow) 2 Bank Name CCB Bank 3 Branch 6 digit number (e.g. 123456) 4 Account Number Your account number with your bank (e.g1234567890) 5 Account Name eg Sample Company Inc 6 A/P EFT File batch Enter or browse to find the file path for AP files 7 A/P EFT File Extension The file extension required by the bank (e.g. .abs) 8 A/P EFT File Type ZA_ABSACASHFOCUS for ABSA Cash Focus format 9 A/P Payment Reference Can be left blank eg not used 10 A/R EFT File batch Enter or browse to find the file path for AR files 11 A/R EFT File Extension The file extension required by the bank (e.g. .abs) 12 A/R EFT File Type ZA_ABSACASHFOCUS ABSA Cash Focus Format 13 A/R Payment Reference Can be left blank eg not used 14 Select the file numbering option either Batch number or File Sequence Number



EFT Vendors

1 Vendor ID Enter or select the vendor id (e.g. 1200). Use the finder to select from existing EFT Vendors, the up arrow to select from AP Vendors 2 Bank Name The Vendor Bank (e.g. Barclay Bank) 3 Branch The Vendor Branch (e.g. 323111) 4 Account Number The Vendor Account number (e.g. 123456789) 5 Account Name The Vendor Bank Account Name (e.g. Chloride Systems Account) 6 Payment Reference Fill in the Bank’s reference. Not used, can be left blank 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Note : when creating an EFT File, the “reference” chosen on the Create EFT File screen is transmitted to the bank, so




EFT Customers

1 Customer ID Enter or select the Customer id (e.g. 1100). Use the finder to select from existing EFT Customers, the up arrow to select from AR Customers 2 Bank Name The Customer Bank (e.g. Commonwealth Bank) 3 Branch The Customer Branch (e.g. 020903) 4 Account Number The Customer Account number (e.g. 0231234001) 5 Account Name The Customer Bank Account Name (e.g. Bargain Mart – San Diego) 6 Payment Reference Fill in the Statement Reference for this customer 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Note : when creating an EFT File, the “reference” chosen on the Create EFT File screen is transmitted to the bank, so

a) a description should be entered for the batch – this is the header reference b) In the Reference field, select Description/Vendor Master/Cheque/Invoice for

the reference for each vendor payment as required.



EFT Setup procedure for South Africa - First National Bank BANKSERV (ACB)

EFT Banks

1 Bank code CCB (select from existing EFT Banks using the finder, or Common Services Banks using the up arrow) 2 Bank Name 3 Branch Code Enter the 6 digit Branch Code 4 Account Number Your account number with your bank (11 digits) 5 Account Name e.g. Sample Company Inc 6 A/P EFT File batch Enter or browse to find the file path for AP files 7 A/P EFT File Extension The file extension required by the bank (e.g. .FNB) 8 A/P EFT File Type ZA_FNBBANKSERVACB for South Africa - First National Bank BANKSERV (ACB) 9 Select the file numbering option either Batch number or File Sequence Number 10 A/R EFT File batch Enter or browse to find the file path for AR files 11 A/R EFT File Extension The file extension required by the bank (e.g. .FNB) 12 A/R EFT File Type ZA_FNBBANKSERVACB for South Africa - First National Bank BANKSERV (ACB) 13 Select the file numbering option either Batch number or File Sequence Number



EFT Vendors



1 Vendor ID Enter or select the vendor id (e.g. 1200) 2 Remit To This field is optional The Remit To gives you the option to record different vendor bank details for each Remit To location that has been setup in A/P Remit To Location. If you leave this field blank, then EFT will use the vendor bank account details for all A/P Remit to locations. If you fill this field in, then EFT will use the vendor / remit to location EFT details for a payment made to a specific remit to location. 3 File Type This field is optional. Select a file type to record different bank details for each bank layout. If you leave this field blank, then EFT will use the file type that has been assigned in EFT Options > Bank Setup

4 Bank Name The Vendor Bank name 5 Branch Code Enter the Vendor’s 6 digit Branch Code 6 Account Number Enter the Vendor Account number (11 digits) 7 The Vendor Bank Account Name (e.g. Chloride Systems) 8 Enter the Non Standard Account Number 9 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group



10 Enter the Account Type 1 = DDA; 0 = Global Accounts

11 Enter a Statement Reference

EFT Customers


• Option to have more than 1 bank file type for a vendor or customer 1 Customer Number Enter or select the Customer Number (e.g. 1100) 2 File Type This field is optional. Select a file type to record different bank details for each bank layout. If you leave this field blank, then EFT will use the file type that has been assigned in EFT Options > Bank Setup 3 Bank Name Enter the Customer’s Bank name 4 Branch Code Enter the Customer’s 6 digit Branch Code 5 Account Number Enter the Customer Account number (11 digits)



6 The Customer’s Bank Account Name (e.g. Bargain Mart – San Diego) 7 Enter the Non Standard Account Number 8 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group 9 Enter the Account Type 1 = DDA; 0 = Global Accounts

10 Enter a Statement Reference



EFT Setup procedure for National Bank of Kenya

EFT Banks

1 Bank code CCB (select from existing EFT Banks using the finder, or Common Services Banks using the up arrow) 2 Bank Name 3 Branch Code Enter the Branch Code 4 Account Number Your account number with your bank 5 Account Name Enter the account name 6 Select the file numbering option either Batch number or File Sequence Number 7 A/P EFT File batch Enter or browse to find the file path for AP files. 8 A/P EFT File Extension The file extension required by the bank Note: This is a CSV file, so it should be CSV 9 A/P EFT File Type KENYA for National Bank of Kenya 10 AP Reference Optional



EFT Vendors

In EFT55 SP4 and above the following options have been added:


1 Vendor ID Enter or select the vendor id (e.g. 1200) Remit To This field is optional The Remit To gives you the option to record different vendor bank details for each Remit To location that has been setup in A/P Remit To Location. File Type This is optional Leave blank. If you leave this field blank, then EFT will use the vendor bank account details for all A/P Remit to locations. If you fill this field in, then EFT will use the vendor / remit to location EFT details for a payment made to a specific remit to location. 2 Bank Name The Vendor Bank name 3 Branch Code Enter the Vendor’s 6 digit Branch Code 4 Account Number Enter the Vendor Account number (11 digits) 5 The Vendor Bank Account Name (e.g. Chloride Systems) 6 Payment Reference Optional 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group



EFT Setup procedure for South Africa - First National Bank Direct Debit (CSV)

EFT Banks

1 Bank code CCB (select from existing EFT Banks using the finder, or Common Services Banks using the up arrow) 2 Bank Name 3 Branch Code Enter the 6 digit Branch Code 4 Account Number Your account number with your bank (11 digits) 5 Account Name e.g. Sample Company Inc 6 Select the file numbering option either Batch number or File Sequence Number 7 A/P EFT File batch Enter or browse to find the file path for AP files 8 A/P EFT File Extension The file extension required by the bank (e.g. .csv) 9 A/P EFT File Type ZA_FNBDD for SA First National Bank Direct Debit 10 AP Reference 11 Select the file numbering option either Batch number or File Sequence Number 12 A/R EFT File batch Enter or browse to find the file path for AR files 13 A/R EFT File Extension The file extension required by the bank (e.g. .csv) 14 A/R EFT File Type ZA_FNBDD for SA First National Bank Direct Debit 13 AR Reference



EFT Vendors



1 Vendor ID Enter or select the vendor id (e.g. 1200) 2 Remit To This field is optional The Remit To gives you the option to record different vendor bank details for each Remit To location that has been setup in A/P Remit To Location. If you leave this field blank, then EFT will use the vendor bank account details for all A/P Remit to locations. If you fill this field in, then EFT will use the vendor / remit to location EFT details for a payment made to a specific remit to location. 3 Bank Name The Vendor Bank name 4 Branch Code Enter the Vendor’s 6 digit Branch Code 5 Account Number Enter the Vendor Account number (11 digits) 6 The Vendor Bank Account Name (e.g. Chloride Systems) 7 Enter the Non Standard Account Number 8 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group 9 Enter the Account Type Select from 1 = Current Account; 2 = Savings Account



EFT Customers


• Option to have more than 1 bank file type for a vendor or customer 1 Customer Number Enter or select the Customer Number (e.g. 1100) 2 File Type This field is optional. Select a file type to record different bank details for each bank layout. If you leave this field blank, then EFT will use the file type that has been assigned in EFT Options > Bank Setup 3 Bank Name Enter the Customer’s Bank name 4 Branch Code Enter the Customer’s 6 digit Branch Code 5 Account Number Enter the Customer Account number (11 digits) 6 The Customer’s Bank Account Name 7 Enter the Account Number 8 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group 9 Process Single receipt per National Account this setting selected in EFT options > Receipt Selection Codes 10 Account Type Select from 1 = Current Account; 2 = Savings Account



Creating an EFT File Select the Create EFT File option from the EFT Transactions menu

• Select A/P Payment Batch, A/R Receipt batch or A/R Refund batch • Select batch number (or range if allowed) • Enter a description • Select if the reference in the file is

o Use Description o Use Reference Number from the Customer/Vendor Master Record o Use Cheque Number o Use Invoice Number

• Select if you want to error or skip on Vendors/Customers not defined in EFT • Select individual payments or selected payments • Click “create file “



South African First National Bank – CAMS Domestic Services You must select “Cheque Number” in the “Reference Field” drop down to include the cheque number in the file layout.

South African ABSA Bolero XML Format There are no special requirements when exporting the appropriate files.

South African Standard Bank (Domestic) Format There are no special requirements when exporting the appropriate files.



Creating a Receipt Batch in EFT Processing V5.5 Create Receipt Batch generates an AR receipt batch for customers according to their payment code selections. Note: You must create at least one receipt selection code in EFT options before you can use this form to create a receipt batch.


setup procedures for eft processing south african - … procedures for eft processing . south...

Documents