To get started, you will want to download TaxBit’s template file so you can see exactly how your data needs to be formatted. The template file contains highlighted rows of example data that is properly formatted. In this tutorial, we will add our data in the rows beneath the example data, and then delete the example data rows once we are finished entering our data.
We will go through each of the columns in the template. Make sure that you don't edit any of the column headers names or position, as they need to be left exactly as they are in order for your file to properly upload.
The first column represents the date and time of your transactions. Data in this column must be formatted in the ISO 8601 standard date time format. The template file included will auto format to the ISO 8601 standard simply from typing out the date and time like so:
Or alternatively just copy and paste from your exported exchange transaction data.
TaxBit supports the following transaction types:
Purchase of crypto with fiat (i.e; Paid $5,000 for 1 BTC)
Sale of crypto for fiat (i.e; Sold 1 BTC for $5,000)
Trading one crypto for another crypto (i.e; Trade 1 BTC for 10 ETH)
Transfer crypto in of your possession
Transfer crypto out of your possession
Received crypto in return for goods or services (i.e; Received 1 BTC in return for mining)
Sent crypto in return for goods or services (i.e; Sent 1 BTC as payment for a car)
If you exported your data from an exchange, some exchanges label everything as buy or sale, including crypto to crypto trades. You need to make sure to change the transaction type to trade if your transaction consisted of trading one cryptocurrency for another.
This columns represents the quantity of currency that you gave up, which should be a fiat value in the case of the transaction type buy, and a cryptocurrency value in the cases of the transaction types trade or sale.
This needs to be the 3-4 character currency symbol of what you gave up, which should be a fiat currency symbol in the case of the transaction type buy, and a cryptocurrency symbol in the cases of the transaction types trade or sale.
This column is optional, but is good to include if you want to be able to sort and filter your transactions by source in your TaxBit account. You can enter the name of the exchange or wallet the currency was sent from.
The next three columns are the same as the previous three, only we are now dealing with the receiving side of the transaction instead of the sending side. Go ahead and fill in your received quantity, received currency, and optionally receiving destination now.
Most exchanges charge fees to transact. If you bought cryptocurrency then it is allowable to add fees into your cost basis and if you "Sell" or "Trade" you can deduct fees from your proceeds. This is beneficial because it will lower your resulting gains or increase your losses. Enter your transaction fees in this column and we will handle the rest!
This needs to be the 3-4 character currency symbol of the fee you paid.
Some exchanges include transaction IDs and block transaction hashes, which can be included in the last two columns if available. These columns are optional, and don't need to be included unless the information is readily available to you.
After you have entered in all of your information, you can now delete the example rows. Now you are ready to convert the excel template file to CSV format and upload it into TaxBit.
In order to convert the Excel document to CSV, click File > Save As > then change the file format from Excel Workbook (.xlsx) to CSV Comma Delimited (.csv), and save it to a location that you can easily find.
In order to convert the Excel document to CSV, click File > Download As > Comma-seperated Values (.csv), and save it to a location that you can easily find.
In order to convert the Excel document to CSV, click File > Export To > CSV... and save it to a location that you can easily find.
Finally, go to the TaxBit CSV import page, then select and upload your file!
Depending on the size of your CSV file processing time could take up to 1 hour. Please do not attempt to upload your CSV file again during this time or you risk creating duplicates. If it’s been over an hour and you do not yet see your transactions in your account, please contact us.