Decrypting Coinbase Accounts
A Guide for Forensic Analysts
As cryptocurrencies become more mainstream, it is vital for forensic analysts to understand and analyze digital currency data. Forensic analysts are increasingly being brought in to trace and help recover crypto assets in criminal matters, such as money laundering and other fraud prosecutions. There is also a noticeable increase in the use of forensic analysts in civil litigations, which can range from contested divorces to probate and bankruptcy cases. This article focuses on how to trace and recover crypto assets using one of the major exchanges as the example. Coinbase is an online cryptocurrency exchange with more than 89 million verified users with $278 billion on the platform. The exchangeâ€™s retail users can buy, sell, send, receive, and exchange 139 different crypto assets.
As cryptocurrencies become more mainstream, it is vital for forensic analysts to understand and analyze digital currency data. Forensic analysts are increasingly being brought in to trace and help recover crypto assets in criminal matters, such as money laundering and other fraud prosecutions. There is also a noticeable increase in the use of forensic analysts in civil litigations, which can range from contested divorces to probate and bankruptcy cases.
This article focuses on how to do this using one of the major exchanges as the example. Coinbase is an online cryptocurrency exchange with more than 89 million verified users and $278 billion on the platform. The exchangeâ€™s retail users can buy, sell, send, receive, and exchange 139 different crypto assets.
Letâ€™s say you were asked to analyze the activity of a user account, but you do not know where to start since there are no monthly statements from Coinbase. The following steps illustrate the process to obtain the data:
- Sign into the Coinbase account
- Click on the profile photo
- Navigate to â€śReportsâ€ť
- Choose â€śGenerate Reportâ€ť for the Transaction History
- Filter the information or choose from CSV or PDF format and â€śGenerate Reportâ€ť
- Click â€śDownloadâ€ť to get the Coinbase transaction report
Of course, this process may require a subpoena for investigating accounts outside your clientâ€™s control, but the option to receive the complete transaction history in an electronic format is a step above what most financial institutions provide. Coinbase does issue 1099-MISC to account holders if â€śearningsâ€ť exceed $600 in a calendar year but does not share any gain or loss activity with the IRS. However, the IRS has successfully issued subpoenas to obtain client information from Coinbase and other exchanges.Â
Once the transaction data has been imported into Excel, you can perform some standard forensic procedures. Examples include:
- Establish values of the holdings
- Summarize the account activity
- Reconcile the transfers and conversions to/from other currencies
- Quantify the amount of crypto sent to and received from other accounts
- Other considerations
These procedures are discussed separately below.
- Establish Values of the Holdings
In the past, establishing crypto asset values was difficult, due to price variations between exchanges and the availability of historical data. Today even the Wall Street Journal reports historical prices, and there are websites devoted to the continuous tracking of roughly 10,000 digital currencies. The Coinbase Transaction History report includes information to establish the cost basis at the time of each transaction. You may need to go one step further and calculate the value of the holdings closer to the trial date.
2. Summarize the Account Activity
The Transaction History report includes the following fields: timestamp, transaction type, asset, quantity transacted, spot price currency, spot price at transaction, subtotal, total (inclusive of fees), and notes. These data groups can be manipulated/pivoted to a more usable format. For example, the following chart illustrates how Bitcoin (BTC) transactions can be summarized by quantity and amount for the past three calendar years.
You can use the transaction summaries for each type of currency to help educate clients on the account activity and determine the scope of additional procedures. For example, you may want to investigate why there were more sales of BTC than purchases/receipts and determine the destination of the â€śsendâ€ť transactions.
These fields can be further segregated by month, individual transactions, or other available evidence depending on the needs of the case. The next section shows how to reconcile the transfers to/from the bank accounts and analyze currency conversions.
3. Reconcile the Transfers and Conversions to/from Other Currencies
Reconciling crypto exchange transfers is similar to a traditional forensic analysis of bank statement activity if you consider Coinbase as a specialized financial institution. Funds transferred out of a traditional bank account will flow directly into the Coinbase account as a â€śbuyâ€ť transaction (or into cash as a â€śUSDâ€ť type). Note that transfers and other cryptocurrency activities occurring prior to the Coinbase account formation will not show up on the Transaction History report.
Transfers out to bank cash accounts require conversion to dollars before leaving Coinbase, so these should be easier to follow. However, the Transaction History report does not include the USD only transactions. You should have the client perform the following steps:
- Click the Coinbase logo or navigate to the home screen
- Select the â€śAssetsâ€ť category
- Select the U.S. Dollar (USD) under â€śYour assetsâ€ť
- Print this page or save to a PDF
There is no option to export the USD wallet activity, but this printout will ensure the withdrawal and deposit transactions are captured for the forensic analysis.
A useful feature of the blockchain is that it maintains a complete record of all the transactions that have ever occurred, facilitating the reconciliation of transfers despite the anonymity. Think of the Bitcoin platform as a giant general ledger. If there are transactions outside the Coinbase exchange, you may consider utilizing a specialized forensic analyst with crypto expertise to help understand the activity in other accounts.
Crypto Asset Conversions
The first step in the reconciliation process is to sort the transactions by type. The Transaction History report tracks the following transaction types: buy, sell, convert, advanced trade fill, send, receive, rewards income, and Coinbase earn. The â€śconvertâ€ť type transactions provide some data, but you will need additional information from the â€śnotesâ€ť field to understand the entire transaction.
The following is an example of the notes data from a sample transaction: â€śConverted 518.90941073 LTC to 6.65444836 BTCâ€ť. The recommendation here is to add an additional row of data to segregate the â€śconvert fromâ€ť data from the â€śconvert to.â€ť This is shown below with some fields removed/rounded for simplicity.
Coinbase charges a fee for these transactions so there will be differences between the â€śconvert fromâ€ť and â€śconvert toâ€ť balances. Understanding the convert data field is also important so you do not confuse the source of funds and/or mistake asset holding fluctuations with those sent to or received from other accounts.
The following is an example of an Excel pivot chart using the modified convert-type transactions, summarized by dollar amounts only (rounded).
Please note Excel pivot tables put the section totals at the top of each category so the above table is shown with this formatting. The â€śGrand Totalâ€ť difference between the convert to and the convert from represents Coinbaseâ€™s transaction fees. Beware of any large variations as that may signal something is wrong with the analysis. You may want to add additional details depending on the needs of the case (such as quantity transacted, spot price, etc.).
- Quantify the Amount of Crypto Sent to and Received from Other Accounts
As described above, the Transaction History report tracks the cryptocurrency assets sent and received from other sources. Sometimes the recipientâ€™s name is listed in the â€śnotesâ€ť field if the account holder has a Coinbase account or is a known related party. Otherwise, only the recipientâ€™s public wallet address is shown (which is a long, nonsensical series of letters and numbers such as: 4WCB5je278eUXVrpW3cAHfxfHjkp1KoKos). You can use the sent and received information to help identify additional user accounts, such as those held on other exchanges. These can be quantified like the BTC example above using the report data.
You should consider discussing with counsel whether the sent transactions represent potential dissipation of the marital estate for divorce cases. In these situations, the Coinbase account holder would have the burden of proof to establish the marital purpose for the transaction(s). You should also ensure consistency between the actual transaction date and current market value as counsel may argue for whichever date produces the highest amount.
- Other Considerations
It is no secret that some people use crypto currencies to mask their identities while others simply may not know the rules for reporting gains and losses. So, do not assume all the activity is reported on the income tax returns. This is more complicated when account holders receive currencies through hard forks in the blockchain or â€śairdroppedâ€ť tokens. The IRS has issued some guidance on the taxation of digital currencies and â€śactively addressing potential noncomplianceâ€ť. You should consider the taxes (un)paid and potential liabilities. The Transaction History data provides information to calculate the tax liabilities associated with unrealized capital gains depending on the type of case. Coinbase also has a separate section of the website devoted to tax reports.Â
Other information contained in the Coinbase accounts that may be accessed with the subpoena include: the account registration records, funding sources, and history of the IP addresses used to access the account. Coinbase also offers a Wallet Extension which allows users to self-custody crypto assets, monitor non-fungible tokens (NFTs), and interact with the Crypto Economy and Web3 (i.e., trade tokens on decentralized exchanges [DEXes]), and access decentralized applications (dApps). These specialized topics may be the subject of future articles.
Coinbase Pro, Institutional, or Prime customers have premium content available so you should understand the type of account the user has in case there is more information available, such as accessing Form 8949 (Sales and Other Dispositions of Capital Assets).
It is time for forensic analysts to embrace crypto cases as standard fare. The top 85 cryptocurrencies each have a market capitalization in excess of $1 billion. At the time of this writing, $2+ trillion of wealth has been created through digital currencies and the daily volume can exceed $100 billion/day. This is especially relevant as the Federal Reserve is considering how a Central Bank Digital Currency (CBDC) might fit into the U.S. money and payments landscape. With approximately 12% of the total market capitalization of crypto assets at the end of 2021, a Coinbase analysis may be coming to an engagement near you.
As the crypto market continues to grow and evolve, forensic analysts called in to examine these cases would be wise to include cryptocurrency activity/assets in their standard document requests and find a specialized crypto forensics expert before the need arises.
We would like to thank Jason Pierce for providing insight and expertise that greatly assisted this research.
 Coinbase Website, https://www.coinbase.com/about?__cf_chl_f_tk=rTRSUJ8NjJBrgJDtoIwNd8QHCxxy2iHo3ZVnjcgKvzU-1649465339-0-gaNycGzNCT0. Last accessed April 8, 2022.
 There are other report options for tax documents and related resources as well as Coinbase Pro reports. See: https://www.coinbase.com/reports. Coinbase also offers gain/loss reports and other content for premium subscribers. See further discussion in Other Considerations below.
 There are also options for date range, asset category (such as Bitcoin, Ethereum, Litecoin, etc.) and transaction type. See further discussion of transaction type below.
 Earnings include airdrops, sweepstakes winnings, sign up incentives, crypto mining and staking, and hard forks.
 Aquilio, Mark, Court Grants IRS Summons of Coinbase Records, Journal of Accountancy, March 1, 2018. The IRS has also obtained records from other exchanges such as Kraken and Poloniex. See AndrĂ©, Spencer and Suominen, Finding John Doe, Part II: IRS Secures Another Victory to â€śRoot Outâ€ť Virtual Currency Tax Noncompliance, McDermott Will & Emory Website: https://www.mwe.com/insights/finding-john-doe-part-ii-irs-secures-another-victory-to-root-out-virtual-currency-tax-noncompliance/, May 7, 2021.
 Wall Street Journal Website, https://www.wsj.com/market-data/quotes/fx/BTCUSD/historical-prices, Last accessed April 10, 2022. Please note that crypto markets are open 24/7 so the â€śopenâ€ť and â€ścloseâ€ť prices are those at the beginning and end of the selected timeframe.
 The Coinbase wallet is a self-custody crypto wallet, which control the users crypto, keys, and data. See https://www.coinbase.com/wallet?__cf_chl_f_tk=qjcx4ZrFum626xrmaCh76jKG1Wvju5hg5LYnpbeZlZs-1650884009-0-gaNycGzNDD0. The userâ€™s cash (USD) is also maintained in the Coinbase wallet.
 Assuming the user is already logged into the account.
 There are crypto-specific credentials such as a Cryptocurrency Transaction Certified Examiner (CTCE) by CipherTrace. There are more vendor certifications by Qlue, Chainalysis, Elliptic, and others.
 Note that the crypto world runs on Coordinated Universal Time (UTC) so the Coinbase reports may need to be converted to your time zone.
 Airdrops involve blockchain-based projects and developers sending out free tokens to members of their communities as part of a broader marketing initiative. Sergeenkov, Andrey, What is a Crypto Airdrop?, Coindesk.com Website: https://www.coindesk.com/learn/what-is-a-crypto-airdrop/. A hard fork is when the developers of a digital currency create a second branch of that currency using the same basic code. See also Reiff, Nathan, Cryptocurrency Hard Forks vs. Airdrops: Whatâ€™s the Difference? Investopedia, October 24, 2021.
 Internal Revenue Service Website: https://www.irs.gov/newsroom/virtual-currency-irs-issues-additional-guidance-on-tax-treatment-and-reminds-taxpayers-of-reporting-obligations. See also Notice 2014-21 and Revenue Ruling 2019-24.
 Such as Gain/loss report (CSV or PDF), Raw transactions report (PDF), TurboTax gain/loss report (CSV). Sign into the account, Click on the profile photo, and navigate to â€śtaxesâ€ť.
 Coinbase 2021 Form 10-K, Page 8.
 Board of Governors of the Federal Reserve System, Money and Payments: The U.S. Dollar in the Age of Digital Transformation, January 2022, page 13.
 Coinbase 2021 Form 10-K, Page 8.
Jason Pierce, CPA, CMA, CFM, CVA, MAFF, is a Senior Vice President in the Economic Damages and Valuations section of J.S. Heldâ€™s Forensic Accounting / Economics / Corporate Finance practice. He specializes in forensic accounting, business valuation, and consulting engagements. Jason brings more than 25 years of experience in various accounting and finance-related disciplines. He works with clients on disputes, transactions, fraud, damages, family law, criminal, and estate planning engagements. He has testified as an expert witness in State courts, Federal courts, and in arbitration proceedings. A regular speaker at legal and professional organizations, Jason also serves as a lead instructor for NACVAâ€™s Master Analyst in Financial Forensics (MAFF) certification program and other courses.
Mr. Pierce can be contacted at (857) 216-9775 or by e-mail to JPierce@jsheld.com.