CSV Import Walkthrough

CSV Import Tutorial

CSV Template

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.

Important Note:

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.

Column 1:
Date and Time

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.

Column 2:
Transaction Type

TaxBit supports the following transaction types:

Buy
Purchase of crypto with fiat (i.e; Paid $5,000 for 1 BTC)
Sale
Sale of crypto for fiat (i.e; Sold 1 BTC for $5,000)
Trade
Trading one crypto for another crypto (i.e; Trade 1 BTC for 10 ETH)
Transfer
Transfer crypto to an exchange or wallet in your possession (i.e; Moved 1 BTC from Coinbase to a hardware wallet)
Income
Received crypto in return for goods or services (i.e; Received 1 BTC in return for mining)
Expense
Sent crypto in return for goods or services (i.e; Sent 1 BTC as payment for a car)

Important Note:

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.

Column 3:
Sent Quantity

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.

Column 4:
Sent Currency

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.

Column 5:
Sending Source

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.

Columns 6-8:
Receiving Columns

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.

Columns 9:
Fee Quantity

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!

Columns 10:
Fee Currency

This needs to be the 3-4 character currency symbol of the fee you paid.

Columns 11-12:
Transaction ID/Hash

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.

File Preparation

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.

Excel
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.

Google Spreadsheets
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.

Apple Numbers
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.

CSV Upload

Finally, go to the TaxBit CSV import page, then select and upload your file!

You will receive an email notification after uploading that will tell you if your upload was successful. If it wasn't successful, the email will contain the error that the file had so you can correct it and try uploading the file again.

Important Note:

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 have still not yet received an email confirmation please contact us.