Exchange buys plus wallet trades in one sheet: where your first SOL rows come from (record-keeping only)

Not tax advice. All numbers, tokens and signatures below are EXAMPLE data. This guide covers record-keeping only. How any of this is treated where you live is a question for a tax professional.

Most memecoin traders bought their first SOL on an exchange and traded from a wallet, so the wallet history starts with SOL arriving, not being bought. Our pump.fun guide explains why the SOL leg of your first swap shows OVERSOLD when that purchase is missing. This guide covers getting the exchange history into the same sheet, and the gap OVERSOLD does not catch.

Get the exchange file

Coinbase. Its help center says statements can be downloaded from the Statements page (desktop: Settings → Accounts → Statements). You can "Generate a custom statement by entering the Asset, Transaction type, and Date information from the drop-downs, choosing the format, and selecting Generate", and monthly statements come as HTML, PDF or CSV. It also notes that "Account statements are available from the time the account was created" (help.coinbase.com).

Kraken. Exports are created under Documents → Exports. "Trades" shows execution details, and "Ledgers" "Includes deposits, withdrawals, fees, and other balance changes over time". CSV is one format option (support.kraken.com). Requests "can take anywhere from a few minutes to up to a week to process". Kraken also notes that trades history "does not include the details of transactions conducted via the Buy Crypto Widget or Kraken app"; those appear only in the Ledger history (support.kraken.com). If you bought through the app, export the Ledger too.

Export from your very first purchase, not just the current year.

Turn it into rows

Each exchange purchase of SOL becomes a Buy row: date, quantity, price, and the exchange fee in fiat. Put the exchange's own reference in Tx hash (G); it has no Solana signature.
Each exchange sale becomes a Sell row the same way.
The withdrawal to your wallet is not a trade. The workbook accepts only Buy and Sell rows; transfers and staking can only be noted in the Notes column and are not calculated. Write the amount, date and arrival signature in Notes (H). See own-wallet transfers.
Wallet swaps stay a Sell plus a Buy with the same signature in G; see swaps paid in SOL vs USDC. For fees: enter the combined fee once per swap, on the token's row, in fiat, and do it the same way all year.
Use one currency for all prices; convert before pasting if the files differ.
Use one time basis for all dates. Check which time zone each file uses.

FIFO runs across the whole file, so exchange SOL and wallet SOL form one queue.

A worked EXAMPLE

Two exchange buys, a withdrawal of 4 SOL, then two wallet swaps:

Date	Type	Token	Qty	Price	Fee	G
2024-11-05	Buy	SOL	3	100	1.50	EXCH-ref1
2025-02-10	Buy	SOL	2	200	1.00	EXCH-ref2
2025-03-01	Sell	SOL	2	180	0	sigA
2025-03-01	Buy	MEMEX	1,000,000	0.00036	0.20	sigA
2025-04-01	Sell	SOL	1.5	150	0	sigB
2025-04-01	Buy	USDC	225	1.00	0.10	sigB

The withdrawal on 2025-02-12 is only a note. Recalculated in the shipped workbook:

Full history: the first SOL Sell uses 2 of the 3 SOL from November 2024 (cost 201.00, realized +159.00). The second uses the last 2024 SOL plus half a 2025 SOL (cost 200.75, realized +24.25). The 2025 Summary shows 183.25; 2024 shows only the 1.50 fee. All rows are OK, and the SOL holding is 1.5 (cost 300.75): 1 still on the exchange plus 0.5 in the wallet.

The gap OVERSOLD doesn't catch

Now leave out the 2024 purchase, as happens when someone exports only the current year:

The first SOL Sell still says OK: there are 2 SOL from February 2025 to match. But its cost is 401.00, and the result is −41.00 instead of +159.00.
Only the second Sell is flagged OVERSOLD. The 2025 Summary shows −41.00, with 1 row needing attention, and the SOL holding is −1.5.

An OK only proves there were enough units; a missing early lot still changes which costs FIFO uses. Check the sheet's SOL holding against the exchange balance plus the wallet balance.

Withdrawal fees and other gaps

If the exchange charged a fee in SOL for the withdrawal, fewer SOL arrived than left. The workbook doesn't book that as a row, so the sheet's SOL holding stays slightly higher than reality. Note the fee in H. Whether it counts for anything is a question for a tax professional.

Checklist

Exchange history exported from the first purchase (Kraken: Ledger too, if you used the app).
Every exchange buy and sell is a row with its reference in G; withdrawals only in Notes (H).
One currency and one time basis across exchange and wallet rows.
Column M says OK, and the SOL holding equals exchange plus wallet.

Related guides

A ready-made option

The Nah Crypto Tax Tracker is an .xlsx plus a PDF guide with plain formulas and no macros: Buy/Sell rows, Tx hash in G, Notes in H, FIFO by date then row order, an OVERSOLD flag and a per-year Summary for 2024 to 2030. FIFO only; not tailored to any country's tax rules. 29 USDC one-time: Nah Crypto Tax Tracker. Not tax advice.

Not affiliated with Coinbase or Kraken. Sources checked 21 October 2026.