How to Upload Vendor Bank Accounts to Fidesic

If you have your vendor banking information stored in a separate system (like your ERP), you can upload this information in flat file format into Fidesic

Overview

When you start using Fidesic for ACH you may have existing vendor banking information that you need to migrate into Fidesic. You can upload vendor banking info using our flat file uploader. 

Note: Once uploaded, this information is stored in an encrypted form and will not be visible to anyone. The flat file you created for uploading should be destroyed appropriately after upload. 

Process

Login to Fidesic and navigate to your Import Files page. 

Select the Vendor Bank Accounts import

Note: This import is only available to the Fidesic Account Owner. If you're not sure who is the account owner, head to the Manage Users page and look for the Account Owner Tag. 

Upload your flat file with the required column headers. This will attach Vendor Banking information to your vendor records. The next time you upload a batch of payments you can pay these vendors via ACH. 

SQL Script to Pull Vendor Banking info From GP. 

SELECT 
    pm.VENDORID, 
    sy.BANKNAME,
    sy.EFTBankAcct,
    sy.EFTTransitRoutingNo
FROM PM00200 pm
LEFT JOIN SY06000 sy ON pm.VENDORID = sy.VENDORID