Guides
  1. DDM
  2. Reports Guide

DDM Reports Matrix

This matrix provides a comprehensive overview of all standard reports generated within the DDM Program.

ReportDescriptionReport NameAvailable FormatUse CaseFrequencyDelivery ProtocolDelivery/Available Time
eJournal Transaction ReportDisplays the total deposits and total withdrawals contained in the transaction file and any exception transactions.eJournal Transaction Report - BXXXXText (IDP version available but not widely used)Used by OPS group to determine differences, if any.DailyEmail and available on CAPAvailable after each transaction file is processed; multiple reports produced if multiple files exist.
Net Settlement ReportDisplays the net activity/settlement amount for the day. Generated after the transaction file (or manual trade request) is processed. Emailed to the client for confirmation. Client must reply to the email indicating whether they agree or disagree with the amount. Report is sent even if no transaction activity for the day. Available versions include: - Separate settlement at the Office code level (used for Fintech relationships)DDM Net Settlement (Net Wire) - BXXXTextUsed by OPS group to confirm daily settlement figureDailyEmail and available on CAPAvailable after each transaction file or manual trade request form is processed. If multiple transaction files or manual trade requests are received, multiple net settlement emails will be produced.
Net Wire Transfer InstructionsAuthorization to initiate internal transfers and/or wire funds to/from the SCGII deposit account. Sent only when there is activity. On the first business day of the month, transfer instructions include details on the fee owed to R&T for using the program.DDM Net Wire Transfer Instructions (Client Name)PDFUsed by OPS group, provides instructions to move funds for daily settlementDailyEmail and available on CAPAvailable after allocation is run, approximately 1:30 pm ET & 4:00 pm ET. Will only be generated if there is activity.
Daily Position ReportProvides a reconciliation of the “send” and “receive” side of the reciprocal relationship, resulting in the net settlement transfer / wire amount for the day. Receive side: Displays the SCG II deposit account’s beginning balance, daily net activity, closing balance and the MTD interest and fee accruals. Send side: Displays the beginning balance, daily net activity and ending balance for the deposits your customers have in the DDM Program. Also displays fee income accrual as a send institution.DDM - MMDA/DDA DAILY REPORT – ####CSVUsed by OPS & Accounting groups, provides daily information for send & receive side balances & accrualsDailyEmail and available on CAPAvailable end of day each business day approximately between 5:30 pm - 7:30 pm ET
Month End Position ReportDisplays closing account balances and interest totals for the period, the DDM fee to be wired to SCGII and the interest settlement for the period. Instructions to credit interest to the SCGII account, wire the DDM fee, and other internal book entries and wires to be executed on the first business day of the following month are noted.DDM - MMDA/DDA DAILY REPORT – ####CSVUsed by OPS & Accounting groups, provides month end settlement instructionsDailyEmail and available on CAPAvailable end of day on the last business day of the month, approximately between 5:30 pm - 7:30 pm ET
Month End Position Report - Omnibus Reciprocal VersionSpecific to Omnibus Reciprocal Relationships - Displays closing account balances and interest totals for the period, the DDM fee to be wired to SCGII and the interest settlement for the period. Instructions to credit interest to the SCGII account, wire the DDM fee, and other internal book entries and wires to be executed on the first business day of the following month are noted.DDM - MMDA/DDA DAILY REPORT – ####CSVUsed by OPS & Accounting groups, provides month end settlement instructions for omnibus reciprocal relationshipsDailyEmail and available on CAPAvailable end of day on the last business day of the month, approximately between 5:30 pm - 7:30 pm ET
Client Bank Balance ReportDisplays the total account balance and allocation of the balance across Program Receiving Institutions for each customer account, the customer’s interest rate, MTD interest accrued, interest posted at month-end, and YTD interest paid.Grand totals are provided at the end of the report.Available versions include: -DUMMY CUSIP version for trust clients -Office code version for clients that need info separated by Office codeDDM Client Bank Balance Report - BXXXCSV & PDFUsed by OPS group, provides daily breakdown of end customers in DDMDailyEmail and available on CAPAvailable end of day on the last business day of the month, approximately between 5:30 pm - 7:30 pm ET
Customer Interest Tier Exception ReportDisplays exceptions to a request to change a Tier Set ID on an existing account or set up a new account with an invalid Tier Set ID (e.g. A request to change a Tier Set ID from T1 to T2 on account 12345 was included in the Account Registration file, but Tier Set ID T2 does not exist).DDM Tier Exception Report - BXXXTextUsed by OPS group, provides daily exceptions to tier set assignments, if anyDailyEmail and available on CAPAvailable after allocation is run, approximately 1:30 pm ET & 4:00 pm ET. Will only be generated if an account registration file is received.
Uninsured Accounts ReportDisplays accounts within the same SSN/TIN that are uninsured.Uninsured Accounts Report - BXXXExcelUsed by OPS group, provides information on uninsured accounts, if anyDaily/On-DemandEmail and available on CAPAvailable after allocation is run, approximately 1:30 pm ET & 4:00 pm ET. Will only be generated if an account has uninsured funds.
Customer Deposits Held at Bank ReportDisplays minimal data on the underlying accounts comprising the balance in the SCGII account at the bank. The information on the report can be used for audits or examinations, and as input to the bank’s Call Report.#### DDM as Agent for Client InvestorsTextUsed by OPS group, provides information on balances being reciprocated back to the clientDailyEmail and available on CAPAvailable end of day on the last business day of the month, approximately between 5:30 pm - 7:30 pm ET
Compensation WorkbookDifferent versions produce depending on if client is Send Only or Reciprocal. If Send Only: Displays daily DDM balance, program rate & accrual with totals on bottom. If Reciprocal: Displays Send Side Balance, Program Rate, Accrual, Pre-paid Interest, Send Side Shortfall, Receive Side Shortfall, Receive Side Balance, Reciprocal Admin Fee Rate, Reciprocal Admin Fee Expense, Send Side Customer Interest Accrual, Receive Customer Interest Accrual, Interest Differentials with totals on the bottom.DDM Compensation Workbook - BXXXCSV & PDFUsed by OPS & Accounting groups, provides breakdown of balances, rates & interest accruing in the DDM programDailyEmail and available on CAPAvailable end of day on the last business day of the month, approximately between 5:30 pm - 7:30 pm ET
DDM Program Update NoticeDisplays the current DDM Program Rate, the current FDIC insurance limits, and a link to the list of participating receiving institutions.Demand Deposit Marketplace (DDM) Program Update Notice (BXXX)HTMLUsed by OPS & Business groups, displays current rate that is set along with a current list of receiving institutions.WeeklyEmail and available on CAPAvailable weekly, every Monday (or first business day of the week) by noon ET
Rate UpdateDisplays the current rate assigned to the SCGII account opened with the client.#### DDM Rate UpdateTextUsed by OPS groups, displays current rate assigned to the SCGII accountOn-DemandEmail and available on CAPGenerated only when the rate on the SCGII account is reset.
Call ReportDisplays information to assist the client with completing their Call Reports.Quarterly Call Report - ### - BXXXPDFUsed by OPS & Business groups, displays information to assist client with completing their Call ReportQuarterlyEmailGenerated by the 2nd business day after quarter end
Data Warehouse - Account BalanceDisplays information related to the customer accounts that were sent into DDM, including account #, title, balance, accrual, rate, branchAccount-Balance-####CSVUsed by OPS, displays information related to customers in the DDM programDailysFTP and available on CAPAvailable end of day each business day approximately between 7:30 pm - 9:30 pm ET
Data Warehouse - Daily TransactionDisplays information related to transactions received on the transaction file, including account number, amount processed, transaction type & errors.Daily Transaction-####CSVUsed by OPS, displays information related to daily transactions receivedDailysFTP and available on CAPAvailable end of day each business day approximately between 7:30 pm - 9:30 pm ET
SAOC Exception ReportDisplays information and instructions on how to treat exceptions caused by uninsured balances due to account ownership categories.SAOC_Exception.BXXXExcelUsed by OPS to clear exceptions related to uninsured balancesOn-DemandEmail and available on CAPGenerated end of day after final allocation if exceptions exist
Accounts Approaching Insurance Coverage Limit ReportDisplays information and instructions on how to treat accounts approaching the insurance coverage limitBXXX_AccountsApproachingInsuranceCoverageLimitTextUsed by OPS to clear exceptions related to accounts approaching possible uninsured scenariosOn-DemandEmail and available on CAPGenerated end of day after final allocation if scenario exist

Where "BXXX" is the assigned Client ID

Where "####" is the # assigned in the DDM Program

Updated 18 days ago

Did this page help you?

R&T Deposit Networks, LLC, R&T Deposit Marketplace, LLC, R&T Deposit Solutions, LLC and R&T Deposit Programs, LLC (each d/b/a R&T Deposit Solutions), each a Delaware limited liability company, (together, “R&T”) provide administrative, recordkeeping, and/or other services to banks, credit unions, trust companies, wealth management firms, broker-dealers and other institutions with respect to deposit placement and sweep programs, including the Demand Deposit Marketplace® (DDM®), Certificate of Deposit Marketplace Exchange℠ (CDMX℠) and R&T Insured Deposits℠ (RTID®) programs, as well as other services. An affiliate of R&T, Stable Custody Group II LLC (“Stable”), acts as agent of participating sending institutions under the DDM and CDMX programs. R&T and Stable, together, “we”, “us” or “our”. All of our services are provided subject to the terms and conditions of the written agreements and/or agency appointments between us and our clients with respect to those services, and we provide no representations or warranties, express or implied, except as expressly set forth in those written agreements and/or appointments. Click here for our legal and other disclosures. We are not an FDIC or NCUA-insured institution. FDIC insurance only covers the failure of an FDIC-insured institution. NCUA insurance only covers the failure of an NCUA-insured institution. Certain conditions must be satisfied for FDIC and NCUA pass-through deposit insurance coverage to apply. Click here for a list of the FDIC and NCUA-insured institutions with which R&T has a direct or indirect business relationship for the placement of deposits under the DDM, CDMX, and RTID programs, and into which a participating institution may place deposits (subject to the terms of those programs and any opt-outs by the participating institution and/or its customers). While the DDM, CDMX, and RTID programs provide access to an expanded level of FDIC or NCUA deposit insurance coverage on funds placed into the programs (subject to program terms and applicable laws, regulations and guidance, including pass-through insurance coverage requirements), the DDM, CDMX and RTID programs, themselves, as well as our other service offerings, are not insured or guaranteed by the FDIC or NCUA, are not deposits, and may lose value. We are not an affiliate of an FDIC or NCUA-insured institution, we are not an office, division, or sub-division of the FDIC or NCUA, and we are not associated with the FDIC or NCUA or office, division, or sub-division thereof. The primary objective of the DDM, CDMX, and RTID programs is to provide customers with convenient access to expanded deposit insurance coverage on their funds (and not for investment enhancements, higher rates of returns or profits). R&T®, Reich & Tang®, Demand Deposit Marketplace®, DDM®, DepositView®, CDMX®, and RTID® are registered marks, and R&T Direct℠ is a pending mark of R&T Deposit Networks, LLC. of R&T Deposit Networks, LLC. IDEA℠, Certificate of Deposit Marketplace Exchange℠, R&T Insured Deposits℠ are unregistered service marks of R&T Deposit Networks, LLC.

© 2026 R&T Deposit Networks, LLC

Privacy Policy Privacy Policy – CA Terms of Use Legal Disclosures Receiving Institution Lists DDM Program Limit Do Not Share My Personal Information Cookies