Can I export transactions or my XPUB?

Most countries require you to declare your crypto transactions for tax purposes. Unfortunately it is not possible to export your transactions from the LIQUID app. But you can easily do this another way.

If you only have a limited amount of addresses, you can download your transactions using a blockchain explorer like blockchair.com (multichain, pdf format), etherscan.io (ERC20 tokens only, csv format), bscscan.com (BSC only, csv format) and others.

Most tax software allows you to import the XPUB of your wallet to retrieve all your transactions. If you have many addresses, this is much easier than making an export for every address separately.

How to get your wallet’s XPUB?

You can derive the XPUB from your backup using this tool: https://iancoleman.io/bip39

Disclaimer: NEVER USE THIS TOOL ONLINE with your key! There is always a risk that your communication is intercepted or the website logs your private key data, which might result in your funds being stolen. You should download the tool and run it from your own computer.

In short, using the Coleman tool to get your XPUB boils down to this:

  • Download the tool to your computer and open it.
  • If your backup is in the form of 24 words:
    • Fill in the 24 words in the field 'BIP39 Mnemonic'.
    • The associated XPUB will be shown in the field ‘Account Extended Public Key’ below.
  • If your backup is in the form of 64 hexadecimal characters:
    • Tick the 'Show entropy details' checkbox first
    • Then fill in your 64 character backup in the field 'Entropy'.
    • The associated XPUB will be shown in the field ‘Account Extended Public Key’ below.

We'll go through each step in more detail below.

1/ Download the tool

At this point, you may even disconnect your computer from the internet. The .html file runs 100% local on your machine.

You can get familiar with the tool by generating a random 24 word seed. The button to do this is in the 2nd paragraph of the page.

generate-random-mnemonic.png

2/ To derive the XPUB from 24 words

  • Fill in the 24 words of your backup in the field 'BIP39 Mnemonic'.
  • The associated XPUB will be shown in the field ‘Account Extended Public Key’ below.

mnemonic-to-XPUB.png
Deriving the XPUB from 24 words can be done easy

3/ To derive the XPUB from 64 characters

  • Tick the checkbox 'Show entropy details'.
  • A box will slide open with a number of new fields. Leave everything as it is.
  • Fill in the 64 hexadecimal characters of your backup in the field 'Entropy'.
  • The associated XPUB will be shown in the field ‘Account Extended Public Key’ below.

hexadecimal-to-XPUB.png
Derive the XPUB from a hexadecimal format in 2 easy steps