Transactions

Q: How to find missing transactions?

:

1. To start finding missing transactions, two files are needed:

• Bitwave Transactions Export

  1. You can find this go by going to Bitwave -> Transactions -> Export -> Set your parameters and click Export

• Transactions Export from blockchain explorer (i.e. Etherscan, Solscan, Snowtrace)

  1. Double check to get all files from the explorer. Some explorers will have Deposits and Withdrawals separate from Internal Transfers. Also if you are including Layer 2 tokens then download that file too.

❗️

If Explorer doesn't have downloadable reports then use TableCapture OR another extension that requires more technical skill is WebScraper

2. Steps to find missing transactions

• Paste both files in different tabs in the same sheet.
• Use a VLOOKUP on the transaction hash in the blockchain export with respect to the transaction ID column in the Bitwave Export.
• Now use a filter for all the results that contain N/A
• These are the txns which are not in Bitwave.

Q:

: