Trader P&L

Trader P&L keeps one ledger for a book of brokerage accounts. You import fills and cash events from each broker; it works out what you actually made, what you still hold, and what the year looks like for tax — as Excel workbooks you can hand to an accountant.

Trader P&L is a private app. An administrator grants it to your workspace before it appears in the Marketplace — ask your account contact if you do not see it.

What you get

• Accounts — every brokerage account in one place: taxable, traditional IRA, Roth IRA, or an entity account. The account type matters, because gains inside an IRA are not taxable and an IRA purchase can permanently disallow a loss taken in a taxable account.
• Instruments — equities, equity options, futures and crypto, each with its contract multiplier and the mark used to value open positions.
• Fills — the immutable record of every execution, keyed by the broker's own execution id so re-importing a statement never double-counts.
• Cash events — dividends, interest, margin interest, borrow and platform fees, staking rewards, deposits and withdrawals.
• Statement reconciliation — a board that walks each month's statement from Imported to Reconciled, with a discrepancy lane and a note trail.
• Tax years — a close workflow that cannot be marked final until a frozen snapshot stands behind it.
• Three Excel reports — account P&L, a portfolio roll-up, and a tax pack.

Import your fills

Trader P&L uses the standard import wizard, so any broker that exports CSV or Excel works.

1. Export your trade confirmations or activity statement from the broker.
2. Open Fills and choose Import.
3. Map the broker's columns to these fields:

   Field	What it holds	Required
   broker_exec_id	The broker's own execution / trade id	Yes
   broker_account_id	Which account the fill belongs to	Yes
   instrument_id	Which instrument was traded	Yes
   side	buy, sell, sell_short, buy_to_cover	Yes
   quantity	Units, always positive — side carries the sign	Yes
   price	Price per unit, before the multiplier	Yes
   commission, fees	Split, because only commission uniformly adjusts basis	No
   trade_date	The date matching uses — not the settle date	Yes
   disposition	trade, exercise, assignment, expiry, transfer_in, transfer_out	No

4. Set the upsert key to broker_exec_id. This is the one setting that matters: with it, re-importing an overlapping statement updates the rows it already has instead of adding duplicates.

Broker column names differ, so the mapping is worth saving a note of the first time you do it. Common sources are Interactive Brokers Flex queries, Schwab and Fidelity activity exports, Tastytrade and TradeStation trade history, and Coinbase or Kraken fills.

Corrections

Brokers reissue fills. Do not edit the original row — add a new fill and point its corrects_trade_fill_id at the one it replaces. The reports drop any fill that a later row corrects, which keeps every historical snapshot reproducible. A chain of corrections resolves to the last link.

Positions transferred in

A position moved from another broker usually arrives without a cost basis. Set disposition to transfer_in and fill in transfer_basis and transfer_acquired_on. If you leave them blank the lot is flagged on the Warnings sheet and left out of the tax pack — it is never assumed to have cost nothing, which would overstate your gain.

The reports

Each report is one click from a record, and each ends with a Warnings sheet listing data problems found while computing — a missing basis, a stale mark, an option settlement that could not be matched. Warnings never stop a report; they tell you what to fix.

Account P&L

From any account. Summary, realized gains lot by lot, open lots, unrealized value, cash events, warnings.

Portfolio P&L

From a tax year. The same picture across every account included in that year, with a per-account breakdown and the consolidated totals.

Tax pack

From a tax year. A Form 8949 sheet in the form's own column order and grouped by box, a Schedule D summary, a Form 6781 sheet for futures and index options, the wash-sale detail, crypto disposals, income, and a notes sheet recording exactly which rules were applied.

How the numbers are worked out

Lot matching. Closes consume open lots by the method on your tax profile — FIFO, LIFO, HIFO, or average cost — with a separate choice for crypto, since many traders run FIFO equities and HIFO crypto. Partial closes split a lot. A short sale's gain is short-term however long it was held.

Wash sales. A loss on a security is disallowed when you buy a substantially identical one within 30 days either side of the sale. Detection spans every account in your book, including IRAs — the rule is not per-account, and checking one account at a time under-reports. An ordinary wash defers the loss into the replacement lot's basis and extends its holding period. A replacement bought inside an IRA disallows the loss permanently: no basis is added anywhere, and it is reported on its own line.

"Substantially identical" is matched on the symbol, and for options on the same underlying, type and strike. Broader judgments — two funds tracking one index, say — are your accountant's call, not the app's.

Futures and index options. Positions marked as Section 1256 contracts mark to market at year end whether or not you closed them, and all the gain splits 60% long-term / 40% short-term regardless of holding period. The flag is editable per instrument because index options on SPX are Section 1256 contracts while options on SPY are not, and no rule based on the symbol gets that reliably right. The prior year's mark comes from the tax year record rather than being guessed, so installing part-way through a trading history does not mis-state year one.

Options. Expiry realizes the whole premium on the expiry date. Exercise and assignment do not realize the premium on their own — it folds into the stock leg settled the same day: a premium received on an assigned call raises the sale proceeds, and a premium paid on an exercised call raises the new lot's basis. If a settlement cannot be matched to its stock leg, you get a warning rather than a silently wrong number in both places.

Crypto is treated as property: no Section 1256 treatment, and no wash sales unless you switch them on for crypto in the tax profile. Staking rewards and airdrops are ordinary income when received, and that amount becomes the lot's cost basis.

Unrealized value comes from the mark you set on each instrument. There is no live price feed. Every unrealized line shows the date its mark came from, a mark more than a week old raises a warning, and an instrument with no mark is shown at cost rather than valued at zero.

Snapshots, and why a filed number stays put

Finalizing a tax year requires a snapshot. A snapshot freezes the computed report together with a fingerprint of the fills it was computed from.

If a backdated fill arrives later and you re-run, the app does not overwrite what you filed. It writes a new snapshot and marks the old one superseded, so you can see exactly what changed and by how much. That is the difference between this and a spreadsheet, where last year's number quietly becomes a different number.

What this app does not do

Stated plainly, so you know where the edges are:

• US federal rules only — no state tax, and no other country's regime.
• No live market data. Marks are values you set.
• One base currency (USD). No foreign-exchange gain or loss.
• No trader mark-to-market election, no straddle rules, no constructive sales.
• No partnership K-1s, and no apportionment of margin interest.
• Corporate actions — splits, symbol changes, mergers — are handled by hand: close the old instrument and open the new one with a transfer_in carrying the basis forward.