This guide will help you set up a Secure File Transfer Protocol (SFTP) connection to share daily transaction data with ModernFi. By following these steps, you'll streamline the process for sharing transaction information, eliminating the need for manual report generation and uploads through ModernFi's Admin Portal

What We Need from You

1. ModernFi will need your financial institution's IP address to whitelist on our server

What ModernFi Will Provide

1. Transactions template file: This is our standard file format that we use to ingest daily transaction data

   
   

2. Private key for SFTP authentication

3. Connection details

Setting up the SFTP Connection

Step 1: Review the Transaction File Format

1. File Format: CSV
2. File Naming Convention: TRANSACTIONS_YYYY-MM-DD.csv
3. Destination Folder on ModernFi's SFTP Server: /transactions/
4. Frequency: One file per day, capturing all activity in the previous 24-hour period

Required Fields

• institution_account_id: internal institution account ID
• amount: Positive for deposits, negative for withdrawals
• transacted_at: UTC time in ISO 8601 format
• institution_transaction_id: internal institution transaction ID

Optional Fields

• description: open string for additional transaction information

Step 2: Receive Authentication Credentials

ModernFi will provide you with

• A private key (sent via SendSafely)
• SFTP server username (e.g., sftp-user-[YourInstitutionName])
• SFTP server host: sftp.prod.modernfi.com

Step 3: Configure Your SFTP Client

1. Install an SFTP client (e.g., FileZilla, WinSCP, or command-line sftp)
2. Set up a new connection with the following details
   1. Host: sftp.prod.modernfi.com
   2. Port: 22 (default SFTP port)
   3. Username: provided by ModernFi
   4. Authentication method: Key file
   5. Key file: Use the private key provided by ModernFi

Step 4: Test the Connection

1. Attempt to connect to the SFTP server using the provided credentials
2. Navigate to the "/transactions/" folder
3. Try uploading a test file to ensure write permissions are correct

Step 5: Automate File Transfers

Set up an automated process to:

1. Generate the daily transaction file in the required format
2. Name the file according to the convention "TRANSACTIONS_YYYY-MM-DD.csv"
3. Transfer the file to the "/transactions/" folder on ModernFi's SFTP server

Troubleshooting

If you encounter issues with the private key, you may need to modify its permissions:

bash
chmod 600 private_key.pem

For command-line connections, use:

sftp -i {{YourInstitutionName}}_private_key.pem sftp-user-{{YourInstitutionName}}@sftp.prod.modernfi.com

Support

If you encounter any issues during the setup process or have questions, please contact ModernFi's support team ([email protected]) or your dedicated Account Manager for assistance