Upload EFT files to SFTP

How does it work?

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.

EFT Processing includes an extra option to upload EFT files directly to a SFTP server.

Licensing Requirements

Requirement! To upload a file directly to SFTP, users require a subscription to the SFTP module, in addition to the subscription to EFT Processing for AP, AR or employee expenses. Contact your Sage partner or Orchid for details.

Supported authentication methods

Orchid's SFTP functionality supports several authentication methods. Check the requirements with your bank.

Username and password
Username and RSA private key file
Combination of both (for banks requiring two-factor authentication)

configuration steps

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:

Field list

Destination Type	Select Download to download the file in your browser. Select SFTP Upload to upload the file to an SFTP site. Note: If you select SFTP Upload without a valid SFTP licence, you will see a warning message on the EFT Bank screen. You need a current subscription to SFTP to upload to SFTP. Although you can save the setup details, in EFT File list, the file will be downloaded in the browser until you get a valid SFTP licence.
SFTP Host Name	IP Address or name of the SFTP Server Example: 123.123.70.70 Append :port if not using default port 22 Example: 123.123.70.70:2222
SFTP User Name	Enter the User Name
SFTP Password	Enter the password
Key File	Private RSA key file. (if using) Browse to upload the key file. See details of key file format below.
Key file password	: Enter the Password applied to the key file. This is recommended to protect the file, but is optional.
Upload To Folder	Target folder on the SFTP server : "/" if you are uploading to the root directory, or "/xxx" if uploading to a folder on the SFTP server. Example: enter "/EFTFiles" to upload to the folder EFTFiles on the FTP server

Key file Setup Tips

SFTP key authentication requires an OpenSSH RSA private key.

SSH keys consist of:

A public key (*.pub) uploaded to the SFTP server (e.g. the bank's or your SFTP server)
A private key uploaded to EFT Processing

Important!

Important: EFT Processing requires the private key file.

If using a key file, you upload the private key in EFT Banks for Sage Intacct.

Key format

The private key file must contain a header and footer similar to:

-----BEGIN RSA PRIVATE KEY-----

MIIEoQIBAAKCAQEAo962U1qVeERjyfoMIwam3h+17Ei9Ddetm8UysRNOHv3ZI3YF

....

AUx+RYObNhAZ7z54RqyOMO+YXIRob0b7JXv/XpusA+BBA1eE/w==

-----END RSA PRIVATE KEY-----

Tip:

Using PuTTY Key Generator to generate the private key

Troubleshooting

Subscription error

You need an active subscription to the Orchid's EFT SFTP service to configure and use SFTP.

If the SFTP subscription expires, and you try to upload a file, you get the following error message:

You do not have a valid subscription to use SFTP

Contact your business partner or Orchid for further assistance.

Error connecting to the SFTP site

If you get error messages such as Permission denied (Password) or Bad Key File, check the details (username, password and key file) in EFT Banks on the SFTP tab.