On September 19, a former Bush-era ethics lawyer flagged that the sitting US president has logged more than 28,700 stock trades, reportedly through automated, hands-off accounts, which is more than the entire US Congress combined. Whatever you make of the politics, the story is a masterclass in why a clean, timestamped trade log matters. This guide explains what a trade log and audit trail actually are, why they protect you at tax time, and how to keep one for every position you hold.
What is a trade log and why does 28,700 trades make the case for one?
A trade log is a timestamped record of every buy and sell you make, capturing the ticker, quantity, price, date, fees, and account. When a public figure racks up 28,700+ trades across automated accounts, the only way anyone can verify what happened, or that nothing improper did, is the paper trail behind each fill.
The same logic applies to you at a smaller scale. Whether you place 12 trades a year or 1,200, the tax authority does not take your word for your gains. It expects records, and the burden of proof sits with you, not the broker.
An audit trail is the chronological, tamper-evident version of that log. Each entry carries a timestamp so a reviewer can reconstruct the sequence of events. This is what separates a defensible tax filing from a shoebox of screenshots.
Trade log vs audit trail: the difference
- Trade log: the raw list of transactions you can sort and export.
- Audit trail: the log plus timestamps, source, and edit history, so each entry can be traced and verified after the fact.
- Tax report: the summarized output built on top of both, showing realized gains, losses, and holding periods.
Why do timestamped records matter for tax reporting?
Timestamped records matter because your tax bill depends on exact dates and prices, not estimates. Holding period, cost basis, and wash-sale windows are all calculated from the specific day and price of each transaction.
In the US, the distinction between short-term and long-term capital gains hinges on whether you held an asset for more than one year to the day. A single missing purchase date can move a gain from the higher short-term rate into the lower long-term bracket, or the reverse.
Where cost basis quietly goes wrong
Cost basis errors are the most common reason a self-filed return gets flagged. They creep in when records are incomplete or scattered across brokers.
- Partial fills logged as one price instead of the true weighted average.
- Corporate actions like splits and spinoffs that change your share count and per-share basis.
- Crypto transfers between wallets that look like disposals but are not.
- Dividend reinvestment that creates dozens of tiny new tax lots a year.
Choosing how those lots are matched at sale time changes what you owe. Our breakdown of FIFO versus LIFO cost basis methods shows how the same trades can produce very different tax outcomes depending on lot selection.
Why broker apps alone are not a complete audit trail
Broker apps are not a complete audit trail because most show your current holdings clearly but bury or truncate historical transactions. Statements often go back only a limited window, and closed positions can vanish from the default view entirely.
The problem compounds the moment you use more than one broker. A holder with accounts at Interactive Brokers, Alpaca, and a crypto venue like Bybit ends up with three separate histories in three formats, none of which reconcile automatically.
| Record source | History depth | Multi-account view | Tax-ready export |
|---|---|---|---|
| Single broker app | Often limited | No | Partial |
| Spreadsheet | As long as you maintain it | Manual | Manual formulas |
| Dedicated tracker | Full, from first entry | Yes | Yes |
Spreadsheets solve the consolidation problem but introduce a maintenance problem. We compared both approaches in detail in portfolio tracker versus spreadsheet, and the short version is that a formula only protects you if you never fat-finger a cell.
How does PortfolioTrackr keep a clean, timestamped record of every trade?
PortfolioTrackr keeps a clean record by capturing every transaction with a timestamp and source the moment it enters your account, then holding that history permanently rather than rolling it off after a few statements. Each entry shows what was traded, when, at what price, and how it arrived in your log.
You can populate that log several ways, and none of them require connecting a broker:
- Manual entry for anything you want to log by hand.
- Voice and text capture for quick fills on the move.
- CSV import from a broker statement.
- Broker screenshots read directly into structured entries.
If you do want automation, PortfolioTrackr connects to 42 brokers through the SnapTrade bridge, plus three direct integrations with Alpaca, Bybit, and Interactive Brokers. Our walkthrough on how to connect a brokerage account covers the setup, but manual and import methods stay available on every plan.
One log across 100 exchanges and 67 currencies
PortfolioTrackr consolidates trades across 100 stock exchanges and displays them in any of 67 currencies, so a position on the NYSE, a listing on the London Stock Exchange, and a share on the Colombo Stock Exchange all sit in one timeline. That matters for tax because each jurisdiction wants figures in its own currency at the transaction-date exchange rate.
The same unified log holds crypto alongside equities. If you run both, our guide to tracking stocks and crypto together explains how one record keeps disposals and transfers straight across asset classes.
What should a defensible trade record actually contain?
A defensible trade record contains enough detail to reconstruct each transaction years later without relying on memory or a broker that may no longer show it. At minimum, every entry should capture the following.
- Date and time of the fill, not just the day you noticed it.
- Ticker and full asset name, for example AAPL, BTC-USD, or EMAAR.AE.
- Quantity and execution price per unit.
- Fees and commissions, which adjust your cost basis.
- Account and currency, so multi-broker and multi-currency filings reconcile.
- Source, whether the entry came from an import, a screenshot, or manual input.
The automated accounts in the news story matter here for one reason: even hands-off trading generates a record. A record you never review is still a record someone else can read, which is exactly why keeping your own copy is not paranoia, it is basic housekeeping.
How does a clean log make tax season faster?
A clean log makes tax season faster because the summary report is already built from verified data, so you are reviewing figures rather than reconstructing them. Instead of chasing statements in March, you export a report that already groups realized gains by holding period.
US equities now settle T+1 as of May 2024, which means trade dates and settlement dates sit closer together, but they are still distinct, and your log should carry the trade date that drives the holding-period calculation. Getting that right by hand across hundreds of transactions is where errors multiply.
- Realized gains and losses summarized by lot and holding period.
- Short-term versus long-term splits calculated from actual dates.
- Fee-adjusted cost basis carried through automatically.
- Currency conversion applied at transaction-date rates.
When you are ready to file, PortfolioTrackr can produce the summary directly. Our guide on generating a capital gains tax report walks through the export, and if you lean on a professional, AI-assisted tax reporting shows how a clean log cuts the hours an accountant bills you for.
The bottom line
The 28,700-trade story is a reminder that scrutiny follows records, and the person best served by a clean log is usually the person who keeps it. You do not need to trade thousands of times to benefit from timestamped, verifiable history.
Keep every buy and sell logged with its date, price, fees, and source, consolidate across brokers and asset classes, and export a tax report built on verified data rather than end-of-year guesswork. PortfolioTrackr handles this whether you connect a broker or enter trades by hand, and the record stays yours regardless of what any single app decides to show. That is transparency you control, on your own timeline.
Capital gains, worked out for you
On Pro and Lifetime: realised gains with a country tax lens, exportable to CSV or PDF when your accountant asks.
See My Tax Position
Frequently asked questions
What is a trade audit trail for tax purposes?
A trade audit trail is a chronological, timestamped record of every buy and sell, including ticker, quantity, price, fees, and source. It lets a tax authority or accountant reconstruct each transaction and verify your reported gains. The burden of proof for cost basis sits with you, so a complete trail protects your filing.
How long should I keep my stock and crypto trade records?
Keep trade records for as long as the position is open plus the years your tax authority can audit, often three to seven years after filing in many jurisdictions. Because cost basis reaches back to your original purchase, records for a long-held position may need to survive a decade or more.
Can PortfolioTrackr keep a timestamped record without connecting a broker?
Yes. PortfolioTrackr lets you build a full timestamped trade log using manual entry, voice, text, CSV import, or broker screenshots on every plan. Connecting a broker is optional. Whichever method you use, each entry captures the date, price, fees, and source so your record stays verifiable and tax-ready.
Why do broker apps lose my old transaction history?
Broker apps often show current holdings clearly but truncate historical transactions after a limited window, and closed positions can disappear from the default view. Using multiple brokers makes it worse, since each keeps a separate history in its own format. A dedicated tracker consolidates everything into one permanent, timestamped log.
Does the trade date or settlement date matter for capital gains?
The trade date drives your capital gains holding period, not the settlement date. US equities settle T+1 as of May 2024, so the two dates are close but still distinct. Your log should record the trade date, since a single day can shift a gain between short-term and long-term rates.