214 Transactions and the 12 Gains My Software Missed
My tax file had 214 crypto transactions since 2021. Coinbase's 1099 showed 118 disposals. My software showed 106. The gap was 12 swaps with $740 of gains, hidden by a wrong derivation path. My accountant fixed the return. The extra tax came to $57.
Two hundred and fourteen rows. That is what the Koinly CSV showed on March 30 at 4:05 in the afternoon, one line per trade, swap, and transfer since August 2021, and my accountant Claire in Des Moines had asked for paper, so I fed all 41 pages thru the office printer while a coworker waited for the good tray.
The whole return hinged on one reconciliation: the 1099 forms the exchanges filed against the numbers my software had computed, because every crypto swap is a taxable disposal in the United States and the IRS now receives those forms directly. Claire's fee was $600. Deadline: April 15. If the two sides of that reconciliation did not match, an IRS letter was the most likely next document in my life.
The 1099 from Coinbase said 118 disposals. Koinly's report said 106. The twelve missing rows carried $740 of gains, and the last of 'em was a 3 AM swap in a Denver hotel that I only remembered making when I saw it priced in black and white on page 31. Claire's own software cross-checked the same way, which is how she saw in ten minutes what I had missed across five years.
forty-one pages for Claire
The history itself is not exotic. A Coinbase account since 2021 for buys, a Kraken account since 2022 for trades, a MetaMask wallet since 2021 for everythin' else: 96 rows from Coinbase, 41 from Kraken, 77 from MetaMask across three addresses. Five-year totals: 118 disposals, $3,912 of gains, and $4,880 of losses carried forward from the 2022 wipeout, every dollar already reported in prior years, which is the only reason my pulse stayed near normal.
118 disposals, 106 found
Claire caught it, not me. I handed her the paper and she did what she does, which is count: 1099 disposals, 118; software report, 106. She circled the gap in green pen and said the one sentence nobody wants to hear from an accountant, which was find them before I can file anything with my name on it.
The hunt took the weekend. All twelve missing rows came from the same nine months in 2023, all swaps on the same hardware wallet, and none of them appeared anywhere in the software import. I re-imported the wallet twice and got the same hole in the same place, which meant the problem was not the file. It was the key. Two hours of forum threads and one support chat later, I had the phrase derivation path, which is how one seed can hold two separate address books that never talk to each other.
the wrong derivation path
The answer, once I dug in: ten minutes. In late 2023 I had created a second account inside the same hardware wallet, and the second account lives on a different derivation path, and my software had been watching only the first path since 2021 because that is the address I gave it back then. Twelve swaps of ethereum to USDC, $740 of grasped gains across 2023 and 2024, sitting the whole time on an address my own tax software had never once looked at.
the 3 AM swap in a Denver hotel
Row 200 of the corrected CSV is my favorite. 3:07 AM. Timestamp: June 22, 2024, swapping 0.05 ETH to USDC at a gain of $212, executed from a hotel room at a Denver conference I barely attended, on hotel wifi, while a fire alarm went off somewhere below me. I have no memory of why that swap was urgent at 3 AM. The 2024 version of me left no note.
$57 of difference
Claire rebuilt the return on April 1 with the corrected CSV, the twelve swaps added $740 of gains, the $4,880 of carried-forward losses from the 2022 wipeout absorbed every dollar of that, and the net extra tax was $57. Fifty-seven dollars. Twelve missing rows, one weekend of panic, a correction letter drafted and never sent, for $57. I would pay $57 to never do it again, which is about what it cost.
accepted at 11:46 PM
I filed on April 7 at 11:40 in the evening from my kitchen table, and the e-file acceptance came back at 11:46, while the dishwasher hummed thru the last cycle of an awfully long tax season. Six minutes. Five years of records, 214 rows, one wrong derivation path, twelve found swaps, $57.
the January reconciliation
Every January, now. The process for next year includes a check where I lay the 1099 forms next to the software import and count both, line by line, before Claire ever sees a page. Counting is the whole trick, and it turns out nobody had counted my second derivation path, not even me. The gap was invisible until a human added the two sides and compared.
the printer, one more time
So, March 30, 4:05 PM, the office printer, 41 pages. I printed the corrected pages the same way a few days later, and Claire stapled the whole thing without a word at our April 2 meeting, then handed it back with the green pen capped. Two hundred and fourteen rows. Twelve were mine to find, and I found 'em. That is tax season now.