Getting Started with EFT - FAQ

If Vendor Approval is enabled in your Sage Intacct database, changes to EFT vendor details can trigger the approval process. There is no Orchid specific approval process.

Orchid's EFT Processing (Sage Intacct) does not include any pre-defined reports. However, all custom objects are available for the custom report writer.

Orchid's EFT Processing for Sage Intacct includes a number of inquiry screens, with filters to select and review the required data:

• Payments included in an EFT File,

• Payments not included in an EFT File,

• EFT files Created

The steps are similar to the initial install. You download the XML file and install it in Platform Services.

For details, refer to:Install EFT Processing Application

The release notes list new features, enhancements and fixes.

In some cases, you may need to update the EFT Roles and permissions.

There is no automatic update of the EFT Processing customizations.

If there are updates available for the Orchid EFT module, you will see the details and date of the updates on the EFT Licence screen.

Contact your Sage Intacct partner to get the update install files.

Installing an update

You can then import the package in Platform Services > Applications. See Installing an update for details.

Release Notes

Refer to EFT Processing Release Notes for details of the new features and fixes in the updates.

Hover your mouse over the icon to the right of the field label to view the details for the field. Tool tips explain what the valid options are for the field.

Note: Tool Tips are configured in the EFT Format.

Contact your Sage partner to organize a trial code or purchase a subscription.

A Licence code is required to use EFT Processing for Sage Intacct.

You can purchase separate subscriptions for EFT Processing for :

• AP Vendor Payments

• AR Customer Payments (Direct Debits)

• Employee Expenses payments

• SFTP upload

The EFT Licence screen is used to enter the activation code and to check if any software updates are available.

The installing user needs security rights to Platform Services.

You can log in to Sage Intacct as an internal user or an external user to perform the installation.

Orchid's EFT Processing is developed in the Sage Intacct environment and all data is stored in Sage Intacct.

All installation and configuration is done logged in Sage Intacct.

The Quick Start video demonstrates the steps to install and configure EFT Processing for Sage Intacct.

By default, permissions to access EFT Details on AP Vendor, AR Customer and T&E Employees are selected for all users.

You can remove access for users who do not need to view or update the EFT details on the Orchid EFT tabs.

In Sage Intacct, you need to create at least one User Role and add the role to the users who need access to EFT Processing.

Refresh the browser

After installing and updating the security, close the browser and log back into Sage Intacct.

If you don't force the refresh, it can take a while for the Orchid menus to display.

Users need at least List and View access to the EFT File Format to view Customers and Vendors in Sage Intacct, even if they don't need any access to EFT Processing.

In addition to the Sage Intacct permissions on the EFT Processing objects, you need to give some users permissions for specific EFT functions.

• Permissions to create EFT files (download to their machine or upload to the configured SFTP).

• Permissions to access the Orchid EFT Tabs for Vendors, Customers and Employees.

Most EFT file formats can be used for AP Vendors/Suppliers, AR Customers and Employee payments, if you are using the same EFT File specifications from the bank.

If using both AP and AR Payments for the same bank, you need to add two EFT bank records, one for Payment type and one for Receipt type. Both EFT Banks can use the same EFT File type.

For Employee Expenses Payments, you use a bank of type Payment.

Orchid EFT Processing supports 800+ bank formats for a variety of banks from 80+ countries. File formats supported include domestic payments in many countries, cross-border payments, positive pay, prenotes, WIRE, ACH, NACHA, CPA005, SEPA, ISO20022, BPAY, etc.

You can configure EFT Processing to validate:

• Field size: minimum and maximum length of EFT details.

• Valid values: ability to add a list of valid values for certain fields.

The EFT Quick Tip video demonstrates examples of validating fields in Orchid's EFT Processing for Sage Intacct

Many banks require the EFT file name to be unique.

Depending on how you often you process a file, you can use a combination of the date, the File Sequence  Number and the daily run number to make the file unique,

To have a unique file number if you generate multiple files for the bank on a given day, you can use a hard coded text (e.g. myfile) and fields in curly brackets in any order in your naming convention: 

When you use Orchid's EFT Processing with a SFTP licence, you can configure a bank to upload directly to SFTP.

When you create an EFT File for a bank configured for SFTP upload, the file is automatically uploaded to the configured SFTP server instead of downloaded in the browser.

EFT Processing supports SFTP with Key file and SFTP with a username and password. You can use both if your bank's SFTP server uses 2 factor authentication.

In EFT Banks, select a bank, go to the SFTP Tab.

In the Destination Type field, select SFTP Upload and enter the required field details.

The other steps to configure and use EFT Processing are the same for all output destinations.

Detailed description of all setup fields are below:

Many file formats require some company address details.

When generating the file, EFT Processing uses the details on EFT Bank for the selected EFT File Format.

Note: It is best practice to update the details for each bank.

To setup default values, you can copy the details from the Sage Intacct Company Information and amend them for the specific bank / format if required.

You need to have the required Sage Intacct security rights on the Company to read the address.

Click to See screenshot below.

Multiple bank accounts for a single vendor

If a vendor has multiple bank accounts, you need to have different vendor codes for the different vendor bank accounts as there is no way on the payment to indicate which bank details to use. You can group the vendors using the Parent feature on the AP Vendor --> Additional Information Tab

Paying some vendors by EFT and some by cheque

Suggested configuration: 

• Set the Vendor's preferred payment method to Record Transfer for vendors paid by EFT

• Set the Vendor's preferred payment method to Check for vendors paid by Check

• Do separate payment runs to select vendors by preferred payment method. You can use Advance Filters on the  Pay Bills AP screen.

  • Print the checks for all Check vendors

  • Generate an EFT File for all EFT Vendors

• If a vendor is not configured for EFT (no EFT File Type on the AP Vendor > Orchid EFT Tab), the vendor will not show on the EFT Payment request.

What payments are included in the Payment Request screen?

You can select what payment methods to show on the Payment Request screen in the EFT Bank setup screen.

If a vendor is configured with an EFT File Format on the Orchid EFT Tab, completed payments for that vendor will appear on the EFT Payment Request screen if the payment method is selected in the EFT Bank setup.

For details, refer to:Selecting Payment Method

Note: If you cannot see a payment on the EFT Payment Request screen, check the filters and check that the payment method on the AP Payment is selected for the bank and format record in EFT bank.

Licence Required

Requirement! You only see the Orchid EFT Tab for Vendor if you have a Licence for EFT Processing AP

You can import EFT Customer details using standard Sage Intacct import routines.

It is best to enter one record manually for your bank's file type, export the records. You can then update the csv file and import back on Sage Intacct.

To import the EFT file format (REFT_FORMAT), you use the actual EFT File Type name, not the EFT File Format ID which is exported.

Refer to Import EFT Customer details for tips on importing EFT Customers.

You can import details for new employees and update employee details if the employee already exists in Sage Intacct.

To import the EFT file format (REFT_FORMAT), you use the actual EFT File Type name, not the EFT File Format ID which is exported.

It is best to enter one record manually for your bank's file type, export the records. You can then update the csv file and import back on Sage Intacct.

You can import EFT Vendor details using standard Sage Intacct import routines.

It is best to enter one record manually for your bank's file type, export the records. You can then update the csv file and import back on Sage Intacct.

To import the EFT file format (REFT_FORMAT), you use the actual EFT File Type name, not the EFT File Format ID which is exported.

Refer to Importing EFT Vendor details for tips on importing EFT Vendors.