All transaction, transfer, and conversion data is fully available for export from the OpenNode platform in the form of .csv (comma separated value) files.
How do I Export Data from OpenNode?
From the Overview page, click the "See all" to the right of the activity field. Or, from any page, navigate to the "Activity" page of the dashboard.
On the next page, click "Download activity"
Specify timeframe and data type
Once selections are complete, click the "Send CSV" button. A link to download your export(s) will be sent to the email address associated with the account.
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.
Payments: Headers
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?”
Transfers: Headers
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.
Conversions: Headers
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