Trading Record Keeping and Accounting Basics

Trade records and accounting are the backbone of a trading business. Without them, taxes cannot be filed accurately, performance cannot be analyzed, costs cannot be controlled, and the business cannot be improved. Records are not optional overhead — they are the data on which every business decision depends.

What to record per trade

Every trade should be captured with at minimum:

• Instrument and exchange
• Entry and exit date, time, and price
• Quantity and direction
• Commission and fees
• Stop and target levels at entry
• Reason for entry and exit — the setup or signal
• Strategy tag — which system the trade belongs to

Without the strategy tag and reason fields, the records cannot support performance attribution — the analysis of which strategies are working and which are not.

Trade-level metrics

From the records, compute per-trade:

• Net P&L = gross P&L − commissions − fees
• R-multiple = net P&L ÷ initial risk, where initial risk = $|$entry − stop$|$ × quantity
• Maximum favorable excursion (MFE) and maximum adverse excursion (MAE)

R-multiples normalize results across position sizes and instruments. MFE and MAE reveal whether stops or targets are optimally placed — a trade that regularly reaches 2R favorable before reversing to stop suggests targets are too tight.

Aggregate metrics

At the strategy and portfolio level, track:

• Win rate = winning trades ÷ total trades
• Expectancy = (win rate × average win) − (loss rate × average loss), in R
• Payoff ratio = average win ÷ average loss
• Profit factor = gross profits ÷ gross losses
• Maximum drawdown and recovery time
• Cost ratio = total costs ÷ gross trading profit

Expectancy is the key figure: a strategy with 35% win rate and 2.5 payoff ratio has expectancy of $0.875R$ per trade, while one with 60% win rate and 1.0 payoff ratio has $0.20R$. Win rate alone is meaningless.

Accounting systems and operational practice

Maintain a trade log (spreadsheet or database capturing every trade), accounting software (double-entry bookkeeping for income, expenses, capital, draws), and tax records (realized gains/losses by lot, wash-sale tracking, section 475 records, reconciling with broker 1099 statements).

• Record at execution, not at end of day — reason and context captured while fresh.
• Reconcile weekly against broker statements.
• Review monthly the strategy-level metrics. Trends in expectancy or cost ratio appear in data before they appear in P&L.
• Archive records for the period required by tax law — typically 7 years in the US.

Patterns invisible in the moment become obvious in aggregate. These findings are available only to the trader who keeps the records.