Upload EFT files to SFTP

How does it work?

When you create an EFT File for a bank configured for SFTP using Orchid's EFT Processing with a SFTP licence, the file is automatically uploaded to the configured Site 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 FTP uses 2 factor authentication.

EFT Processing includes the option to upload EFT files directly to SFTP.

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.

configuration steps

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

In the Destination Typefield, 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.

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 FTP site : "/" 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

SSH keys are made up of two keys - a public key and a private key.

You upload the public key to the FTP server (e.g. the bank's FTP site or your FTP Site). The file name for the public key is *.pub.

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

Key format

You need to use an OpenSSH key using the RSA format.

The Header & Footer row should look like this:

-----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.