Cutting Trade Reconciliation Time by 85% for a Miami Broker-Dealer
A mid-size broker-dealer was spending 3+ hours every day reconciling trades in Excel. EPerf replaced the process with a live blotter portal, reducing end-of-day reconciliation to under 25 minutes.
Client
A FINRA-registered broker-dealer in Miami with 22 traders across three desks — equities, fixed income, and structured products.
Problem
Each desk ran its own Excel workbook. End-of-day reconciliation required a junior analyst to manually consolidate three files, cross-reference against the prime broker feed, and email a summary to the risk desk. The process took 3–4 hours, was error-prone, and had no audit trail.
Solution
EPerf built the CapMarkets Blotter — a web-based trade entry and position tracking portal. Trades are entered in real-time, positions aggregate automatically, and end-of-day exports are generated and delivered without manual intervention.
Results
- End-of-day reconciliation: 3.5 hours → 23 minutes
- P&L discrepancies in first 6 months: 0
- Compliance sign-off workflow adopted across all three desks
- Audit log accepted by external auditors without modification