How do I export my trading history?

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.

Under the “Orders” menu go to the “Spot Order” page. Then click on “Trade History” (not Order History). From here click on the “Export” button in the top right corner and a popup should appear. For Period select “Beyond 6 Months – Custom” and then use the date picker to select the date range for the tax year you wish to export. The date range is limited to 12 months, so you will need to export each year separately if you need multiple years. 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 click on “Beyond 6 Months – Custom” and you should see the download available at the bottom. The file which is downloaded should be zip file which you can extract the .csv data file from which will be in the following format;

Date(UTC)	Pair	Side	Price	Executed	Amount	Fee
2020-12-25 16:20:00	NAVBTC	BUY	0.00001510	213.1900000000NAV	0.00321917BTC	0.2131900000NAV

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

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

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

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;

Date	Order	Type	Coin	NZD	Amount	Address	Memo
2019-11-14 20:55:00	<id>	buy	BTC	164.00	0.01181222000000000000	<bitcoin_address>
2019-12-28 20:30:26	<id>	sell	BTC	200	0.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

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/

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

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

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

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

XICNXXBT

2017-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

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

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/