Data Exchange & File Options
The DDM Program relies on the exchange of data between the Participating Institution and R&T. Depending on the institution's technology stack and volume, this exchange is managed through either an automated file process or a manual "DDM Lite" self-service process.
Role of Data Exchange
The Data Exchange layer is responsible for:
- Receiving inbound data from Participating Institutions
- Validating and normalizing data formats
- Ensuring data integrity prior to processing
- Distributing outbound data and reporting
This layer abstracts differences across core systems and integration methods, enabling consistent processing within the DDM Program.
Data Exchange Methods
Participating Institutions can exchange data with R&T using one of the following methods:
- File-Based – The most common approach, using batch file transfers aligned to end-of-day or scheduled processing
- API-Based – Enables programmatic, real-time or near real-time interaction with DDM Program capabilities
- Portal-Based (CAP / DDM Lite) – Manual, user-driven interaction through the Client Access Portal (CAP)
The appropriate method depends on:
- Core system capabilities
- Transaction volume
- Desired level of automation
Automated Process (Standard)
Most Participating Institutions use automated file transfers generated during their end-of-day (EOD) processing. R&T works with various software providers (e.g. bank core processors, trust system accounting platforms) and service bureaus to facilitate these connections.
Intake Files from Participating Institution to R&T
-
Account Registration File: Used to open new accounts or update existing account details.
-
Transaction File: Contains the daily deposit and withdrawal activity.
If a transaction is received for an account not yet created, the system will automatically open a "no registration" template account to prevent deposit transactions from being rejected.
Note: Accounts without registration data cannot receive access to deposit insurance coverage until data is provided.
Outbound Files from R&T to Participating Institution (Optional)
-
Balance File: Provides daily Customer balances and Month-to-Date (MTD) accrued interest.
-
Client Deposits per Bank (CDB) File: Lists account balances at each specific Receiving Institution for transparency.
-
Interest Posting File: Available in ASCII or NACHA formats to record interest credits.
-
Automated Entry/GL File: A customized file formatted to automate the posting of daily entries (e.g., accruals)to the institution's General Ledger.
Non-Automated Process (DDM Lite)
For Participating Institutions that do not utilize automated file transfers, R&T provides a manual option. This requires the use of the Client Access Portal (CAP) to utilize the self-service capabilities to manage account creation/updates and transaction activity.
Note: DDM Lite users do not receive outbound files from R&T.
Data Exchange Responsibility Models
Depending on the institution’s setup, data may be transmitted by:
- The Participating Institution directly
- A Core Processor or service provider on behalf of the Participating Institution
- A third-party system aggregating or managing data transmission
This impacts:
- File format alignment
- Testing coordination
- Ongoing operational support
Core Integration
R&T maintains relationships with many core banking processors and trust accounting system platforms. Implementation requirements vary by provider. Contact your Relationship Manager or Sales Executive to discuss existing integrations and determine the appropriate implementation approach for your organization.
-
Modules: Some providers require a specific software module to generate R&T-compatible files.
-
Queries: Other providers use specific database queries to extract the necessary registration and transaction data.
-
Core Fact Sheet: Technical specifications for file formats, headers, and required fields are provided during implementation and onboarding.
API-Based Integration (Advanced)
In addition to file-based exchange, some Participating Institutions may integrate with R&T using APIs.
APIs enable:
- Real-time or near real-time data exchange
- Programmatic access to account and transaction data
- Reduced reliance on batch file processing
API adoption depends on:
- Core system capabilities
- Integration maturity of the institution
What's Next
- Learn how account registration data is used to help maximize access to deposit insurance coverage in Account Ownership Category Allocation Methods.
Updated 18 days ago
