Setup procedures for EFT Processing

(1)

Setup procedures for EFT Processing

North American Banks

(2)

EFT Options ... 9

A/P Options ... 9

A/R Options ... 10

E-mail ... 11

Options ... 12

Canadian CIBC Bank ... 13

Canadian – CIBC Bank Positive Pay Format ... 14

Canadian – CIBC for Direct Payments ... 14

Canadian TD Bank ... 14

Canadian TD Bank US$ Format ... 14

Canadian RBC Bank ... 15

Canadian RBC Bank – AP Link ... 15

Canadian RBC – A/P Link Incl ACH ... 17

Canadian EFT (80 byte Record) ... 17

Canadian Scotiabank ... 17

Canadian Scotia Direct 105 Byte ... 17

Canadian Scotiabank – Web Import ... 19

Canadian – Bank of Montreal ... 19

Canadian – Bank of Montreal EFT Direct 80 Byte file ... 19

Canadian – Bank of Montreal Positive Pay ... 20

Canadian – Alberta Treasury Bank ... 21

Canadian – Alberta Treasury Bank using File System Number ... 22

Canada – HSBC Bank Canada ... 22

Canada – HSBC Bank Canada Bacs Standard 18 ... 22

Canada – Caisse Populaire Desjardins ... 22

Canada – Canada’s TD Bank Positive Pay ... 24

Canada – Canadian Beanstream ACH ... 24

Canada – Canadian Beanstream Credit Card format ... 24

Canada – RBC Express (flat txt file) ... 25

Canada – Canadian Beanstream EFT ... 26

Canada – Canadian RBC for Payee Match ... 27

Canada – Canadian RBC Cross Border payments ... 27

Canada – Royal Bank of Canada (STD152) Debit/Credit File ... 27

Canadian - Bank of Nova Scotia - PIAP ... 28

Canada – Royal Bank of Canada ACH Debit/Credit with IAT Rules ... 28

Australian HSBC ... 28

USA Mellon Global Cash Management ... 28

Canadian Bank Reconciliation (RTF) ... 30

Canadian CPA Standard 005 AFT File Specification... 30

Canadian - CIBC CPA Standard 005/EFT1464... 31

Canadian – Royal Bank of Canada - Jamaica ... 31

National Bank of Canada ... 32

Estonia – Hansabank Domestic Layout ... 32

Estonia – Hansabank Foreigh Layout ... 32

USA – Solano Bank ... 33

(3)

USA – NACHA Standard ... 34

USA – NACHA Standard - Self Balancing ... 36

USA – Nacha Standard, User Defined Transaction Type ... 36

USA – NACHA CTX Standard ... 36

USA – ACH Direct EFT format for the Payment Gateway ... 36

USA – International ACH Transactions (IAT) File Format ... 38

USA – Nordea Bank - NACHA Standard... 38

USA – Frost Bank - NACHA Standard ... 38

USA – Pinnacle National Bank... 39

USA – Sovereign Bank ... 39

USA – JP Morgan Chase ... 39

USA – Wilmington Trust Co ... 40

USA - Commerce Bank ACH ... 40

USA - CommerceBank Wire Transfer ... 40

USA – Bank of America - NACHA ... 41

USA – First American Bank ACH... 41

Emirates National Bank Dubai ... 41

Setup your bank, customers and vendors ... 42

EFT Setup procedure for Canadian CIBC ... 43

EFT Banks ... 43

EFT Vendors ... 44

EFT Setup procedure for Canadian CIBC Positive Pay ... 45

EFT Banks ... 45

EFT Vendors ... 46

EFT Setup procedure for Canadian CIBC Direct Payments ... 48

EFT Banks ... 48

EFT Vendors ... 49

EFT Customers ... 50

EFT Setup procedure for Canadian TD Bank ... 51

EFT Banks ... 51

EFT Vendors ... 52

EFT Setup procedure for Canadian TD Bank – US$ Format ... 54

EFT Banks ... 54

EFT Vendors ... 55

EFT Setup procedure for Canadian RBC... 57

EFT Banks ... 57

EFT Vendors ... 58

EFT Setup procedure for Canadian RBC – AP Link ... 60

EFT Banks ... 60

EFT Vendors ... 63

EFT Setup procedure for Canadian RBC – AP Link Incl ACH ... 66

EFT Banks ... 66

(4)

EFT Vendors ... 71

EFT Setup procedure for Canadian Scotiabank ... 73

EFT Banks ... 73

EFT Vendors ... 74

EFT Setup procedure for Canadian Scotia Direct 105 Byte ... 76

EFT Banks ... 76

EFT Vendors ... 78

EFT Setup procedure for Canadian Scotiabank – Web Format ... 80

EFT Banks ... 80

EFT Vendors ... 81

EFT Setup procedure for Canadian – Bank of Montreal ... 83

EFT Banks ... 83

EFT Vendors ... 84

EFT Setup procedure for Canadian – Bank of Montreal EFT Direct 80 Byte format ... 86

EFT Banks ... 86

EFT Vendors ... 87

EFT Setup procedure for Canadian – Bank of Montreal Positive Pay ... 89

EFT Banks ... 89

EFT Vendors ... 90

EFT Setup procedure for Canadian – Alberta Treasury Bank ... 91

EFT Banks ... 91

EFT Vendors ... 92

EFT Setup procedure for Canadian – Alberta Treasury Bank using File System Number ... 94

EFT Banks ... 94

EFT Vendors ... 95

EFT Setup procedure for Canadian HSBC Bank Canada ... 97

EFT Banks ... 97

EFT Vendors ... 98

EFT Setup procedure for Canadian HSBC Bank Canada BACS Standard 18 .... 100

EFT Banks ... 100

EFT Vendors ... 101

EFT Setup procedure for Canadian Caisse Populaire Desjardins ... 103

EFT Banks ... 103

EFT Vendors ... 104

(5)

EFT Vendors ... 108

EFT Setup procedure for Canadian - Royal Bank of Canada ACH Debit/Credit with IAT Rules ... 109

EFT Banks ... 109

EFT Vendors ... 111

EFT Setup procedure for Canadian - Canadian Bank of Nova Scotia - PIAPEFT Banks... 113

EFT Vendors ... 114

EFT Setup procedure for HSBC ... 116

EFT Banks ... 116

EFT Vendors ... 117

EFT Setup procedure for Canadian Beanstream ACH ... 119

EFT Banks ... 119

EFT Vendors ... 120

EFT Setup procedure for Canadian Beanstream Credit Card format ... 122

EFT Banks ... 122

EFT Setup procedure for Canadian Beanstream EFT ... 125

EFT Banks ... 125

EFT Vendors ... 126

EFT Setup procedure for Canadian RBC Express (flat txt file) ... 128

EFT Banks ... 128

EFT Vendors ... 129

EFT Setup procedure for Canadian RBC for Payee Match (AP only) ... 131

EFT Banks ... 131

EFT Vendors ... 132

EFT Setup procedure for Canadian RBC for Cross Border payments ... 133

EFT Banks ... 133

EFT Setup procedure for Royal Bank of Canada (STD152) Debit/Credit ... 134

EFT Banks ... 134

EFT Vendors ... 135

EFT Setup procedure for USA Mellon Global Cash Management ... 138

EFT Banks ... 138

EFT Vendors ... 139

EFT Setup procedure for Canadian Bank Reconciliation (RTF) ... 141

EFT Banks ... 141

EFT Vendors ... 142

EFT Setup procedure for Canadian CPA Standard 005 AFT File specification (CAN_CPA) ... 144

EFT Banks ... 144

(6)

EFT Banks ... 147

EFT Vendors ... 148

EFT Setup procedure for Canadian - CIBC CPA Standard 005/EFT1464 ... 150

EFT Banks ... 150

EFT Vendors ... 151

EFT Setup procedure for Royal Bank of Canada - Jamaica ... 153

EFT Banks ... 153

EFT Setup procedure for HSBC BACS (Canada) ... 154

EFT Banks ... 154

EFT Vendors ... 155

EFT Setup procedure for National Bank of Canada ... 157

EFT Banks ... 157

EFT Vendors ... 158

EFT Setup procedure for Estonian Hansabank Domestic Layout ... 160

EFT Banks ... 160

EFT Vendors ... 161

EFT Setup procedure for Estonian Hansabank Foreign Layout ... 163

EFT Banks ... 163

EFT Vendors ... 164

EFT Setup procedure for USA Solano Bank Layout ... 166

EFT Banks ... 166

EFT Vendors ... 167

EFT Setup procedure for USA CITIBANK Layout ... 169

EFT Banks ... 169

EFT Vendors ... 170

EFT Setup procedure for USA CITIBANKFT – funds transfer Layout ... 172

EFT Banks ... 172

EFT Vendors ... 173

EFT Vendor Remittance Address ... 173

EFT Setup procedure for USA CITIBANKPF- ACH PreFormat Layout ... 176

EFT Banks ... 176

EFT Vendors ... 177

EFT Setup procedure for USA – Harris Bank ACH ... 179

EFT Banks ... 179

EFT Vendors ... 180

(7)

EFT Setup procedure for USA NACHA CTX Standard Layout ... 187

EFT Banks ... 187

EFT Vendors ... 188

USA – ACH Direct EFT format for the Payment Gateway ... 190

EFT Banks ... 190

EFT Vendors ... 191

EFT Setup procedure for USA - International ACH Transactions (IAT) File Format ... 193

EFT Banks ... 193

EFT Vendors ... 195

EFT Setup procedure for USA Nordea - NACHA Standard Layout ... 199

EFT Banks ... 199

EFT Vendors ... 200

EFT Setup procedure for USA - NACHA Standard Self Balancing ... 202

EFT Banks ... 202

EFT Vendors ... 203

EFT Setup procedure for USA - NACHA Standard, User Defined Transaction Type ... 205

EFT Banks ... 205

EFT Vendors ... 206

EFT Setup procedure for USA FROST - NACHA Standard Layout ... 208

EFT Banks ... 208

EFT Vendors ... 209

EFT Setup procedure for USA Pinnacle National Bank - NACHA Standard Layout ... 211

EFT Banks ... 211

EFT Vendors ... 212

EFT Setup procedure for USA Sovereign Bank - NACHA Standard Layout ... 214

EFT Banks ... 214

EFT Vendors ... 215

EFT Setup procedure for USA JP Morgan Chase Layout ... 217

EFT Banks ... 217

EFT Vendors ... 219

EFT Setup procedure for USA Wilmington Trust Co - NACHA Standard Layout ... 221

(8)

EFT Banks ... 224

EFT Vendors ... 225

EFT Setup procedure for USA CommerceBank Wire Transfer ... 227

EFT Banks ... 227

EFT Vendors ... 228

EFT Setup procedure for USA Bank of America - NACHA... 229

EFT Banks ... 229

EFT Vendors ... 230

EFT Setup procedure for USA First American Bank ACH ... 232

EFT Banks ... 232

EFT Vendors ... 233

Creating the EFT File... 234

EFT Setup procedure for Emirates National Bank Dubai ... 235

EFT Banks ... 235

EFT Vendors ... 236

(9)

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

(10)

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

(11)

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.

(12)

Options

• Select the bank or primary bank. Selecting a bank enables the EFT Screen labels to be tailored to the bank

(13)

Canadian CIBC Bank

(14)

Canadian – CIBC Bank Positive Pay Format

Select CAN_CIBCPP as the primary bank

Canadian – CIBC for Direct Payments

Select CAN_CIBC_DIRPAY as the primary bank

Canadian TD Bank

(15)

Select CAN_TDUSA as the primary bank :

Canadian RBC Bank

Select CAN_RBC as the primary bank if you want $$AA exported in the header row of the EFT File select:

Otherwise select CAN_RBC1 as the primary bank:

Canadian RBC Bank – AP Link

(16)

If you want to control the type of remittance sent to the customers/vendors by the bank on the AR Customer/AP Vendor record – using the “Destination” option (e-mail, print), then select CAN_RBCAPL as the primary bank.

If you want to control the type of remittance advice (none, e-mail, fax – see RBC’s AP Link Payment Type list choices) by entering the appropriate code on the EFT Customer/EFT Vendor, then select CAN_RBCAPL1 as the primary bank

(17)

Canadian RBC – A/P Link Incl ACH

Select CAN_RBCAPLACHas the primary bank :

Canadian EFT (80 byte Record)

Select CAN_EFT as the primary bank :

Canadian Scotiabank

(18)

(19)

Canadian Scotiabank – Web Import

Select CAN_SCOTIAWEB as the primary bank :

Canadian – Bank of Montreal

Select CAN_BOMONTREAL as the primary bank

Canadian – Bank of Montreal EFT Direct 80 Byte file

(20)

Canadian – Bank of Montreal Positive Pay

(21)

Canadian – Alberta Treasury Bank

(22)

Canadian – Alberta Treasury Bank using File System Number

Select CAN_ATBFS as the primary bank

Canada – HSBC Bank Canada

Select CAN_HSBC as the primary bank

Canada – HSBC Bank Canada Bacs Standard 18

Select CAN_HSBC as the primary bank

(23)

(24)

Canada – Canada’s TD Bank Positive Pay

Select CAN_TDPP as the primary bank

Canada – Canadian Beanstream ACH

Select CAN_BEANSTREAMACH as the primary bank

Canada – Canadian Beanstream Credit Card format

(25)

Canada – RBC Express (flat txt file)

(26)

Canada – Canadian Beanstream EFT

(27)

Canada – Canadian RBC for Payee Match

Select CAN_ RBCPAYEEMATCH as the primary bank

Canada – Canadian RBC Cross Border payments

Select CAN_ RBCACH as the primary bank

Note: CAN_RBCACH_APLINK and CAN_RBCACH_EXPRESS are based on the Canadian ACH 152 Standard, with the IAT address requirements

Canada – Royal Bank of Canada (STD152) Debit/Credit File

(28)

Canadian - Bank of Nova Scotia - PIAP

Select CAN_SCOTIAPIAP as the primary bank

Canada – Royal Bank of Canada ACH Debit/Credit with IAT

Rules

Australian HSBC

Select HSBC_AU as the primary bank :

(29)

(30)

Canadian Bank Reconciliation (RTF)

Select CAN_RECON as the primary bank :

Canadian CPA Standard 005 AFT File Specification

Select CAN_CPA as the primary bank (when upgrading from EFT Processing V5.3) otherwise Select CAN_CPA005:

(31)

Canadian - CIBC CPA Standard 005/EFT1464

Select CAN_CPA005CIBC as the primary bank :

Canadian – Royal Bank of Canada - Jamaica

(32)

Canada - HSBCNET BACS

Select CAN_HSBCBACS as the primary bank :

National Bank of Canada

Select CAN_NBC as the primary bank :

Estonia – Hansabank Domestic Layout

(33)

Select EST_HANSAFOREIGN as the primary bank :

USA – Solano Bank

Select USA_SOLANO as the primary bank

USA – Citibank

(34)

USA – Citibank Funds Transfer

Select CITIBANKFT as the primary bank

USA – Citibank ACH - PreFormat

Select CITIBANKPF as the primary bank

USA – Harris Bank ACH

(35)

(36)

USA – NACHA Standard - Self Balancing

Select NACHA_SB as the primary bank

USA – Nacha Standard, User Defined Transaction Type

Select NACHA_UDTT as the primary bank

USA – NACHA CTX Standard

Select NACHA_CTX as the primary bank

(37)

(38)

USA – International ACH Transactions (IAT) File Format

USA – Nordea Bank - NACHA Standard

Select USA_NORDEA as the primary bank

USA – Frost Bank - NACHA Standard

(39)

USA – Pinnacle National Bank

Select USA_PINNACLE as the primary bank

USA – Sovereign Bank

Select USA_SOVEREIGN as the primary bank

USA – JP Morgan Chase

(40)

USA – Wilmington Trust Co

Select USA_WILMINGTON as the primary bank

USA - Commerce Bank ACH

Select COMMERCE_ACH as the primary bank

USA - CommerceBank Wire Transfer

(41)

USA – Bank of America - NACHA

Select USA_BOAMERICA as the primary bank

USA – First American Bank ACH

Select USA_FIRSTAMERICAN as the primary bank

Emirates National Bank Dubai

(42)

(43)

EFT Setup procedure for Canadian CIBC

EFT Banks

1 Bank Name CIBC

2 Financial Institution ID  9 digit number (e.g. 080002999)

3  Account Number  Your account number with your bank (e.g. 999888777) 4  Payment Code (transaction code) for AP Payments eg 460

5  Account Name eg Sample Company LTD

6 _{Receipt Code (transaction code) for AR Payments eg 460}

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. .CIB) 9  A/P EFT File Type  CAN_CIBC for Canadian CIBC

10  A/P Payment Reference  Organisation id eg 0102060878

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. .CIB) 13  A/R EFT File Type  CAN_CIBC for Canadian CIBC

(44)

EFT Vendors

1  Vendor ID  Enter or select the vendor id (e.g. 1200)

2  Bank Name  The Vendor Bank (e.g. Westpac Current Account)

3  Financial Institution ID  The Vendor Financial institution id (e.g. 099955533) 4  Account Number  The Vendor Account number (e.g. 1234567890)

5  Account Name  The Vendor Bank Account Name (e.g. Chloride Systems) 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

(45)

EFT Setup procedure for Canadian CIBC Positive Pay

EFT Banks

1 Bank Name CIBC

2 Bank Transit Number  5 digit number (e.g. 12345)

3  Account Number  Your account number with your bank (e.g. 123456789012) 4  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. .CPP) 8  A/P EFT File Type  CAN_CIBCPP for Canadian CIBC Positive Pay

9  Legacy System Identifier  CIBC Reference ID eg 123450000012345678. ID issued by CIBC Business Contact Centre. Format TTTTTXXXXXAAAAAAASSS. Enter the 17 Characters for TTTTTXXXXXAAAAAAA and the program will automatically add the SSS from the file numbering

(46)

EFT Vendors

The rest of the information 2..7 is optinal and is not used in the EFT Positive Payment File

2  Bank Name  The Vendor Bank (e.g. Westpac Current Account)

When generating an EFT File, you must select “Use Cheque Number” in order for the cheque number to be exported in the EFT Positive Payment file.

(47)

(48)

EFT Setup procedure for Canadian CIBC Direct Payments

EFT Banks

1 Bank Name CCB 2 Bank and Branch Code

3  Account Number  Your account number with your bank (e.g. 123456789012) 4  Account Name e.g. Sample Company

7  A/P EFT File Extension  The file extension required by the bank (e.g. .CIB) 8  A/P EFT File Type  CAN_CIBC_DIRPAY for Canadian CIBC – Direct Payments

9  Payment Code (Typically 77 for supplier)

10 & 15  Select the file numbering option - must be File Sequence 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. .CIB) 13 _{A/R EFT File Type}_{CAN_CIBC_DIRPAY for Canadian CIBC – Direct}

(49)

EFT Vendors

2  Bank Name  The Vendor Bank (e.g. Royal Bank of Canada) 3  Bank and Branch Code

4  Account Number  The Vendor Account number

(50)

EFT Customers

1  Customer ID  Enter or select the Customer id (e.g. 1100) 2  Bank Name  The Customer Bank Name (e.g. TD Bank) 3  Bank and Branch Code

4  Account Number  The Vendor Account number

(51)

EFT Setup procedure for Canadian TD Bank

EFT Banks

1 Bank Name TD Bank

3  Account Number  Your account number with your bank (e.g. 999888777) 4 _{Account Name eg Sample Company LTD}

6  A/P EFT File Extension  The file extension required by the bank (e.g. .TDB) 7  A/P EFT File Type  CAN_TD for Canadian TD Bank

8  Originator ID Number  Organisation id eg 0102060878

9 A/R EFT File batch  Enter or browse to find the file path for AR files

10  A/R EFT File Extension  The file extension required by the bank (e.g. .TDB) 11  A/R EFT File Type  CAN_CIBC for Canadian TD Bank

(52)

EFT Vendors

1  Vendor ID  Enter or select the vendor id (e.g. 1200) 2  Bank Name  The Vendor Bank (e.g. Barclays Bank)

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

6  Account Type (S/C)  Enter S or C depending on the vendors account type 7  Status  Status must be active for an EFT Payment. Modifying this field can be controlled by a security group

(53)

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  Financial Institution ID  The Customer Financial institution id (e.g. 444555888)

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

(54)

EFT Setup procedure for Canadian TD Bank – US$ Format

EFT Banks

1 Bank Name TD Bank – US$ Format

2 Financial Institution ID  9 digit number (e.g098765432)

6 _{A/P EFT File Extension}_{The file extension required by the bank (e.g. .TDB)}

7  A/P EFT File Type  CAN_TDUSA for Canadian TD Bank – US$ Format 8  Originator ID Number  Organisation id eg 123654

10  A/R EFT File Extension  The file extension required by the bank (e.g. .TDB) 11  A/R EFT File Type  CAN_TDUSA for Canadian TD Bank – US$ Format 12  Originator ID Number  Organisation id eg 123654

(55)

EFT Vendors

6  Account Type (S/C)  This payment reference must be entered as “S” for savings account and “C” for current account

(56)

EFT Customers

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

(57)

EFT Setup procedure for Canadian RBC

EFT Banks

1 Bank Code  Select or enter the appropriate bank code. (e.g. CCB) 2  Bank Name  Enter the bank name (e.g. royal Bank of Canada)

3 Financial Institution ID/Transit Number  The Financial Institution ID is 4 digits. The transit or branch number is 5 digits. Enter them both as a single 9 digit number (e.g. 113456789)

4  Account Number  Your account number with the bank (e.g. 999888777) 5  Account Name eg Sample Company Inc

6 _{Client ID}_{This is used for the A/R format only. Contact the bank to find out}

what your Client ID is. 10 digit client number as follows : 6 digit client number assigned by the Royal Bank and 4 digit subsidiary number assigned by the client. Where no subsidiary exists, insert zeros as the last 4 digits of this field. (eg

123450000)

8  A/P EFT File Extension  The file extension required by the bank (e.g. RBC) 9  A/P EFT File Type  CAN_RBC for Canadian RBC

(58)

10  A/P Payment Reference  Three digit code as defined in Pre-Authorized Debits (PADs) Service manual (Chapter 7) for CPA codes or USA codes. Contact your bank for a full list. (eg 999). Recommendation : use 450

12  A/R EFT File Extension  The file extension required by the bank (e.g. RBC) 13  A/R EFT File Type  CAN_RBC for Canadian RBC

14  Transaction Code  Three digit code as defined in Pre-Authorized Debits (PADs) Service manual (Chapter 7) for CPA codes or USA codes. Contact your bank for a full list. (eg 450)

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

EFT Vendors

1  Customer ID  Enter or select the Customer id (e.g. 1200) 2  Bank Name  The Customer Bank (e.g. Barclays Bank)

4  Account Number  The Customer Account number (e.g. 123456789012) 5  Account Name  The Customer Bank Account Name (eg. Chloride Systems Account)

6  Country  Enter CAN or USA for Canada or USA

(59)

EFT Customers

1  Customer ID  Enter or select the Customer id (e.g. 1200) 2  Bank Name  The Customer Bank (e.g. Barclays Bank)

4  Account Number  The Customer Account number (e.g. 0398462222) 5  Account Name  The Customer Bank Account Name (eg. Ronald Black Current Account)

6  Country  Enter CAN or USA for Canada or USA

(60)

EFT Setup procedure for Canadian RBC – AP Link

EFT Banks

1 Bank Code  Select or enter the appropriate bank code. (e.g. CCB) 2  Bank Name  Enter the bank name (e.g. Royal Bank of Canada)

3 Financial Institution ID/Transit Number  The Financial Institution ID is 4 digits. The transit or branch number is 5 digits. Enter them both as a single 9 digit number (e.g. 113456789)

4  Account Number  Your account number with the bank (e.g. 999888777) 5  Account Name eg Sample Company Inc

7  A/P EFT File Extension  The file extension required by the bank (e.g. RBC) 8  A/P EFT File Type  CAN_RBCAPL or CAN_RBCAPL1 for Canadian RBC – AP Link. See Note 1 Below

9  A/P Payment Reference  not used

11  A/R EFT File Extension  The file extension required by the bank (e.g. RBC) 12  A/R EFT File Type  CAN_RBCAPL or CAN_RBCAPL1 for Canadian RBC AP Link. See Note 1 Below

(61)

EFT Processing Setup of North American Banks

_____________________________________________________________________ NOTE 1 : CAN_RBCAPL VS CAN_RBCAPL1

In the Royal Bank of Canada – AP Link, you need to instruct the bank what type of payment you are making.

A FEDI Only Financial EDI pay only (No Remittance Delivery)

B FEDI with EDI Remit Financial EDI pay/EDI remittance

C FEDI with Fax Remit Financial EDI pay/fax remittance D FEDI with eMail Remit Financial EDI pay/eMail remittance

E PDS Only ACH Direct Deposit pay only (PDS) (No Remittance Delivery)

F PDS with Fax Remit ACH Direct Deposit pay/fax remittance (PDS)

G PDS with eMail Remit ACH Direct Deposit pay/eMail remittance (PDS)

H PDS Payroll ACH Direct Deposit Payroll (No Remittance Delivery)

I PAD Only ACH Personally Approved Debits (PAD) (No Remittance Delivery) J PAD with Fax ACH Personally Approved Debits/fax remittance (PAD)

K PAD with eMail ACH Personally Approved Debits/email remittance (PAD)

L CHQ Cheque

M CHQ/DA Cheque/Disbursement Auditor

N CHQ/DA/PM Cheque/Disbursement Auditor/Payee Match

O DA Disbursement Auditor

P Wires Only Wires pay only (No Remittance Delivery)

Q Wires with Fax Wires with Fax

R Wires with eMail Wires with eMail

S Payee Match Payee Match

T Payee Match/CHQ Payee Match/Cheque Issuance

U Payee Match/DA Payee Match/DA

V Fax Only FAX Remittance Only

W eMail Only eMail Remittance Only

For Payments to Vendors, you can use types A..H, L..W For direct debits from Customers, you can use types I, J, K

If you want to use the delivery method on the vendor to dictate types E (no

remittance), F (fax remittance), G (e-mail remittance), then select CAN_RBCAPL as A/P EFT File Type.

(62)

_____________________________________________________________________ If you want to use the delivery method on the customer to dictate types I (no

remittance), J (fax remittance), K (e-mail remittance), then select CAN_RBCAPL as A/R EFT File Type.

If you want to use the delivery method on the EFT Vendor record to dictate types A..H, L..W then select CAN_RBCAPL1 as A/P EFT File Type.

(63)

_____________________________________________________________________ If you want to use the delivery method on the EFT Customer record to dictate types I, J, K then select CAN_RBCAPL1 as A/R EFT File Type.

EFT Vendors

Using a primary bank of CAN_RBCAPL1

1  Customer ID  Enter or select the Customer id (e.g. 1500) 2  Bank Name  The Customer Bank (e.g. Chase Manhattan) 3  Financial Institution ID  The Customer Financial institution id

(64)

6  Pay Type (E/F/G)  Enter the payment type required : A..H, L..W

Using a primary bank of CAN_RBCAPL

1  Customer ID  Enter or select the Customer id (e.g. 1500) 2  Bank Name  The Customer Bank (e.g. Chase Manhattan) 3  Financial Institution ID  The Customer Financial institution id

(e.g. 123456888)

5  Account Name  The Customer Bank Account Name (eg. Gould Manufacturing Ltd.)

6 Payment Reference  Enter any payment reference for this vendor (eg 1500) 7  Status  Status must be active for an EFT Payment. Modifying this field can be controlled by a security group

EFT Customers

(65)

1  Customer ID  Enter or select the Customer id (e.g. 1600) 2  Bank Name  The Customer Bank (e.g. Westpac)

6 Pay Type (I/J/K)  Enter the payment type required : I, J or K

(66)

1  Customer ID  Enter or select the Customer id (e.g. 1600) 2  Bank Name  The Customer Bank (e.g. Westpac)

6 Payment Reference  Enter any payment reference for this customer (eg 1600) 7  Status  Status must be active for an EFT Payment. Modifying this field can be controlled by a security group

EFT Setup procedure for Canadian RBC – AP Link Incl ACH

EFT Banks

1 Bank Code  Select or enter the appropriate bank code. (e.g. CCB) 2  Bank Name  Enter the bank name (e.g. Royal Bank of Canada)

3 Financial Institution ID/Transit Number  The Financial Institution ID is 4 digits. The transit or branch number is 5 digits. Enter them both as a single 9 digit

(67)

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. RBC) 8  A/P EFT File Type  CAN_RBCAPLACH for Canadian RBC – AP Link Incl ACH

9  A/P Payment Reference  not used

10 Select the file numbering option either Batch number or File Sequence Number or Fixed

12  A/R EFT File Extension  The file extension required by the bank (e.g. RBC) 13  A/R EFT File Type  CAN_RBCAPLACH for Canadian RBC – AP Link Incl ACH

14  A/R Payment Reference  not used

15  Select the file numbering option either Batch number, File Sequence Number, fixed or same as payments

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

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

(68)

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  Financial Institution ID  The Vendor Financial institution ID 6  Account Number  The Vendor Account number

7  The Vendor Bank Account Name (e.g. Chloride Systems) 8  Pay Type 

(69)

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  Financial Institution ID  The Customer’s Financial institution ID 5  Account Number  The Customer’s Account number

6  The Customer’s Bank Account Name (e.g. Bargain Mart – San Diego) 7  Pay Type  I/K/K

(70)

EFT Setup procedure for Canadian EFT (80 Byte Record)

EFT Banks

1 Bank Code Enter the bank code (or use the finder to select it) EG CCB 2_{Bank Name}_{Enter the bank name eg CCB Bank}

7  A/P EFT File Extension  The file extension required by the bank (e.g. .EFT) 8  A/P EFT File Type  CAN_EFT for Canadian EFT

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. .EFT) 12  A/R EFT File Type  CAN_EFT for Canadian EFT

(71)

EFT Vendors

6  Payment Reference  can be used for notes. Not used in the EFT file

(72)

EFT Customers

5  Account Name  The Customer Bank Account Name (e.g. Mr Ronald Black) 6  Payment Reference  Not used in this format. Can be used for any notes

(73)

EFT Setup procedure for Canadian Scotiabank

EFT Banks

1 Bank Code Enter the bank code (or use the finder to select it) EG CCB 2Bank Name Enter the bank name eg CCB Bank

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. .SCO) 8  A/P EFT File Type  CAN_SCOTIA for Canadian Scotiabank

9  Customer Number  Customer number supplied by Scotiabank eg 1234567890 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. .EFT) 12  A/R EFT File Type  CAN_SCOTIA for Canadian Scotiabank

(74)

EFT Vendors

(75)

EFT Customers

(76)

EFT Setup procedure for Canadian Scotia Direct 105 Byte

EFT Banks

1 Bank Code Enter the bank code (or use the finder to select it) EG CCB 2 Bank Name Enter the bank name

3 _{Financial Institution ID}_{9 digit number}

4  Account Number  Your account number with your bank (e.g. 999888777) 5  Account Name e.g. Sample Company Inc

(77)

7  Originator Short Name 

8  A/P EFT File batch  Enter or browse to find the file path for AP files

9  A/P EFT File Extension  The file extension required by the bank (e.g. .SCO) 10 A/P EFT File Type  CAN_SCOTIASD105 for Canadian Scotia Direct 105 Byte

11  Customer Number  Customer number supplied by Scotia bank

12  Select the file numbering option either Batch number or File Sequence Number 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. .EFT) 15 A/R EFT File Type  CAN_SCOTIASD105 for Canadian Scotia Direct 105 Byte

16  Customer Number  Customer number supplied by Scotia bank

(78)

EFT Vendors

• 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.

4  Bank Name  The Vendor Bank name (e.g. Standard Chartered Bank) 5  Financial Institution ID  The Vendor Financial institution ID

6  Account Number  The Vendor Account number 7  The Vendor Bank Account Name (e.g. Chloride Systems)

8  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

(79)

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  Financial Institution ID  The Customer’s Financial institution ID 5  Account Number  The Customer’s Account number

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

7  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

(80)

EFT Setup procedure for Canadian Scotiabank – Web Format

EFT Banks

1 Bank Code Enter the bank code (or use the finder to select it) EG CCB 2Bank Name Enter the bank name eg CCB Bank

3 Institution/Transit ID  Enter your 3 digit Institution id followed by your 5 digit Transit ID (e.g. 11155555)

4  Account Number  Your account number with your bank (e.g. 999888777) 5 _{Account Name eg Sample Company Inc}

7  A/P EFT File Extension  The file extension required by the bank (e.g. .BNS) 8  A/P EFT File Type  CAN_SCOTIAWEB for Canadian Scotiabank – Web 9  Payment Group  Enter the payment group used for AP transactions in the ScotiaBank Web client eg PaymentGroupABC

11  A/R EFT File Extension  The file extension required by the bank (e.g. .EFT) 12  A/R EFT File Type  CAN_SCOTIA for Canadian Scotiabank

(81)

EFT Vendors

3  Institution ID/Transit  The Vendor Financial institution id (e.g. 22266666) 4  Account Number  The Vendor Account number (e.g. 123456789)

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

6  Payment Reference  can be used for sundry information to be sent in the bank file.

(82)

EFT Customers

1  Customer ID  Enter or select the Customer id (e.g. 1100) 2  Bank Name  The Customer Bank (e.g. Commonwealth Bank) 3  Institution ID/Transit ID  The Customer Financial institution id (e.g. 020903555)

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

6  Payment Reference  Can be used sundry information to be sent to the bank 7  Status  Status must be active for an EFT Payment. Modifying this field can be controlled by a security group

(83)

EFT Setup procedure for Canadian – Bank of Montreal

EFT Banks

1 Bank Code Enter the bank code (or use the finder to select it) EG CCB 2Bank Name Enter the bank name eg ABC Bank

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

8  A/P EFT File Type  CAN_BOMONTREAL for Canadian Bank of Montreal 9  Originator ID Number  Customer number supplied by Bank of Montreal eg 1234567890

11  A/R EFT File Extension  The file extension required by the bank (e.g. .EFT) 12  A/R EFT File Type  CAN_BOMONTREAL for Canadian Bank of Montreal 13  Originator ID Number  Customer number supplied by Bank of Montreal eg

(84)

EFT Vendors

(85)

EFT Customers

(86)

EFT Setup procedure for Canadian – Bank of Montreal EFT

Direct 80 Byte format

EFT Banks

1 Bank Code Enter the bank code (or use the finder to select it) EG CCB 2Bank Name Enter the bank name eg City Commercial Bank

7  A/P EFT File Extension  The file extension required by the bank (e.g. .BOM) 8  A/P EFT File Type  CAN_BOM80 for Canadian Bank of Montreal – 80 Byte format

9 _{Originator ID Number}_{Customer number supplied by Bank of Montreal eg}

1234567890

11  A/R EFT File Extension  The file extension required by the bank (e.g. .EFT) 12  A/R EFT File Type  CAN_BOM80 for Canadian Bank of Montreal – 80 Byte format

(87)

EFT Vendors

(88)

EFT Customers

(89)

EFT Setup procedure for Canadian – Bank of Montreal

Positive Pay

EFT Banks

1  Bank Code  Enter the bank code (or use the finder to select it) EG CCB 2  Bank Name  Enter the bank name eg City Commercial Bank

3  Bank Code  Enter the Bank Code (up to 11 digits)

4  Account Number  Your account number with your bank (up to 20 digits) 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. .txt) 8  A/P EFT File Type  CAN_BOMPP for Canadian Bank of Montreal Positive Pay Format

9  AP Payment Reference  Enter your payment reference from the bank

10_{Select the file numbering option either Batch number or File Sequence 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. .txt) 13  A/R EFT File Type  CAN_BOMPP for Canadian Bank of Montreal Positive Pay Format

(90)

EFT Vendors

• 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.

4  Bank Name  The Vendor Bank name (e.g. Standard Chartered Bank) 5  Bank Code  Enter the Vendor’s Bank Code

6  Account Number  The Vendor Account number 7  The Vendor Bank Account Name (e.g. Chloride Systems)

8  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

(91)

EFT Setup procedure for Canadian – Alberta Treasury Bank

EFT Banks

1 Bank Code Enter the bank code (or use the finder to select it) EG CCB 2Bank Name Enter the bank name eg City Commercial Bank

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

8  A/P EFT File Type  CAN_ATB for Canadian Alberta Treasury Bank

9  Originator ID Number  Customer number supplied by Alberta Treasury Bank eg 1234567890

11  A/R EFT File Extension  The file extension required by the bank (e.g. . ABT) 12  A/R EFT File Type  _ATB for Canadian Alberta Treasury Bank

(92)

EFT Vendors

(93)

EFT Customers

(94)

EFT Setup procedure for Canadian – Alberta Treasury Bank

using File System Number

EFT Banks

1 Bank Code Enter the bank code (or use the finder to select it) EG CCB 2Bank Name Enter the bank name eg Standard Bank

3 Institution ID  9 digit number (e.g. 021901119) A 9-digit account number that will always contain 02190---9 where the 3 dashes are your company’s branch transit number. Institution ID for Returns

4  Account Number  A 9 digit account number. Though CPA format allows for up to 12 digits. This is your company settlement account number including 2 digit sub number 24. (e.g. 123456724)

5  Account Name eg Sample Company Inc

6  Client ID  The sixth, seventh, eighth and ninth digits of the 10 digit Customer Number assigned to you by ATB Document Processing Centre. EG for Customer Number 2199012340, the Client ID would be 1234.

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. .atb) 9  A/P EFT File Type  CAN_ATBFS for Canadian Alberta Treasury Bank using File system Number

10  Originator ID Number  Customer number supplied by Alberta Treasury Bank eg 2199012340