Broker Reconciliation

Comprehensive reconciliation of broker positions, prices, margins and fees.

Current Business Challenges

EPIC addresses the most challenging obstacles faced by businesses today.

Connecting to multiple broker accounts and aggregating the information in one place

Reconciling intra-day and end-of-day trade attributes and open positions in internal trade capture systems to those reported by brokers

Calculating and reconciling broker fees

Calculating the Initial and Maintenance margin using the SPAN tools provided by ICE and CME as well as verifying the broker invoices

Top Day Trade Reconciliation

The Broker Reconciliation App allows users to run intraday trade reconciliations to ensure there are no errors in trade entries.

  • Capture today’s trades from the customer’s trade capture system, and automatically align them with the trades downloaded from brokers.
  • Reconcile the trades across a user-defined set of attributes and tag the trades that show a mismatch.
  • Easily drill down to the trades for more in-depth analysis.
  • Easily maintain the master list of exchange products being traded in the portfolio.

End-of-Day Position Reconciliation

The end-of-day open positions reconciliation feature in RPM’s Broker Reconciliation App seamlessly identifies breaks in the total open positions across all exchange-traded products.

  • Automatically aggregate all open trades across multiple broker accounts and reconcile with the open positions information downloaded from brokers.
  • Identify gaps in the errors as well as the marks against the values reported by brokers.
  • Archive reconciliation results for trend analysis
  • Easy drill-down to the trade level details on data captured from the customer’s own trade capture system as well as the data downloaded from brokers.
  • Generate Excel-based reports, which allow users to further analyze the breaks.
  • Timely report availability at the start of the business day.

Broker Fee Reconciliation

The Broker Reconciliation App comes with a powerful fee calculation and reconciliation feature. Customers can independently verify the fees charged by brokers before paying them.

  • Calculate and reconcile the following types of fees:
    • Clearing Fee
    • Exchange Fee
    • NFA Fee
    • Execution Fee
    • Broker Commission
  • Easily drill down to the trade level details on data captured from the customer’s own trade capture system as well as the data downloaded from brokers.
  • Archive reconciliation results for trend analysis

Margin Reconciliation

Get a comprehensive toolkit to calculate initial and maintenance margins using the Standard Portfolio Analysis of Risk (SPAN) margin system. The broker tool provides user-friendly front-end access to the SPAN margin system provided by CME and ICE.

  • Built-in wrapper around the SPAN margin calculators provided by ICE and CME
  • Out-of-box connectivity to ICE and CME Risk Arrays ISO monthly billing JE
  • Easy maintenance of SPAN settings using the intuitive settings panel in the Broker Reconciliation App.
  • Automatically determine when positions roll-off based on contract expiration dates, which are defined by an exchange holiday calendar and a date rule, usually articulated verbally in exchange rules.
  • In addition to the Initial and Maintenance margin, the app also computes Open Trade Equity, Net Option Value and Margin Excess.

Other Features

Easy integration with powerful business intelligence tools like Tableau and Power BI

Intuitive Mappings UI

Easy maintenance of SPAN settings using the intuitive settings panel of apps

Trend analysis of open positions and margins across all FCM accounts and exchanges

Re-run reconciliation post trades are finalized in trade capture system to resolve exceptions

Plug n Play Apps

Purpose-built apps to support critical business functions from day one.

Get Started Today

Talk With An Adviser

Request a Demo