1. Cibc Eft 80 Byte File Layout Free
2. Cibc Eft 80 Byte File Layout Pdf
3. Eft 80 Byte File Layout
4. Cibc Eft 80 Byte File Layout
5. Cibc Eft 80 Byte File Layout Download

• Laureen Hicks
• 3 years ago
• Views:

Transcription

1 Setup procedures for EFT Processing North American Banks V5.4 to V2014 Last updated V /03/2010

I am trying to setup EFT file format for TD Bank in Canada, but on GP 2013 R2 doesn't have this file type on the EFT File Format Maintenance. Did any of you used GP EFT format for TD Bank if so please share your experience. The file format is called EFT 80 Byte File by TD Commercial Banking. 80 BYTE FIXED LENGTH REMITTANCE RECORDS Implementation Guide New Customer Version. Multiple records per electronic file. 250 Proprietary fixed length format, which contains a Header Record, Detail Record and Summary Record. FedEx Electronic Invoice and Remittance.

2 EFT Options... 9 A/P Options... 9 A/R Options Options Canadian CIBC Bank Canadian CIBC Bank Positive Pay Format Canadian CIBC for Direct Payments Canadian TD Bank Canadian TD Bank US$ Format Canadian RBC Bank Canadian RBC Bank AP Link Canadian RBC A/P Link Incl ACH Canadian EFT (80 byte Record) Canadian Scotiabank Canadian Scotia Direct 105 Byte Canadian Scotiabank Web Import Canadian Bank of Montreal Canadian Bank of Montreal EFT Direct 80 Byte file Canadian Bank of Montreal Positive Pay Canadian Alberta Treasury Bank Canadian Alberta Treasury Bank using File System Number Canada HSBC Bank Canada Canada HSBC Bank Canada Bacs Standard Canada Caisse Populaire Desjardins Canada Canada s TD Bank Positive Pay Canada Canadian Beanstream ACH Canada Canadian Beanstream Credit Card format Canada RBC Express (flat txt file) Canada Canadian Beanstream EFT Canada Canadian RBC for Payee Match Canada Canadian RBC Cross Border payments Canada Royal Bank of Canada (STD152) Debit/Credit File Canadian - Bank of Nova Scotia - PIAP Canada Royal Bank of Canada ACH Debit/Credit with IAT Rules Australian HSBC USA Mellon Global Cash Management Canadian Bank Reconciliation (RTF) Canadian CPA Standard 005 AFT File Specification Canadian - CIBC CPA Standard 005/EFT Canadian Royal Bank of Canada - Jamaica National Bank of Canada Estonia Hansabank Domestic Layout Estonia Hansabank Foreigh Layout USA Solano Bank USA Citibank USA Citibank Funds Transfer USA Citibank ACH - PreFormat USA Harris Bank ACH Prepared by : Orchid Systems Page 2 of 238

3 USA NACHA Standard USA NACHA Standard - Self Balancing USA Nacha Standard, User Defined Transaction Type USA NACHA CTX Standard USA ACH Direct EFT format for the Payment Gateway USA International ACH Transactions (IAT) File Format USA Nordea Bank - NACHA Standard USA Frost Bank - NACHA Standard USA Pinnacle National Bank USA Sovereign Bank USA JP Morgan Chase USA Wilmington Trust Co USA - Commerce Bank ACH USA - CommerceBank Wire Transfer USA Bank of America - NACHA USA First American Bank ACH Emirates National Bank Dubai Setup your bank, customers and vendors EFT Setup procedure for Canadian CIBC EFT Banks EFT Vendors EFT Setup procedure for Canadian CIBC Positive Pay EFT Banks EFT Vendors EFT Setup procedure for Canadian CIBC Direct Payments EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian TD Bank EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian TD Bank US$ Format EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian RBC EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian RBC AP Link EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian RBC AP Link Incl ACH EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian EFT (80 Byte Record) EFT Banks Prepared by : Orchid Systems Page 3 of 238

4 EFT Vendors EFT Customers EFT Setup procedure for Canadian Scotiabank EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian Scotia Direct 105 Byte EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian Scotiabank Web Format EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian Bank of Montreal EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian Bank of Montreal EFT Direct 80 Byte format EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian Bank of Montreal Positive Pay EFT Banks EFT Vendors EFT Setup procedure for Canadian Alberta Treasury Bank EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian Alberta Treasury Bank using File System Number EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian HSBC Bank Canada EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian HSBC Bank Canada BACS Standard EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian Caisse Populaire Desjardins EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian - Canada TD Bank Positive Pay (only supports AP) EFT Banks Prepared by : Orchid Systems Page 4 of 238

5 EFT Vendors EFT Setup procedure for Canadian - Royal Bank of Canada ACH Debit/Credit with IAT Rules EFT Banks EFT Vendors EFT Setup procedure for Canadian - Canadian Bank of Nova Scotia - PIAPEFT Banks EFT Vendors EFT Setup procedure for HSBC EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian Beanstream ACH EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian Beanstream Credit Card format EFT Banks EFT Customers EFT Setup procedure for Canadian Beanstream EFT EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian RBC Express (flat txt file) EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian RBC for Payee Match (AP only) EFT Banks EFT Vendors EFT Setup procedure for Canadian RBC for Cross Border payments EFT Banks EFT Setup procedure for Royal Bank of Canada (STD152) Debit/Credit EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA Mellon Global Cash Management EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian Bank Reconciliation (RTF) EFT Banks EFT Vendors EFT Setup procedure for Canadian CPA Standard 005 AFT File specification (CAN_CPA) EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian CPA Standard 005 File specification (CAN_CPA005) Prepared by : Orchid Systems Page 5 of 238

6 EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian - CIBC CPA Standard 005/EFT EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Royal Bank of Canada - Jamaica EFT Banks EFT Setup procedure for HSBC BACS (Canada) EFT Banks EFT Vendors EFT Customers EFT Setup procedure for National Bank of Canada EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Estonian Hansabank Domestic Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Estonian Hansabank Foreign Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA Solano Bank Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA CITIBANK Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA CITIBANKFT funds transfer Layout EFT Banks EFT Vendors EFT Vendor Remittance Address EFT Customers EFT Setup procedure for USA CITIBANKPF- ACH PreFormat Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA Harris Bank ACH EFT Banks EFT Vendors EFT Customers To Create an EFT file for the bank EFT Setup procedure for USA NACHA Standard Layout EFT Banks EFT Vendors Prepared by : Orchid Systems Page 6 of 238

7 EFT Customers EFT Setup procedure for USA NACHA CTX Standard Layout EFT Banks EFT Vendors EFT Customers USA ACH Direct EFT format for the Payment Gateway EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA - International ACH Transactions (IAT) File Format EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA Nordea - NACHA Standard Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA - NACHA Standard Self Balancing EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA - NACHA Standard, User Defined Transaction Type EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA FROST - NACHA Standard Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA Pinnacle National Bank - NACHA Standard Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA Sovereign Bank - NACHA Standard Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA JP Morgan Chase Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA Wilmington Trust Co - NACHA Standard Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA CommerceBank ACH Prepared by : Orchid Systems Page 7 of 238

8 EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA CommerceBank Wire Transfer EFT Banks EFT Vendors EFT Setup procedure for USA Bank of America - NACHA EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA First American Bank ACH EFT Banks EFT Vendors Creating the EFT File EFT Setup procedure for Emirates National Bank Dubai EFT Banks EFT Vendors Creating a Receipt Batch in EFT Processing V Prepared by : Orchid Systems Page 8 of 238

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 Select if the users are allowed to select individual payment from a batch Prepared by : Orchid Systems Page 9 of 238

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 Select if the users are allowed to select individual payment from a batch Prepared by : Orchid Systems Page 10 of 238

11 This tab lets you: Define your Server. If you leave this field blank, then the Sage Accpac ERP default way of sending s using your Microsoft Outlook client will be used. If you define the server, then SMTP will be used to send s and the following parameters will be required: Server The User The Password The Comes from Notes : Check your 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 servers will allow you to log on as a certain user and send as anyone, others will only allow you to send as the logged on user. So if you log on as 'Joe', but try to send as some servers won't allow it. In your 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 . You can use the 'Send Test ...' to check your settings. You will be prompted to enter an address to send the test to. Prepared by : Orchid Systems Page 11 of 238

12 Options Select the bank or primary bank. Selecting a bank enables the EFT Screen labels to be tailored to the bank Prepared by : Orchid Systems Page 12 of 238

13 Canadian CIBC Bank Select CAN_CIBC as the primary bank : Prepared by : Orchid Systems Page 13 of 238

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 Select CAN_TD as the primary bank : Canadian TD Bank US$ Format Prepared by : Orchid Systems Page 14 of 238

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 Select CAN_RBCAPL or CAN_RBCAPL1 as the primary bank : Prepared by : Orchid Systems Page 15 of 238

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 ( , print), then select CAN_RBCAPL as the primary bank. If you want to control the type of remittance advice (none, , 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 Prepared by : Orchid Systems Page 16 of 238

17 Canadian RBC A/P Link Incl ACH Select CAN_RBCAPLACH as the primary bank : Canadian EFT (80 byte Record) Select CAN_EFT as the primary bank : Canadian Scotiabank Select CAN_SCOTIA as the primary bank : Canadian Scotia Direct 105 Byte Select CAN_SCOTIASD105 as the primary bank : Prepared by : Orchid Systems Page 17 of 238

18 Prepared by : Orchid Systems Page 18 of 238

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 Select CAN_BOM80 as the primary bank Prepared by : Orchid Systems Page 19 of 238

20 Canadian Bank of Montreal Positive Pay Select CAN_BOMPP as the primary bank Prepared by : Orchid Systems Page 20 of 238

21 Canadian Alberta Treasury Bank Select CAN_ATB as the primary bank Prepared by : Orchid Systems Page 21 of 238

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 Canada Caisse Populaire Desjardins Select CAN_HSBC as the primary bank Prepared by : Orchid Systems Page 22 of 238

23 Prepared by : Orchid Systems Page 23 of 238

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 Select CAN_BEANSTREAMCC as the primary bank Prepared by : Orchid Systems Page 24 of 238

25 Canada RBC Express (flat txt file) Select CAN_RBCEXPRESS as the primary bank Prepared by : Orchid Systems Page 25 of 238

26 Canada Canadian Beanstream EFT Select CAN_BEANSTREAMEFT as the primary bank Prepared by : Orchid Systems Page 26 of 238

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 Select CAN_RBC2XCLIENTCODE as the primary bank Prepared by : Orchid Systems Page 27 of 238

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 : USA Mellon Global Cash Management Select USA_MELLONGCM as the primary bank : Prepared by : Orchid Systems Page 28 of 238

29 Prepared by : Orchid Systems Page 29 of 238

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: Prepared by : Orchid Systems Page 30 of 238

31 Canadian - CIBC CPA Standard 005/EFT1464 Select CAN_CPA005CIBC as the primary bank : Canadian Royal Bank of Canada - Jamaica Select RBC_JAMAICA as the primary bank : Prepared by : Orchid Systems Page 31 of 238

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 Select EST_HANSADOMESTIC as the primary bank : Estonia Hansabank Foreigh Layout Prepared by : Orchid Systems Page 32 of 238

33 Select EST_HANSAFOREIGN as the primary bank : USA Solano Bank Select USA_SOLANO as the primary bank USA Citibank Select CITIBANK as the primary bank Prepared by : Orchid Systems Page 33 of 238

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 Select USA_HARRISBANK as the primary bank USA NACHA Standard Select NACHA as the primary bank Prepared by : Orchid Systems Page 34 of 238

35 Prepared by : Orchid Systems Page 35 of 238

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 USA ACH Direct EFT format for the Payment Gateway Select USA_ACHEFT as the primary bank Prepared by : Orchid Systems Page 36 of 238

37 Prepared by : Orchid Systems Page 37 of 238

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 Select USA_FROST as the primary bank Prepared by : Orchid Systems Page 38 of 238

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 Select USA_JPMC as the primary bank Prepared by : Orchid Systems Page 39 of 238

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 Select COMMERCE_WIRE as the primary bank Prepared by : Orchid Systems Page 40 of 238

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 Select EMR_NAT_DUBAI as the primary bank Prepared by : Orchid Systems Page 41 of 238

42 Setup your bank, customers and vendors Prepared by : Orchid Systems Page 42 of 238

43 EFT Setup procedure for Canadian CIBC EFT Banks 1 Bank Name CIBC 2 Financial Institution ID 9 digit number (e.g ) 3 Account Number Your account number with your bank (e.g ) 4 Payment Code (transaction code) for AP Payments eg Account Name eg Sample Company LTD 6 Receipt Code (transaction code) for AR Payments eg 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 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 14 A/R Payment Reference Organisation id eg Select the file numbering option either Batch number or File Sequence Number Prepared by : Orchid Systems Page 43 of 238

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 ) 4 Account Number The Vendor Account number (e.g ) 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 Prepared by : Orchid Systems Page 44 of 238

45 EFT Setup procedure for Canadian CIBC Positive Pay EFT Banks 1 Bank Name CIBC 2 Bank Transit Number 5 digit number (e.g ) 3 Account Number Your account number with your bank (e.g ) 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 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 10 Select the file numbering option - must be File Sequence Number Prepared by : Orchid Systems Page 45 of 238

46 EFT Vendors 1 Vendor ID Enter or select the vendor id (e.g. 1200) 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) 3 Financial Institution ID The Vendor Financial institution id (e.g ) 4 Account Number The Vendor Account number (e.g ) 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 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. Prepared by : Orchid Systems Page 46 of 238

47 Prepared by : Orchid Systems Page 47 of 238

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 ) 4 Account Name e.g. Sample Company 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..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 Payments 14 Receipt Code (Typically 77 for supplier) Prepared by : Orchid Systems Page 48 of 238

49 EFT Vendors 1 Vendor ID Enter or select the vendor id (e.g. 1200) 2 Bank Name The Vendor Bank (e.g. Royal Bank of Canada) 3 Bank and Branch Code 4 Account Number The Vendor Account number 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 Prepared by : Orchid Systems Page 49 of 238

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 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 Prepared by : Orchid Systems Page 50 of 238

51 EFT Setup procedure for Canadian TD Bank EFT Banks 1 Bank Name TD Bank 2 Financial Institution ID 9 digit number (e.g ) 3 Account Number Your account number with your bank (e.g ) 4 Account Name eg Sample Company LTD 5 A/P EFT File batch Enter or browse to find the file path for AP files 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 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 12 Originator ID Number Organisation id eg Select the file numbering option either Batch number or File Sequence Number Prepared by : Orchid Systems Page 51 of 238

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) 3 Financial Institution ID The Vendor Financial institution id (e.g ) 4 Account Number The Vendor Account number (e.g ) 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 Prepared by : Orchid Systems Page 52 of 238

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 ) 4 Account Number The Customer Account number (e.g ) 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 Prepared by : Orchid Systems Page 53 of 238

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.g ) 3 Account Number Your account number with your bank (e.g ) 4 Account Name eg Sample Company Inc 5 A/P EFT File batch Enter or browse to find the file path for AP files 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 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_TDUSA for Canadian TD Bank US$ Format 12 Originator ID Number Organisation id eg Select the file numbering option either Batch number or File Sequence Number Prepared by : Orchid Systems Page 54 of 238

55 EFT Vendors 1 Vendor ID Enter or select the vendor id (e.g. 1200) 2 Bank Name The Vendor Bank (e.g. Barclays Bank) 3 Financial Institution ID The Vendor Financial institution id (e.g ) 4 Account Number The Vendor Account number (e.g ) 5 Account Name The Vendor Bank Account Name (e.g. Chloride Systems Account) 6 Account Type (S/C) This payment reference must be entered as S for savings account and C for current account 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Prepared by : Orchid Systems Page 55 of 238

56 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 ) 4 Account Number The Customer Account number (e.g ) 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 Prepared by : Orchid Systems Page 56 of 238

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 ) 4 Account Number Your account number with the bank (e.g ) 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 ) 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. RBC) 9 A/P EFT File Type CAN_RBC for Canadian RBC Note: If you want $$AA exported in the header row of the EFT file select CAN_RBC, otherwise use CAN_RBC1 Prepared by : Orchid Systems Page 57 of 238

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 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. 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) 3 Financial Institution ID The Customer Financial institution id (e.g ) 4 Account Number The Customer Account number (e.g ) 5 Account Name The Customer Bank Account Name (eg. Chloride Systems Account) 6 Country Enter CAN or USA for Canada or USA 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Prepared by : Orchid Systems Page 58 of 238

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) 3 Financial Institution ID The Customer Financial institution id (e.g ) 4 Account Number The Customer Account number (e.g ) 5 Account Name The Customer Bank Account Name (eg. Ronald Black Current Account) 6 Country Enter CAN or USA for Canada or USA 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Prepared by : Orchid Systems Page 59 of 238

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 ) 4 Account Number Your account number with the bank (e.g ) 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. 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 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. RBC) 12 A/R EFT File Type CAN_RBCAPL or CAN_RBCAPL1 for Canadian RBC AP Link. See Note 1 Below 13 A/R Payment Reference not used 14 Select the file numbering option either Batch number or File Sequence Number Prepared by : Orchid Systems Page 60 of 238

61 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 Remit Financial EDI pay/ 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 Remit ACH Direct Deposit pay/ 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 ACH Personally Approved Debits/ 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 Wires with 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 Only 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 ( remittance), then select CAN_RBCAPL as A/P EFT File Type. Prepared by : Orchid Systems Page 61 of 238

62 If you want to use the delivery method on the customer to dictate types I (no remittance), J (fax remittance), K ( 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. Prepared by : Orchid Systems Page 62 of 238

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 (e.g ) 4 Account Number The Customer Account number (e.g ) 5 Account Name The Customer Bank Account Name (eg. Gould Manufacturing Ltd.) Prepared by : Orchid Systems Page 63 of 238

64 6 Pay Type (E/F/G) Enter the payment type required : A..H, L..W 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group 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 ) 4 Account Number The Customer Account number (e.g ) 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 Using a primary bank of CAN_RBCAPL1 Prepared by : Orchid Systems Page 64 of 238

65 1 Customer ID Enter or select the Customer id (e.g. 1600) 2 Bank Name The Customer Bank (e.g. Westpac) 3 Financial Institution ID The Customer Financial institution id (e.g ) 4 Account Number The Customer Account number (e.g ) 5 Account Name The Customer Bank Account Name (eg. Ronald Black Current Account) 6 Pay Type (I/J/K) Enter the payment type required : I, J or K 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Using a primary bank of CAN_RBCAPL Prepared by : Orchid Systems Page 65 of 238

66 1 Customer ID Enter or select the Customer id (e.g. 1600) 2 Bank Name The Customer Bank (e.g. Westpac) 3 Financial Institution ID The Customer Financial institution id (e.g ) 4 Account Number The Customer Account number (e.g ) 5 Account Name The Customer Bank Account Name (eg. Ronald Black Current Account) 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 number 4 Account Number Your account number with the bank 5 Account Name e.g. Sample Company Inc Prepared by : Orchid Systems Page 66 of 238

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 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. 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 A/P Remit To Location. Prepared by : Orchid Systems Page 67 of 238

Cibc Eft 80 Byte File Layout Free

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 9 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group 10 Select ACH PDS status Prepared by : Orchid Systems Page 68 of 238

69 EFT Customers In EFT55 SP4 the following options have been added: 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 8 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group 9 ACH-PAD (DCD/PDD) Prepared by : Orchid Systems Page 69 of 238

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 3 Financial Institution ID 9 digit number (e.g ) 4 Account Number Your account number with your bank (e.g ) 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..eft) 8 A/P EFT File Type CAN_EFT for Canadian EFT 9 Originator ID Number Organisation id eg 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 13 Originator ID Number Organisation id eg Select the file numbering option either Batch number or File Sequence Number Prepared by : Orchid Systems Page 70 of 238

71 EFT Vendors 1 Vendor ID Enter or select the vendor id (e.g. 1200) 2 Bank Name The Vendor Bank (e.g. Barclays Bank) 3 Financial Institution ID The Vendor Financial institution id (e.g ) 4 Account Number The Vendor Account number (e.g ) 5 Account Name The Vendor Bank Account Name (e.g. Chloride Systems Account) 6 Payment Reference can be used for notes. Not used in the EFT file 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Prepared by : Orchid Systems Page 71 of 238

72 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 ) 4 Account Number The Customer Account number (e.g ) 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 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Prepared by : Orchid Systems Page 72 of 238

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 3 Financial Institution ID 9 digit number (e.g ) 4 Account Number Your account number with your bank (e.g ) 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..sco) 8 A/P EFT File Type CAN_SCOTIA for Canadian Scotiabank 9 Customer Number Customer number supplied by Scotiabank eg 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 13 Customer Number Customer number supplied by Scotiabank eg Select the file numbering option either Batch number or File Sequence Number Prepared by : Orchid Systems Page 73 of 238

74 EFT Vendors 1 Vendor ID Enter or select the vendor id (e.g. 1200) 2 Bank Name The Vendor Bank (e.g. Barclays Bank) 3 Financial Institution ID The Vendor Financial institution id (e.g ) 4 Account Number The Vendor Account number (e.g ) 5 Account Name The Vendor Bank Account Name (e.g. Chloride Systems Account) 6 Payment Reference can be used for notes. Not used in the EFT file 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Prepared by : Orchid Systems Page 74 of 238

75 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 ) 4 Account Number The Customer Account number (e.g ) 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 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Prepared by : Orchid Systems Page 75 of 238

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 ) 5 Account Name e.g. Sample Company Inc 6 Scotiabank Data Centre Enter one of the following codes: Prepared by : Orchid Systems Page 76 of 238

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 17 Select the file numbering option either Batch number or File Sequence Number Prepared by : Orchid Systems Page 77 of 238

78 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 (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 9 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Prepared by : Orchid Systems Page 78 of 238

79 EFT Customers In EFT55 SP4 the following options have been added: 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 8 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Prepared by : Orchid Systems Page 79 of 238

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 ) 4 Account Number Your account number with your bank (e.g ) 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..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 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 13 Payment Group Enter the payment group used for AP transactions in the ScotiaBank Web client eg PaymentGroupDEF 14 Select the file numbering option either Batch number or File Sequence Number Prepared by : Orchid Systems Page 80 of 238

81 EFT Vendors 1 Vendor ID Enter or select the vendor id (e.g. 1200) 2 Bank Name The Vendor Bank (e.g. Barclays Bank) 3 Institution ID/Transit The Vendor Financial institution id (e.g ) 4 Account Number The Vendor Account number (e.g ) 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. 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Prepared by : Orchid Systems Page 81 of 238

Setup procedures for EFT Processing

Setup procedures for EFT Processing South African Banks V5.4 to V2014 Last updated V1.74 07/09/2012 EFT Options... 4 A/P Options... 4 A/R Options... 4 E-mail... 5 Options... 6 South African First National

More information

Accounting. EFT Direct User Guide

Accounting EFT Direct User Guide Sage 50 EFT Direct User Guide Before You Start 1 Hardware and Software Requirements 1 Make Arrangements with Your Bank 1 Getting Help 2 The Manuals 2 Online Help 2 Installing

More information

Or What makes Canadian Banking different?

CANADIAN BANKING Sharing a Border Or What makes Canadian Banking different? Ray Kohler Senior Relationship Manager, US Markets RBC Royal Bank 1 Agenda Understand the basic differences between Canadian

More information

EFT 2012 GETTinG STarTEd GuidE

EFT Getting Started Guide 2012 EFT Direct for Sage Simply Accounting User Guide Before You Start...1 Hardware and Software Requirements...1 Make Arrangements with Your Bank...2 Getting Help...2 The Manuals...2

More information

User Guide Electronic Funds Transfer (EF T) Service

User Guide Electronic Funds Transfer (EF T) Service Contents What You Need to Know About ATB s EFT Service 4 Funding EFT Files 4 1.Liquidity Limit 4 2.Exchange Funding 5 Limits 5 1.File Limits 6 2.Limits

More information

Generate Electronic Payments in Accounts Payable

Generate Electronic Payments in Accounts Payable IMPORTANT NOTICE This document and the Sage 300 Construction and Real Estate software may be used only in accordance with the Sage 300 Construction and

More information

Direct Deposit of Payroll Cash Concentration and Disbursement Consumer Debits and Credits. About ACH

Automated Clearing House (ACH) Payments Use ACH to make a wide variety of payment types. Each data entry screen is specifically designed for a different kind of payment. Payment types, also called applications,

More information

Guide to Federal Financial EDI Payments

Guide to Federal Financial EDI Payments Published by Financial Management Service Department of the Treasury 1997 For additional copies of the Guide to Federal Financial EDI Payments, contact: Product

More information

IAT Scenarios Simplified

IAT Scenarios Simplified Several abbreviated scenarios are provided below to better understand when a specific payment transaction involving the U.S. ACH Network would be deemed an International ACH Transaction

More information

Section VIII: ACH Payment Processing

Section VIII: ACH Payment Processing Contents About ACH Payments... 2 About the Automated Clearing House... 2 ACH Terms and Features... 2 Workflow Example: ACH Payroll Application... 4 To Add a Database...

More information

International ACH Transactions (IAT) Frequently Asked Questions Corporate Customers. Contents

International ACH Transactions (IAT) Frequently Asked Questions Corporate Customers IAT changes were made for regulatory compliance The first step is to understand and recognize OFAC requirements - corporates

More information

NACHA FORMAT. Record Title Record Type Code File Header Record - This record includes your company name and

NACHA FORMAT ACH Input File Structure The NACHA format is composed of 94 character records. All records and fields are required, except the record 7 - Entry Detail that is optional. Title File Header -

More information

EFT Overview Guide for Canada

EFT Overview Guide for Canada 051812 2012 Blackbaud, Inc. This publication, or any part thereof, may not be reproduced or transmitted in any form or by any means, electronic, or mechanical, including photocopying,

More information

OVERVIEW AND TERMINOLOGY

ACH Online Services OVERVIEW AND TERMINOLOGY There are ACH terms and definitions that are helpful to understand in order to use the ACH Online Service. In addition, there are basic tasks (accessing ACH

More information

Microsoft Dynamics GP. Cashbook Bank Management

Microsoft Dynamics GP Cashbook Bank Management Copyright Copyright 2010 Microsoft. All rights reserved. Limitation of liability This document is provided as-is. Information and views expressed in this

More information

Cathay Business Online Banking. User Guide. Version 1.0

Cathay Business Online Banking User Guide Version 1.0 07/2013 Disclaimer: The information and materials in these pages, including text, graphics, links, or other items are provided as is and available.

More information

CHAPTER 7: CASH AND BANK MANAGEMENT SETUP

Chapter 7: Cash and Bank Management Setup CHAPTER 7: CASH AND BANK MANAGEMENT SETUP Objectives Introduction The objectives are: Set up cash bank transaction types. Set up bank transaction groups. Set up

More information

Online Banking Notes for Reckon Accounts 2013

Online Banking Notes for Reckon Accounts 2013 Importing Transactions Online Banking is a feature fully available in Reckon Accounts 2013. Online Banking allows the user to import their bank statements

More information

Brian Pelletier presents: AP SETTINGS REVIEW

Brian Pelletier presents: AP SETTINGS REVIEW ADMINISTERING USERS Why this? New options continually available Newer staff may not be aware of options Goals Review Settings program and available options

More information

Table of Contents. 2 Copyright 2009 Bank of American Fork. All Rights Reserved.

Table of Contents Logging In... 3 Changing Your Password... 4 Cash User Login Screen... 5 Navigation... 6 Account Access Page... 7 Account Activity Options... 8 Transactions... 9 Download... 10 Statements...

More information

SYSTEM LOGIN/PASSWORD SUPPORT

SYSTEM LOGIN/PASSWORD SUPPORT Why am I unable to log into the system? What if I forgot my password? Why do I need to create Security Questions/Answers? Why does it ask me if I want to remember this computer?

More information

Environmental Scan - International Interoperability Standards -

Environmental Scan - International Interoperability Standards - Environmental Scan - International Interoperability Standards - February 2009 TABLE OF CONTENTS EXECUTIVE SUMMARY 1 I INTRODUCTION 2 1. PURPOSE

More information

Electronic Funds Transfer (EFT) Payment Guide

Government of the District of Columbia Office of the Chief Financial Officer Office of Tax and Revenue 2015 Electronic Funds Transfer (EFT) Payment Guide Bank Information for Payments TXP and Addenda Record

More information

Microsoft Dynamics GP. Cashbook Bank Management

Microsoft Dynamics GP Cashbook Bank Management Copyright Copyright 2007 Microsoft Corporation. All rights reserved. Complying with all applicable copyright laws is the responsibility of the user. Without

More information

4. Do not make changes to the Master record. To create a custom form, click Copy.

Custom Invoice Import Custom imports allow for the creation of Munis invoices through a fixed or delimited file import. Customization of the import form can be edited to fit an existing export or report

More information

Electronic Funds Transfer (EFT) Payment Guide

Government of the District of Columbia Office of the Chief Financial Officer Office of Tax and Revenue 2015 Electronic Funds Transfer (EFT) Payment Guide Bank Information for Payments TXP and TPP Addenda

More information

Cash Management User Guide

Cash Management User Guide Version 9.0 February 2006 Document Number CBUG-90UW-01 Lawson Enterprise Financial Management Legal Notices Lawson does not warrant the content of this document or the results

More information

Sage 300 ERP 2014. Bank Services User's Guide

Sage 300 ERP 2014 Bank Services User's Guide This is a publication of Sage Software, Inc. Copyright 2014. Sage Software, Inc. All rights reserved. Sage, the Sage logos, and the Sage product and service

More information

Savings Accounts CHOOSING THE RIGHT SAVINGS ACCOUNT FOR YOUR NEEDS

Savings Accounts CHOOSING THE RIGHT SAVINGS ACCOUNT FOR YOUR NEEDS ISBN 978-0-662-48270-3 Catalogue No. FC5-10/2008E-PDF Table of Contents Introduction 2 What is a savings account? 2 What is the difference

More information

A ribbon has replaced the Desktop toolbar. You still have access to the same features, but the new interface makes them easier to find.

Sage 100 2016 What s New Global Enhancements New Product Key Required If you use the Payroll module, you must enter your new product key when installing Sage 100 2016. If you enter a product key obtained

More information

Sage 300 ERP 2012. Bank Services User's Guide

Sage 300 ERP 2012 Bank Services User's Guide This is a publication of Sage Software, Inc. Copyright 2014. Sage Software, Inc. All rights reserved. Sage, the Sage logos, and the Sage product and service

More information

PARITY SOFTWARE S SAGE ERP X3 CASHBOOK USER MANUAL

PARITY SOFTWARE S SAGE ERP X3 CASHBOOK USER MANUAL Introduction Parity s Cashbook allows for the efficient reconciliation of Bank Statements to Bank Entry transactions within Sage ERP X3. Parity s Cashbook

More information

CAFT is a user-friendly web-based application that allows you to apply one-time or recurring Automated Funds Transfer (AFT) transactions

CAFT is a user-friendly web-based application that allows you to apply one-time or recurring Automated Funds Transfer (AFT) transactions Whether you need to pay employees and suppliers or collect payments

More information

AFN-AccountsPayableEFTGuide-120506

120506 2006 Blackbaud, Inc. This publication, or any part thereof, may not be reproduced or transmitted in any form or by any means, electronic, or mechanical, including photocopying, recording, storage

More information

Business Online Banking

Business Online Banking User Guide Rev. 01/11 Table of Contents Logging In... 1 Viewing the Online Banking Agreement... 3 Changing Your Company Password... 4 Cash User Login Screen... 5 Changing Your Cash

More information

9.1 Banking Services Policy

9.1 Banking Services Policy Policy Statement This Banking Services Policy (the policy ) has been developed to facilitate centralized control of all bank accounts, banking services, and negotiations of

More information

Payments & Transfers ACH

Payments & Transfers ACH Online Banking Payments & Transfers ACH Online Banking / 2 Module Outline Introduction... 1 Slide 1: Module Overview... 3 Payments & Transfers - ACH... 4 Slide 2: ACH General Information...

More information

Cathay Business Online Banking

Cathay Business Online Banking A QUICK GUIDE TO CATHAY BUSINESS ONLINE BANKING R6119 CATHAY 8_5x11 Cover V2.indd 1 6/11/13 5:50 PM Welcome Welcome to Cathay Business Online Banking (formerly known as Cathay

More information

User Manual. Online Treasury Manager: ACH Initiation

User Manual Online Treasury Manager: ACH Initiation Table of Contents OVERVIEW...1 System Access... 1 Login/Logout Procedures... 2 Online Treasury Manager Modules... 2 Accessing Images... 3 System Availability

More information

CANADIAN PAYMENTS ASSOCIATION ASSOCIATION CANADIENNE DES PAIEMENTS

CANADIAN PAYMENTS ASSOCIATION ASSOCIATION CANADIENNE DES PAIEMENTS Procedural Reference Document PRD-002 PROCEDURES FOR U.S. DOLLAR AND FOREIGN CURRENCY TRANSFERS WITHIN CANADA November 2009 CANADIAN PAYMENTS

More information

Tuition Payment Options 2016-2017

Tuition Payment Options 2016-2017 Payment Options Tuition payments can be made by one of the following methods: International Cheque payable to Appleby College Online Banking Western Union Business Solutions

More information

NEBRASKA FILE FORMAT FOR EMPLOYERS

NEBRASKA FILE FORMAT FOR EMPLOYERS Electronic Funds Transfer (EFT) / Electronic Data Interchange (EDI) Transactions 1. Your company transmits the payment and remittance information to your financial institution.

More information

Demystifying ACH Payments to Canada

Demystifying ACH Payments to Canada NACHA Payments 2008 May 18 21, 2008 Elizabeth McQuerry Assistant V.P., Retail Payments Office Federal Reserve Doug Kreviazuk V.P., Policy & Research Canadian Payments

More information

ACH Welcome Kit. Rev. 10/2014. Member FDIC Page 1 of 8

ACH Welcome Kit Rev. 10/2014 Member FDIC Page 1 of 8 Dear Customer, Thank you for utilizing FirstMerit s ACH services. We have finalized the setup of your ACH product and you may now begin processing ACH

More information

AP314: Payment Processing. Instructor Led Training

AP314: Payment Processing Instructor Led Training Lesson 1: Understanding Payment Processing Introduction Welcome Welcome to Cardinal Training! This training provides employees with the skills and information

More information

Sage Accpac ERP 5.6A. SageCRM 6.2 I Integration Update Notice

Sage Accpac ERP 5.6A SageCRM 6.2 I Integration Update Notice 2009 Sage Software, Inc. All rights reserved. Sage, the Sage logos, and all Sage Accpac product and service names mentioned herein are registered

More information

LOCAL TRAINING INITIATIVE

Training Standards System LOCAL TRAINING INITIATIVE BOOKS OF ACCOUNT AND RECORD KEEPING Best Practice Guidelines Page 1 of 13 The LTI must comply with public procurement guidelines when purchasing goods

More information

Preparing For Canadian Cheque Image Exchange NOTICES

ECCHOInsights: Preparing For Cheque Oct. 15, 2015 October 15, 2015 Preparing For Cheque William L. Saffici Saffici Payment Consulting LLC Phyllis Meyerson, AAP, CCM ECCHO NOTICES This presentation may

More information

MICR Check Printing. Quick Start Guide

MICR Check Printing Quick Start Guide Mekorma MICR Quick Start Guide Copyright 2013, Mekorma Enterprises. All Rights Reserved. Your right to copy this documentation is limited by copyright law and the

More information

User Guide ACH and Wire Transfer

ONLINE CASH MANAGEMENT User Guide ACH and Wire Transfer Put the power to manage your business accounts where it should be... in your hands. TABLE OF CONTENTS Log In Process... 1 Company Login... 1 Cash

More information

EFT Overview Guide for Australia and New Zealand

EFT Overview Guide for Australia and New Zealand 111109 2009 Blackbaud, Inc. This publication, or any part thereof, may not be reproduced or transmitted in any form or by any means, electronic, or mechanical,

More information

Integrating Payables and Receivables to Unlock Working Capital

Integrating Payables and Receivables to Unlock Working Capital Approved for 1 CTP / CCM recertification credit by the Association of Financial Professionals May 2009 Introductions David Kunz Treasury Management

More information

Chapter 7. Banner Introduction... 7-3. Menu Navigation Tables... 7-4. Automated Clearing House Forms... 7-5

Chapter 7 Automated Clearing House Banner Introduction......... 7-3 7 Automated Clearing House Standards. 7-3 National Automated Clearing House Association Standards. 7-3 Canadian Payment Association Standards..........

More information

Scotia Bill Payment Remittance Reporting Service

Payment Services Getting Started Scotia Bill Payment Remittance Reporting Service July 2010 Table of Contents 1 Registration & Login...........................................................3 a. Your

More information

State of Iowa Department of Human Services Employers Partnering In Child Support 501 Sycamore Street, Suite 500 Waterloo, IA 50703-4651

Introduction Electronic Funds Transfer (EFT) / Electronic Data Information (EDI) Transactions INFORMATION FOR EMPLOYERS Electronic Funds Transfer (EFT) / Electronic Data Information (EDI) allows employers

More information

The Commonwealth of Massachusetts Department of Revenue Child Support Enforcement Division

The Commonwealth of Massachusetts Department of Revenue Child Support Enforcement Division ELECTRONIC FUNDS TRANSFER (EFT) & ELECTRONIC DATA INTERCHANGE (EDI) INFORMATION FOR EMPLOYERS Thank you for your

More information

Electronic Banking Cash Manager User Guide

Electronic Banking Cash Manager User Guide Table of Contents Logging In... 1 Changing Your Password... 2 Cash User Login Screen... 3 Cash Management User Single Sign On... 4 Navigation... 5 Account Listing

More information

Cash Management. Solutions That Fit

TREASURY SERVICES Cash Management Solutions That Fit TABLE OF CONTENTS The Role of Cash Management Business Cash Cycle...3 Progressive Plan Phase I Information Management & Transaction Control...4 Zero

More information

Once form has been completed by one or more employees the information can be entered on the employees direct deposit screen.

Banyon Data Systems, Inc. DIRECT DEPOSIT MODULE BDS Direct Deposit or ACH (Automated Clearing House) allows your entity to transfer its employee s pay directly to their bank accounts. This module does

More information

Chapter A5: Creating client files and attaching bank accounts

Chapter A5: Creating client files and attaching bank accounts This chapter is aimed at BankLink Administrators It covers the set up of your BankLink Practice clients. A BankLink Practice user needs BankLink

More information

NEWSTAR Training Guide. Banking, Consolidations and Tax Systems

NEWSTAR Training Guide Banking, Consolidations and Tax Systems Document A11 / A12 / A19-0.1 November 2005 NEWSTAR Training Guide: Banking, Consolidations and Tax Systems 2005 Constellation HomeBuilder

More information

A/P Payment Selection Based on A/R Cash Receipts AP-1108

A/P Payment Selection Based on A/R Cash Receipts AP-1108 Overview This Extended Solution modifies the A/R Cash Receipt update process to write an Amount paid on a Sales Order Invoice to a corresponding

More information

CANADIAN PAYMENTS ASSOCIATION ASSOCIATION CANADIENNE DES PAIEMENTS RULE E3 RULES APPLICABLE TO ELECTRONIC DATA INTERCHANGE TRANSACTIONS

CANADIAN PAYMENTS ASSOCIATION ASSOCIATION CANADIENNE DES PAIEMENTS RULE E3 RULES APPLICABLE TO ELECTRONIC DATA INTERCHANGE TRANSACTIONS 2014 CANADIAN PAYMENTS ASSOCIATION 2014 ASSOCIATION CANADIENNE DES

More information

Bank Account 1 September 2015

Chapter 8 Training Notes Bank Account 1 September 2015 BANK ACCOUNTS Bank Accounts, or Bank Records, are typically setup in PrintBoss after the application is installed and provide options to work with

More information

Create Company. User Guide

Create Company User Guide Important Notice TaiRox does not warrant or represent that your use of this software product will be uninterrupted or error-free or that the software product can be run with any

More information

for Sage 100 ERP Bank Reconciliation Overview Document

for Sage 100 ERP Bank Reconciliation Document 2012 Sage Software, Inc. All rights reserved. Sage Software, Sage Software logos, and the Sage Software product and service names mentioned herein are registered

More information

BUSINESS ONLINE BANKING CASH MANAGEMENT USER GUIDE

BUSINESS ONLINE BANKING CASH MANAGEMENT USER GUIDE TABLE OF CONTENTS LogIn Process...1 Company Login... 1 Cash User Login... 3 Cash Management User Single Sign On... 4 Navigation...5 Account Listing Page...6

More information

A Guide to Accounts Payable Supplier Processes

A Guide to Accounts Payable Supplier Processes The Johnson & Johnson Family of Companies believe in the benefits associated with the efficiencies gained through methods of electronic or paperless invoicing.

More information

December 2004 2303 Camino Ramon, Suite 210 San Ramon, CA 94583-1389 Voice: 925.244.5930 Fax: 925.867.1580 Website: www.miscorp.com

December 2004 2303 Camino Ramon, Suite 210 San Ramon, CA 94583-1389 Voice: 925.244.5930 Fax: 925.867.1580 Website: www.miscorp.com Copyright 2004 All rights protected and reserved TABLE OF CONTENTS I.

More information

TRANS-TASMAN ANZ TRANSACTIVE AUSTRALIA AND NEW ZEALAND 01.2012. Simplifying and connecting your transaction banking across Australia and New Zealand

TRANS-TASMAN ANZ TRANSACTIVE User GUIDE AUSTRALIA AND NEW ZEALAND 01.2012 Simplifying and connecting your transaction banking across Australia and New Zealand contents Notes...4 Introduction to the ANZ

More information

Corporate egateway Supports a centralised payment and collection factory

Corporate Supports a centralised payment and collection factory Corporate is Nordea s file based mass payment service for customers demanding one point of entry for bulk payments and collections in the

More information

International ACH Transactions (IAT) File Format Guide

U.S Bank created this IAT file format guide to be used as a supplemental tool to the format listed in the NACHA rules. Organizations can use this to help make changes in their system to prepare for the

More information

Sage Accpac ERP 5.6A. Update Notice

Sage Accpac ERP 5.6A Update Notice 2009 Sage Software, Inc. All rights reserved. Sage, the Sage logos, and all Sage Accpac product and service names mentioned herein are registered trademarks or trademarks

More information

Sage HRMS 2014 Sage HRMS Payroll Getting Started Guide. October 2013

Sage HRMS 2014 Sage HRMS Payroll Getting Started Guide October 2013 This is a publication of Sage Software, Inc. Document version: October 18, 2013 Copyright 2013. Sage Software, Inc. All rights reserved.

More information

Straight2Bank Payments Initiation User Guide

Straight2Bank Payments Initiation User Guide Last Updated: June 2014 Table of Contents PURPOSE... 4 1. OVERVIEW OF PAYMENT SERVICES ON STRAIGHT2BANK... 5 2. MAKING PAYMENTS ON STRAIGHT2BANK... 7 3. USING

More information

DIRECT PAYMENTS (ACH TRANSFER MODULE)

DIRECT PAYMENTS (ACH TRANSFER MODULE) Direct payments is an add on module to utility billing that allows customers to pay their utility bill by a recur ACH payment. Please note that the term ACH (Automatic

More information

ELECTRONIC FUNDS TRANSFER (EFT): A payment made through Fed Wire or the ACH is referred to as an EFT.

FINANCE AND TREASURY POLICIES AND PROCEDURES E056 INCOMING ELECTRONIC FUND TRANSFERS PURPOSE To establish procedures to enable identification of incoming electronic fund transfers and expedite the related

More information

Click the Entries tab to enter transactions that originated at the bank.

Reconciling Bank Statements If this is the first time you have reconciled a bank statement for this company, you must prepare your bank accounts. See Chapter 4, Setting Up Bank Services, in the Tax and

More information

Oracle Payables Implementation Overview with screenshots Compilation of Oracle Payables Implementation notes by Ranu Srivastava ...

Compilation of Oracle Payables Implementation notes by Ranu Srivastava... Setting up Banks... Defining Internal Bank... Payables Options... Defining Payment Documents... Creating Suppliers... Overview

More information

A Business Signer who has the Manage Users feature assigned to them can create other users on the User Management page in DFCU OnLine.

MANAGING USERS A Business Signer who has the Manage Users feature assigned to them can create other users on the User Management page in DFCU OnLine. To add a user and configure rights: 1. In the Menu,

More information

BackOffice 7.3 Bet a Release Notes BackOffice 7.3 Release Notes Accounts Receivable New Features Open Issues

ebackoffice 7.3 Beta Release Release Notes Notes Accounts Receivable New Features 2 Credit Memo 2 AR Netting 2 Customer 3 Dunning Letters 3 Non-AR Cash Receipts 4 Settlement 4 Terms 5 Write-off Receivable

More information

Corporate Online. Import format for Payment Processing Service files

Corporate Online Import format for Payment Processing Service files Payment Processing Service file specification About Corporate Online Westpac Corporate Online is an internet-based electronic platform,

More information

Computer Helper Publishing, Inc. 800-533-5227 www.churchwindows.com

Training 2010 Financial to Accounting Transition Book 3: Transactions & Corrections Computer Helper Publishing, Inc. 800-533-5227 www.churchwindows.com Book 3 Transactions & Corrections Basic Transactions...

More information

EFT Participant Setup Form 1. Wachovia Bank / State of NC

EFT Participant Setup Form Wachovia Bank / State of NC INSTRUCTIONS 1. This Setup Form is to be completed by new participants in the EFT Master Services Agreement (Contract No. 14-05001) offered by the

More information

The Education Edge / The Financial Edge 7.85

Minimum System Requirements This document lists the minimum infrastructure required to run your Blackbaud. We recommend the purchase of topof-the-line equipment when possible and that organizations budget

More information

for Sage 100 ERP General Ledger Overview Document

for Sage 100 ERP General Ledger Document 2012 Sage Software, Inc. All rights reserved. Sage Software, Sage Software logos, and the Sage Software product and service names mentioned herein are registered

More information

Contact Treasury Management Support: 866-563-1010 (toll free) Monday through Friday, 7:30 am 5:30 pm (Pacific Time) TreasuryManagement@umpquabank.

Contact Treasury Management Support: 866-563-1010 (toll free) Monday through Friday, 7:30 am 5:30 pm (Pacific Time) TreasuryManagement@umpquabank.com Updated October 2013 - TreasuryPro 3.8 Contents Welcome...

More information

Renewing your Licence and Paying your Fees: Step-by-Step

Renewing your Licence and Paying your Fees: Step-by-Step 1. Click the Pay Fees link under the Payments section of the left-navigation menu. NOTE: To renew a licence, you must pay the licence renewal fee.

More information

December 2007. Additions to Release 6.3C...2

RELEASE 6.3C December 2007 6.3C Additions to Release 6.3C...2 Login... 2 Login Screen Security... 2 Company... 2 EIS Dashboard... 2 Building... 3 Tenant... 6 Supplier... 8 Banking... 9 Jobs... 10 System

More information

Online Payroll Remittance Manual for Employers

Online Payroll Remittance Manual for Employers Before you start using the online payroll website Fraud Filter and Bank Changes Depending on your bank s ACH fraud filtering mechanisms you may need to identify

More information

Electronic Funds Transfer (EFT) Guide

Electronic Funds Transfer (EFT) Guide 112614 2009 Blackbaud, Inc. This publication, or any part thereof, may not be reproduced or transmitted in any form or by any means, electronic, or mechanical, including

More information

Microsoft Dynamics GP. Analytical Accounting

Microsoft Dynamics GP Analytical Accounting Copyright Copyright 2011 Microsoft. All rights reserved. Limitation of liability This document is provided as-is. Information and views expressed in this document,

More information

Pre-Authorized Debit

Pre-Authorized Debit Pre-Authorized Debit is an agreement between two parties that allows one party to debit funds via the Canadian Electronic Funds Transfer Network directly from another party s bank

More information

Sage Payroll Services

SAGE ACCPAC Sage Accpac ERP Sage Payroll Services Integration Guide 2006 Sage Accpac International, Inc. All rights reserved. Sage Software, Sage Software logos, and all Sage Accpac product and service

More information

A/P Direct Deposit (EFT) (with Electronic Tax Payment) for Solomon IV (Release 2.x) Users Guide Reference

A/P Direct Deposit (EFT) (with Electronic Tax Payment) for Solomon IV (Release 2.x) Users Guide Reference Solomon IV Enhancement Product A/P Direct Deposit (EFT) (with Electronic Tax Payment) By Sandler

More information

Element Payment Services is a third party software system that processes credit card and automatic bank account (ACH) transactions through PestPac.

Element Payment Services is a third party software system that processes credit card and automatic bank account (ACH) transactions through PestPac. Element complies with all Federal regulations regarding

More information

Sage 300 ERP 2014. Tax Services User's Guide

Sage 300 ERP 2014 Tax Services User's Guide This is a publication of Sage Software, Inc. Copyright 2014. Sage Software, Inc. All rights reserved. Sage, the Sage logos, and the Sage product and service

More information

Features for France. Microsoft Corporation. Published: November 2006

Features for France Microsoft Corporation Published: November 2006 Microsoft Dynamics is a line of integrated, adaptable business management solutions that enables you and your people to make business

More information

M4 Systems. Email Remittance (ER) User Guide

M4 Systems Email Remittance (ER) User Guide M4 Systems Ltd Tel: 0845 5000 777 International: +44 (0)1443 863910 www.m4systems.com www.dynamicsplus.net Table of Contents Introduction ------------------------------------------------------------------------------------------------------------------

More information

Sage 300 ERP 2014. Sage CRM 7.2 Integration Upgrade Guide

Sage 300 ERP 2014 Sage CRM 7.2 Integration Upgrade Guide This is a publication of Sage Software, Inc. Version 2014 Copyright 2013. Sage Software, Inc. All rights reserved. Sage, the Sage logos, and the

More information

• Laureen Hicks
• 3 years ago
• Views:

Transcription

1 Setup procedures for EFT Processing North American Banks V5.4 to V2014 Last updated V /03/2010

2 EFT Options... 9 A/P Options... 9 A/R Options Options Canadian CIBC Bank Canadian CIBC Bank Positive Pay Format Canadian CIBC for Direct Payments Canadian TD Bank Canadian TD Bank US$ Format Canadian RBC Bank Canadian RBC Bank AP Link Canadian RBC A/P Link Incl ACH Canadian EFT (80 byte Record) Canadian Scotiabank Canadian Scotia Direct 105 Byte Canadian Scotiabank Web Import Canadian Bank of Montreal Canadian Bank of Montreal EFT Direct 80 Byte file Canadian Bank of Montreal Positive Pay Canadian Alberta Treasury Bank Canadian Alberta Treasury Bank using File System Number Canada HSBC Bank Canada Canada HSBC Bank Canada Bacs Standard Canada Caisse Populaire Desjardins Canada Canada s TD Bank Positive Pay Canada Canadian Beanstream ACH Canada Canadian Beanstream Credit Card format Canada RBC Express (flat txt file) Canada Canadian Beanstream EFT Canada Canadian RBC for Payee Match Canada Canadian RBC Cross Border payments Canada Royal Bank of Canada (STD152) Debit/Credit File Canadian - Bank of Nova Scotia - PIAP Canada Royal Bank of Canada ACH Debit/Credit with IAT Rules Australian HSBC USA Mellon Global Cash Management Canadian Bank Reconciliation (RTF) Canadian CPA Standard 005 AFT File Specification Canadian - CIBC CPA Standard 005/EFT Canadian Royal Bank of Canada - Jamaica National Bank of Canada Estonia Hansabank Domestic Layout Estonia Hansabank Foreigh Layout USA Solano Bank USA Citibank USA Citibank Funds Transfer USA Citibank ACH - PreFormat USA Harris Bank ACH Prepared by : Orchid Systems Page 2 of 238

3 USA NACHA Standard USA NACHA Standard - Self Balancing USA Nacha Standard, User Defined Transaction Type USA NACHA CTX Standard USA ACH Direct EFT format for the Payment Gateway USA International ACH Transactions (IAT) File Format USA Nordea Bank - NACHA Standard USA Frost Bank - NACHA Standard USA Pinnacle National Bank USA Sovereign Bank USA JP Morgan Chase USA Wilmington Trust Co USA - Commerce Bank ACH USA - CommerceBank Wire Transfer USA Bank of America - NACHA USA First American Bank ACH Emirates National Bank Dubai Setup your bank, customers and vendors EFT Setup procedure for Canadian CIBC EFT Banks EFT Vendors EFT Setup procedure for Canadian CIBC Positive Pay EFT Banks EFT Vendors EFT Setup procedure for Canadian CIBC Direct Payments EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian TD Bank EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian TD Bank US$ Format EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian RBC EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian RBC AP Link EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian RBC AP Link Incl ACH EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian EFT (80 Byte Record) EFT Banks Prepared by : Orchid Systems Page 3 of 238

4 EFT Vendors EFT Customers EFT Setup procedure for Canadian Scotiabank EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian Scotia Direct 105 Byte EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian Scotiabank Web Format EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian Bank of Montreal EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian Bank of Montreal EFT Direct 80 Byte format EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian Bank of Montreal Positive Pay EFT Banks EFT Vendors EFT Setup procedure for Canadian Alberta Treasury Bank EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian Alberta Treasury Bank using File System Number EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian HSBC Bank Canada EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian HSBC Bank Canada BACS Standard EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian Caisse Populaire Desjardins EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian - Canada TD Bank Positive Pay (only supports AP) EFT Banks Prepared by : Orchid Systems Page 4 of 238

5 EFT Vendors EFT Setup procedure for Canadian - Royal Bank of Canada ACH Debit/Credit with IAT Rules EFT Banks EFT Vendors EFT Setup procedure for Canadian - Canadian Bank of Nova Scotia - PIAPEFT Banks EFT Vendors EFT Setup procedure for HSBC EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian Beanstream ACH EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian Beanstream Credit Card format EFT Banks EFT Customers EFT Setup procedure for Canadian Beanstream EFT EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian RBC Express (flat txt file) EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian RBC for Payee Match (AP only) EFT Banks EFT Vendors EFT Setup procedure for Canadian RBC for Cross Border payments EFT Banks EFT Setup procedure for Royal Bank of Canada (STD152) Debit/Credit EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA Mellon Global Cash Management EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian Bank Reconciliation (RTF) EFT Banks EFT Vendors EFT Setup procedure for Canadian CPA Standard 005 AFT File specification (CAN_CPA) EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian CPA Standard 005 File specification (CAN_CPA005) Prepared by : Orchid Systems Page 5 of 238

6 EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Canadian - CIBC CPA Standard 005/EFT EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Royal Bank of Canada - Jamaica EFT Banks EFT Setup procedure for HSBC BACS (Canada) EFT Banks EFT Vendors EFT Customers EFT Setup procedure for National Bank of Canada EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Estonian Hansabank Domestic Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for Estonian Hansabank Foreign Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA Solano Bank Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA CITIBANK Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA CITIBANKFT funds transfer Layout EFT Banks EFT Vendors EFT Vendor Remittance Address EFT Customers EFT Setup procedure for USA CITIBANKPF- ACH PreFormat Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA Harris Bank ACH EFT Banks EFT Vendors EFT Customers To Create an EFT file for the bank EFT Setup procedure for USA NACHA Standard Layout EFT Banks EFT Vendors Prepared by : Orchid Systems Page 6 of 238

7 EFT Customers EFT Setup procedure for USA NACHA CTX Standard Layout EFT Banks EFT Vendors EFT Customers USA ACH Direct EFT format for the Payment Gateway EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA - International ACH Transactions (IAT) File Format EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA Nordea - NACHA Standard Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA - NACHA Standard Self Balancing EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA - NACHA Standard, User Defined Transaction Type EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA FROST - NACHA Standard Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA Pinnacle National Bank - NACHA Standard Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA Sovereign Bank - NACHA Standard Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA JP Morgan Chase Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA Wilmington Trust Co - NACHA Standard Layout EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA CommerceBank ACH Prepared by : Orchid Systems Page 7 of 238

8 EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA CommerceBank Wire Transfer EFT Banks EFT Vendors EFT Setup procedure for USA Bank of America - NACHA EFT Banks EFT Vendors EFT Customers EFT Setup procedure for USA First American Bank ACH EFT Banks EFT Vendors Creating the EFT File EFT Setup procedure for Emirates National Bank Dubai EFT Banks EFT Vendors Creating a Receipt Batch in EFT Processing V Prepared by : Orchid Systems Page 8 of 238

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 Select if the users are allowed to select individual payment from a batch Prepared by : Orchid Systems Page 9 of 238

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 Select if the users are allowed to select individual payment from a batch Prepared by : Orchid Systems Page 10 of 238

11 This tab lets you: Define your Server. If you leave this field blank, then the Sage Accpac ERP default way of sending s using your Microsoft Outlook client will be used. If you define the server, then SMTP will be used to send s and the following parameters will be required: Server The User The Password The Comes from Notes : Check your 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 servers will allow you to log on as a certain user and send as anyone, others will only allow you to send as the logged on user. So if you log on as 'Joe', but try to send as some servers won't allow it. In your 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 . You can use the 'Send Test ...' to check your settings. You will be prompted to enter an address to send the test to. Prepared by : Orchid Systems Page 11 of 238

12 Options Select the bank or primary bank. Selecting a bank enables the EFT Screen labels to be tailored to the bank Prepared by : Orchid Systems Page 12 of 238

13 Canadian CIBC Bank Select CAN_CIBC as the primary bank : Prepared by : Orchid Systems Page 13 of 238

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 Select CAN_TD as the primary bank : Canadian TD Bank US$ Format Prepared by : Orchid Systems Page 14 of 238

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 Select CAN_RBCAPL or CAN_RBCAPL1 as the primary bank : Prepared by : Orchid Systems Page 15 of 238

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 ( , print), then select CAN_RBCAPL as the primary bank. If you want to control the type of remittance advice (none, , 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 Prepared by : Orchid Systems Page 16 of 238

17 Canadian RBC A/P Link Incl ACH Select CAN_RBCAPLACH as the primary bank : Canadian EFT (80 byte Record) Select CAN_EFT as the primary bank : Canadian Scotiabank Select CAN_SCOTIA as the primary bank : Canadian Scotia Direct 105 Byte Select CAN_SCOTIASD105 as the primary bank : Prepared by : Orchid Systems Page 17 of 238

18 Prepared by : Orchid Systems Page 18 of 238

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 Select CAN_BOM80 as the primary bank Prepared by : Orchid Systems Page 19 of 238

20 Canadian Bank of Montreal Positive Pay Select CAN_BOMPP as the primary bank Prepared by : Orchid Systems Page 20 of 238

21 Canadian Alberta Treasury Bank Select CAN_ATB as the primary bank Prepared by : Orchid Systems Page 21 of 238

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 Canada Caisse Populaire Desjardins Select CAN_HSBC as the primary bank Prepared by : Orchid Systems Page 22 of 238

23 Prepared by : Orchid Systems Page 23 of 238

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 Select CAN_BEANSTREAMCC as the primary bank Prepared by : Orchid Systems Page 24 of 238

25 Canada RBC Express (flat txt file) Select CAN_RBCEXPRESS as the primary bank Prepared by : Orchid Systems Page 25 of 238

26 Canada Canadian Beanstream EFT Select CAN_BEANSTREAMEFT as the primary bank Prepared by : Orchid Systems Page 26 of 238

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 Select CAN_RBC2XCLIENTCODE as the primary bank Prepared by : Orchid Systems Page 27 of 238

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 : USA Mellon Global Cash Management Select USA_MELLONGCM as the primary bank : Prepared by : Orchid Systems Page 28 of 238

29 Prepared by : Orchid Systems Page 29 of 238

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: Prepared by : Orchid Systems Page 30 of 238

31 Canadian - CIBC CPA Standard 005/EFT1464 Select CAN_CPA005CIBC as the primary bank : Canadian Royal Bank of Canada - Jamaica Select RBC_JAMAICA as the primary bank : Prepared by : Orchid Systems Page 31 of 238

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 Select EST_HANSADOMESTIC as the primary bank : Estonia Hansabank Foreigh Layout Prepared by : Orchid Systems Page 32 of 238

33 Select EST_HANSAFOREIGN as the primary bank : USA Solano Bank Select USA_SOLANO as the primary bank USA Citibank Select CITIBANK as the primary bank Prepared by : Orchid Systems Page 33 of 238

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 Select USA_HARRISBANK as the primary bank USA NACHA Standard Select NACHA as the primary bank Prepared by : Orchid Systems Page 34 of 238

35 Prepared by : Orchid Systems Page 35 of 238

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 USA ACH Direct EFT format for the Payment Gateway Select USA_ACHEFT as the primary bank Prepared by : Orchid Systems Page 36 of 238

37 Prepared by : Orchid Systems Page 37 of 238

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 Select USA_FROST as the primary bank Prepared by : Orchid Systems Page 38 of 238

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 Select USA_JPMC as the primary bank Prepared by : Orchid Systems Page 39 of 238

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 Select COMMERCE_WIRE as the primary bank Prepared by : Orchid Systems Page 40 of 238

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 Select EMR_NAT_DUBAI as the primary bank Prepared by : Orchid Systems Page 41 of 238

42 Setup your bank, customers and vendors Prepared by : Orchid Systems Page 42 of 238

43 EFT Setup procedure for Canadian CIBC EFT Banks 1 Bank Name CIBC 2 Financial Institution ID 9 digit number (e.g ) 3 Account Number Your account number with your bank (e.g ) 4 Payment Code (transaction code) for AP Payments eg Account Name eg Sample Company LTD 6 Receipt Code (transaction code) for AR Payments eg 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 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 14 A/R Payment Reference Organisation id eg Select the file numbering option either Batch number or File Sequence Number Prepared by : Orchid Systems Page 43 of 238

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 ) 4 Account Number The Vendor Account number (e.g ) 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 Prepared by : Orchid Systems Page 44 of 238

45 EFT Setup procedure for Canadian CIBC Positive Pay EFT Banks 1 Bank Name CIBC 2 Bank Transit Number 5 digit number (e.g ) 3 Account Number Your account number with your bank (e.g ) 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 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 10 Select the file numbering option - must be File Sequence Number Prepared by : Orchid Systems Page 45 of 238

46 EFT Vendors 1 Vendor ID Enter or select the vendor id (e.g. 1200) 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) 3 Financial Institution ID The Vendor Financial institution id (e.g ) 4 Account Number The Vendor Account number (e.g ) 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 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. Prepared by : Orchid Systems Page 46 of 238

47 Prepared by : Orchid Systems Page 47 of 238

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 ) 4 Account Name e.g. Sample Company 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..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 Payments 14 Receipt Code (Typically 77 for supplier) Prepared by : Orchid Systems Page 48 of 238

49 EFT Vendors 1 Vendor ID Enter or select the vendor id (e.g. 1200) 2 Bank Name The Vendor Bank (e.g. Royal Bank of Canada) 3 Bank and Branch Code 4 Account Number The Vendor Account number 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 Prepared by : Orchid Systems Page 49 of 238

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 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 Prepared by : Orchid Systems Page 50 of 238

51 EFT Setup procedure for Canadian TD Bank EFT Banks 1 Bank Name TD Bank 2 Financial Institution ID 9 digit number (e.g ) 3 Account Number Your account number with your bank (e.g ) 4 Account Name eg Sample Company LTD 5 A/P EFT File batch Enter or browse to find the file path for AP files 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 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 12 Originator ID Number Organisation id eg Select the file numbering option either Batch number or File Sequence Number Prepared by : Orchid Systems Page 51 of 238

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) 3 Financial Institution ID The Vendor Financial institution id (e.g ) 4 Account Number The Vendor Account number (e.g ) 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 Prepared by : Orchid Systems Page 52 of 238

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 ) 4 Account Number The Customer Account number (e.g ) 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 Prepared by : Orchid Systems Page 53 of 238

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.g ) 3 Account Number Your account number with your bank (e.g ) 4 Account Name eg Sample Company Inc 5 A/P EFT File batch Enter or browse to find the file path for AP files 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 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_TDUSA for Canadian TD Bank US$ Format 12 Originator ID Number Organisation id eg Select the file numbering option either Batch number or File Sequence Number Prepared by : Orchid Systems Page 54 of 238

55 EFT Vendors 1 Vendor ID Enter or select the vendor id (e.g. 1200) 2 Bank Name The Vendor Bank (e.g. Barclays Bank) 3 Financial Institution ID The Vendor Financial institution id (e.g ) 4 Account Number The Vendor Account number (e.g ) 5 Account Name The Vendor Bank Account Name (e.g. Chloride Systems Account) 6 Account Type (S/C) This payment reference must be entered as S for savings account and C for current account 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Prepared by : Orchid Systems Page 55 of 238

56 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 ) 4 Account Number The Customer Account number (e.g ) 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 Prepared by : Orchid Systems Page 56 of 238

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 ) 4 Account Number Your account number with the bank (e.g ) 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 ) 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. RBC) 9 A/P EFT File Type CAN_RBC for Canadian RBC Note: If you want $$AA exported in the header row of the EFT file select CAN_RBC, otherwise use CAN_RBC1 Prepared by : Orchid Systems Page 57 of 238

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 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. 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) 3 Financial Institution ID The Customer Financial institution id (e.g ) 4 Account Number The Customer Account number (e.g ) 5 Account Name The Customer Bank Account Name (eg. Chloride Systems Account) 6 Country Enter CAN or USA for Canada or USA 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Prepared by : Orchid Systems Page 58 of 238

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) 3 Financial Institution ID The Customer Financial institution id (e.g ) 4 Account Number The Customer Account number (e.g ) 5 Account Name The Customer Bank Account Name (eg. Ronald Black Current Account) 6 Country Enter CAN or USA for Canada or USA 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Prepared by : Orchid Systems Page 59 of 238

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 ) 4 Account Number Your account number with the bank (e.g ) 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. 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 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. RBC) 12 A/R EFT File Type CAN_RBCAPL or CAN_RBCAPL1 for Canadian RBC AP Link. See Note 1 Below 13 A/R Payment Reference not used 14 Select the file numbering option either Batch number or File Sequence Number Prepared by : Orchid Systems Page 60 of 238

61 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 Remit Financial EDI pay/ 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 Remit ACH Direct Deposit pay/ 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 ACH Personally Approved Debits/ 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 Wires with 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 Only 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 ( remittance), then select CAN_RBCAPL as A/P EFT File Type. Prepared by : Orchid Systems Page 61 of 238

62 If you want to use the delivery method on the customer to dictate types I (no remittance), J (fax remittance), K ( 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. Prepared by : Orchid Systems Page 62 of 238

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 (e.g ) 4 Account Number The Customer Account number (e.g ) 5 Account Name The Customer Bank Account Name (eg. Gould Manufacturing Ltd.) Prepared by : Orchid Systems Page 63 of 238

64 6 Pay Type (E/F/G) Enter the payment type required : A..H, L..W 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group 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 ) 4 Account Number The Customer Account number (e.g ) 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 Using a primary bank of CAN_RBCAPL1 Prepared by : Orchid Systems Page 64 of 238

65 1 Customer ID Enter or select the Customer id (e.g. 1600) 2 Bank Name The Customer Bank (e.g. Westpac) 3 Financial Institution ID The Customer Financial institution id (e.g ) 4 Account Number The Customer Account number (e.g ) 5 Account Name The Customer Bank Account Name (eg. Ronald Black Current Account) 6 Pay Type (I/J/K) Enter the payment type required : I, J or K 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Using a primary bank of CAN_RBCAPL Prepared by : Orchid Systems Page 65 of 238

66 1 Customer ID Enter or select the Customer id (e.g. 1600) 2 Bank Name The Customer Bank (e.g. Westpac) 3 Financial Institution ID The Customer Financial institution id (e.g ) 4 Account Number The Customer Account number (e.g ) 5 Account Name The Customer Bank Account Name (eg. Ronald Black Current Account) 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 number 4 Account Number Your account number with the bank 5 Account Name e.g. Sample Company Inc Prepared by : Orchid Systems Page 66 of 238

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 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. 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 A/P Remit To Location. Prepared by : Orchid Systems Page 67 of 238

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 9 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group 10 Select ACH PDS status Prepared by : Orchid Systems Page 68 of 238

69 EFT Customers In EFT55 SP4 the following options have been added: 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 8 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group 9 ACH-PAD (DCD/PDD) Prepared by : Orchid Systems Page 69 of 238

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 3 Financial Institution ID 9 digit number (e.g ) 4 Account Number Your account number with your bank (e.g ) 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..eft) 8 A/P EFT File Type CAN_EFT for Canadian EFT 9 Originator ID Number Organisation id eg 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 13 Originator ID Number Organisation id eg Select the file numbering option either Batch number or File Sequence Number Prepared by : Orchid Systems Page 70 of 238

71 EFT Vendors 1 Vendor ID Enter or select the vendor id (e.g. 1200) 2 Bank Name The Vendor Bank (e.g. Barclays Bank) 3 Financial Institution ID The Vendor Financial institution id (e.g ) 4 Account Number The Vendor Account number (e.g ) 5 Account Name The Vendor Bank Account Name (e.g. Chloride Systems Account) 6 Payment Reference can be used for notes. Not used in the EFT file 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Prepared by : Orchid Systems Page 71 of 238

72 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 ) 4 Account Number The Customer Account number (e.g ) 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 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Prepared by : Orchid Systems Page 72 of 238

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 3 Financial Institution ID 9 digit number (e.g ) 4 Account Number Your account number with your bank (e.g ) 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..sco) 8 A/P EFT File Type CAN_SCOTIA for Canadian Scotiabank 9 Customer Number Customer number supplied by Scotiabank eg 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 13 Customer Number Customer number supplied by Scotiabank eg Select the file numbering option either Batch number or File Sequence Number Prepared by : Orchid Systems Page 73 of 238

74 EFT Vendors 1 Vendor ID Enter or select the vendor id (e.g. 1200) 2 Bank Name The Vendor Bank (e.g. Barclays Bank) 3 Financial Institution ID The Vendor Financial institution id (e.g ) 4 Account Number The Vendor Account number (e.g ) 5 Account Name The Vendor Bank Account Name (e.g. Chloride Systems Account) 6 Payment Reference can be used for notes. Not used in the EFT file 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Prepared by : Orchid Systems Page 74 of 238

75 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 ) 4 Account Number The Customer Account number (e.g ) 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 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Prepared by : Orchid Systems Page 75 of 238

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 ) 5 Account Name e.g. Sample Company Inc 6 Scotiabank Data Centre Enter one of the following codes: Prepared by : Orchid Systems Page 76 of 238

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 17 Select the file numbering option either Batch number or File Sequence Number Prepared by : Orchid Systems Page 77 of 238

78 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 (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 9 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Prepared by : Orchid Systems Page 78 of 238

79 EFT Customers In EFT55 SP4 the following options have been added: 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 8 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Prepared by : Orchid Systems Page 79 of 238

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 ) 4 Account Number Your account number with your bank (e.g ) 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..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 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 13 Payment Group Enter the payment group used for AP transactions in the ScotiaBank Web client eg PaymentGroupDEF 14 Select the file numbering option either Batch number or File Sequence Number Prepared by : Orchid Systems Page 80 of 238

81 EFT Vendors 1 Vendor ID Enter or select the vendor id (e.g. 1200) 2 Bank Name The Vendor Bank (e.g. Barclays Bank) 3 Institution ID/Transit The Vendor Financial institution id (e.g ) 4 Account Number The Vendor Account number (e.g ) 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. 7 Status Status must be active for an EFT Payment. Modifying this field can be controlled by a security group Prepared by : Orchid Systems Page 81 of 238

Setup procedures for EFT Processing

Setup procedures for EFT Processing South African Banks V5.4 to V2014 Last updated V1.74 07/09/2012 EFT Options... 4 A/P Options... 4 A/R Options... 4 E-mail... 5 Options... 6 South African First National

More information

Accounting. EFT Direct User Guide

Accounting EFT Direct User Guide Sage 50 EFT Direct User Guide Before You Start 1 Hardware and Software Requirements 1 Make Arrangements with Your Bank 1 Getting Help 2 The Manuals 2 Online Help 2 Installing

More information

Or What makes Canadian Banking different?

CANADIAN BANKING Sharing a Border Or What makes Canadian Banking different? Ray Kohler Senior Relationship Manager, US Markets RBC Royal Bank 1 Agenda Understand the basic differences between Canadian

More information

EFT 2012 GETTinG STarTEd GuidE

EFT Getting Started Guide 2012 EFT Direct for Sage Simply Accounting User Guide Before You Start...1 Hardware and Software Requirements...1 Make Arrangements with Your Bank...2 Getting Help...2 The Manuals...2

More information

User Guide Electronic Funds Transfer (EF T) Service

User Guide Electronic Funds Transfer (EF T) Service Contents What You Need to Know About ATB s EFT Service 4 Funding EFT Files 4 1.Liquidity Limit 4 2.Exchange Funding 5 Limits 5 1.File Limits 6 2.Limits

More information

Generate Electronic Payments in Accounts Payable

Generate Electronic Payments in Accounts Payable IMPORTANT NOTICE This document and the Sage 300 Construction and Real Estate software may be used only in accordance with the Sage 300 Construction and

More information

Direct Deposit of Payroll Cash Concentration and Disbursement Consumer Debits and Credits. About ACH

Automated Clearing House (ACH) Payments Use ACH to make a wide variety of payment types. Each data entry screen is specifically designed for a different kind of payment. Payment types, also called applications,

More information

Guide to Federal Financial EDI Payments

Guide to Federal Financial EDI Payments Published by Financial Management Service Department of the Treasury 1997 For additional copies of the Guide to Federal Financial EDI Payments, contact: Product

More information

IAT Scenarios Simplified

IAT Scenarios Simplified Several abbreviated scenarios are provided below to better understand when a specific payment transaction involving the U.S. ACH Network would be deemed an International ACH Transaction

More information

Section VIII: ACH Payment Processing

Section VIII: ACH Payment Processing Contents About ACH Payments... 2 About the Automated Clearing House... 2 ACH Terms and Features... 2 Workflow Example: ACH Payroll Application... 4 To Add a Database...

More information

International ACH Transactions (IAT) Frequently Asked Questions Corporate Customers. Contents

International ACH Transactions (IAT) Frequently Asked Questions Corporate Customers IAT changes were made for regulatory compliance The first step is to understand and recognize OFAC requirements - corporates

More information

NACHA FORMAT. Record Title Record Type Code File Header Record - This record includes your company name and

NACHA FORMAT ACH Input File Structure The NACHA format is composed of 94 character records. All records and fields are required, except the record 7 - Entry Detail that is optional. Title File Header -

More information

EFT Overview Guide for Canada

EFT Overview Guide for Canada 051812 2012 Blackbaud, Inc. This publication, or any part thereof, may not be reproduced or transmitted in any form or by any means, electronic, or mechanical, including photocopying,

More information

OVERVIEW AND TERMINOLOGY

ACH Online Services OVERVIEW AND TERMINOLOGY There are ACH terms and definitions that are helpful to understand in order to use the ACH Online Service. In addition, there are basic tasks (accessing ACH

More information

Microsoft Dynamics GP. Cashbook Bank Management

Microsoft Dynamics GP Cashbook Bank Management Copyright Copyright 2010 Microsoft. All rights reserved. Limitation of liability This document is provided as-is. Information and views expressed in this

More information

Cathay Business Online Banking. User Guide. Version 1.0

Cathay Business Online Banking User Guide Version 1.0 07/2013 Disclaimer: The information and materials in these pages, including text, graphics, links, or other items are provided as is and available.

More information

CHAPTER 7: CASH AND BANK MANAGEMENT SETUP

Chapter 7: Cash and Bank Management Setup CHAPTER 7: CASH AND BANK MANAGEMENT SETUP Objectives Introduction The objectives are: Set up cash bank transaction types. Set up bank transaction groups. Set up

More information

Online Banking Notes for Reckon Accounts 2013

Online Banking Notes for Reckon Accounts 2013 Importing Transactions Online Banking is a feature fully available in Reckon Accounts 2013. Online Banking allows the user to import their bank statements

More information

Brian Pelletier presents: AP SETTINGS REVIEW

Brian Pelletier presents: AP SETTINGS REVIEW ADMINISTERING USERS Why this? New options continually available Newer staff may not be aware of options Goals Review Settings program and available options

More information

Table of Contents. 2 Copyright 2009 Bank of American Fork. All Rights Reserved.

Table of Contents Logging In... 3 Changing Your Password... 4 Cash User Login Screen... 5 Navigation... 6 Account Access Page... 7 Account Activity Options... 8 Transactions... 9 Download... 10 Statements...

More information

SYSTEM LOGIN/PASSWORD SUPPORT

SYSTEM LOGIN/PASSWORD SUPPORT Why am I unable to log into the system? What if I forgot my password? Why do I need to create Security Questions/Answers? Why does it ask me if I want to remember this computer?

More information

Environmental Scan - International Interoperability Standards -

Environmental Scan - International Interoperability Standards - Environmental Scan - International Interoperability Standards - February 2009 TABLE OF CONTENTS EXECUTIVE SUMMARY 1 I INTRODUCTION 2 1. PURPOSE

More information

Electronic Funds Transfer (EFT) Payment Guide

Government of the District of Columbia Office of the Chief Financial Officer Office of Tax and Revenue 2015 Electronic Funds Transfer (EFT) Payment Guide Bank Information for Payments TXP and Addenda Record

More information

Microsoft Dynamics GP. Cashbook Bank Management

Microsoft Dynamics GP Cashbook Bank Management Copyright Copyright 2007 Microsoft Corporation. All rights reserved. Complying with all applicable copyright laws is the responsibility of the user. Without

More information

4. Do not make changes to the Master record. To create a custom form, click Copy.

Custom Invoice Import Custom imports allow for the creation of Munis invoices through a fixed or delimited file import. Customization of the import form can be edited to fit an existing export or report

More information

Electronic Funds Transfer (EFT) Payment Guide

Government of the District of Columbia Office of the Chief Financial Officer Office of Tax and Revenue 2015 Electronic Funds Transfer (EFT) Payment Guide Bank Information for Payments TXP and TPP Addenda

More information

Cash Management User Guide

Cash Management User Guide Version 9.0 February 2006 Document Number CBUG-90UW-01 Lawson Enterprise Financial Management Legal Notices Lawson does not warrant the content of this document or the results

More information

Sage 300 ERP 2014. Bank Services User's Guide

Sage 300 ERP 2014 Bank Services User's Guide This is a publication of Sage Software, Inc. Copyright 2014. Sage Software, Inc. All rights reserved. Sage, the Sage logos, and the Sage product and service

More information

Savings Accounts CHOOSING THE RIGHT SAVINGS ACCOUNT FOR YOUR NEEDS

Savings Accounts CHOOSING THE RIGHT SAVINGS ACCOUNT FOR YOUR NEEDS ISBN 978-0-662-48270-3 Catalogue No. FC5-10/2008E-PDF Table of Contents Introduction 2 What is a savings account? 2 What is the difference

More information

A ribbon has replaced the Desktop toolbar. You still have access to the same features, but the new interface makes them easier to find.

Sage 100 2016 What s New Global Enhancements New Product Key Required If you use the Payroll module, you must enter your new product key when installing Sage 100 2016. If you enter a product key obtained

More information

Sage 300 ERP 2012. Bank Services User's Guide

Sage 300 ERP 2012 Bank Services User's Guide This is a publication of Sage Software, Inc. Copyright 2014. Sage Software, Inc. All rights reserved. Sage, the Sage logos, and the Sage product and service

More information

PARITY SOFTWARE S SAGE ERP X3 CASHBOOK USER MANUAL

PARITY SOFTWARE S SAGE ERP X3 CASHBOOK USER MANUAL Introduction Parity s Cashbook allows for the efficient reconciliation of Bank Statements to Bank Entry transactions within Sage ERP X3. Parity s Cashbook

More information

CAFT is a user-friendly web-based application that allows you to apply one-time or recurring Automated Funds Transfer (AFT) transactions

CAFT is a user-friendly web-based application that allows you to apply one-time or recurring Automated Funds Transfer (AFT) transactions Whether you need to pay employees and suppliers or collect payments

More information

AFN-AccountsPayableEFTGuide-120506

120506 2006 Blackbaud, Inc. This publication, or any part thereof, may not be reproduced or transmitted in any form or by any means, electronic, or mechanical, including photocopying, recording, storage

More information

Business Online Banking

Business Online Banking User Guide Rev. 01/11 Table of Contents Logging In... 1 Viewing the Online Banking Agreement... 3 Changing Your Company Password... 4 Cash User Login Screen... 5 Changing Your Cash

More information

9.1 Banking Services Policy

9.1 Banking Services Policy Policy Statement This Banking Services Policy (the policy ) has been developed to facilitate centralized control of all bank accounts, banking services, and negotiations of

More information

Payments & Transfers ACH

Payments & Transfers ACH Online Banking Payments & Transfers ACH Online Banking / 2 Module Outline Introduction... 1 Slide 1: Module Overview... 3 Payments & Transfers - ACH... 4 Slide 2: ACH General Information...

More information

Cathay Business Online Banking

Cathay Business Online Banking A QUICK GUIDE TO CATHAY BUSINESS ONLINE BANKING R6119 CATHAY 8_5x11 Cover V2.indd 1 6/11/13 5:50 PM Welcome Welcome to Cathay Business Online Banking (formerly known as Cathay

More information

User Manual. Online Treasury Manager: ACH Initiation

User Manual Online Treasury Manager: ACH Initiation Table of Contents OVERVIEW...1 System Access... 1 Login/Logout Procedures... 2 Online Treasury Manager Modules... 2 Accessing Images... 3 System Availability

More information

CANADIAN PAYMENTS ASSOCIATION ASSOCIATION CANADIENNE DES PAIEMENTS

CANADIAN PAYMENTS ASSOCIATION ASSOCIATION CANADIENNE DES PAIEMENTS Procedural Reference Document PRD-002 PROCEDURES FOR U.S. DOLLAR AND FOREIGN CURRENCY TRANSFERS WITHIN CANADA November 2009 CANADIAN PAYMENTS

Cibc Eft 80 Byte File Layout Pdf

More information

Tuition Payment Options 2016-2017

Tuition Payment Options 2016-2017 Payment Options Tuition payments can be made by one of the following methods: International Cheque payable to Appleby College Online Banking Western Union Business Solutions

More information

NEBRASKA FILE FORMAT FOR EMPLOYERS

NEBRASKA FILE FORMAT FOR EMPLOYERS Electronic Funds Transfer (EFT) / Electronic Data Interchange (EDI) Transactions 1. Your company transmits the payment and remittance information to your financial institution.

More information

Demystifying ACH Payments to Canada

Demystifying ACH Payments to Canada NACHA Payments 2008 May 18 21, 2008 Elizabeth McQuerry Assistant V.P., Retail Payments Office Federal Reserve Doug Kreviazuk V.P., Policy & Research Canadian Payments

More information

ACH Welcome Kit. Rev. 10/2014. Member FDIC Page 1 of 8

ACH Welcome Kit Rev. 10/2014 Member FDIC Page 1 of 8 Dear Customer, Thank you for utilizing FirstMerit s ACH services. We have finalized the setup of your ACH product and you may now begin processing ACH

More information

AP314: Payment Processing. Instructor Led Training

AP314: Payment Processing Instructor Led Training Lesson 1: Understanding Payment Processing Introduction Welcome Welcome to Cardinal Training! This training provides employees with the skills and information

More information

Sage Accpac ERP 5.6A. SageCRM 6.2 I Integration Update Notice

Sage Accpac ERP 5.6A SageCRM 6.2 I Integration Update Notice 2009 Sage Software, Inc. All rights reserved. Sage, the Sage logos, and all Sage Accpac product and service names mentioned herein are registered

More information

LOCAL TRAINING INITIATIVE

Training Standards System LOCAL TRAINING INITIATIVE BOOKS OF ACCOUNT AND RECORD KEEPING Best Practice Guidelines Page 1 of 13 The LTI must comply with public procurement guidelines when purchasing goods

More information

Preparing For Canadian Cheque Image Exchange NOTICES

ECCHOInsights: Preparing For Cheque Oct. 15, 2015 October 15, 2015 Preparing For Cheque William L. Saffici Saffici Payment Consulting LLC Phyllis Meyerson, AAP, CCM ECCHO NOTICES This presentation may

More information

MICR Check Printing. Quick Start Guide

MICR Check Printing Quick Start Guide Mekorma MICR Quick Start Guide Copyright 2013, Mekorma Enterprises. All Rights Reserved. Your right to copy this documentation is limited by copyright law and the

More information

User Guide ACH and Wire Transfer

ONLINE CASH MANAGEMENT User Guide ACH and Wire Transfer Put the power to manage your business accounts where it should be... in your hands. TABLE OF CONTENTS Log In Process... 1 Company Login... 1 Cash

More information

EFT Overview Guide for Australia and New Zealand

EFT Overview Guide for Australia and New Zealand 111109 2009 Blackbaud, Inc. This publication, or any part thereof, may not be reproduced or transmitted in any form or by any means, electronic, or mechanical,

More information

Integrating Payables and Receivables to Unlock Working Capital

Integrating Payables and Receivables to Unlock Working Capital Approved for 1 CTP / CCM recertification credit by the Association of Financial Professionals May 2009 Introductions David Kunz Treasury Management

More information

Chapter 7. Banner Introduction... 7-3. Menu Navigation Tables... 7-4. Automated Clearing House Forms... 7-5

Chapter 7 Automated Clearing House Banner Introduction......... 7-3 7 Automated Clearing House Standards. 7-3 National Automated Clearing House Association Standards. 7-3 Canadian Payment Association Standards..........

Eft 80 Byte File Layout

More information

Scotia Bill Payment Remittance Reporting Service

Payment Services Getting Started Scotia Bill Payment Remittance Reporting Service July 2010 Table of Contents 1 Registration & Login...........................................................3 a. Your

More information

State of Iowa Department of Human Services Employers Partnering In Child Support 501 Sycamore Street, Suite 500 Waterloo, IA 50703-4651

Introduction Electronic Funds Transfer (EFT) / Electronic Data Information (EDI) Transactions INFORMATION FOR EMPLOYERS Electronic Funds Transfer (EFT) / Electronic Data Information (EDI) allows employers

More information

The Commonwealth of Massachusetts Department of Revenue Child Support Enforcement Division

The Commonwealth of Massachusetts Department of Revenue Child Support Enforcement Division ELECTRONIC FUNDS TRANSFER (EFT) & ELECTRONIC DATA INTERCHANGE (EDI) INFORMATION FOR EMPLOYERS Thank you for your

More information

Electronic Banking Cash Manager User Guide

Electronic Banking Cash Manager User Guide Table of Contents Logging In... 1 Changing Your Password... 2 Cash User Login Screen... 3 Cash Management User Single Sign On... 4 Navigation... 5 Account Listing

More information

Cash Management. Solutions That Fit

TREASURY SERVICES Cash Management Solutions That Fit TABLE OF CONTENTS The Role of Cash Management Business Cash Cycle...3 Progressive Plan Phase I Information Management & Transaction Control...4 Zero

More information

Once form has been completed by one or more employees the information can be entered on the employees direct deposit screen.

Banyon Data Systems, Inc. DIRECT DEPOSIT MODULE BDS Direct Deposit or ACH (Automated Clearing House) allows your entity to transfer its employee s pay directly to their bank accounts. This module does

More information

Chapter A5: Creating client files and attaching bank accounts

Chapter A5: Creating client files and attaching bank accounts This chapter is aimed at BankLink Administrators It covers the set up of your BankLink Practice clients. A BankLink Practice user needs BankLink

More information

NEWSTAR Training Guide. Banking, Consolidations and Tax Systems

Cibc Eft 80 Byte File Layout

NEWSTAR Training Guide Banking, Consolidations and Tax Systems Document A11 / A12 / A19-0.1 November 2005 NEWSTAR Training Guide: Banking, Consolidations and Tax Systems 2005 Constellation HomeBuilder

More information

A/P Payment Selection Based on A/R Cash Receipts AP-1108

A/P Payment Selection Based on A/R Cash Receipts AP-1108 Overview This Extended Solution modifies the A/R Cash Receipt update process to write an Amount paid on a Sales Order Invoice to a corresponding

More information

CANADIAN PAYMENTS ASSOCIATION ASSOCIATION CANADIENNE DES PAIEMENTS RULE E3 RULES APPLICABLE TO ELECTRONIC DATA INTERCHANGE TRANSACTIONS

CANADIAN PAYMENTS ASSOCIATION ASSOCIATION CANADIENNE DES PAIEMENTS RULE E3 RULES APPLICABLE TO ELECTRONIC DATA INTERCHANGE TRANSACTIONS 2014 CANADIAN PAYMENTS ASSOCIATION 2014 ASSOCIATION CANADIENNE DES

More information

Bank Account 1 September 2015

Chapter 8 Training Notes Bank Account 1 September 2015 BANK ACCOUNTS Bank Accounts, or Bank Records, are typically setup in PrintBoss after the application is installed and provide options to work with

More information

Create Company. User Guide

Create Company User Guide Important Notice TaiRox does not warrant or represent that your use of this software product will be uninterrupted or error-free or that the software product can be run with any

More information

for Sage 100 ERP Bank Reconciliation Overview Document

for Sage 100 ERP Bank Reconciliation Document 2012 Sage Software, Inc. All rights reserved. Sage Software, Sage Software logos, and the Sage Software product and service names mentioned herein are registered

More information

BUSINESS ONLINE BANKING CASH MANAGEMENT USER GUIDE

BUSINESS ONLINE BANKING CASH MANAGEMENT USER GUIDE TABLE OF CONTENTS LogIn Process...1 Company Login... 1 Cash User Login... 3 Cash Management User Single Sign On... 4 Navigation...5 Account Listing Page...6

More information

A Guide to Accounts Payable Supplier Processes

A Guide to Accounts Payable Supplier Processes The Johnson & Johnson Family of Companies believe in the benefits associated with the efficiencies gained through methods of electronic or paperless invoicing.

More information

December 2004 2303 Camino Ramon, Suite 210 San Ramon, CA 94583-1389 Voice: 925.244.5930 Fax: 925.867.1580 Website: www.miscorp.com

December 2004 2303 Camino Ramon, Suite 210 San Ramon, CA 94583-1389 Voice: 925.244.5930 Fax: 925.867.1580 Website: www.miscorp.com Copyright 2004 All rights protected and reserved TABLE OF CONTENTS I.

More information

TRANS-TASMAN ANZ TRANSACTIVE AUSTRALIA AND NEW ZEALAND 01.2012. Simplifying and connecting your transaction banking across Australia and New Zealand

TRANS-TASMAN ANZ TRANSACTIVE User GUIDE AUSTRALIA AND NEW ZEALAND 01.2012 Simplifying and connecting your transaction banking across Australia and New Zealand contents Notes...4 Introduction to the ANZ

More information

Corporate egateway Supports a centralised payment and collection factory

Cibc Eft 80 Byte File Layout Download

Corporate Supports a centralised payment and collection factory Corporate is Nordea s file based mass payment service for customers demanding one point of entry for bulk payments and collections in the

More information

International ACH Transactions (IAT) File Format Guide

U.S Bank created this IAT file format guide to be used as a supplemental tool to the format listed in the NACHA rules. Organizations can use this to help make changes in their system to prepare for the

More information

Sage Accpac ERP 5.6A. Update Notice

Sage Accpac ERP 5.6A Update Notice 2009 Sage Software, Inc. All rights reserved. Sage, the Sage logos, and all Sage Accpac product and service names mentioned herein are registered trademarks or trademarks

More information

Sage HRMS 2014 Sage HRMS Payroll Getting Started Guide. October 2013

Sage HRMS 2014 Sage HRMS Payroll Getting Started Guide October 2013 This is a publication of Sage Software, Inc. Document version: October 18, 2013 Copyright 2013. Sage Software, Inc. All rights reserved.

More information

Straight2Bank Payments Initiation User Guide

Straight2Bank Payments Initiation User Guide Last Updated: June 2014 Table of Contents PURPOSE... 4 1. OVERVIEW OF PAYMENT SERVICES ON STRAIGHT2BANK... 5 2. MAKING PAYMENTS ON STRAIGHT2BANK... 7 3. USING

More information

DIRECT PAYMENTS (ACH TRANSFER MODULE)

DIRECT PAYMENTS (ACH TRANSFER MODULE) Direct payments is an add on module to utility billing that allows customers to pay their utility bill by a recur ACH payment. Please note that the term ACH (Automatic

More information

ELECTRONIC FUNDS TRANSFER (EFT): A payment made through Fed Wire or the ACH is referred to as an EFT.

FINANCE AND TREASURY POLICIES AND PROCEDURES E056 INCOMING ELECTRONIC FUND TRANSFERS PURPOSE To establish procedures to enable identification of incoming electronic fund transfers and expedite the related

More information

Click the Entries tab to enter transactions that originated at the bank.

Reconciling Bank Statements If this is the first time you have reconciled a bank statement for this company, you must prepare your bank accounts. See Chapter 4, Setting Up Bank Services, in the Tax and

More information

Oracle Payables Implementation Overview with screenshots Compilation of Oracle Payables Implementation notes by Ranu Srivastava ...

Compilation of Oracle Payables Implementation notes by Ranu Srivastava... Setting up Banks... Defining Internal Bank... Payables Options... Defining Payment Documents... Creating Suppliers... Overview

More information

A Business Signer who has the Manage Users feature assigned to them can create other users on the User Management page in DFCU OnLine.

MANAGING USERS A Business Signer who has the Manage Users feature assigned to them can create other users on the User Management page in DFCU OnLine. To add a user and configure rights: 1. In the Menu,

More information

BackOffice 7.3 Bet a Release Notes BackOffice 7.3 Release Notes Accounts Receivable New Features Open Issues

ebackoffice 7.3 Beta Release Release Notes Notes Accounts Receivable New Features 2 Credit Memo 2 AR Netting 2 Customer 3 Dunning Letters 3 Non-AR Cash Receipts 4 Settlement 4 Terms 5 Write-off Receivable

More information

Corporate Online. Import format for Payment Processing Service files

Corporate Online Import format for Payment Processing Service files Payment Processing Service file specification About Corporate Online Westpac Corporate Online is an internet-based electronic platform,

More information

Computer Helper Publishing, Inc. 800-533-5227 www.churchwindows.com

Training 2010 Financial to Accounting Transition Book 3: Transactions & Corrections Computer Helper Publishing, Inc. 800-533-5227 www.churchwindows.com Book 3 Transactions & Corrections Basic Transactions...

More information

EFT Participant Setup Form 1. Wachovia Bank / State of NC

EFT Participant Setup Form Wachovia Bank / State of NC INSTRUCTIONS 1. This Setup Form is to be completed by new participants in the EFT Master Services Agreement (Contract No. 14-05001) offered by the

More information

The Education Edge / The Financial Edge 7.85

Minimum System Requirements This document lists the minimum infrastructure required to run your Blackbaud. We recommend the purchase of topof-the-line equipment when possible and that organizations budget

More information

for Sage 100 ERP General Ledger Overview Document

for Sage 100 ERP General Ledger Document 2012 Sage Software, Inc. All rights reserved. Sage Software, Sage Software logos, and the Sage Software product and service names mentioned herein are registered

More information

Contact Treasury Management Support: 866-563-1010 (toll free) Monday through Friday, 7:30 am 5:30 pm (Pacific Time) TreasuryManagement@umpquabank.

Contact Treasury Management Support: 866-563-1010 (toll free) Monday through Friday, 7:30 am 5:30 pm (Pacific Time) TreasuryManagement@umpquabank.com Updated October 2013 - TreasuryPro 3.8 Contents Welcome...

More information

Renewing your Licence and Paying your Fees: Step-by-Step

Renewing your Licence and Paying your Fees: Step-by-Step 1. Click the Pay Fees link under the Payments section of the left-navigation menu. NOTE: To renew a licence, you must pay the licence renewal fee.

More information

December 2007. Additions to Release 6.3C...2

RELEASE 6.3C December 2007 6.3C Additions to Release 6.3C...2 Login... 2 Login Screen Security... 2 Company... 2 EIS Dashboard... 2 Building... 3 Tenant... 6 Supplier... 8 Banking... 9 Jobs... 10 System

More information

Online Payroll Remittance Manual for Employers

Online Payroll Remittance Manual for Employers Before you start using the online payroll website Fraud Filter and Bank Changes Depending on your bank s ACH fraud filtering mechanisms you may need to identify

More information

Electronic Funds Transfer (EFT) Guide

Electronic Funds Transfer (EFT) Guide 112614 2009 Blackbaud, Inc. This publication, or any part thereof, may not be reproduced or transmitted in any form or by any means, electronic, or mechanical, including

More information

Microsoft Dynamics GP. Analytical Accounting

Microsoft Dynamics GP Analytical Accounting Copyright Copyright 2011 Microsoft. All rights reserved. Limitation of liability This document is provided as-is. Information and views expressed in this document,

More information

Pre-Authorized Debit

Pre-Authorized Debit Pre-Authorized Debit is an agreement between two parties that allows one party to debit funds via the Canadian Electronic Funds Transfer Network directly from another party s bank

More information

Sage Payroll Services

SAGE ACCPAC Sage Accpac ERP Sage Payroll Services Integration Guide 2006 Sage Accpac International, Inc. All rights reserved. Sage Software, Sage Software logos, and all Sage Accpac product and service

More information

A/P Direct Deposit (EFT) (with Electronic Tax Payment) for Solomon IV (Release 2.x) Users Guide Reference

A/P Direct Deposit (EFT) (with Electronic Tax Payment) for Solomon IV (Release 2.x) Users Guide Reference Solomon IV Enhancement Product A/P Direct Deposit (EFT) (with Electronic Tax Payment) By Sandler

More information

Element Payment Services is a third party software system that processes credit card and automatic bank account (ACH) transactions through PestPac.

Element Payment Services is a third party software system that processes credit card and automatic bank account (ACH) transactions through PestPac. Element complies with all Federal regulations regarding

More information

Sage 300 ERP 2014. Tax Services User's Guide

Sage 300 ERP 2014 Tax Services User's Guide This is a publication of Sage Software, Inc. Copyright 2014. Sage Software, Inc. All rights reserved. Sage, the Sage logos, and the Sage product and service

More information

Features for France. Microsoft Corporation. Published: November 2006

Features for France Microsoft Corporation Published: November 2006 Microsoft Dynamics is a line of integrated, adaptable business management solutions that enables you and your people to make business

More information

M4 Systems. Email Remittance (ER) User Guide

M4 Systems Email Remittance (ER) User Guide M4 Systems Ltd Tel: 0845 5000 777 International: +44 (0)1443 863910 www.m4systems.com www.dynamicsplus.net Table of Contents Introduction ------------------------------------------------------------------------------------------------------------------

More information

Sage 300 ERP 2014. Sage CRM 7.2 Integration Upgrade Guide

Sage 300 ERP 2014 Sage CRM 7.2 Integration Upgrade Guide This is a publication of Sage Software, Inc. Version 2014 Copyright 2013. Sage Software, Inc. All rights reserved. Sage, the Sage logos, and the

More information