Detailed Examples for all Transaction Types (A-Z)

We maintain this Google Sheet and regularly add notes as we get feedback and make improvements to our example dataset. You can download this as a sample CSV by clicking the button below:


Airdrop

Cashback

Deposit

Donation

Fee

FeeRebate

Gambling

Gift

Income

LoanCollateral

LoanCollateralUnlocked

LoanInterest

LoanPrincipal

LoanPrincipalPayment

Lost

MarginGain

MarginLoss

Mining

Purchase
Spouse Gift

Stake

StakingReward

Stolen

Trade

Unstake

Withdrawal

AirDrop

Used in circumstances where crypto assets are transferred to you, that you did not explicitly buy.

If you need to add a ‘free’ airdrop - use the PriceAmount, PriceBaseAsset and PriceQuoteAsset columns to specify a 0 price for the asset. You will be able to see that there is a fixed User Price used on the prices tab for the transaction in the activity screen.

Airdrop,2019-10-01T13:51:43Z,100,OMG,,,,,,,Airdrop,,, Airdrop,2018-09-27T09:21:43Z +0000,50,ADA,,,,,,,Free airdrop of 50 ADA (manually valued to 0),0,ADA,GBP

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

Airdrop

2019-10-01T13:51:43Z

100

OMG


Cashback

Cashback,2022-05-11T08:23:32Z,0.1,CRO,,,,,,,Cashback received from cashback credit card,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

Cashback

2022-05-11T08:23:32Z

0.1

CRO


Deposit

Deposit,2019-09-26T21:23:43Z,2000,GBP,,,,,,,Deposit of funds,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

Deposit

2019-09-26T21:23:43Z

2000

GBP


Withdrawal

Withdrawal,2019-10-14T12:22:22Z,,,0.3,BTC,,,0.05,BTC,Move some bitcoin to my wallet,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

Withdrawal

2019-10-14T12:22:22Z

0.3

BTC

0.05

BTC


Stake

A crypto asset that you’ve staked, to earn staking rewards (for example)

Stake,2022-05-13T08:23:32Z,,,10,FLOW,,,,,,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

Stake

2022-05-13T08:23:32Z

10

FLOW

Unstake

The unstaking of the crypto asset that was previously staked

Unstake,2022-05-25T08:23:32Z,10,FLOW,,,,,,,,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

Unstake

2022-05-25T08:23:32Z

10

FLOW


StakingReward

A staking reward received on your staked crypto assets

StakingReward,2022-05-20T08:23:32Z,1,FLOW,,,,,,,,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

StakingReward

2022-05-20T08:23:32Z

1

FLOW


FeeRebate

A fee rebate given - a typical example would be a crypto exchange giving you a rebate on fees, for staking a certain asset or by being a VIP customer.

FeeRebate,2022-05-09T08:23:32Z,0.01,ETH,,,,,,,The exchange refunded me some ETH as maker fee rebate,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

FeeRebate

2022-05-09T08:23:32Z

0.01

ETH


Income

Income acquired in a given crypto asset

Income,2022-05-12T08:23:32Z,1000,USDC,,,,,,,Did some consultancy work for a client,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

Income

2022-05-12T08:23:32Z

1000

USDC


Mining

The acquisition of crypto assets from mining on a proof-of-work chain

Mining,2014-05-10T08:23:32Z,0.9,BTC,,,,,,,Mined some BTC back in the day,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

Mining

2014-05-10T08:23:32Z

0.9

BTC


Trade

Buying or selling of spot crypto assets

Trade,2019-09-29T11:01:23Z,0.064,BTC,3,ETH,,,0.001,ETH,Buy some BTC with ETH,,, Trade,2020-09-27T09:21:43Z,0.2,BTC,1344.76,USD,,,4.32,GBP,Buy 0.2 BTC,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

Trade

2019-09-29T08:23:32Z

5

ETH

720.85

GBP

0.05

ETH


MarginGain

The realised gain from a margin trade

MarginGain,2022-05-07T09:21:43Z,1.6,BTC,,,,,,,Closed a margin position at a gain,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

MarginGain

2019-10-09T11:32:00Z

1400

GBP

0.005

BTC


MarginLoss

The realised loss from a margin trade

MarginLoss,2022-05-08T10:12:23Z,,,1,BTC,,,,,Closed a margin position at a loss,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

ValueAmount

ValueCurrency

FeeAmount

FeeCurrency

MarginLoss

2019-10-11T22:21:22Z

100

GBP

0.0025

BTC


Fee

A specific, one-off fee

Fee,2022-05-29T08:23:32Z,,,0.01,ADA,,,,,Failed to execute transaction - still got charged a fee,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

Fee

2022-05-29T08:23:32Z

0.01

ADA


LoanPrincipal

This represents the asset that you’ve borrowed

LoanPrincipal,2021-07-29T10:01:23Z,10,ETH,,,,,10,GBP,Loan principal of 10 eth,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

LoanPrincipal

2021-07-29T10:01:23Z

10

ETH

10

GBP

LoanCollateral

This represents the locking of your loan collateral

LoanCollateral,2021-07-30T11:01:23Z,10,ETH,,,,,,,Loan collateral lock,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

LoanCollateral

2021-07-30T11:01:23Z

10

ETH


LoanInterest

This represents any/all interest payments made on the borrowed asset

LoanInterest,2021-10-29T11:01:23Z,,,,,,,5,GBP,Loan interest of a fiver,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

LoanInterest

2021-10-29T11:01:23Z

5

GBP


LoanPrincipalPayment

This represents the repayment of the borrowed asset

LoanPrincipalPayment,2021-11-29T11:01:23Z,,,10,ETH,,,,,Loan principal repaid,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

LoanPrincipalPayment

2021-11-29T11:01:23Z

10

ETH


LoanCollateralUnlocked

This represents the unlock of the loan collateral

LoanCollateralUnlocked,2021-07-30T11:01:23Z,,,10,ETH,,,,,Loan collateral unlocked,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

LoanCollateralUnlocked

2021-07-30T11:01:23Z

10

ETH


Gift

Someone who is not your spouse has gifted you an asset, or you have sent a gift to them

Gift,2019-10-02T09:21:53Z,4,LTC,,,,,,,"Oh! Someone's given me some LTC, which I’ve manually valued",100,LTC,GBP Gift,2019-10-03T04:23:23Z,,,0.5,LTC,,,,,Give someone some LTC because I'm nice,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

PriceAmount

PriceBaseAsset

PriceQuoteAsset

Gift

2019-10-02T09:21:53Z

4

LTC

100

LTC

GBP


Spouse

You have gifted an asset to your spouse, or your spouse has gifted you an asset

Spouse,2022-05-28T08:23:32Z,400,ADA,,,140,GBP,,,Received a lovely gift from my wife - with her cost basis of 140 GBP,,, Spouse,2019-12-25T12:22:22Z,,,0.01,BTC,,,0.0001,BTC,Christmas gift to my spouse,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

Spouse

2019-12-25T12:22:22Z

0.01

BTC

0.0001

BTC


Gambling

A win or loss of a crypto asset at a casino

Gambling,2019-10-03T06:53:34Z,0.1,BTC,,,,,,,Yay! Won some BTC at a casino,,, Gambling,2019-10-03T08:23:41Z,,,0.05,BTC,,,,,Woah almost lost my winnings!,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

Gambling

2019-10-03T06:53:34Z

0.1

BTC

Gambling

2019-10-03T08:23:41Z

0.05

BTC


Purchase

A purchase of an item made with a crypto asset

Purchase,2019-10-04T17:23:12Z,,,0.1,LTC,,,,,Made a nice purchase! Probably pizza,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

Purchase

2019-10-04T17:23:12Z

0.1

LTC


Donation

A charitable gift

Donation,2019-10-04T18:45:03Z,,,0.5,DASH,,,,,Donated to charity. I almost feel human,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

Donation

2019-10-04T18:45:03Z

0.5

DASH


Lost

An example would be losing a hard drive containing your private key, rendering the assets unrecoverable

Lost,2019-10-08T10:29:43Z,,,0.01,LTC,,,,,"Lost that wallet, lucky it had very little in it.",,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

Lost

2019-10-08T10:29:43Z

0.01

LTC


Stolen

Assets which have been stolen for example during a phishing or social engineering scam

Stolen,2019-10-07T09:22:03Z,,,3,DASH,,,,,Ooops! Should have been more careful,,,

Type

Date

InOrBuyAmount

InOrBuyCurrency

OutOrSellAmount

OutOrSellCurrency

FeeAmount

FeeCurrency

Stolen

2019-10-07T09:22:03Z

3

DASH


Did this answer your question?