Skip to main content

How do I download my account activity?

Updated
Read time: 3 min
Article Summary

This article explains how to download River's activity CSVs, understand each column, and import data into tax software like Koinly and CoinTracker.

You can download either your bitcoin activity or your account activity as CSV files. 

Your bitcoin activity CSV contains all completed bitcoin transactions on your account. Your account activity CSV contains a complete record of all bitcoin and cash transactions. 

After downloading, you can import your River CSV files into a tax or performance tracking software.

Please note that you can only download account activity from a web browser and not directly from the mobile app.


Step 1: Click "Taxes & Documents"
From river.com, click "Taxes & Documents" on the left side of the homepage. 


Step 2: Generate CSV
On the right side of the screen, you will see two drop-down boxes, one drop-down for the type of report you would like to generate and the other drop-down for the time period. After making your selections, click "Generate."

Please note that your CSV download will take a few moments to generate. Do not refresh the page until the download is complete.


Step 3: CSV downloaded
Once your CSV has been generated, your file will be saved to your computer's downloads folder.

How do I understand my CSV files?

Bitcoin Activity CSV

Column Title Description 
Date The date and time of the transaction in Coordinated Universal Time.
Sent Amount The amount of bitcoin or cash that was deducted from your account, not including any fees.
Sent Currency

The currency type of the "Sent Amount." This would be either BTC or USD. 

 For a bitcoin buy, the sent currency would be USD, as cash left your bank account in exchange for bitcoin.
Received Amount

The amount of bitcoin or cash that was deposited into your River account, not including fees.

For a bitcoin buy, the received amount would be the amount of exchanged bitcoin.
Received Currency

The currency of the "Received Amount." This would be either BTC or USD.

For a bitcoin buy, the currency would be BTC, as bitcoin entered your River account in exchange for cash. 
Fee Amount The amount that was paid in fees for the transaction.
Fee Currency The currency of the fee paid for the transaction. This would be either BTC or USD. 
Tag

Tags denote what type of transaction took place: 

  • "Buy" is for a bitcoin buy.
  • "Sell" is for a bitcoin sell.
  • "Mining" is for a mining payout.
  • "Withdrawal" is for any bitcoin sent using an automatic withdrawal.
  • "Income" is for any bitcoin received through a referral payout.
  • "Interest" is for any Bitcoin Interest on Cash.

Please note that cost basis information will be limited in the Account Activity CSV if there are unknown lots for any deposited bitcoin into your River account. 

Account Activity CSV

Column Title Description 
Date The date and time of the transaction in Coordinated Universal Time. 
Reference Code The reference code associated with a specific transaction. 
Transaction Type

Types of transactions include: 

  • Buy
  • Sell
  • Send
  • Receive
  • Auto Withdrawal
  • Mining Payout
  • Cash Deposit
  • Cash Withdrawal
  • Referral Reward
  • Internal Transfer
Sent Amount The amount of bitcoin or cash that was deducted from your account, not including any fees.
Sent Currency

The currency of the "Sent Amount." This would be BTC or USD.

  • For a BTC buy, the currency would be USD, as USD is leaving your account in exchange for BTC

The currency type of the "Sent Amount." This would be either BTC or USD. 

  • For a bitcoin buy, the sent currency would be USD, as cash left your bank account in exchange for bitcoin.
Received Amount

The amount of bitcoin or cash that was deposited into your River account, not including fees. 

For a bitcoin buy, the received amount would be the amount of exchanged bitcoin. 
Received Currency

The currency of the "Received Amount." This would be either BTC or USD.

For a bitcoin buy, the currency would be BTC, as bitcoin entered your River account in exchange for cash.
Fee Amount The amount that was paid in fees for the transaction.
Fee Currency The currency of the fee paid for the transaction. This would be either BTC or USD.
Total Amount The total amount of bitcoin or cash that has entered or left your River account, including fees.
Total Currency The currency of the total amount. This would be either BTC or USD.  
Method This explains how the funds moved to or from your account. This may be a bank transfer, on-chain, Lightning, wire, or other. 
Source This explains where the transaction originated. This may be your River cash balance, a linked bank account, your bitcoin balance, or other.
Destination This explains where the funds were headed. This may be your River cash balance, your bitcoin balance, a bitcoin wallet address, a linked bank account, or other.
Cost Basis The cost basis for the transaction, based on your chosen cost basis methodology. This column will be blank if your transaction includes an unknown lot.
Cost Basis Currency For a known lot, this will show as "USD." For an unknown lot, this will be blank.
Bitcoin Price Amount

For any buys, sells, sends, interest payouts, or mining payouts, this is the bitcoin price at the time of the transaction. 

For other transaction types, this will be blank.
Bitcoin Price Currency If there is a "Bitcoin Price Amount," this will show as "USD." Otherwise, this will be blank.
Transaction ID For bitcoin on-chain transfers or automatic withdrawals, this will show the associated transaction ID. 
Recurring If a transaction is for a recurring buy, this cell will contain "True." Otherwise, it will contain "False."
Tag

Tags denote what type of transaction took place: 

  • "Buy" is for a bitcoin buy.
  • "Sell" is for a bitcoin sell.
  • "Mining" is for a mining payout.
  • "Withdrawal" is for any bitcoin sent using an automatic withdrawal.
  • "Income" is for any bitcoin received through a referral payout.
  • "Interest" is for any Bitcoin Interest on Cash.

How do I import my downloaded CSV files into a tax tracking software?

To track your transactions for tax and performance purposes, you can import your generated CSV files to common software with minimal effort. 

Below are common software options and steps to format your River data. You may need to copy it into the software's template or edit the River file directly.

  • Koinly
    1. Repurpose the data in the "Tag" column into Koinly's "Label" column.
    2. Remove "Buy," "Sell," and any other tags not supported by Koinly.
  • CoinTracker
    1. Change order of columns.
      • Received columns should go before Sent columns.
    2. Rename "Received Amount" to "Received Quantity."
    3. Rename "Sent Amount" to "Sent Quantity."
    4. Remove "Buy" and "Sell" tags and any others that are not accepted by CoinTracker.
    5. Add the fee amount to the received or sent amounts depending on transaction type. River file does not include fees into the Received and Sent values but CoinTracker expects fees to be included. The fee will be the same currency as the value you need to add it to.
      • For example: For BTC buys, you need to add the fee to the value in "Sent Amount."
         
Back to top

Related articles