User Guide
Automated Trade Reconciliation System — everything you need to get started.
Overview
The Automated Reconciliation System matches trade records against settlement records to identify discrepancies in amounts, quantities, and timing. It also supports triangular reconciliation — verifying that net settlement movements agree with held positions.
Trade ↔ Settlement
Match trade orders with their corresponding settlement confirmations. Detect amount, quantity, and timing differences.
Triangular Recon
Verify settlement movements against position records for three-way consistency: Trade → Settlement → Position.
Analytics Dashboard
Real-time KPIs, trend charts, and breakdowns by symbol, counterparty, and discrepancy type.
Workflow
Import Data
Upload CSV files
Create Batch
Configure & run
Review Results
Matched & unmatched
Resolve Discrepancies
Investigate & resolve
Import Data
Navigate to the Import page to upload your trade, settlement, and position data as CSV files.
CSV Format Requirements
| Data Type | Required Columns |
|---|---|
| Trades | trade_id, trade_date, symbol, side, quantity, price, amount |
| Settlements | settlement_id, trade_date, settlement_date, symbol, side, quantity, price, amount |
| Positions | account_id, symbol, quantity, cost_basis, trade_date |
Optional Columns
These columns are optional but improve matching accuracy:
account_id— Account identifier for filtering and position reconciliationcounterparty— Counterparty/broker name for analytics breakdown
Tip: You can also click "Generate Sample Data" on the Dashboard to populate the system with realistic demo data and see how everything works.
Reconciliation
The Reconciliation page is where you create and run matching batches.
Create a Batch
Click "+ New Batch" and give it a name. Check "Enable Triangular Reconciliation" if you have position data and want three-way verification.
Run the Batch
Click "Run" to start matching. The system will match trades to settlements based on symbol, side, amount, quantity, and date proximity.
View Results
Once complete, click "View" to see matched pairs and discrepancies. Use the All / Matched / Unmatched filter tabs to focus on what matters.
Matching Rules
| Criteria | Description |
|---|---|
| Symbol | Must match exactly (e.g., AAPL ↔ AAPL) |
| Side | Must match (BUY ↔ BUY, SELL ↔ SELL) |
| Amount | Tolerance: configurable threshold (default $1.00) |
| Quantity | Must match exactly |
| Date | Trade date within configurable window (default ±1 day) |
Triangular Reconciliation
When enabled, the system performs a second phase after trade-settlement matching:
Step 1: Match trades to settlements (standard reconciliation)
Step 2: Group matched settlements by (account_id, symbol)
Step 3: Compute net quantity and net amount per group
Step 4: Compare net values against position records
Step 5: Flag any position-level discrepancies
Note: Position data must be imported before running triangular reconciliation. Without positions, only trade-settlement matching will be performed.
Discrepancy Management
The Discrepancy page lets you track and resolve all identified mismatches.
Discrepancy Types
Resolution Workflow
Dashboard
The Dashboard provides an at-a-glance view of your reconciliation health.
KPI Cards
- Total Batches — Number of reconciliation batches
- Open Discrepancies — Pending items needing attention
- Match Rate — Overall matching percentage
- Total Records — Trades + settlements processed
Charts
- Match Rate Trend — Last 7 completed batches
- Discrepancies by Type — Breakdown of AMOUNT, QUANTITY, etc.
- By Symbol — Which securities have most discrepancies
- By Counterparty — Which brokers have issues
- Discrepancy Trend — Daily new vs. resolved counts
Quick Start
Get up and running in under a minute with sample data:
Generate Sample Data
On the Dashboard, click "Generate Sample Data". This creates ~100 trades, settlements, and positions with a realistic discrepancy rate, then automatically runs reconciliation.
Explore the Dashboard
View KPIs and charts. The match rate, discrepancy breakdowns, and trends are now populated with data.
Review Reconciliation Results
Go to the Reconciliation page, click "View" on the completed batch. Filter by Unmatched to see discrepancies with full trade/settlement details.
Manage Discrepancies
On the Discrepancy page, filter by type or status. Click a discrepancy to view details and resolve it with notes.
Reset Anytime
Click "Clear Data" on the Dashboard to wipe everything and start fresh — either with new sample data or your own CSV imports.
FAQ
What file format is supported for import? ▼
CSV (comma-separated values) files with a header row. UTF-8 encoding is recommended. Date fields should be in YYYY-MM-DD format.
How is the match rate calculated? ▼
Match Rate = (Matched Pairs × 2) ÷ (Total Trades + Total Settlements) × 100%. Each matched pair covers one trade and one settlement, so the denominator counts all records that participated in matching.
What happens if a trade has no matching settlement? ▼
It's flagged as an UNMATCHED result with a MISSING discrepancy type. This appears in the Reconciliation results and the Discrepancy management page for investigation.
Can I run reconciliation multiple times? ▼
Each batch can only be run once. However, you can create multiple batches with the same data. Previously matched results are cached — running a batch that was already completed returns the existing results (idempotent).
What does triangular reconciliation add? ▼
Standard reconciliation only verifies Trade ↔ Settlement. Triangular adds Settlement ↔ Position verification: it groups net settlement movements by account and symbol, then checks whether the computed net matches the actual position held. This catches issues like missing settlements, incorrect position bookings, or corporate action adjustments.
How do I resolve a discrepancy? ▼
Go to the Discrepancy page, find the item, and click the Resolve button. You can add resolution notes (e.g., "Broker confirmed late settlement") and the status changes from PENDING → RESOLVED.