Blotter

Blotter — Meaning, Definition & Full Explanation

A blotter is a chronological record of all trades executed by a trader or trading desk during a specific period, typically one trading day. It captures essential trade details—including execution time, price, quantity, security name, buy/sell direction, and settlement status—and serves as the primary audit trail for trade verification and reconciliation. Blotters are mandatory in regulated markets and are generated automatically by trading platforms or broker software.

What is Blotter?

A blotter is a real-time or end-of-day transaction log that documents every trade executed in equity, foreign exchange (forex), bond, commodity, or derivative markets. The term originates from the physical ledgers ("blotting pads") that traders once used to record trades by hand; modern blotters are digital records maintained in trading software.

The blotter functions as the source document for trade management. It includes not only completed trades but also cancelled or rejected orders, partial fills, and amendments. Each entry contains the trade timestamp, instrument identifier (ISIN, ticker, or contract code), quantity, execution price, counterparty or venue details, and the trader's unique identifier.

Blotters are customizable—traders can add fields such as profit/loss, strategy tags, counterparty credit ratings, or market conditions. They are used across all asset classes and serve three critical functions: (1) intraday monitoring to track P&L and risk exposure, (2) end-of-day reconciliation with counterparties and clearing houses, and (3) compliance and audit purposes. Regulatory authorities require brokers and trading firms to maintain blotters for specified periods (typically 5–7 years) as evidence of proper order handling and best execution.

How Blotter Works

The blotter creation process begins the moment a trader enters an order into the trading system:

1. Order Entry & Timestamp: The trader submits a buy or sell order. The trading platform automatically records the order time (to milliseconds) and assigns a unique order ID.

2. Execution Recording: When the order is matched on an exchange or with a counterparty, the blotter captures the execution time, fill price, filled quantity, and venue. If the order is partially filled, each fill generates a separate blotter entry.

3. Data Population: The platform automatically populates fields such as security code (ISIN or ticker), trade type (equity, bond, forex), settlement date, and counterparty name. Certain fields (trader ID, desk, strategy) are pre-configured for the trader.

4. Status Tracking: The blotter records whether the trade settled, failed, was cancelled, or was amended. Pending trades remain visible until final settlement confirmation is received from the clearing house.

5. Intraday Review: Throughout the trading day, the trader can filter and sort the blotter by security, counterparty, or P&L to monitor open positions and risk exposure.

6. End-of-Day Reconciliation: At day-end, the blotter is compared against (a) exchange/clearing house confirms, (b) counterparty advices, and (c) the back office settlement system. Discrepancies trigger investigation.

7. Export & Archival: The final blotter is exported (usually to CSV or PDF), signed off by the trader and supervisor, and archived for compliance and audit trails.

Variants include intraday blotters (trades during the day) and settlement blotters (trades by settlement status), both accessible within the same system.

Blotter in Indian Banking

In India, the blotter is a regulatory requirement under RBI and SEBI guidelines. SEBI's regulations on broker conduct and best execution practices mandate that all trading firms maintain detailed blotters as contemporaneous records of trades. The RBI requires scheduled commercial banks engaged in forex and money market trading to maintain blotters that are reconciled daily.

Major Indian brokers—including HDFC Securities, Motilal Oswal, Zerodha, and bank-affiliated arms (SBI Securities, ICICI Direct)—provide blotter modules within their trading platforms. NSE (National Stock Exchange) and BSE (Bombay Stock Exchange) settlement systems integrate with broker blotters to ensure all trades are accounted for in the clearing and settlement process.

For treasury operations in banks, the blotter is critical for recording forex forwards, interest rate swaps, government securities trades, and call money transactions. The RBI's Master Direction on Over-the-Counter (OTC) Derivatives and the Liquidity Management Framework require banks to maintain blotters as part of their risk management and audit framework.

Blotters are relevant to JAIIB (Juniors' Associate, Indian Institute of Bankers) syllabi under modules covering treasury operations and trade settlement. Candidates studying for CAIIB (Certified Associate, Indian Institute of Bankers) encounter blotters in advanced treasury and compliance contexts.

The blotter's retention period in India aligns with SEBI's record-keeping norms (typically 5 years for equity trades and 7 years for commodity trades), and breaches of blotter maintenance attract penalties under the Securities Contracts (Regulation) Act, 1956.

Practical Example

Priya is a junior trader at ABC Securities Ltd, a Delhi-based stock broker. On 15 January 2024, she receives a client order to buy 5,000 shares of Reliance Industries (ISIN: INE002A01018) at ₹2,850 per share.

At 9:47 AM, Priya enters the buy order on the NSE trading terminal. The blotter automatically records Order ID #RJ4521, timestamp 09:47:32, and order type as "Buy, Reliance, 5000 shares, Limit ₹2,850."

At 10:02 AM, 3,000 shares are filled at ₹2,849, and at 10:15 AM, the remaining 2,000 shares are filled at ₹2,851. The blotter now shows two separate trade records:

• Trade 1: 10:02 AM, Buy, 3,000 @ ₹2,849 = ₹8,547,000
• Trade 2: 10:15 AM, Buy, 2,000 @ ₹2,851 = ₹5,702,000

At 3:30 PM (end of trade), Priya reviews her blotter and verifies that both trades are marked as "Settled" by NSDL (National Securities Depository Limited). She adds internal notes: "Client order #CL2984, Strategy: Value pickup." At 4:00 PM, she exports the blotter and files it in the firm's trading records system, where it will be retained for audit and compliance review.

Blotter vs Trade Confirmation

Aspect	Blotter	Trade Confirmation
Purpose	Internal audit trail and position tracking	External proof of trade to counterparty/client
Timing	Real-time or end-of-day	Usually within 24 hours of trade
Detail Level	Highly detailed; includes cancelled/amended orders	Simplified; only confirmed trades
Audience	Trader, compliance, back office, auditors	Client, counterparty, settlement system
Retention	5–7 years (regulatory requirement)	5 years minimum (client records)

The blotter is an internal document for the trading firm's own use and compliance. A trade confirmation is an external document sent to the client or counterparty to acknowledge the trade. Both are created from the same underlying trade data, but the blotter captures far more granularity and serves the firm's operational and regulatory needs, while the confirmation meets contractual and disclosure obligations.

Key Takeaways

• A blotter is a contemporaneous, transaction-level record of all trades executed by a trader or trading desk, typically captured in real-time by trading software.

• Blotters must include trade time (to the nearest second), security identifier, quantity, price, buy/sell direction, venue, and settlement status.

• In India, maintaining accurate blotters is a SEBI and RBI regulatory requirement for all brokers and banks engaged in securities and forex trading.

• Blotters are used for intraday P&L monitoring, end-of-day reconciliation with counterparties and clearing houses (NSE, BSE, NSDL, CDSL), and compliance audits.

• Blotters must be retained for a minimum of 5 years (equities) to 7 years (commodities) as per SEBI record-keeping norms and are subject to audit by internal compliance teams and external regulators.

• Cancelled, amended, and rejected orders are recorded in the blotter and are not deleted; this creates a complete audit trail of trader activity.

• The blotter differs from a trade confirmation in that it