How to Track P&L Across Multiple Brokers

You have a futures account at Interactive Brokers, some spot crypto on an exchange, and a stock app on your phone. Each one shows you a profit number. None of them shows you your number. That gap is where multi-account traders quietly lose track of how they are actually doing.

No single broker is wrong. Each one reports accurately on the slice it holds. The problem is that no broker can see the others. To track P&L across multiple brokers, you have to assemble that view yourself, because nobody does it for you.

This guide walks through a practical way to do it: how to pull the numbers together, why totals get corrupted by double-counting and missed fees, how to handle multiple currencies, and what a "real" P&L figure even means once cash keeps moving in and out.

TL;DR

• Each broker only reports on its own account. Your real P&L is the sum across all of them, computed on one consistent basis.
• The three most common corruption sources are double-counted transfers, missing fees, and mixed currencies.
• Decide up front whether you want realized P&L, total P&L (realized plus unrealized), or a true return percentage. They answer different questions.
• Tax rules like the wash sale rule apply across every account under your tax ID, even though no single broker tracks them that way.
• A dedicated tracker or a disciplined spreadsheet, refreshed on a fixed cadence, beats logging into four apps and doing mental math.

Why one broker can never show your real P&L

A brokerage statement is scoped to a single account. It knows what you bought and sold there, the fees it charged, and the cash balance it holds. It has no visibility into the position you opened at another firm, the wire you sent from a third, or the currency conversion the fourth applied.

For an active retail trader spread across venues, this creates three blind spots at once:

1. You cannot see total exposure. You might be long the same underlying in two accounts and be far more concentrated than either statement suggests. The SEC's investor education materials describe diversification as spreading investments to reduce exposure to any single asset or market event, and you cannot manage concentration you cannot see (see Investor.gov).
2. You cannot measure true performance. A 40% gain in a small account and a 5% loss in a large one net out very differently depending on how much capital sat in each. Per-account percentages do not add up. Our guide on tracking your portfolio performance covers the metrics that do.
3. You cannot reconcile against your own records. If your journal says one thing and three statements say another, you need a single consolidated figure to check against.

Consolidation is the act of closing those blind spots on purpose.

Decide which P&L number you actually want

"Profit and loss" is not one figure. Before you consolidate anything, pick the question you are answering, because the workflow differs.

• Realized P&L counts only closed positions: what you actually banked or lost. It is the cleanest to reconcile and the basis most tax reporting starts from.
• Total P&L adds unrealized P&L, the paper gain or loss on positions you still hold. This tells you where you stand right now, but it moves every time the market ticks.
• Return percentage expresses gain against the capital that produced it. This is the only figure that lets you compare a large account and a small one fairly, or compare yourself to a benchmark.

That last one has a subtlety worth understanding. Because you move cash in and out of trading accounts, a simple "ending value minus deposits" calculation misattributes performance. The finance industry separates two methods here. A time-weighted return strips out the effect of your deposit and withdrawal timing to measure how the investments themselves performed, while a money-weighted return (also called dollar-weighted, and mathematically an internal rate of return) reflects how you did given when you added or pulled capital. As the CFA Level 1 curriculum notes, a money-weighted return gives more weight to periods when the account is largest, which can penalize performance for cash-flow timing outside your control, whereas a time-weighted return ignores contributions and withdrawals (see AnalystPrep's CFA Level 1 notes).

For a self-directed trader, both are useful. Time-weighted answers "is my strategy any good?" Money-weighted answers "did my timing of adding capital help or hurt?" Just know which one a tool reports so you are not comparing two different things across accounts.

The consolidation workflow, step by step

Here is a repeatable process that works whether you use a spreadsheet or dedicated software.

1. Inventory every account. List each broker, exchange, and app where you hold or trade anything. Note the base currency of each. Missing an account is the fastest way to a wrong total.

2. Pull the raw data. For each account, export the transaction history and current positions. Most brokers offer a CSV export; Interactive Brokers additionally offers a structured Flex report. Pull transactions, not just a summary screenshot, because you need every fill, fee, and cash movement to rebuild P&L correctly.

3. Normalize to one schema. Map each export into the same columns: date, symbol, action, quantity, price, fee, currency, account. This is tedious the first time and mechanical after that. If a spreadsheet is where this lives today, why your Excel trading journal keeps breaking explains where hand-mapping starts to fall apart.

4. Convert to one reporting currency. Pick a single currency for the consolidated view and convert everything into it. This is where most manual trackers go wrong, and it deserves its own section below.

5. Compute P&L per position, then sum. Match buys to sells to get realized P&L per closed trade, mark open positions to current price for unrealized P&L, and subtract every fee. Then total across all accounts.

6. Reconcile against your journal. Your consolidated number should match what your own records say. When it does not, one side has an error, and finding it is the whole point. A regular trading journal audit is how you catch the mismatches before they harden into a wrong total.

The three ways consolidated P&L gets corrupted

Most wrong totals come down to the same three errors. Watch for each one.

Double-counting transfers

When you wire cash or transfer a position from one account to another, it appears as an outflow in the source and an inflow in the destination. If your tracker treats both as trading activity, you either invent profit or invent loss out of thin air. A transfer is not a trade. Tag internal movements between your own accounts separately so they cancel out and never touch your P&L figure. It is one of the most common reasons a consolidated total refuses to match.

Missing or misplaced fees

Commissions, exchange fees, funding rates on perpetual futures, currency-conversion spreads, and withdrawal fees all reduce your real return. A summary screen sometimes reports P&L before some of these. Crypto exchanges in particular bury fees inside the fill price or charge them in a third token. If you consolidate gross numbers, your total will overstate profit. Always pull fees at the transaction level and subtract them explicitly. Small per-trade fees are easy to dismiss, but for an active trader they compound into a number that changes the picture.

Mixed currencies treated as one

Adding 500 USD of gain to 500 EUR of gain does not give you 1,000 of anything. If you sum raw numbers across accounts denominated in different currencies, the total is meaningless. Every figure has to be converted to one reporting currency at an appropriate exchange rate before it is summed, which is the next section.

Handling multiple currencies without breaking the math

If all your accounts settle in the same currency, you can skip this. Many multi-broker traders cannot: a US stock account in dollars, a European account in euros, crypto quoted against various pairs.

The core rule is that you convert before you sum, never after. Two decisions shape how you convert:

• Which rate for realized trades. The cleanest approach converts each closed trade's P&L at the exchange rate on the date it was realized, so historical results are not distorted by today's rate.
• Which rate for open positions. Unrealized P&L is naturally marked at the current rate, since that is what you would get if you closed now.

Doing this by hand in a spreadsheet is possible but fragile, because you are looking up and applying dozens of historical rates. This is exactly the kind of work worth automating. The realized-versus-open split above mirrors the realized vs. unrealized P&L distinction, which is worth getting straight before you convert anything. Whatever tool you use, the discipline is the same: one reporting currency, converted at a defensible rate, applied consistently.

What multiple accounts do to your taxes

Consolidation is not only about knowing your number. It also protects you at tax time, because some rules operate across all your accounts even though no single broker enforces them that way.

The clearest example is the wash sale rule. Under IRS Publication 550, a wash sale occurs when you sell stock or securities at a loss and, within 30 days before or after the sale, buy substantially identical securities (see the IRS wash sales guidance). The disallowed loss does not vanish; it is added to the cost basis of the replacement shares. The catch for multi-account traders is that brokers only track and report wash sales within the same account under the same security identifier. Charles Schwab spells this out plainly: the rule applies across all your accounts, including accounts at other firms and even a spouse's accounts, but your broker will not calculate cross-account violations for you (see Schwab's wash sale primer).

That means if you sell a stock at a loss in one broker and rebuy it in another within the window, the loss is disallowed, and it is on you to catch it and report it correctly. A consolidated view of every fill across every account is what makes that possible. None of this is tax advice; when the numbers get complex, a qualified tax professional is the right call.

Spreadsheet or dedicated tool?

A spreadsheet can absolutely produce a correct consolidated P&L. It is free, flexible, and yours. The cost is time and fragility: every month you re-export, re-paste, re-map columns, re-apply currency rates, and hope no formula broke. For four accounts across three currencies with fees buried in fills, it becomes a recurring chore that quietly invites the exact errors above.

Dedicated portfolio trackers automate the repetitive parts, though a tracker and a journal answer different questions: import once, normalize automatically, convert currencies, and flag transfers so they do not corrupt totals. The trade-off is trusting the tool's math, which is why reconciling against your own journal stays important regardless of the tool.

TradeReveal sits in this category. Its free core includes portfolio tracking across manually logged and broker-synced holdings, IBKR Flex import, and multi-currency reporting that consolidates every account into a single reporting currency you choose. It is one way to skip the monthly spreadsheet rebuild, not the only way. The workflow in this article matters more than any specific tool; whatever you use, the goal is one honest number you can trust.

Frequently Asked Questions

How do I calculate total P&L across brokers manually?

Export every transaction from each account, normalize them into one consistent format, convert all figures to a single reporting currency, match buys to sells for realized P&L, mark open positions to current price for unrealized P&L, subtract every fee, and sum across accounts. Tag internal transfers separately so they do not count as trades.

Why don't my broker P&L numbers add up to my real profit?

Usually one of three reasons: transfers between your accounts are being double-counted as gains or losses, fees are missing from a summary figure, or you are adding numbers in different currencies without converting them first. Consolidating from transaction-level data rather than summary screens fixes all three.

Does the wash sale rule apply across different brokers?

Yes. The IRS rule applies to all accounts under your tax ID, including accounts at different firms and a spouse's accounts. Individual brokers only track wash sales within their own account, so cross-broker violations are your responsibility to identify and report. See IRS Publication 550 and consult a tax professional for your situation.

Should I use time-weighted or money-weighted return?

Use time-weighted return to judge whether your strategy is performing well, because it removes the effect of when you added or withdrew cash. Use money-weighted return to see whether your timing of adding capital helped or hurt. They answer different questions, so know which one a tool is reporting.

Is it better to just consolidate everything into one broker?

Consolidating accounts simplifies tracking, but many traders keep multiple brokers on purpose for specific instruments, lower fees, or redundancy. You do not have to close accounts to get a clean P&L. A consolidated view gives you the single number without forcing you to abandon the venues you use for good reasons.

Final Thoughts

Multiple brokers is a normal setup, not a mistake to unwind. The mistake is letting each account's partial view stand in for the whole. Your real profit and loss is the sum across every venue, computed on one consistent basis, in one currency, with transfers excluded and fees included.

Build the habit once: inventory your accounts, pull transaction-level data, normalize, convert, sum, and reconcile against your own records. Do that on a fixed cadence and the number stops being a mystery you reconstruct in your head and becomes something you can actually trust, benchmark, and act on. The tool is secondary. The discipline of one honest number is what compounds.

Start your free TradeReveal account today

Happy Trading,

The TradeReveal Team

Sources

• IRS, Publication 550: Investment Income and Expenses (Wash Sales): irs.gov/publications/p550
• U.S. SEC / Investor.gov, Asset Allocation and Diversification: investor.gov
• AnalystPrep, CFA Level 1: Money-Weighted and Time-Weighted Rates of Return: analystprep.com
• Charles Schwab, A Primer on Wash Sales: schwab.com