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.
How do I add vendor bank account information to Fidesic?
You can add vendor bank account information to Fidesic by uploading an import file through the Import Files page or by entering it manually on an individual vendor card. Use the import method to migrate multiple vendors at once; use the vendor card method to add, update, validate, or remove a single vendor's banking details.
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.
How do I add bank accounts to multiple vendors at once?
Your role needs the Manage Vendors and Manage Vendor Bank Accounts permissions, plus at least one admin permission. Without them, the Vendor Bank Accounts import isn't listed.
- Go to gear menu → Import Files.
- Select the Vendor Bank Accounts import.
- Upload your file. Use these column headers, with one bank account per row:
- Vendor ID: the vendor ID as it appears in your accounting system
- Nickname: a name for the account, such as the vendor's bank name
- Bank Account: the vendor's bank account number
- Routing Number: the vendor's bank routing number

The headers must match these names. A file whose columns are named differently, such as GP's EFTBankAcct, is rejected. In Excel, format the Bank Account and Routing Number columns as text so numbers keep their leading zeros.
Fidesic attaches the banking information to your vendor records. The next time you upload a payment batch, you can pay these vendors by ACH.
How do I manage the bank account for a specific vendor?
To add, view, update, or remove a bank account for a single vendor:
- Open the vendor's card in Fidesic.
- Click the Bank Account tab.
- If a bank account is already on file, its details are shown, with a delete button to remove it.
- If no bank account is on file, click Add Bank Account and enter the account details.

How do I pull existing vendor banking information from Dynamics GP?
This query returns GP's vendor EFT bank details with the column headers the import expects. Save the results as a spreadsheet and upload it.
SELECT
pm.VENDORID AS [Vendor ID],
sy.BANKNAME AS [Nickname],
sy.EFTBankAcct AS [Bank Account],
sy.EFTTransitRoutingNo AS [Routing Number]
FROM PM00200 pm
JOIN SY06000 sy ON pm.VENDORID = sy.VENDORID
WHERE sy.EFTBankAcct <> ''