How to Import Solana Transactions into Koinly
Koinly is a popular crypto tax tool. If you use it, you can export your Solana history from LanaTax and import it directly — here's exactly how.
Option 1: Adding Solana to Koinly Directly Koinly's built-in sync
Koinly has a built-in Solana wallet integration. You add your public wallet address and Koinly fetches your transactions automatically. It works, but it has real limitations — especially if you've been active in DeFi or NFTs.
- — Works for simple wallets with mostly SOL transfers and straightforward trades
- ✗ Can be very slow to sync for wallets with hundreds or thousands of transactions
- ✗ Frequently miscategorizes Solana-specific transactions — DeFi interactions, LP positions, and NFT mints often come in as UNKNOWN
- ✗ Misses some transaction types entirely, particularly complex DeFi interactions involving multiple token changes in one transaction
- ✗ You'll spend considerable time manually reviewing and correcting categorizations after the sync
If your Solana activity is limited to a handful of SOL transfers and a few trades, Koinly's direct integration might be enough. For anyone who has used DeFi protocols, minted NFTs, or had significant on-chain activity, the CSV route produces cleaner results.
Option 2: LanaTax CSV Export + Koinly Import
We built LanaTax specifically for Solana, using Helius to enrich and classify transactions before they ever reach your spreadsheet or tax tool. The result is a cleaner CSV that Koinly can interpret more accurately. Here's how to do it:
- 1 Go to tax.saneapps.com and enter your Solana wallet address. LanaTax will fetch your full transaction history for free.
- 2 Review the transaction table. Look for any transactions labeled UNKNOWN — these are ones where even Helius couldn't determine the type. Note them for manual review in Koinly.
- 3 Click the "Export CSV" button in the Tax Export tab. Your browser will download the CSV file.
- 4 In Koinly, go to Wallets → Add Wallet. Search for "Solana" and select it.
- 5 On the wallet page, click "Import from file" and upload the LanaTax CSV. Koinly will process all transactions and calculate gains and losses.
- ✓ LanaTax CSV is compatible with Koinly's universal CSV import format
- ✓ Helius-enriched categorization means fewer UNKNOWN transactions to manually fix
- ✓ You control what data leaves your machine — no wallet connection required
- ✓ Completely free — LanaTax charges nothing for the export
- ✓ Works for wallets of any size, with no sync timeout issues
CSV Column Mapping LanaTax → Koinly
Koinly's universal CSV format expects specific column names. LanaTax exports map directly to these fields, which is why the import works without any manual column remapping.
Koinly uses the TxHash field to deduplicate transactions, so if you import the same wallet multiple times (via direct sync and CSV), Koinly will merge duplicates rather than double-count them. That said, it's cleaner to use one method consistently per wallet.
Tips for a Clean Import Best practices
A few extra steps before and after the import will save you hours of manual corrections later.
- ✓ Review in LanaTax first. Look for obvious anomalies — transactions with very high or very low USD values, or any labeled UNKNOWN. It's easier to investigate these in LanaTax before importing.
- ✓ Fix UNKNOWN transactions in Koinly after import. Koinly lets you manually set the type for any transaction. UNKNOWN transactions are flagged in the review queue — go through each one and assign the correct label.
- ✓ Koinly review prompts are normal. After import, Koinly will often highlight transactions it wants you to review. This doesn't mean anything went wrong — it's asking you to confirm categorizations it's uncertain about.
- ✓ For multiple wallets, export each separately. Run LanaTax once for each Solana wallet address, export a separate CSV for each, and import each CSV into a separate Koinly wallet. Don't merge CSVs manually.
- ✓ Check your date range. LanaTax fetches your full available history. If Koinly already has some transactions from a previous direct sync, watch for the duplication notice. Koinly handles this gracefully via TxHash matching, but it's worth confirming.
- — Note your tax year. Koinly calculates gains across all years in your import. If you only need one tax year, you can filter in Koinly's reports — you don't need to trim the CSV beforehand.