1. support@cryptact
  2. Ledger (formally tax@cryptact)
  3. How to use

Custom File for any other trades

Avatar
support desk

For unsupported exchanges, you can still upload trade history by preparing for a custom file. 

Please read the following instructions and create an Excel（.xlsx) or CSV (.csv) file, and upload it in "Custom" box at the upload screen of Cryptact.

Caution: Invalid trades

If you upload a custom file to fix invalid trades such as unsupported coins or missing prices, please be careful that those invalid trades might be rectified automatically in our future system enhancements. Before uploading a custom file, please ensure those invalid trades remain invalid; otherwise you might end up with double booking.

Table of contents

  1. The format of a custom file
  2. Custom file examples - case by case
    1. Trades at unsuported exchanges, dealing with hard forks
    2. Joined ICO
    3. Purchase goods or service by cryptocurrencies
    4. Mining
    5. Transaction fee
    6. Missing prices
    7. Unsupported coins
    8. Received coins by bonus, campaign, or AirDrop
    9. Interests from coin lending
    10. Staking reward
    11. Borrowing/Returning between individuals
    12. Give a tip / Decrease the position
    13. Expense paid in Fiat currency
  3. Derivatives 

1.The format of a custom file

You don't have to upload cryptocurrency transfers in general.

You don't have to upload transfers between your accounts or addresses to calculate positions in Cryptact. If you want to reduce your position by transaction fee, however, please follow Transaction fee

Name Description Example
Timestamp
Trade datetime in YYYY/MM/DD HH:mm:ss
Timezone can be specified in the upload screen later.
 2016/12/23 12:23:34
Action BUY/SELL/PAY/MINING/SENDFEE/TIP/REDUCE/BONUS/LENDING BUY
Source data source name (exchange or shop name) Happy Travel
Base
Base currency
Please choose from Supported Coins 
 ICN
DerivType
Type of derivaties. Choose among "fx", "future", and "option".
You can omit this column if you don't trade derivatives
  
DerivDetails
Details of derivatives 
You can omit this column if you don't trade derivatives
  
Volume Amount of change of base currency (in absolute value) 150
Price

Base currency price in Counter currency

If this field is empty, cryptact uses its own price

 550
Counter
Counter currency
Please choose from the supported coins list
 JPY
Fee Fee for the trade 0
FeeCcy
Fee currency
Please choose from the supported coins list
 JPY
Comment
Optional. Please use this field for your own purpose as Cryptact doesn't use this.
  

 

2.Custom file examples - case by case

Please check the following files which contains all samples

 

Example 1: Buy ETHBTC ( i.e. pay BTC to get ETH) at an unsupported exchange

You bought 2 ETH and paid BTC when the price of ETH was 0.5 BTC. The fee was 0.01 ETH.

 

Timestamp Action Source Base Volume Price Counter Fee FeeCcy
Trade datetime BUY your exchange name here ETH 2 0.5 BTC 0.01 ETH

 

Example 2: Got coins by hard fork

You got 10 BCH by hard fork
Timestamp Action Source Base Volume Price Counter Fee FeeCcy
Trade datetime BUY any BCH 10 0 (*1) USD 0 USD

(*1) Please specify $0 if it is hard fork.

 

Example: You joined ICO of XP by sending ETH. You sent 10ETH and got 500XP.

Timestamp Action Source Base Volume Price Counter Fee FeeCcy
The time when you sent ETH BUY any XP 500 0.02 
=10ETH/500XP
 ETH 0 JPY

 

Please make fee currency and counter currency to be the same.
 

Example 1: You paid 0.01 BTC to get a product worth 5,000 JPY. Given the price of the product and the amount of BTC paid, the rate of BTC is 1BTC=500,000JPY.

Timestamp Action Source Base Volume Price Counter Fee FeeCcy
datetime when you bought the product PAY any BTC 0.01 500000
5,000/0.01 = 500,000
 JPY 0 JPY
Should be the same as Counter

 

Example 2: You paid 0.01BTC for a service whose price is quoted only in BTC.

Timestamp Action Source Base Volume Price Counter Fee FeeCcy
datetime when you bought the product PAY any BTC 0.01
Blank
 JPY 0 JPY (*1)
 

 (*1)Should be the same as Counter

 

Example 3: Cryptocurrency XYZW was not in the supported coin list. You paid 5 XYZW for a product. You know 1 XYZW was 300 JPY at that time.

Timestamp Action Source Base Volume Price Counter Fee FeeCcy
datetime when you bought the product PAY Any CTT2 (*1) 5 300 (*2) JPY 0 JPY (*3)
 

(*1)Please use the dummy symbol

(*2)Please find the rate by yourself.

(*3)Should be the same as Counter

 

Specify mining cost to the Fee column. We only support Fee currency which is same as Counter.

 

Example 1: Mined a coin whose price is available in Cryptact

You mined ETH and got 1 ETH. The cost was 10 USD.
Timestamp Action Source Base Volume Price                   Counter Fee FeeCcy
datetime when you mined MINING Any ETH 1
(Empty *1)
JPY 10 USD

 (*1)If you empty the price column, crypact will look up the price instead if we have the one.

 

Example 2: Mined a coin whose price is NOT available in cryptact.

You mined LSK and got 10LSK. The LSK price at that time was 1,000JPY per LSK. The cost was 1 USD.
Timestamp Action Source Base Volume Price Counter Fee FeeCcy
datetime you mined MINING Any LS 10 1000 JPY 1 USD

 

By default, fee is used only to reduce the position. If you want fee to be included into loss, please specify it in the settings screen.
 

Example: You spent 0.001 BTC for transfer.

Timestamp Action Source Base Volume Price Counter Fee FeeCcy
Transfer datetime SENDFEE any BTC 0.0001 （Emply *1) JPY (*2) 0(*2) BTC(*2)

   (*1) If you empty the price column, crypact will look up the price instead if we have the one.
(*2)We don't use Counter, Fee, FeeCcy columns. Please follow the example above.

 

Please divide the trade into two trades using a fiat currency.
 

Example: You bought 10ETH and paid 1BTC when 1ETH=0.1BTC. In Cryptact, that trade became invalid due to a missing price.
You researched by yourself and found 1BTC was 1,500,000 JPY at that time.

Timestamp Action Source Base Volume Price Counter Fee FeeCcy
trade datetime SELL any BTC 1 1500000 
Please find out the rate by yourself.
 JPY 0 JPY
trade datetime BUY any ETH 10 150000
0.1（ETHBTC price） x (BTCJPY price above)
 JPY 0.01 ETH

 

You can use dummy symbols from CTT2 to CTT199, if a certain currency is not supported in Cryptact.
 

Example: When 1BNK was 0.5BTC, you bought 2 BNK and paid 1BTC. Fee was 0.01BNK. In Cryptact, the trade became invalid becuase BNK wasn't supported.

Timestamp Action Source Base Volume Price Counter Fee FeeCcy
trade timestamp BUY any CTT2 2 0.5 BTC 0.01 CTT2

 

Example: You joined an exchange's trade campaign, and received 0.01BTC.

Timestamp Action Source Base Volume Price Counter Fee FeeCcy
datetime you received the coin BONUS Any BTC 0.01
(Empty *1)
 JPY(*2)
 
 0 JPY

 (*1) If you empty the price column, crypact will look up the price instead if we have the one.

(*2)We only supports fiat currencies as Counter for this trade type.

 

Example 2: You received 500XYZW by AirDrop. XYZW was not in the supported coins list. You researched by yourself and found 1 XYZW = 10JPY at that time.

Timestamp Action Source Base Volume Price Counter Fee FeeCcy
timestamp of the AirDrop BONUS Any CTT3
 (*1)
 500 10 JPY (*2)
 
 0 JPY

(*1)Use a dummy symbol as the currency isn't supported.

(*2)We only support fiat in trade type 'BONUS'

 

Example: You lent 10ETH to an exchange, and received 0.1ETH as an interest.

Timestamp Action Source Base Volume Price Counter Fee FeeCcy
datetime of the interest LENDING Any ETH 0.1
(Empty *1)
 JPY 0 JPY

 (*1) If you empty the price column, crypact will look up the price instead if we have the one.

 

Example: You got two LSK as a reward for staking. 　

Timestamp Action Source Base Volume Price Counter Fee FeeCcy
datetime of the interest STAKING Any LSK 2
(Empty *1)
 JPY 0 JPY

 (*1) If you empty the price column, crypact will look up the price instead if we have the one.

 

Example: Borrowing 3BAT at compound, then returned.

Timestamp Action Source Base Volume Price Counter Fee FeeCcy
datetime of the borrowing BORROW Any BAT 3
(Empty)
 JPY 0 JPY
datetime of the returning RETURN Same one with borrowing BAT 3
(Empty)
 JPY 0 JPY

※Please be noted: As there are no clear guidelines for DeFi, etc., there is a possibility that the content may change in the future.

 

2.12.Give a tip / Decrease the position

Example: Gave my friend 0.0001 BTC as a tip.

Timestamp Action Source Base Volume Price Counter Fee FeeCcy
datetime of giving a tip REDUCE Any BTC 0.0001
(Empty)
 JPY 0 JPY

※note: Decrease the position without affecting the profit and loss. 

 

Example: There is 2,000JPY in expenses that can be included in the cost of mining.

Timestamp Action Source Base Volume Price Counter Fee FeeCcy
datetime of payment CASH Any JPY 0
0
 JPY 2000 JPY

※note: If you have an income in a fiat currency, please enter a negative number in the Fee.

※note: If you paid in USD or other fiat currency, please fill USD in Base, Counter, and FeeCcy.

 

 

3.Derivaties

Specify DerivType and DerivDetail. Positions and profit and loss will be calculated by using DerivType+DerivDetail as a key.

 

Articles in this section