How to set up Electronic Funds Transfers (EFT) in Sage 50 Accounting

Set up Electronics Funds Transfer (EFT) or Customer Automated Funds Transfers (CAFT). Create an export file to use with the bank's software to process Automatic Fund transfers in Sage 50 Accounting.

Watch a video

Watch this short video on how to set up EFT in Sage 50 Accounting.

Follow the steps 

If you prefer to follow step-by-step guidance. use the steps below.

Before you begin

1. If you’re a new user to EFT/CAFT, you’ll need to get the EFT account credentials from your bank
2. Sage 50 has no direct connection to your bank
   • The Upload button in Sage 50 generates the files for you to upload to the bank
   • You’ll have to upload the generated file manually to the bank using your bank's website
3. It isn’t possible to send or receive EFT funds in foreign currency

Preliminary Setup

1. On Sage 50's main screen, click Setup, Settings, Company, Payment Processing.
2. You have the option for Direct Payments (Beanstream/Bambora) and EFT Direct.
3. Select EFT Direct and fill in the rest of the information such as: Bank Name, Name.
   
   • Always select CPA Standard for Bank Name
   • You can click Set up a new bank or modify existing banks to update bank account information
4. Use the Select a Bank for direct deposit and pre-authorized debit drop-down list to select your financial institution.
5. Select "OK" to save the changes.
   

Payroll

1. You’ll need to enable the option for doing direct deposit for all your employees.
2. Process the Paycheques and make sure to check the Direct Deposit checkbox on all new payroll.
   
3. Generate EFT .DAT files for upload to the bank. 

Vendors

1. You’ll need to enable the option to send direct deposit payments to your vendors.
2. Process the Direct Deposit.
3. Generate EFT .DAT files for upload to the bank.

Customers

1. Enable your customers to generate Pre-Authorized Debits (PAD) requests.
2. Process the PAD transaction.
3. Generate the .DAT file to upload to your bank.