All transaction, transfer, and conversion data is fully available for export off the OpenNode platform in the form of .csv (comma separated value) files. Our export files make it easy to manage your accounting, as many leading accounting software programs allow for .csv file imports.

How do I export data off of OpenNode?

From the Overview page, you can click the "see all" to the right of the activity field. Or, from any page, you can navigate to the "Activity" page of the dashboard. 

On the next page, click "download activity"

From there, you have a few options: timeframe and type

You can create reports based on a certain time frame in the "timeframe" option.

The "type" field breaks the exports into a few different types: payments, transfers, conversions, or all the above. See more information below.

When you've selected what you want to export, click the "Send CSV" button and your export will be sent to your account email address so that you can download it.

What information does each type of export file contain? 

  • The payments export .csv file lists all of the transactions you've received via your OpenNode account.
  • The transfers export .csv file lists all of the times funds, in either Bitcoin or your preferred local currency, were moved off of the OpenNode platform.
  • The conversions export .csv file lists the instances where Bitcoin was converted into your preferred currency, including what the exchange rate was at the time of the conversion.

Headers: Payments

OpenNode ID: Unique ID for a given payment not Bitcoin ID

Date: UTC date that transfer was executed

Time: UTC time of day that transfer was executed

Payment amount: The payment amount in BTC

Processing fee paid: The fee that was paid by the merchant to OpenNode for facilitating the payment

Originating amount: what the charge was set for in fiat / btc

Merchant account amount: always denominated in local / account currency

Automatically converted to merchant account currency: Yes or no field answering the question, “Was a transaction automatically converted?”

Headers: Transfers

OpenNode ID: Unique ID for a given transfer

Type of Transfer: Lightning Network, Bank transfer, or on-chain Bitcoin transfer

Date: UTC date that transfer was executed

Time: UTC time of day that transfer was executed

Amount: Amount that was transferred. Value is denominated based on the Currency field

Transfer fees paid: The total fees paid for the transfer. Value is denominated based on the Currency field.

Headers: Conversions

OpenNode ID: Unique ID for a given conversion

Date: UTC date that transfer was executed

Time: UTC time of day that transfer was executed

From amount: The value of currency before the conversion; what the value is converting from

From currency: The currency of the value before the conversion

To amount: The value of currency after the conversion; what the value is converting to

To currency: The currency of the value after the conversion

From/To exchange rate: Exchange rate quoted at the time of conversion. Always noted in “from currency” / “to currency”. I.e. if changing from Bitcoin to dollars, the exchange rate is in USD/BTC.

Fees paid (BTC): Conversion fee paid in Bitcoin

Did this answer your question?