Are there doubts about what HMRC expects for cryptocurrency records or how to produce usable transaction history from Coinbase UK? This guide focuses on practical, HMRC‑aligned record keeping for crypto so that reporting on Self Assessment is defensible, efficient and repeatable.
The content is aimed at individuals and small businesses using Coinbase UK and similar custodial platforms; it concentrates on the precise records to retain, step‑by‑step export and reconciliation workflows, common HMRC queries and concrete safeguards to avoid penalties.
Key takeaways: what to know in 1 minute
- Keep a full export of transactions: date, type, asset, quantity, GBP value at disposal/acquisition, fees and counterparty (if external).
- Use CSV exports and reconcile: a CSV from Coinbase UK plus a short reconciliation log proves how figures were calculated.
- Apply HMRC pooling rules: crypto‑to‑crypto swaps and transfers between own wallets affect cost basis, record the GBP value at the time of each event.
- Treat staking and airdrops as taxable events: ensure receipt date, token quantity and GBP value are recorded separately from trading history.
- Prepare an evidence pack for HMRC: raw CSVs, exchange statements, screenshots of balances (timestamped) and a reconciliation worksheet.
Why record keeping for crypto matters under UK law
HMRC treats many crypto transactions as capital disposals or income depending on the event. Proper record keeping is not optional: Self Assessment requires figures that are reproducible, and HMRC compliance checks rely on auditable trails. The statutory expectation is that records are accurate, contemporaneous and retained for the required period (usually five years after the 31 January submission deadline for the relevant tax year).
Refer to the official guidance from HMRC for detailed rules: HMRC: Tax on cryptoassets.
How to export Coinbase UK transaction history for HMRC
This section provides a step‑by‑step workflow to export usable data from Coinbase UK for HMRC reporting. The objective is a complete CSV that includes timestamps, types and GBP valuations.
- Sign in to Coinbase UK and navigate to the account activity or reports section.
- Use the official export tool to generate a full account history or date‑range CSV. See Coinbase guidance: Coinbase: exporting data.
Step 2: request all relevant exports
- Export transactions (trades, deposits, withdrawals).
- Export account statements (monthly/annual) where available.
- Export fees and network fees separately if produced.
Step 3: produce GBP valuations for each row
- Coinbase may show values in native token units and USD. HMRC requires GBP values at the time of each event. Where the CSV lacks GBP, add a column with GBP value using a reliable historical rate (see below).
Step 4: preserve raw evidence
- Download the raw CSV(s) and save copies in at least two secure locations (encrypted cloud backup and an offline copy).
- Take timestamped screenshots of the export confirmation and the account summary for the date ranges used.
Using CSV exports from Coinbase UK for tax calculations
CSV exports are the working material for tax calculations. A repeatable workflow reduces errors and speeds up self‑assessment.
Recommended CSV columns to keep (minimum)
- Date/time (UTC)
- Transaction type (buy, sell, send, receive, swap, stake reward, airdrop)
- Asset (BTC, ETH, etc.)
- Quantity
- Fee (asset and GBP equivalent)
- GBP value at time of event (acquisition or disposal)
- Counterparty or wallet address (if external)
- Transaction ID / reference
How to get accurate GBP values
- Use a reputable historical exchange rate provider and record the source for each date (for example aggregator APIs or CoinMarketCap, CoinGecko). Cite the source in the reconciliation worksheet.
- For trades executed on Coinbase, Coinbase’s own GBP conversion at the time can be used if present in the export.
Practical checklist before running calculations
- Confirm CSV includes every trading and non‑trading event.
- Identify transfers between user’s own wallets and mark them as internal transfers (not disposals), but keep evidence.
- Separate staking/airdrops into a distinct ledger for income calculations.
Calculating capital gains from Coinbase UK trades
Capital gains calculations follow HMRC’s pooling and disposal rules. This section summarises the process and offers a reconciled example.
How HMRC pooling works in brief
- HMRC uses an average cost method with specific time‑based matching rules: same day, 30‑day matching and then pooled units for identical assets.
- For each disposal, determine which acquisition batches match the disposal using the HMRC ordering rules and calculate gain/loss in GBP.
Example calculation (simplified)
- Bought 1.5 BTC on 01‑Mar‑2024 at £30,000 total (cost £20,000 proportionate).
- Bought 0.5 BTC on 20‑Jul‑2024 at £20,000 total.
- Sold 1 BTC on 12‑Aug‑2024 for £25,000.
- Apply same day then 30‑day rules; if none apply, use pooled average cost across holdings in the pool at disposal date. Compute gain = proceeds (£25,000) minus apportioned cost.
- Use spreadsheet formulas or approved crypto tax software that understands HMRC matching rules. Always validate software results by manual checks for several sample disposals.
Reporting crypto-to-crypto trades and cost basis on Coinbase UK
Crypto‑to‑crypto trades are treated as disposals for capital gains. The crucial point is to calculate GBP proceeds at the time of swap and the GBP cost of the asset disposed.
What to record at the moment of the swap
- Type: crypto‑to‑crypto swap
- Asset sold, asset acquired and their quantities
- GBP value of disposed asset at time of swap (use market rate)
- Fees paid (in asset or GBP) and who charged them
Example: swap ETH for BTC
- Swap 10 ETH for 0.3 BTC on 01‑Jun‑2025.
- Determine the GBP value of the 10 ETH at that timestamp, that is the disposal proceeds for ETH, and the acquisition cost for the 0.3 BTC (ignoring fees). If fees exist, allocate them to the disposal or acquisition as appropriate.
Cost basis and pooling treatment
- The acquired BTC enters the BTC pool at the GBP cost established by that swap. Maintain a clear ledger row connecting the disposal and acquisition values so HMRC can trace the transaction.
Avoiding mistakes when reporting Coinbase UK staking and airdrops
Staking rewards and airdrops are often mishandled. They can be taxable as income and may create a base cost for later disposals.
How to record staking and airdrops correctly
- Record the date and time of receipt, asset, quantity and GBP value at receipt.
- Treat staking rewards as income at the GBP value when received; include them on the appropriate income tax return if required.
- For airdrops, confirm whether the event is unsolicited or requires action, unsolicited receipts are usually taxable when the taxpayer obtains control and can dispose of the tokens.
Common pitfalls
- Using end‑of‑day prices rather than the price at the actual timestamp. HMRC expects a reasonable method; document the chosen source.
- Folding staking income into capital gains without recording the initial income declaration and base cost.
Common HMRC queries about Coinbase UK statements
Preparing for queries reduces time spent responding and the risk of assessment adjustments.
Typical HMRC questions
- Can the taxpayer show the GBP conversion method for each event? Provide the source and a calculation column.
- Are transfers between wallets explained and evidenced? Provide transaction IDs and screenshots showing both sides of the transfer.
- How were crypto‑to‑crypto swaps valued? Provide market snapshots and the CSV row that links disposal and acquisition.
How to prepare an evidence pack
- Raw CSV exports from Coinbase (all pages/date ranges).
- A reconciliation worksheet that maps CSV rows to tax calculations and shows GBP conversion sources.
- Screenshots of key account balances with timestamps and transaction IDs.
- Copies of wallet transaction receipts for any transfers off‑exchange.
Comparison: manual record keeping vs exchange exports vs tax software
| Approach |
Typical accuracy |
Time required |
Best for |
| Manual spreadsheets |
Medium |
High |
Small number of trades; auditors who prefer control |
| Exchange CSV exports + reconciliation |
High |
Medium |
Most individuals using Coinbase UK |
| Dedicated crypto tax software |
Very high (if configured) |
Low once set up |
Frequent traders and professionals |
CSV export workflow and checks
CSV export workflow
📥
Step 1 → Export full transaction CSV from Coinbase
🔍
Step 2 → Add GBP valuation column using a chosen rate source
🧾
Step 3 → Mark internal transfers and separate staking/airdrops
✅
Step 4 → Reconcile totals to bank statements or withdrawal records
📦
Step 5 → Save an evidence pack for HMRC
Strategic analysis: advantages, risks and common errors
Benefits / when to apply ✅
- Use full export workflows when preparing Self Assessment to ensure numbers are auditable.
- Use tax software for scale: it enforces HMRC matching rules and speeds reconciliation.
- Keep separate ledgers for trading vs income (staking, airdrops) to simplify tax classification.
Errors to avoid / risks ⚠️
- Missing GBP valuations for crypto‑to‑crypto swaps.
- Treating internal transfers as disposals without evidence.
- Losing raw CSV exports or failing to keep timestamped screenshots.
How to prepare a HowTo export summary for an accountant
- Attach the raw CSV(s) (one file per account and date range).
- Provide a one‑page reconciliation summary that maps CSV rows to disposals, incomes and transfers.
- Include a short note describing the GBP source and the method used for rounding.
Questions frequently asked by users about record keeping for crypto
What records does HMRC require for crypto transactions?
HMRC expects date, type of transaction, asset, quantity, GBP value at time, fees and transaction reference. Retain underlying evidence for five years after the relevant self‑assessment filing deadline.
How long should crypto records be kept?
Keep records for at least five years after the 31 January submission deadline for the tax year to which they relate; in practice, keep raw exports longer where possible.
Can Coinbase statements alone satisfy HMRC?
Coinbase statements are strong evidence if they include GBP valuations, fees and transaction IDs. Supplement with screenshots and a reconciliation workbook to demonstrate calculations.
How should staking rewards be recorded?
Record staking receipts with date, token quantity and GBP value at receipt. Declare as miscellaneous income if HMRC guidance indicates income treatment.
Are transfers between personal wallets taxable?
Transfers between wallets owned by the same person are not disposals if control is not relinquished, but keep transaction IDs and timestamps to prove the link.
Which exchange rate source is acceptable to HMRC?
HMRC does not prescribe a single provider; use a reputable, time‑stamped source (CoinGecko, CoinMarketCap or exchange rate snapshots) and document the choice.
Is a single CSV enough for multiple years?
Provide per‑year summaries to match tax year reporting, plus raw CSVs covering the full period. Ensure the reconciliation shows which rows map to each tax year.
Your next step:
- Export all Coinbase UK CSVs for the tax year and save encrypted copies.
- Create a reconciliation worksheet mapping disposals, incomes and transfers with GBP valuations and the source cited.
- If trades exceed a handful, consider reputable crypto tax software and validate outputs with at least three manual checks.
