FTP document access
Beta functionalityThis 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 | 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 | This report aggregates all new accounts opened within a specific time period. | NEWACC_{partner_corr_code} _mmddyyy.pdf | 8:00 am ET | |
| Cash Report | 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 | 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 | 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 | 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 | 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 | This report shows customer accounts' detailed withdrawal and deposit activity. | FUNDSMOVEMENT_{partner_corr_code} _mmddyyy.pdf | 8:00 am ET | |
| Large Trader Identification Report | 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 | 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 | This report returns accounts that failed to meet margin requirements. | MARGINLIQUIDATION_{partner_corr_code} _mmddyyy.pdf | 8:00 am ET | |
| Minimum Net Equity Report | 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 | 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 | 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 | This report shows any clients holding 2% of a specific security | TWOPERCENTHOLDINGS_{partner_corr_code} _mmddyyy.pdf | 8:00 am ET | |
| Good Faith Violation | 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
Updated 9 months ago
Did this page help you?