All transaction, transfer, and conversion data is fully available for export from the OpenNode platform in *.csv (comma separated value) and *xls (excel) formats.
How do I Export Data from OpenNode?
From the Dashboard landing page, click "View all activity" from the top of the Recent Activity table. Or, from any page, navigate to "Activity" from the top navigation bar.
From the Activity page, select "Export activity"
Specify Report type and timeframe
Then select format and click "Send Email". A link to download your export(s) will be sent to the email address associated with the account.
What information does each report type contain?
Payments lists all of the transactions received via your OpenNode account.
Transfers lists all of funds transfers, in Bitcoin or preferred local currency
Conversions lists exchange transactions, including the exchange rate at the time of conversion.
Account summary provides Bitcoin and local currency balances 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