FTP document access

📘
Beta functionality
This functionality is not yet available to all partners. Contact your Relationship Manager to learn more about timing and availability.

The DriveWealth SFTP environment is a secure, centralized file delivery system that provides partners with access to operational, regulatory, and reconciliation reports. Files are delivered in standard formats and are available daily or as specified below.

Protocol: SFTP (SSH File Transfer Protocol)
Authentication: Public-key authentication (details provided during onboarding)
Availability: 24/7 access; files delivered per defined schedule

Access and authentication

Each partner will be granted access to a dedicated SFTP path. Access is controlled via public key authentication and managed through Drivewealth’s DevOps and Security teams. Partners must provide an approved public key (in the form of a .pub file) in advance of setup.

Access to UAT and Production files are authorized independently against different public keys.

File naming conventions

Each delivered file is named consistently using the following structure: [Report_Name]_yyyymmdd[_hhmmss].csv The timestamp at the end is available only for specific report types.

Example: OpenedAccounts_20250701_080101.csv

Report catalog and delivery details

Each report listed below is delivered via SFTP under the structure noted above. All times listed are New York/Eastern time.

Correspondent reports

Time: See table below
Path: /outbound/data-products/partner-catalog-v1/correspondent/yyyymmdd/[FileName]

Report Name	Format	Description	File Name	Time
Account List Report	CSV	The Account List details the full list of all client names and account numbers in relation to the specified Partner.	`{partner_corr_code} _ACTLIST_yyyymmdd.csv`	4:00 am ET
Position Report	CSV	Lists of active positions in client accounts for a specified period with security details such as symbol, security type, and name of security.	`{partner_corr_code} _POS_yyyymmdd.csv`	4:00 am ET
Activity Report	CSV	The Activity Report outlines the transactions occurring in the Partner's account for a specific period.	`{partner_corr_code} _ACTIVITY_yyyymmdd.csv`	4:00 am ET
Corporate Action	CSV	The Corporate Activity Report details all Corporate Action related activities in the customer accounts for the Partner in the specified period.	`{partner_corr_code} _CORP_ACTIVITY_yyyymmdd.csv`	4:00 am ET
Open Lots Report	CSV	The Open Lots report indicates the securities in customer accounts with trade and settled dates.	`{partner_corr_code} _OPENLOTS_yyyymmdd.csv`	4:00 am ET
Cash Sale Not Long Report	PDF	Provide a comprehensive overview of cash accounts with short positions for a specified period.	`CASHSALENOTLONG_{partner_corr_code} _mmddyyy.pdf`	8:00 am ET
New Accounts Report	PDF	This report aggregates all new accounts opened within a specific time period.	`NEWACC_{partner_corr_code} _mmddyyy.pdf`	8:00 am ET
Cash Report	PDF	This provides a comprehensive overview of daily balances of all customer accounts with detailed account balances broken out by date.	`{partner_corr_code} _CASH_yyyymmdd.csv`	8:00 am ET
90 Day Restriction Report	PDF	Lists all accounts currently in a 90-day restriction due to a good faith (GF) or pattern day trade (PDT) violation. During this 90-day period, an investor may still purchase securities with cash in the account, but the investor must fully pay for any purchase on the date of the trade	`CASH90R_{partner_corr_code} _mmddyyy.pdf`	8:00 am ET
Cash Call Report	PDF	Lists accounts that are unable to meet their cash obligations (such as funding a trade, margin requirement, or other debt) and are therefore subject to a cash call.	`CASHCALL_{partner_corr_code} _mmddyyy.pdf`	8:00 am ET
Concentration Report	PDF	This report returns accounts that have (SMV >= $50K or balances >=$50K) and combined MV of top 2 positions exceeds half of the account's margin equity value	`CONCENTRATION_{partner_corr_code} _mmddyyy.pdf`	8:00 am ET
FINRA R1 Report	PDF	The FINRA RI report shows margin debits, cash accounts, and margin account credit balances for the specified date.	`FINRAR1_{partner_corr_code} _mmddyyy.pdf`	8:00 am ET
Funds Movement Report	PDF	This report shows customer accounts' detailed withdrawal and deposit activity.	`FUNDSMOVEMENT_{partner_corr_code} _mmddyyy.pdf`	8:00 am ET
Large Trader Identification Report	PDF	This report is in compliance with SEC Exchange Act Rule 13h-1, which requires the identification of any large traders with 2 million shares or $20 million in a trading day. This report provides a list of said accounts identified as a large trader and subject to the rule	`LTID_{partner_corr_code} _mmddyyy.pdf`	8:00 am ET
Liquidation Exception Report	PDF	This report returns accounts where positions were liquidated, but the liquidation did not follow the standard margin call, house call, or maintenance margin liquidation procedures.	`LIQUIDATIONEXCEPTION_{partner_corr_code} _mmddyyy.pdf`	8:00 am ET
Margin Account Liquidation Report	PDF	This report returns accounts that failed to meet margin requirements.	`MARGINLIQUIDATION_{partner_corr_code} _mmddyyy.pdf`	8:00 am ET
Minimum Net Equity Report	PDF	Tracks the Pattern Day Trader (PDT) accounts that fall below the 25K threshold. An account flagged as a PDT is required to maintain a minimum of 25K of equity.	`MINEQUITY_{partner_corr_code} _mmddyyy.pdf`	8:00 am ET
Non-Pattern Day Trader Margin Report	PDF	This report has been replaced with a counter on DriveHub under the Pattern Day Trading tab.	`NONPATTERNDT_{partner_corr_code} _mmddyyy.pdf`	8:00 am ET
TEFRA Non-Resident Withholding Report	PDF	This report returns accounts that are non-U.S. person with details on types of the payment and the withholding rate.	`NRATEFRAWITHHOLDING_{partner_corr_code} _mmddyyy.pdf`	8:00 am ET
2% Holding Report	PDF	This report shows any clients holding 2% of a specific security	`TWOPERCENTHOLDINGS_{partner_corr_code} _mmddyyy.pdf`	8:00 am ET
Good Faith Violation	PDF	This report return the list of account with GFV flags	`GOODFAITHVIOLATION_{partner_corr_code} _mmddyyy.pdf`	8:00 am ET

Trade Recap reports

🚧
This report is only available for DVP accounts.

Time: Account-specific
Path: /outbound/data-products/partner-catalog-v1/TradeRecap/yyyymmdd/TradeRecap_<AccountNo>_<NetOrGross>_yyyymmdd_hhmmss.csv

Non-Custody Fails report

🚧
This report is only available for DVP accounts.

Time: 4:00 PM
Path: /outbound/data-products/partner-catalog-v1/fail_report/yyyymmdd/nc_fail_report_ yyyymmdd_hhmmss.csv