Crypto transaction log with pooled cost

How to use it

1. 1Add every transaction in date order, one row per token movement. A swap is two rows: the token given and the token received.
2. 2Enter values in pounds at the time of the transaction, and any fees in pounds.
3. 3Tokens received as income from mining, staking or lending, or as pay, go in at their value when received. Income Tax applies to that value, and Capital Gains Tax only to later growth.
4. 4Transfers between your own wallets aren't disposals. Record them for the trail; they don't change the pool.
5. 5The pool columns use average cost per token. Same-day and 30-day matches follow the share rules instead, so work those out separately.

What each field means

Token

Use the same name every time, such as BTC. Each token has its own pool.

Type

Acquisitions, disposals, or a transfer between your own wallets.

Number of tokens

Always positive. The type sets the direction.

Value in pounds

The cost, proceeds or market value at the time.

Tokens held after

Your balance of that token after the row.

Pool cost before and after

The pooled cost of that token either side of the row.

Pooled cost of disposal

The share of the pool used by a disposal: pool cost × tokens disposed ÷ tokens held.

Gain or loss

Proceeds less fees less the pooled cost.

What counts as a disposal

You may owe Capital Gains Tax when you dispose of cryptoasset tokens by selling them, exchanging them for a different token, using them to pay for goods or services, or giving them away, unless the gift is to your spouse, civil partner or a charity. If your total gains for the tax year are above the £3,000 annual exempt amount, you must report them and pay.

Tokens from employment, mining, staking or lending count as income. If you've paid Income Tax on a token's value, Capital Gains Tax applies only to the gain after you received it.

Pooling and the records HMRC asks for

HMRC requires each type of token to be pooled. When you buy or receive tokens, add what you paid to the pool. When you dispose of some, deduct the same proportion of the pooled cost. Tokens bought on the same day as a sale, or within 30 days after it, aren't pooled: they're matched under the rules for shares in HMRC helpsheet HS284.

For each pool, keep the type of token, the date, the number disposed of and left, the value in pounds, bank statements and the pooled cost before and after each disposal. Exchange reports can help, but they aren't tax calculations and don't track pooled costs.

Licence and disclaimer

Free to use, copy and adapt for your own business or personal records. Please don't resell it or republish it as your own template.

A template is a starting point, not advice for your circumstances. Check the result against the GOV.UK guidance linked below, or ask an accountant.