I am Mag, a street photographer/Artist. Here is a brief profile.
Street photographer & artist searching for beauty hidden in everyday life, started his career in December 2021. Based on the technique of street snapshots, he takes photographs with the theme of moments where reality and fiction are ambiguously intermingled and where there is a blank space for the imagination. He is also challenging unconventional photographic expressions such as collaborations, secondary works, and abstract expressions based on photography.
This is not an announcement of an artwork...but an announcement that I have created a Chrome extension called "Btc Transaction Exporter" that outputs Bitcoin/Ordinals transaction history in CSV for tax return purposes.
It is free to use. I hope you will see it through to the end, as I have summarized how to use it, how it was created, my thoughts and feelings about it and about donations!
Introduction
Btc Transaction Exporter is a chrome extension that exports bitcoin transaction history in csv.
Sites such as mempool allow you to view transaction history in your browser, but do not provide the ability to save history.
I have created this chrome extension to help those who like Bitcoin and Ordinals to enjoy the activity more and save time on administrative work.
Demo video
Main Feature
-
No wallet connection
-
No wallet data collecting
-
Use Mempool/MagicEden's Free API to retrieve all transactions for a given wallet address
-
Total UXTO of vin and vout per address for easy viewing
-
Label the sum of vin and vout for main address
-
Transaction fee on a separate line
-
For transactions creating Ordinals Inscription, add content_type to supplemental information
-
For text/plain Ordinals Inscription used in BRC-20, etc., add text content to supplementary information
-
Using MagicEden API, add Ordinals inscription name and collection name to supplementary information
note) This is only an extension to obtain transaction history. I am not a tax expert, so I would appreciate it if you could organize and utilize the history for your own tax returns.
Sample CSV
Sample CSV file. You can import it into Google Spreadsheet, for example, and filter it by the myAddress column to see a list about your addresses. You can hide or append unnecessary columns as you check transactions.
How to generate CSV
-
Download extension from Chrome Web Store.
-
Open the Chrome Extension.
-
Enter the Main Address to which you want to export the csv.
-
Enter another bitcoin address(optional); if you are using a wallet such as Xverse, you may have a bitcoin address separate from your taproot address. It will be marked as your address.
-
Enter an alias for the wallet(optional). The alias name will be included in the exported csv.
-
Click Export CSV. After a few moments, the CSV will be exported.
note: Because the free mempool and magiceden APIs are used, the request time is set to every second due to rate limitation. Therefore, if the number of histories is large, it may take a little longer. Please understand.
CSV Data Column
-
timestamp: Timestamp (YYYY/MM/DD hh:mm:ss)
-
txid: Mempool transaction id
-
txUrl: Mempool transaction url
-
address: Taproot/bitcoin address
-
vin: Transaction input btc
-
vout: Transaction output btc
-
vdiff: Btc value of (vin - vout)
-
myAddress: Mark * if address is yours
-
date: Date(YYYY/MM/DD)
-
description: If the transaction reveals the behavior of the inscription, a supplement will be included in the memo
-
inDiff: Value if vdiff is positive
-
outDiffWithoutFee: Value if vdiff is negative (excluding gas cost)
-
fee: Gas cost
-
ordInscriptionNumber: Inscription number (Only if the inscription of Ordinals is known)
-
ordContentType: Inscription content type(Only if the inscription of Ordinals is known)
-
ordContentText: Inscription content text(Only if content type is text/plain, and the inscription of Ordinals is known)
-
ordInscriptionUrl: Inscription URL of Magiceden(Only if the inscription of Ordinals is known)
Background of the creation
I usually create artwork in the web3 space, but I was trying to organize my Ordinals transaction history as I am about to file my tax return 😭. I tried to look at the mempool site, but ran into the following issues...
-
Not being able to export CSV with Etherscan like ETH
-
There is the concept of UTXO, which is simply a format that makes it difficult to quickly understand deposits and withdrawals
-
Inscription creation and sending of Ordinals is difficult to understand only from mempool.
-
There is no functionality that can be replaced by other sites.
So, I looked into the free Mempool and MagicEden APIs and worked on CSV output myself, and managed to do the following to output the data for myself. Now I am horrified that I had to do it manually...
-
To make UTXO as address-by-address as possible
-
To be able to see the difference between deposits and withdrawals
-
To be able to see the transactions involved in Ordinals.
However, as I was making it, I thought that there might be many other people who would have trouble with this, so I worked on developing it into a Chrome extension so that other people can make use of it.
It may have some rough edges, but I would be happy if you could try using it.
About Donate
I am a web3 photographer and artist, and I created this extension to save time on paperwork so that I can enjoy my work with Bitcoin and Ordinals more.
I will continue to improve the feedback, but if you like it, I would be very happy if you could make a donation to help me improve this extension and promote my activities.
The donation addresses are below:
More Details
For more details about the extension, please see the documentation on GitBook. The extension is open source, so if you have any requests or corrections, you can send us a PullRequest or Issue! Please take a look if you are interested.
Conclusion
I hope this extension will be of some help to you. If you have any questions about this extension, please feel free to DM or reply to Mag on Twitter!
I hope to work hard again on art production in the future. Thank you very much!
Thank you for reading to the end! If you think this post is good, I would appreciate it if you could spread the word by RT or liking it if you like! Please feel free to contact me again with any questions or concerns!
Appendix
For your reference, I will post a link to my past notes on my NFT activities. Please take a look at them if you are interested.