Activity Report
What Is an Activity Report?
An Activity Report (or Activity Statement) is a detailed record provided by a brokerage or financial institution that lists all transaction history, trade executions, deposits, withdrawals, and fee assessments within a specific account over a given period.
An Activity Report is the "paper trail" of your financial life as a trader. While a portfolio view shows you what you own *now*, the activity report shows you *how* you got there. It is a chronological ledger of every single event that has affected the cash or security balance of your account. For active traders, this report is the primary source of truth. It details the exact time and price of every trade execution, the commission paid, the settlement date, and any corporate actions like stock splits or dividend payments. It essentially answers the question: "Where did my money go?" Without this report, a trader is flying blind, unaware of the hidden costs (like margin interest or borrow fees) that might be eating into their profits. It transforms the abstract concept of P&L into concrete, verifiable data points. Brokerages are required by law (SEC Rule 10b-10 in the US) to provide trade confirmations, and monthly statements (Rule 15c3-2) are standard. The Activity Report aggregates all this data into a single, searchable history. It is the document you provide to your accountant, your spouse, or the IRS to prove your financial activities. Furthermore, in the event of a dispute with your broker—say, a trade was executed at a price different from your limit order—the Activity Report serves as the definitive evidence needed to file a claim or complaint. It is the legal record of your rights to the assets you hold.
Key Takeaways
- A comprehensive log of all actions taken in a trading account.
- Includes trade confirmations (buys/sells), dividends, interest, and transfers.
- Used for tax reporting, performance analysis, and reconciling account balances.
- Typically generated daily, monthly, and annually.
- Crucial for identifying unauthorized transactions or errors.
- Often downloadable in formats like PDF, CSV, or OFX for accounting software.
How an Activity Report Works
The Activity Report is generated by the broker's back-office clearing system. Every time an "event" occurs in your account, it is logged in a database with a timestamp and a transaction type. 1. Transaction Logging: When you click "Buy," the system records the order. When the trade executes, it records the fill price, quantity, exchange venue, and time (often down to the millisecond). 2. Settlement Processing: Two days later (T+2), or T+1 for most stocks now, the system records the movement of cash and shares. This distinction between "Trade Date" and "Settlement Date" is visible on the report and is crucial for calculating interest. 3. Daily Reconciliation: At the end of each day, the system tallies all debits and credits to ensure the ending balance matches the starting balance plus activity. 4. Report Generation: You request a report for a specific date range (e.g., "Last Month"). The system queries the database and formats the list of events into a readable table. This automated process ensures that the report is an immutable record. Once a trade settles and appears on the report, it cannot be changed without a formal "correction" entry. Understanding the flow of this report is crucial for managing margin. For example, knowing exactly when a dividend is credited versus when margin interest is debited can help a trader manage their cash balance to avoid a margin call. The report provides the granular detail needed to optimize these timing decisions.
Components of an Activity Report
A standard activity report typically contains several key sections that break down the account's performance and status: 1. Trades: The core section showing Date, Time, Symbol, Action (Buy/Sell/Short/Cover), Quantity, Price, Commission, and Net Amount. This is the raw data for P&L. 2. Deposits & Withdrawals: Records of cash moving in and out via ACH, wire, or check. It tracks the "Net New Money" in the account. 3. Income: Dividends received, bond interest payments, and interest on cash balances. This section highlights the passive income generated by the portfolio. 4. Fees: Margin interest charged, borrow fees for short selling, data subscription fees, and regulatory fees (like SEC Section 31 fees). This reveals the "friction" costs of trading. 5. Corporate Actions: Stock splits, mergers, spin-offs, or symbol changes. These entries explain sudden changes in share count or price that aren't due to trading. 6. Journal Entries: Internal transfers between sub-accounts (e.g., moving cash from a margin account to a short account) or corrections made by the broker.
Reading the Report: Key Columns
To interpret the report correctly, you must understand the columns:
- Trade Date vs. Settlement Date: Trade date determines tax liability; settlement date determines when cash is actually moved.
- Transaction Type: Distinguishes between a "Buy" (opening a position) and a "Buy to Cover" (closing a short position).
- Debit/Credit: Debits (money leaving) are often shown in parentheses or red; Credits (money entering) are positive.
- Commission: The fee paid to the broker. Even "free" brokers may list small regulatory fees here.
- Net Amount: The final impact on your cash balance (Price * Quantity +/- Fees).
Important Considerations for Traders
The most critical consideration is reconciliation. Traders should habitually compare their Activity Report against their own trading journal. Discrepancies can happen—brokerage systems can have glitches, or you might have missed a "mandatory reorganization fee" for a stock split. Finding these errors early allows you to contest them. Additionally, be aware of "Settlement Date" vs. "Trade Date." Your activity report might show cash moving on the settlement date, while your tax reporting generally relies on the trade date. Confusing the two can lead to tax filing errors. Finally, downloading these reports regularly is a best practice, as brokers may archive or remove older reports after a few years, leaving you without records if you are audited. Keeping a local backup of your monthly statements is a basic hygiene practice for any serious investor.
Real-World Example: Reconciling a Trade
A trader buys 100 shares of AAPL at $150 but notices their cash balance dropped by $15,010. They check the Activity Report to understand the discrepancy.
Why It Matters for Taxes
Come tax season, the Activity Report is your best friend (or worst enemy). It is the raw data used to calculate capital gains and losses. While brokers provide a Form 1099-B, active traders—especially those subject to "Wash Sale" rules—often need to reconstruct their trading history using the detailed Activity Report to verify the broker's calculations or to apply special tax treatments (like Mark-to-Market election). The report helps identify specific lots of shares sold (e.g., LIFO vs. FIFO), which can have a massive impact on the tax bill.
FAQs
Ideally, you should review it daily or at least weekly. Catching an error (like a trade executed at the wrong price or an unauthorized withdrawal) is much easier to resolve if reported immediately. Most brokers have a limited window (e.g., 2-5 days) for you to contest a trade confirmation. Waiting until the end of the month might be too late to reverse a costly mistake.
They are related but different. A "Trade Confirm" is a specific document generated for a *single* trade (like a receipt). An Activity Report is a *list* of all trades and other events over a period of time. Think of the Trade Confirm as an individual receipt and the Activity Report as your monthly bank statement. You need the report to see the big picture of your account's health.
Yes, almost all modern brokerages allow you to export your activity report as a CSV (Comma Separated Values) or Excel file. This is essential for traders who keep their own trading journals or use third-party tax software to calculate gains and losses. It allows for custom analysis, such as calculating your win rate or average profit per trade.
If you see a "Wash Sale" adjustment on your report, it means you sold a security at a loss and bought it back within 30 days. The report will show that the loss was disallowed for tax purposes and added to the cost basis of the new position. This is a critical detail for accurate tax filing, as it prevents you from claiming the loss on your current tax return.
The Bottom Line
The Activity Report is the ledger of your trading business. An Activity Report is the definitive record of every financial event in your brokerage account. Through detailed logging of trades, fees, and transfers, it ensures transparency and allows for accurate performance tracking. While it may seem tedious to review, it is the primary tool for tax preparation and fraud detection. Traders looking to treat their trading like a business must regularly audit their activity reports to ensure every penny is accounted for. Ignorance of your activity report is negligence of your capital. By reviewing it consistently, you ensure that your records match the broker's and that no hidden fees are eroding your hard-earned profits.
More in Market Data & Tools
At a Glance
Key Takeaways
- A comprehensive log of all actions taken in a trading account.
- Includes trade confirmations (buys/sells), dividends, interest, and transfers.
- Used for tax reporting, performance analysis, and reconciling account balances.
- Typically generated daily, monthly, and annually.