Export a Solana wallet to Koinly CSV (including closed token accounts)
The problem
Koinly's Solana sync and most address-only exporters read the token accounts a wallet holds today. If you bought a memecoin, sold it and closed the account to get the rent back, that account is gone, and so are its trades. The result is missing cost basis and "negative balance" warnings.
What this export does
- Walks the wallet's full signature history, so trades in closed token accounts are recovered.
- Keeps the ~0.002 SOL token-account rent out of your trade prices and lists rent reclaims separately.
- Merges WSOL into SOL, so wrap/unwrap does not appear as a trade.
- Marks failed transactions (fee only) and spam dust.
- Writes Koinly's universal CSV layout, plus a fix list: sends that may be transfers to your own wallets, airdrops, and complex transactions to review.
How to import
- Run the export and download
koinly.csv. - In Koinly: Wallets → Add wallet → pick your Solana wallet (or "Custom CSV") → Import from file → upload the CSV. Do not also auto-sync the same address, or trades are counted twice.
- Work through the fix list: mark self-transfers, check airdrops.
Try it: paste a public Solana address at api.stillroach.com/docs/wallet-export. The free preview shows the first rows and how many items need checking. Pay with a Stillroach credit pack (USDC or SOL) to unlock the full CSVs. No email, no card.
Free previewPublic addresses only. We never ask for a seed phrase or private key. Results are deleted after 24 hours. This is not tax advice: check the output with your tax tool or accountant.
More guides
- Awaken Tax Solana CSV: export a wallet in Awaken's format
- CoinLedger missing Solana transactions? Import a complete CSV
- pump.fun taxes: export every memecoin trade from your Solana wallet
- Solana closed token accounts and rent reclaims: how they show up in tax reports
- Solscan CSV export limited to 1,000 rows? Export the full Solana history