HQ Wealth and CoinTracking: The Complete Import and Export Guide

CoinTracking is the veteran of crypto portfolio tracking — it has been around long enough that its CSV format has become the de-facto interchange standard for the whole industry. Koinly officially consumes CoinTracking exports (https://koinly.io/integrations/cointracking/), and so does Blockpit (https://help.blockpit.io/hc/en-us/articles/14013883587868). If a tool speaks one competitor format, it speaks CoinTracking.

HQ Wealth speaks it in both directions. Whether you are consolidating a CoinTracking history into HQ Wealth's double-entry ledger — with FIFO, LIFO, HIFO and AVCO cost basis, wallet and exchange reconciliation, and IFRS-grade reporting — or you need to hand a CoinTracking-formatted file to an accountant, auditor or another platform, this guide walks you through both flows step by step.

Who typically makes this move? Three groups: DeFi-heavy traders who have outgrown a tracker and need real accounting, finance teams that must reconcile crypto against traditional books, and anyone whose accountant asked for something an ordinary tax tool cannot produce. If you are searching for a CoinTracking alternative with a proper ledger underneath, the migration below takes about fifteen minutes.

Exporting from HQ Wealth to CoinTracking

HQ Wealth generates a file that matches the official CoinTracking CSV import format exactly, as documented at https://cointracking.info/import/import_csv/. In HQ Wealth, open Reports → Export → CoinTracking CSV, choose your date range and journals, and download.

The 11-column format, verified against the official spec

CoinTracking expects a fixed header with eleven columns in this exact order. Get the order wrong and the import fails or silently misreads your data.

| Pos | Column | Required | Format | Example | | --- | --- | --- | --- | --- | | 1 | Type | Yes | A valid CoinTracking transaction type | Trade | | 2 | Buy Amount | Yes for incoming and trades | Decimal, dot separator | 0.5 | | 3 | Buy Currency | Yes with a Buy Amount | Ticker symbol | BTC | | 4 | Sell Amount | Yes for outgoing and trades | Decimal, dot separator | 12500 | | 5 | Sell Currency | Yes with a Sell Amount | Ticker symbol | USDT | | 6 | Fee | No | Decimal, dot separator | 0.0005 | | 7 | Fee Currency | No | Ticker symbol | BNB | | 8 | Exchange | No | Free text | Binance | | 9 | Trade-Group | No | Free text label | DeFi | | 10 | Comment | No | Free text | Exported from HQ Wealth | | 11 | Date | Yes | YYYY-MM-DD HH:MM:SS | 2026-07-01 14:30:00 |

Four optional columns may follow after Date: Liquidity pool, Tx-ID, Buy Value in Account Currency and Sell Value in Account Currency. If the two value columns are empty or zero, CoinTracking calculates them automatically from its own price data. Only the type, the amounts, the currencies and the date are mandatory — fee, exchange, trade-group and comment can stay blank. HQ Wealth fills all fifteen columns where data exists, including on-chain transaction IDs, so nothing is lost in transit.

Prefer a spreadsheet? CoinTracking also offers an official Excel import (https://cointracking.info/import/import_xls/) built around the template CoinTracking_Excel_Import.xls (https://cointracking.info/import/CoinTracking_Excel_Import.xls). Download the template, paste HQ Wealth's exported rows over the demo rows it ships with, save as XLS or XLSX, and upload. For large books, the plain CSV is faster and safer.

How HQ Wealth types translate

CoinTracking's transaction taxonomy runs to roughly 35 types — the richest DeFi vocabulary of any platform we have verified — which is why the mapping from HQ Wealth is nearly one to one. Highlights:

| HQ Wealth type | CoinTracking type | | --- | --- | | BUY, SELL, CRYPTO_TRADE | Trade | | DEPOSIT | Deposit | | WITHDRAWAL | Withdrawal | | STAKING_REWARD | Staking | | LIQUIDITY (add side) | Provide Liquidity | | LIQUIDITY (remove side) | Remove Liquidity | | LP token received or returned | Receive LP Token, Return LP Token | | LP reward income | LP Rewards | | INCOME (interest, lending, dividends) | Interest Income, Lending Income, Dividends Income | | GIFT_OUT | Gift | | FEE | Other Fee |

Because both platforms model liquidity pools, LP tokens and staking as first-class transaction types rather than generic transfers, DeFi positions survive the round trip intact. That makes CoinTracking the best-fit interchange partner for DeFi-heavy books among the platforms we support.

Timezone: pick it at import time, not in the file

CoinTracking does not read a timezone from the file. Instead, you choose one from a dropdown at import time, ranging from GMT-11:00 Midway Island to GMT+14:00 Kiritimati. HQ Wealth exports all timestamps in UTC, so when you upload the file to CoinTracking, select GMT+0 in the dropdown. Pick anything else and every transaction shifts by hours — enough to move year-end trades into the wrong tax year.

Never open the CSV in Excel

CoinTracking's own documentation warns that editing the CSV in Excel corrupts the layout — Excel reformats dates, strips leading zeros and mangles large numbers into scientific notation. If you must inspect or edit the file, use a plain text editor such as Notepad++ or VS Code. If you want a spreadsheet workflow, use the official Excel template route instead.

Importing from CoinTracking into HQ Wealth

Migrating from CoinTracking to HQ Wealth starts with one file: the CSV (Full Export), generated from the Export button above the trade table in CoinTracking. This is the same file CoinTracking itself can re-import into another account, and the same format Koinly and Blockpit consume — the closest thing the industry has to a lingua franca.

Two settings matter before you click Export:

Interface language: English. The Full Export is language-sensitive — column headers and type names follow your interface language, and a re-import only works when both sides use the same language. HQ Wealth's importer expects the English-locale export. Switch CoinTracking to English first if you use it in another language.
Account timezone: UTC. Set your CoinTracking account timezone to UTC before exporting so every timestamp lands unambiguously. HQ Wealth stores everything in UTC internally.

Then, in HQ Wealth, go to Imports → CoinTracking, upload the file, and review the preview screen before committing. Every imported row is staged against your existing journals, so duplicates from a prior wallet or exchange sync are flagged instead of double-counted.

How CoinTracking types map into HQ Wealth (our mapping)

The table below shows how our importer classifies each CoinTracking type. This is HQ Wealth's mapping, not something CoinTracking publishes.

| CoinTracking type | HQ Wealth type | | --- | --- | | Trade, Margin Trade, Derivatives / Futures Trade | CRYPTO_TRADE (BUY or SELL when one side is fiat) | | Deposit | DEPOSIT | | Withdrawal, Spend | WITHDRAWAL | | Staking, Masternode, LP Rewards | STAKING_REWARD | | Income, Mining, Interest Income, Lending Income, Dividends Income, Reward / Bonus, Airdrop, Gift / Tip | INCOME | | Provide Liquidity, Remove Liquidity, Receive LP Token, Return LP Token | LIQUIDITY | | Gift, Donation | GIFT_OUT | | Stolen, Lost | WITHDRAWAL, tagged as a loss event for review | | Borrowing Fee, Settlement Fee, Other Fee, Other Expense, Margin Loss / Fee | FEE | | Receive Loan, Repay Loan, Add Collateral, Liquidation | DEPOSIT or WITHDRAWAL, tagged as loan activity |

Non-taxable variants of income types carry their non-taxable flag through as a tag, so your tax pack treats them correctly. After import, HQ Wealth rebuilds cost-basis lots under your chosen method — FIFO, LIFO, HIFO or AVCO — so your realized-gain figures reflect your accounting policy, not the tracker's.

Quick reference

| Step | HQ Wealth to CoinTracking | CoinTracking to HQ Wealth | | --- | --- | --- | | File | 11-column CSV (or XLS template) | CSV (Full Export) | | Where | Reports → Export → CoinTracking CSV | Export button above the trade table | | Language | Not applicable | English interface required | | Timezone | Exported in UTC; pick GMT+0 at import | Set account timezone to UTC first | | Editing | Text editor only, never Excel | Do not edit — upload as generated |

Common pitfalls to avoid:

Opening the CSV in Excel. It silently corrupts dates and amounts. Use the Excel template route if you need a spreadsheet.
Exporting in a non-English interface. The Full Export inherits your interface language and will not parse. Switch to English, re-export.
Skipping timezone discipline. A mismatched timezone shifts every trade — worst case, across a tax-year boundary. UTC in, GMT+0 selected, every time.
Reordering or renaming columns. The 11-column header is fixed. Do not add columns before Date; optional columns go after it.

Frequently asked questions

What is the CoinTracking CSV import format? It is a fixed 11-column CSV — Type, Buy Amount, Buy Currency, Sell Amount, Sell Currency, Fee, Fee Currency, Exchange, Trade-Group, Comment, Date — with four optional trailing columns (Liquidity pool, Tx-ID, and buy/sell values in your account currency). The official spec lives at https://cointracking.info/import/import_csv/, and HQ Wealth's exporter follows it exactly.

Does CoinTracking support Excel import? Yes. Download the official template CoinTracking_Excel_Import.xls from https://cointracking.info/import/import_xls/, replace the demo rows with your data, save as XLS or XLSX, and upload. HQ Wealth's CSV export pastes straight into the template.

How do I migrate from CoinTracking to HQ Wealth? Set your CoinTracking interface language to English and your account timezone to UTC, generate a CSV (Full Export) from the Export button above the trade table, then upload it under Imports → CoinTracking in HQ Wealth. The importer maps all of CoinTracking's roughly 35 transaction types — including staking, LP and loan activity — onto HQ Wealth's ledger and rebuilds your cost basis.

Why will my CoinTracking export CSV not import elsewhere? The two usual causes are language and layout. The Full Export is language-sensitive, so a German or French export will not match an English-expecting importer. And if the file was ever opened and saved in Excel, the layout is likely corrupted. Re-export in English and upload the untouched file.

Bring your CoinTracking history into a real ledger

If CoinTracking got you through your first tax seasons but you now need double-entry accounting, wallet-level reconciliation, selectable cost-basis methods and reports an auditor will accept, HQ Wealth is built for exactly that migration. Export your Full Export today, import it at https://wealth.hq-fs.com, and see your entire history rebuilt as a proper set of books — DeFi positions included. And because the exchange works both ways, you are never locked in.