From how to file cryptocurrency taxes to ensuring you get the most out of your data, our team at Founder’s CPA is your go-to resource for cryptocurrency success and compliance. In this blog post, we’ll talk about the process of downloading your cryptocurrency transaction history and pricing to a handy Excel spreadsheet. Within minutes, you’ll have a better understanding of how to create a CSV file of your transactions across your wallets and exchanges that you’ll be able to use to your advantage. 

How to File Cryptocurrency Taxes First Step: Data Prep

Before we can discuss how to file cryptocurrency taxes, we first have to figure out how to get your crypto data ready for filing.  Excel can be one tool for doing that.  As long as you have a subscription to Microsoft 365, you’ll be able to leverage the stock functionality to access and pull cryptocurrency prices. This is a lesser-known Excel fact that some people might now know about. But why should you care? This is a great way to keep track of relevant data about your cryptocurrency and can serve as a helpful reference in the future. 

As of now, you can access information on Bitcoin, Bitcoin Cash, Litecoin, Ripple, and Ethereum in Excel. You’ll be able to see prices in USD, EUR, CAD, and more. Let’s say that you want to see the price of Litecoin in USD. All you need to do is enter LTC/USD into a cell and Microsoft will automatically pull the relevant price. 

You’ll also be able to look up the historical cryptocurrency prices in Excel. To do this, you’ll need to use the STOCKHISTORY function, and it will show prices at intervals including daily, monthly, or weekly. 

Despite how helpful these features are, always remember that Excel has its limitations. It doesn’t support many different types of cryptocurrencies and it’s unable to import transactions from your exchanges or wallets. 

Are Any Crypto Wallets or Exchanges Supported on Excel?

Transactions from platforms such as Coinbase or from blockchains such as Ethereum cannot be automatically imported into Excel. For many, this makes it more difficult to keep a streamlined record of transactions on this platform alone. Details such as the price of your crypto when you purchased it or when you disposed of it cannot be automatically tracked. You’ll need to use a third-party service to achieve this such as CoinTracking.info. 

How to Download Cryptocurrency Data

Once you choose the third-party service of your choice, it’s easy to get started. Simply connect your wallets and exchanges and the platform should automatically import your transactions. From there, you’ll be able to download a CSV file that contains all relevant data about your cryptocurrency transactions. 

Still Not Sure How to File Cryptocurrency Taxes? Trust Our Experts for Help 

If you’re looking for additional information in this realm, such as how to file cryptocurrency taxes or how to stay compliant with various tax requirements, it’s best to consult with an expert. Our team has experience with crypto funds, blockchain startups, high-net-worth investors, and so much more. Reach out to our team at Founder’s CPA for a complimentary consultation to get started!

Curt Mastio
Post by Curt Mastio
Nov 22, 2023 1:45:31 PM
Curt Mastio started Founder’s CPA in 2017 and currently serves as the Managing Partner of the firm. After obtaining both his Bachelor’s and Master’s degrees in accounting from the University of Illinois in Urbana-Champaign Curt started his career in Big Four public accounting. Shortly thereafter Curt served as the Chief Financial Officer of Storage Squad began his stint as an Adjunct Instructor at Northwestern University’s Farley Center for Entrepreneurship and has been teaching Accounting & Finance to undergraduate students for 6+ years. In his current role Curt oversees strategy, operations, and business development at Founder’s CPA. Further, Curt has experience working directly with 200+ startups and small businesses providing accounting, tax, and outsourced CFO services. His industry expertise lies in the SaaS, Blockchain, Marketplace, and Fintech industries. He has served as a key advisor working directly with startups that range from pre-revenue to companies generating over $30 million dollars a year in revenue. Lastly, he serves a key role working directly with the firm’s clients that have collectively raised over $200 million in venture capital funding to date. Curt is also an active advisor, mentor, and investor in the startup ecosystem. He has facilitated numerous workshops, webinars, and presentations to incubators and other startup-centric organizations. He is also an active mentor for Techstars in both Chicago and Iowa. Outside of his daily professional duties Curt is actively involved with Beat the Streets Chicago and was a founding member of its Young Professionals Board. His efforts in both leadership and community involvement were recognized when he was awarded the Illinois CPA Society’s Outstanding Young Professional Leadership Award in 2020. He was also a panelist at their annual conference in 2022 where he spoke about his experiences starting and operating a public accounting firm. He maintains an active Certified Public Accountant designation that he obtained in 2014. Outside of work, Curt can be found spending time with his friends & family including his dog Rufus. His hobbies include golf, boating, cooking, reading, and attending sporting events & concerts.