Latest Blog Posts

How do I export my trading history?

You are here:
< All Topics
Table of Contents

Each exchange has a different method of exporting your trading history so it can be uploaded into the Taxoshi calculator. Generally your trading history export can usually be found in your account options.

Some exchanges let you export your entire history which is fine, you can narrow down the date range you want to report on during the Taxoshi report wizard. Others let you select a date range or export by calendar year. Either way, you need to make sure the data you export covers all the dates you want to include in a report, even if that means making multiple exports. The Taxoshi report wizard allows you to upload multiple files even if they’re from the same exchange, just make sure you don’t duplicate entries or miss some of the dates you want to report on.


Binance

Under the “Orders” menu go to the “Spot Order” page. Then click on “Trade History” (not Order History). From here there are two ways you can export your trading history; Generate All Trade Statements or Export Recent Trade History.

The preferred way is to use the “Generate All Trade Statements” method, so click that link and a popup should appear. For Period select “Customize” and then use the date picker to select the date range for the tax year you wish to export. For Pairs choose “All – All” and then click Generate.

This file will take some time to be generated but you should receive an email when it is ready to be downloaded. When it’s ready, return to this popup window and you should see the download available at the bottom. The file which is downloaded should be a .csv file in the following format;

Date(UTC)PairSidePriceExecutedAmountFee
2020-12-25 16:20:00NAVBTCBUY0.00001510213.1900000000NAV 0.00321917BTC 0.2131900000NAV

Alternatively you can click on “Export Recent Trade History” and select “Custom” then use the date picker to select the date range you wish to export. This option only allows you to export 3 months at a time, so you’ll need to make multiple exports to get all the data you need to calculate for one tax year then and upload all of them to Taxoshi. The files which are downloaded should be a .xlsx file in the following format;

Date(UTC)MarketTypePriceAmountTotalFeeFee Coin
2020-12-25 16:20:00NAVBTCSELL0.0000475413.48 0.01964030 0.00001964 BTC

If your exports do not have these exact columns, then check you are in the right area of Binance. Currently we only support processing the Trade History exports under Spot Orders. A common mistake is to try and upload the Order History export under Spot Orders, but this file does not have all the required information to do the calculation correctly.

If you edit the file in any spreadsheet software, make sure the date format is preserved when you save the file. Most software will reformat the dates which will mean we can not process the file.

If you can’t find this page or have any trouble exporting your trading history, you will need to contact Binance directly as we can not offer any further assistance with your account there.

https://www.binance.com/en/support-center


Bittrex

Click on the “Orders” menu and in the “Order History” section there should be a button to “Download History” “Buy/Sell History” page. Bittrex only allows you to export by the calendar year. Since most tax years overlap the calendar years you’ll need to export 2 years to cover one full tax year. The file format which Bittrex outputs is a “csv” file which Taxoshi will accept in the report wizard when you select “Bittrex”.

Uuid Exchange TimeStamp OrderType Limit Quantity QuantityRemaining Commission Price PricePerUnit IsConditional Condition ConditionTarget ImmediateOrCancel Closed TimeInForceTypeId TimeInForce
<id> BTC-DASH 1/15/2019 10:03:37 PM LIMIT_SELL 0.01900000 110.00000000 0.00000000 0.00524049 2.09622686 0.01905661 FALSE
0.00000000 FALSE 1/15/2019 10:03:38 PM 0
<id> BTC-DASH 1/20/2019 9:14:35 PM LIMIT_BUY 0.01914160 37.78900000 0.00000000 0.00180834 0.72334190 0.01914160 FALSE
0.00000000 TRUE 1/20/2019 9:14:35 PM 2

If you edit the file in any spreadsheet software, make sure the date format is preserved when you save the file. Most software will reformat the dates which will mean we can not process the file.

If you can’t find this page or have any trouble exporting your trading history, you will need to contact Bittrex directly as we can not offer any further assistance with your account there.

https://bittrexglobal.zendesk.com/hc/en-us


Poloniex

Under the “Orders” menu go to the “My Trade History and Analysis” page. From here you can click on “Export History” in the top right of the page. Choose “Trade” for the history type and select the date range you want to export. The file format which Poloniex outputs is a “csv” with the following format;

Date Market Category Type Price Amount Total Fee Order Number Base Total Less Fee Quote Total Less Fee Fee Currency Fee Total
2019-05-20 02:32:31 ETH/BTC Exchange Sell 0.03135727 2.95514726 0.09266535 0.2% <id> 0.09248001 -2.95514726 BTC 0.00018533
2019-05-20 02:29:29 NAV/BTC Exchange BUY 0.00002774 7607.42818954 0.21103005 0.2% <id> 0.21060798 7607.42818954 BTC 0.00042206

If you edit the file in any spreadsheet software, make sure the date format is preserved when you save the file. Most software will reformat the dates which will mean we can not process the file.

If you can’t find this page or have any trouble exporting your trading history, you will need to contact Poloniex directly as we can not offer any further assistance with your account there.

https://support.poloniex.com/hc/en-us


Easy Crypto

Under the “My Account” menu go to the “Orders” page. From here you can click on “Download a CSV of your complete orders” in the bottom left of the page. This will export your entire history, so there is nothing else to do. The file format which Easy Crypto outputs is a “csv” file in the following format;

DateOrderTypeCoinNZDAmountAddressMemo
2019-11-14 20:55:00 <id> buyBTC164.000.01181222000000000000 <bitcoin_address>
2019-12-28 20:30:26 <id>sellBTC2000.01181222000000000000

If you edit the file in any spreadsheet software, make sure the date format is preserved when you save the file. Most software will reformat the dates which will mean we can not process the file.

If you can’t find this page or have any trouble exporting your trading history, you will need to contact Easy Crypto directly as we can not offer any further assistance with your account there.

https://www.easycrypto.nz/help


BitPrime

In the navigation menu, click on the “My Account”, then click on “Orders” on the account menu. From here you can click on the “Export CSV” button above your order history. This will export your entire history, so there is nothing else to do. The file format which BitPrime outputs is a “csv” file in the following format;

Order Date Status Amount Cryptocurrency Wallet Total Actions
<id> 2019/12/30 Completed 0.02627293 Bitcoin (BTC) <bitcoin_address> $300.00 View

If you edit the file in any spreadsheet software, make sure the date format is preserved when you save the file. Most software will reformat the dates which will mean we can not process the file.

If you can’t find this page or have any trouble exporting your trading history, you will need to contact BitPrime directly as we can not offer any further assistance with your account there.

https://www.bitprime.co.nz/knowledge-base/


Vimba

Click on the “Transactions” menu and from here click on “Export CSV” link in the top right of the page. This will export your entire history, so there is nothing else to do. The file format which Vimba outputs is a “csv” file in the following format;

Date Type Crypto Status Fee Rate NZD CryptoAmount
12/07/2019 SAVED bitcoin Delivered 0.10011 mBTC $17,464.20 $50.00 2.76013 mBTC
09/07/2019 SOLD bitcoin Sold 0 mBTC $17,632.35 $1,566.01 88.81458 mBTC
07/06/2019 BOUGHT bitcoin Delivered 0 mBTC $12,304.33 $50.00 4.06361 mBTC

If you edit the file in any spreadsheet software, make sure the date format is preserved when you save the file. Most software will reformat the dates which will mean we can not process the file.

If you can’t find this page or have any trouble exporting your trading history, you will need to contact Vimba directly as we can not offer any further assistance with your account there.

https://support.vimba.co


Dasset

Click on the “Balances” menu and scroll to the bottom of the page. Configure the history export and press “submit”. This will export your entire history, so there is nothing else to do. The file format which Dasset outputs is a “csv” file in the following format;

Trade ID TradeTime (Pacific/Auckland) Status Trading pair (Instrument) Side Quantity Price Fee Fee Currency Total
<id> 2020-09-23 02:34:17 PM Completed BTC-NZD BUY 0.0005 15826.649904725 0.09206193551718280 NZD 8.00538689
<id> 2020-09-23 02:36:25 PM Completed BTC-NZD SELL 0.00051111 15828.349409736 0.09411766107669480 NZD 8.18414533

If you edit the file in any spreadsheet software, make sure the date format is preserved when you save the file. Most software will reformat the dates which will mean we can not process the file.

Dasset has recent transitioned to a new platform and not all of their historical trade data is available in the format which we support yet. If you can’t find this page or have any trouble exporting your full trading history, you will need to contact Dasset directly as we can not offer any further assistance with your account there.

https://support.dassetx.com/hc/en-nz


Local Bitcoins

Click on the “Dashboard” icon in the top right of the nagivation bar. Then click on the “Completed Trades” tab on the dashboard. Then press the “Download data in CSV format” button and choose where you want to save the file. This will export your entire history, so there is nothing else to do. The file format which Localbitcoins outputs is a “csv” file which Taxoshi will accept in the report wizard when you select “Localbitcoins”.

id created_at buyer seller trade_type btc_amount btc_traded fee_btc btc_amount_less_fee btc_final fiat_amount fiat_fee fiat_per_btc currency exchange_rate transaction_released_at online_provider reference
<id> 2020-10-15 08:00:00+00:00 user1 user2 ONLINE_BUY 1 1 0 1 1 15000.00 0 15000.00 NZD 15000.00 2020-10-15 09:00:00+00:00 CASH_DEPOSIT <ref>
<id>2020-11-17 08:00:00+00:00 user1 user3 ONLINE_SELL 1 1 0 1 1 25000.00 0 25000.00 NZD 25000.00 2020-11-17 09:00:00+00:00 SPECIFIC_BANK <ref>

If you edit the file in any spreadsheet software, make sure the date format is preserved when you save the file. Most software will reformat the dates which will mean we can not process the file.

If you can’t find this page or have any trouble exporting your full trading history, you will need to contact Localbitcoins directly as we can not offer any further assistance with your account there.

https://localbitcoins.com/support/request


Kraken

Click on the “History” tab in the menu at the top of the page. Then click on the “Export” sub menu on that page. From here set the date range you wish to export and click “Submit”. The export will be queued and available to download through once it has been generated.

The file which is downloaded should be a .csv file in the following format;

txid ordertxid pair time type ordertype price cost fee vol margin misc ledgers
<id> OZM7B7-IX4C7-GYOBX6 XICNXXBT2017-02-15 07:47:20.124 buy market 0.000371 2.000000 0.005200 5390.83557951 0.000000
LM73TA-CKUYK-FLQZA3,LEP46J-LIB2D-EJQTLC

If you edit the file in any spreadsheet software, make sure the date format is preserved when you save the file. Most software will reformat the dates which will mean we can not process the file.

If you can’t find this page or have any trouble exporting your full trading history, you will need to contact Kraken directly as we can not offer any further assistance with your account there.

https://support.kraken.com/hc/en-us


Kraken

Click on the “Trade” tab in the menu at the top of the page. At the bottom, there should be a section of the page labelled “Order History”. Click on the download icon to the right of the section heading. Choose the dates you wish to export, tick the box that says “include unsettled orders (partially filled)”, choose the option “Download order history as CSV” and click the download button.

The file which is downloaded should be a .csv file in the following format;

Settled Date Date Order GUID Order Type Status Open/Closed Primary Currency Volume Outstanding Secondary Currency Price Average Price Value Brokerage Brokerage Fee GST Total Cost
23 Jun 2020 11:14:36 23 Jun 2020 11:14:36 33f9c8d6-3bde-41b0-91a4-74ef7da73b6b Market Buy Filled Closed BTC 0.33149238 0.00000000 NZD   15008.26 4975.12 24.87 0.50%   4999.99
18 May 2020 17:42:33 18 May 2020 17:42:33 b577a6e2-6a26-4105-b224-e2619fde7078 Market Buy Filled Closed ETH 13.60320553 0.00000000 NZD   365.72 4974.99 24.87 0.50%   4999.87

If your file is not in this format, it’s likely you exported the Transaction History from the “Accounts” page instead of your trading history. Please follow the instructions above to download the correct file.

If you edit the file in any spreadsheet software, make sure the date format is preserved when you save the file. Most software will reformat the dates which will mean we can not process the file.

If you can’t find this page or have any trouble exporting your full trading history, you will need to contact Independent Reserve directly as we can not offer any further assistance with your account there.

https://www.independentreserve.com/help


Exodus Wallet

Open your exodus wallet and click on the history icon in the top menu bar. On the history page there should be three vertical dots which you can click to open a drop down menu. From the menu you can choose “Export All Exchanged” or “Export All Transactions” will work as well.

The file which is downloaded should be a .csv file in the following format;

DATE TYPE FROMPORTFOLIO TOPORTFOLIO OUTAMOUNT OUTCURRENCY FEEAMOUNT FEECURRENCY OUTTXID OUTTXURL INAMOUNT INCURRENCY INTXID INTXURL ORDERID PERSONALNOTE TOADDRESS
Sat Dec 30 2017 11:43:58 GMT+1300 (New Zealand Daylight Time) exchange
-0.182
ETH
-0.0005721
ETH
<transaction_id><block_explorer_link>3.9876542 LTC <transaction_id><block_explorer_link><order_id>


Some details like the transaction id’s and block explorer links have been truncated for readability.

If you edit the file in any spreadsheet software, make sure the date format is preserved when you save the file. Most software will reformat the dates which will mean we can not process the file.

If you can’t find this page or have any trouble exporting your full trading history, you will need to contact Exodus directly as we can not offer any further assistance with your account there.

https://www.exodus.com/contact-support/

Other Resources


IRD Guidance

The Inland Revenue has released more information on their position on cryptocurrency and tax


Read More

Employee Schemes

Inland Revenue is extending its guidance on cryptocurrencies to cover their use in employee share schemes


Read More

Industry Opinion

Scott Mason from Findex unpacks the Inland Revenue guidance on cryptocurrency taxation


Read More

Taxoshi is a New Zealand startup with the vision of bringing deeper compliance to the blockchain ecosystem globally. Join us on the journey.