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 file lists all of the transactions you've received via your OpenNode account.
The Transfers file lists all of the times funds, in either Bitcoin or your preferred local currency, were moved off of the OpenNode platform.
The Conversions file lists the instances where Bitcoin was converted into your preferred currency, including what the exchange rate was at the time of the conversion.
The Account summary file displays the bitcoin and local currency balance at the time the report was generated.
Headers: Payments
OpenNode ID: Unique ID for a given payment, not a Bitcoin blockchain 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 whatever local currency the account is set in
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
Status of Transfer: Says if the status of the transfer is pending or complete upon the time that the report was generated
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