EFT Banks Setup Screen
Use this screen to setup EFT bank details for banks setup in Sage 300 Bank Services and configure how to generate EFT files for Payments/Refunds, Receipts and Payroll files.
Tip: Use the Finder to select a bank already configured in EFT Banks, use the Zoom button to select a bank from Bank Services.
Fields and Controls
Enter a Bank Code as defined in Bank Services.
The name of the bank account, up to 60 characters.
Select "Regular" for EFT to process the transaction
Select "Clearing Bank" If you want the AP Payment batch to post to Bank Services in total, as a single entry per EFT Payment.
See Setup and Use EFT Clearing Bank for details on how to process your payments using a clearing bank.
This field is enabled if the "Clearing Bank" bank type has been selected. By clicking on the search button, select which bank code is applicable.
Select Use Next Bank Transfer Number to let Bank Services generate the transfer number
Select Use AP Batch Number to use the AP Batch Number as the Transfer Number . Use this option to facilitate bank reconciliation, for example when using OFX import.
This field is enabled if the "Clearing Bank" bank type has been selected.
Type the banking industry code that identifies this bank.
If EFT Processing Options / Primary Bank / Encrypt Bank BSB/Acct. No. is selected, you will only see the last 4 digits of the details entered.
Type the number of the bank account (assigned to the account by your bank). The number can be up to 22 characters.
Type the name of the bank account .
Depending on the File Type selected below and the formats.ini file, up to 10 additional fields can be configured.
Example: in Canada: Destination Data Centre and Short Name.
This applies to ISO20022 file types only, depending on the bank specifications.
if there is an originator ID, update this field with ‘Othr’.
If there isn’t an Originator ID, update this field with ‘BIC' or 'BEI’ and set the OrgID field with the BIC code.
Payments and Refunds Tab
Select where you wan t to save the file :
File : You need to enter the EFT File path where the file will be saved.
Download: Choose this option to download the file to your local machine before uploading to the bank.
Tip: This is particularly relevant when using EFT web screens as the user may not have access to the server.
SFTP: You need to fill in the FTP Host Name and credentials to connect to the FTP site.
When using SFTP, you can select to enter user name and password or SFTP with Key file or both.,
Select SFTP -2FA if your bank uses 2 factor authentication and requires both a username and password and a key file.
Refer to Setup SFTP Output Destination for details on setting up SFTP to send EFT files.
Tip: Use the Test SFTP File Upload button to test before uploading a file.
If you select Key File then you enter the key file filename and (optionally) a password for the file. The key file should be either on a local drive (eg c:) and will need to be copied to each computer running the Create EFT function, or on a network share.
The key file can have a password too if required by the bank.
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
Click the Browse button to select the path the files will be exported to. Ensure that you have sufficient rights to access the folder.
Tip: Use UNC Path so that all users and workstations can access the folder. If using mapped drive, there is a risk that some users have a different drive mapping.
Enter the required file extension.
Select the required file type by using the Finder.
See System Formats and User Formats
Enter a payment reference code.
Note: The field name may be re-labelled based on the EFT format for the selected file type.
If the file name is set to "File Sequence Number", this number is updated when you
Tip: If you need to reexport a file, set the file sequence number back by 1 to generate the file with the same number.
Receipts Tab
Use the Receipts Tab to configure EFT Files generated for A/R Receipt Batches.
- SFTP: You need to fill in the FTP Host Name and credentials you want to use. Refer to Output Destination:
- File : No additional parameters needed. Enter the File path and extension below.
Choose Same as Payments to use the settings on the Payments and Refunds Tab
or You can select the file name from the following
- File Sequence Number: this uses the File Sequence Number on the EFT Banks Payments & Refunds tab or Receipts Tab, and adds 1 to it.
- Batch Number: from the Batch number entered
- Fixed Name: you can type in the file name at the end of the EFT File Path, and can include the variables highlighted on the right hand side of the screen. Variables include the current date and time, the batch number, the file sequence number and fixed text.
- Global Sequence 1..10: this gives you 10 File Sequence Numbers that can be used across multiple banks.
Click the Browse button to select the path the files will be exported to. (Ensure that you have sufficient rights to access the folder.
Tip: Use UNC Path so that all users and workstations can access the folder. If using mapped drive, there is a risk that some users have a different drive mapping.
Enter the required file extension.
Select the required file type by using the Finder. The available file types is derived from all the file types in the formats.ini file and the userformats.ini file.
See System Formats and User Formats for additional details.
Enter a receipt reference code.
If the file name is set to "File Sequence Number", this number is updated when you
Tip: If you need to reexport a file, set the file sequence number back by 1 to generate the file with the same number.
Payroll Tab
File : Enter the file path below.
You can select the file name from the following:
-
File Sequence Number: this uses the File Sequence Number on the EFT Banks Payroll Tab, and adds 1 to it.
-
Pay Period End Date YYYYMMDD
-
Fixed Name: you can type in the file name at the end of the EFT File Path, and can include the variables highlighted on the right hand side of the screen. Variables include the current date and time, the batch number, the file sequence number and fixed text.
-
Global Sequence 1..10: this gives you 10 File Sequence Numbers that can be used across multiple banks. Global File Sequence Example
Click the Browse button to select the path the files will be exported to. Ensure that you have sufficient rights to access the folder.
Tip: Use UNC Path so that all users and workstations can access the folder. If using mapped drive, there is a risk that some users have a different drive mapping.
Enter the required file extension.
Select the required file type by using the Finder.
See System Formats and User Formats
Enter a payment reference code.
Note: The field name may be re-labelled based on the EFT format for the selected file type.
If the file name is set to "File Sequence Number", this number is updated when you
Tip: If you need to reexport a file, set the file sequence number back by 1 to generate the file with the same number.