Setup procedures for EFT Processing

(1)

Setup procedures for EFT Processing

South African Banks

(2)

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 Setup procedure for South ABSA Local Format ... 25

(3)

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 Banks ... 46

EFT Vendors ... 47

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

EFT Banks ... 48

EFT Vendors ... 49

EFT Setup procedure for South ABSA Cashfocus format ... 50

EFT Banks ... 50

EFT Vendors ... 51

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

EFT Banks ... 54

EFT Vendors ... 55

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

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

(4)

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

(5)

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

(6)

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

(7)

South African First National Bank – CAMS Domestic Services

Select ZA_FNBCAMS as the primary bank :

(8)

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 :

(9)

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:

(10)

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

(11)

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:

(12)

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:

(13)

(14)

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

(15)

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

(16)

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

(17)

EFT Setup procedure for South African First National Bank

ACB Format

EFT Banks

2 Bank Name  CCB Bank

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

(18)

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.

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

8  The account types: 1 = DDA Accounts 0 = Global Accounts

(19)

EFT Vendors – non standard bank account no.

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.

8  The account types: 1 = DDA Accounts 0 = Global Accounts

(20)

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

(21)

EFT Customers – non standard bank account no.

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

(22)

EFT Setup procedure for South ABSA Bolero XML Format

EFT Banks

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

(23)

EFT Vendors

2  Bank Name  The Vendor Bank (e.g. Barclay Bank)

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

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.

(24)

EFT Customers

3  Branch  The Customer Branch (e.g. 645987888)

5  Account Name  The Customer Bank Account Name (e.g. Bargain Mart – San Diago)

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

(25)

EFT Setup procedure for South ABSA Local Format

EFT Banks

5  Account Name eg Sample Company Inc

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)

(26)

EFT Vendors

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

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.

(27)

(28)

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

(29)

(30)

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)

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

(31)

EFT Vendors

3  BSB Number  The Vendor Branch (e.g. 323111)

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

(32)

EFT Customers

2  Bank Name  The Customer Bank (e.g. HSBC Bank)

(33)

(34)

EFT Setup procedure for South African Standard Bank

(Domestic)

EFT Banks

7  A/P EFT File Extension  The file extension required by the bank (e.g. .std)

(35)

EFT Vendors

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.

(36)

EFT Customers

6  Payment Reference  Fill in the Statement Reference

(37)

(38)

EFT Setup procedure for NetBankBusiness CSV

EFT Banks

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)

8  A/P EFT File Extension  This needs to be CSV

9  A/P EFT File Type  ZA_ NETBANKBUS_CSV

(39)

EFT Setup procedure for NetBankBusiness

EFT Banks

2 Bank Name  eg City Commercial Bank

3 Branch  Enter the branch number (e.g. 123456)

6  Seed  Enter the 32 digit seed from the bank used in the hash calculation

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

(40)

EFT Vendors

6  Sub Account Number  Fill in the sub account number if appropirate

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

(41)

(42)

EFT Customers

5  Account Name  The Customer Bank Account Name (e.g. Bargain Mart – San Diego)

6  Payment Reference  Fill in the Statement Reference

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

(43)

(44)

EFT Setup procedure for Standard Bank – Business Online

Domestic Banking (Value Dated – 8 digit date import)

EFT Banks

2 Bank Name  eg Standard Bank

3 Branch  Enter the branch number (e.g. 123456)

6  Company Code  Enter the 4 digit Company Code provided by the bank

(45)

EFT Vendors

5  Account Name  The Vendor Bank Account Name (e.g. Chloride Bank Savings Account)

6  Payment Reference  Fill the statement reference for this vendor

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

(46)

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

5  Account Name e.g. Sample Company Inc

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.

(47)

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

(48)

EFT Setup procedure for South Africa Standard Bank

Business Online Domestic Banking SSVS PRE-FORMAT

EFT Banks

3 Branch  6 digit number

6 File Naming  Select the file numbering option either Batch number or File Sequence Number

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

(49)

EFT Vendors

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.

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

(50)

EFT Setup procedure for South ABSA Cashfocus format

EFT Banks

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)

(51)

EFT Vendors

6  Payment Reference  Fill in the Bank’s reference. Not used, can be left blank

(52)

(53)

EFT Customers

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

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

(54)

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)

7  A/P EFT File Extension  The file extension required by the bank (e.g. .FNB)

(55)

EFT Vendors

5  Branch Code  Enter the Vendor’s 6 digit Branch Code

6  Account Number  Enter the Vendor Account number (11 digits)

8  Enter the Non Standard Account Number

(56)

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

11  Enter a Statement Reference 

EFT Customers

(57)

6  The Customer’s Bank Account Name (e.g. Bargain Mart – San Diego)

9  Enter the Account Type  1 = DDA; 0 = Global Accounts

(58)

EFT Setup procedure for National Bank of Kenya

EFT Banks

2  Bank Name

3  Branch Code  Enter the Branch Code

5  Account Name  Enter the account name

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

(59)

EFT Vendors

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

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.

6  Payment Reference  Optional

(60)

EFT Setup procedure for South Africa - First National Bank

Direct Debit (CSV)

EFT Banks

2  Bank Name

3  Branch Code  Enter the 6 digit Branch Code

4  Account Number  Your account number with your bank (11 digits)

(61)

EFT Vendors

(62)

EFT Customers

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

(63)

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

(64)

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.

(65)

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.