OpenNode
Bitcoin Accounting
OpenNode + Clams
CSV (custom mapping)OpenNode is a Bitcoin payment processor supporting both on-chain and Lightning payments for merchants. Clams imports your OpenNode payment history via CSV export. Accurate cost basis for merchant accounting and tax preparation.
What Clams tracks
- Bitcoin payments received with cost basis
- On-chain and Lightning transactions
- Timestamps for all payments
- Fees and processing costs
- Withdrawals to external wallets
- Auto categorizing of transfers to your other connected wallets
How it works
Export from OpenNode
In your OpenNode dashboard, go to Activity, select "Export activity", choose your report type and timeframe, then click "Send Email" to receive a download link.
Create a custom mapping
Build a mapping.json file that tells Clams how to interpret your CSV columns. See the custom connections guide for a full walkthrough.
Register connection
Register your mapping as a connection with the Clams CLI.
$ clams connections create --label my-opennode --kind Custom --configuration-file mapping.json
Import CSV
Import your CSV file. Update the file path to point to your download.
$ clams connections import --label my-opennode --input-format csv --file opennode.csv
Generate journal entries
Process your imported transactions into accounting journals with the command below.
$ clams journals process
Frequently asked questions
What data does Clams import from OpenNode?
Through a custom CSV mapping you create once, Clams imports your OpenNode payment history including payment amounts, timestamps, fees, and fiat conversion rates. This gives you accurate cost basis for capital gains calculations.
Does Clams access my OpenNode account?
No. CSV import is completely offline. You export your transaction history from OpenNode and import the file into Clams. No connection to your OpenNode account is required.
Can I track multiple OpenNode accounts?
Yes. Import each OpenNode account's CSV separately in Clams. Each gets independent tracking and reporting.
Does Clams track both on-chain and Lightning payments?
Yes. OpenNode's CSV export includes both on-chain and Lightning payments. Your custom mapping imports both payment types into Clams.
How do I get capital gains reports from my OpenNode payments?
Export your transaction history from OpenNode as CSV and import into Clams. Clams uses your payment data to calculate cost basis. Generate a capital gains report with clams reports capital-gains, ready to review with your accountant.
Does Clams automatically recognize OpenNode's CSV format?
No. OpenNode data comes in through a Custom connection: you create a CSV mapping once, a JSON file that tells Clams which columns contain dates, amounts, and transaction types, then reuse it for every future export. The custom connections guide walks you through it.
Start tracking your OpenNode payments
Install Clams and import your payment history in minutes.