All Collections
Connecting Accounts & Importing Data
Adding Custom CSV Accounts
Detailed Examples for all Importable Transaction Types (A-Z)
Detailed Examples for all Importable Transaction Types (A-Z)

Detailed information for custom CSV transaction types

Daniel Howitt avatar
Written by Daniel Howitt
Updated over a week ago

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

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?