EFT Banks Form - Overview

Use this form to setup EFT details for the banks setup in Sage 300 Bank Services.

Note: The field labels are renamed for different banks depending on the bank formats setup in Formats.ini, when the file type is selected on the Payments and Refunds Tab, Receipts Tab or the Payroll Tab

  • Choose the Bank (using the Finder or the Arrows)

  • Enter the Bank Details -

  • Bank/Branch Code, this should be the BIC/Swift bank code, usually 8 to 11 characters.

  • Account Number and Account Name

  • IBAN Code, this is the International Banking Account Number – up to 34 characters. (typically required for payments to Europe)

  • Additional / configurable fields for the bank: e.g. in Canada: Destination Data Centre and Short Name.

See Also

If using a clearing bank to facilitate bank reconciliation, refer to Setup and Use EFT Clearing Bank.

If you upload the file to a FTP Site (yours or one provided by the bank), Setup SFTP Output Destination.

For details on how to use each field, view EFT Banks Setup Screen

Payments and Refunds Tab

Use this Tab to configure how EFT Processing creates files for Payments and Refunds, including the output destination, the file type, how to name the file

File Sequence Number: the file will be called the File Sequence number on the bank, and after using the file sequence number, EFT Processing will increase the file sequence number by 1.

Note: If the EFT File format includes the File Sequence Number, you generally select the "File Sequence Number" option to name the file. If you select Batch Numbering to name the file, EFT Processing uses the batch number as the [FSN] value.

Batch Number : the file will be called APbbbb.{ext} or ARbbbb.{ext} where bbbb is the batch number being exported.

Pay Period End Date YYYYMMDD: for EFT Payroll files

Fixed File Name : User defined file name using any characters plus the following variables in the file name :

  • {yyyy} for the year, {mm} for the Month, {dd} for the Day

  • {bbbb} up to 4 numbers for the batch number

  • {N} gives you a running number starting from 0 each day. This is often used in conjunction with batch number to keep track of the number of exports in a calendar day.

  • {S} gives you a running sequence number for the selected bank- You can use up to 4 numbers for the file sequence number. You typically use this option instead of batch number for a unique number per file.

  • {entry} for the entry number, this works with option that each entry to be generated in a single file.

Example: You can use up to 4 digits for {B}, {S} and {N}
Example for Batch Number 2
{b} for 1 digit, e.g. 2
{bb} for 2 digits, e.g. 02
{bbb} for 3 digits, e.g. 002
{bbbb} for 4 digits, e.g. 0002

Global Sequence 1..10. You are able to share a Global File Sequence number between multiple banks if required. EFT Processing will increase the global file sequence number used by one after creating the file.

Note: If the EFT File format includes the Global File Sequence Number, you need to select the "Global File Sequence Number" option to name the file.

Example: Global File Sequence Example

Receipts Tab

Use this Tab to configure how EFT Processing creates files for Direct Debit Transactions

Payroll Tab

Use this Tab to configure how EFT Processing creates files for payroll payments.

 

To use the EFT Banks form

  1. Choose Save to keep any changes you make.

  2. Choose Close to leave the form without changing any information.

  3. Choose Delete to delete bank details. You will be prompted to confirm that you want to delete. You only get this option if your security profile allows you to delete.

Important! Before changing any of the settings or other information in the EFT Banks form, make sure you understand the impact the options have on processing with your Bank.

See also

Steps for setting up EFT Processing