Polkalytics

A Google-Scale Analytics Service for Polkadot

With Polkalytics Tax Reports, you can finally get your Polkadot taxes done!

Alice und Bob

Alice und Bob take in-depth looks at the Kusama and Polkadot ecosystem. They make complicated facts understandable for the broader community.

**aka: “FINALLY I can get my Polkadot taxes done!”**

Since March 2022, I have been building an analytics engine for Polkadot. The first product to launch on Polkalytics is personal reports of your on-chain activities that will finally enable you to do your taxes. In the future, Polkalytics will offer consulting services and additional products for tax consultancies, businesses, parachains, and protocols.

In this post, you will learn about the types of analytics that are becoming possible and about **Polkalytic’s first product: Polkadot Tax Reports.** And I will share the report that was generated for my personal main Polkadot and Kusama addresses.

* Visit [www.polkalytics.io](http://www.polkalytics.io) now to apply for the Closed Alpha program.
* Follow on Twitter: [@polkalytics](https://twitter.com/home)

# Polkadot lacks Analytics

*What’s my crypto profit and loss? How much revenue are parachains actually making? Where is money flowing in the ecosystem? Who is the best RMRK NFT flipper? Which DeFi protocols are actually gaining traction? Whom should I copy-trade?*

There are a million questions about Polkadot in our collective mind every day. Most of them haven’t been answered before. For some, you can use tools like the [Subscan Blockchain Explorer](https://www.subscan.io/) or put in the effort and do your own Spreadsheet and programming magic.

But let’s be honest: Polkadot is still very inaccessible when it comes to gaining insights into *what is actually happening on-chain*. There is no universal analytics tool and because of the diversity of parachains, we are still far away from it.

To make things easier, I released the open-source library Subscrape in March 2022 ([Announcement](https://polkaverse.com/@alice-und-bob/subscrape-releasing-v1-0-and-roadmap-for-v2-0-32075))

[![](https://ipfs.subsocial.network/ipfs/QmaaVr9coMJKSNe6KtyvxD2b5CdAeqczzUvpXkawt8ahmr)](https://twitter.com/alice%5Fund%5Fbob/status/1506040033899335680)

Over the months, I have used Subscrape to do all kinds of analytics, like

* [Mangata X DEX stats](https://twitter.com/alice%5Fund%5Fbob/status/1609629338520981506)
* [Crowdloan Analysis](https://twitter.com/alice%5Fund%5Fbob/status/1504844681338929152)
* [XCM Netflows](https://twitter.com/alice%5Fund%5Fbob/status/1567540375698415616)
* [Investigating on-chain flows after the aUSD error mint](https://twitter.com/alice%5Fund%5Fbob/status/1558895707398045697)

As I went down deeper into the rabbit hole, I had many conversations with people from the Polkadot ecosystem and they all had the same pain point: “I can’t file taxes for my on-chain activities”.

# Polkalytics Tax Reports

Polkalytics Tax Reports is a service that generates personalized reports of your on-chain activities that enable you to file your Polkadot taxes.

If you use Binance or Kraken or any other centralized exchange, you can just **click an “Export” button and get a full-fledged report that you can hand to your tax consultant.** If you are an active on-chain user of Polkadot, you are out of your luck. No “Export” button for you.

To solve the problem, I had to build something that is bigger than a simple scraper. An engine, that reads ALL data from the chain to fetch transfers, fees, staking, XCM activity, crowdloan participation, DEX swaps, and everything else.

After 3 months of long after-work evenings, the first version of Polkalytics Tax Reports was finished in early December. Since then I am serving individuals who participate in the Polkalytics Closed Alpha. To get your personal report, you can apply for the Closed Alpha program today by visiting [www.polkalytics.io](http://www.polkalytics.io).

Interested to see what the reports look like? I am publishing sample reports of my personal main account here: [Drive folder](https://drive.google.com/drive/folders/14WqTKlAR6bfb2zr5VqxOEn0WWdPsc1j1?usp=share%5Flink).

At the moment, Polkalytics Tax Reports supports the Polkadot and Kusama relay chain. Support for more chains will be added in the coming weeks. As a Polkalytics Closed Alpha program participant, you will get access to ALL upcoming Polkalytics features for the first year.

# The Analytics Boutique opens Shop

Polkalytics is more than just tax reports.

**Polkalytics offers specialized reports for parachains** that want to learn more about what is actually going on on-chain, gather protocol KPIs, and offer transparency to their communities.

**Polkalytics gives crypto tax consultancies an edge** by offering services that none of their competitors can.

**Polkalytics helps investors understand what happens on-chain,** to get capture signals as they happen, and make informed decisions faster.

Polkalytics uses the power of Google Cloud to index all chains. The goal is to generate insights on demand at Google-scale.

If you think that Polkalytics can help you achieve your goals faster or better, [reach out](https://www.polkalytics.io/contact) and we’ll have a conversation.

# Stay in the Loop

* Visit [www.polkalytics.io](http://www.polkalytics.io) now to apply for the Closed Alpha program.
* Follow on Twitter: [@polkalytics](https://twitter.com/home)
* Share the [announcement thread](https://twitter.com/alice%5Fund%5Fbob/status/1609629330061119489)

aka: “FINALLY I can get my Polkadot taxes done!”

Since March 2022, I have been building an analytics engine for Polkadot. The first product to launch on Polkalytics is personal reports of your on-chain activities that will finally enable you to do your taxes. In the future, Polkalytics will...

Polkalytics - A Google-Scale Analytics Service for Polkadot

*This article gives the first details on Polkalytics Account Reports, follows the path of an on-chain riddle, and begins the quest to survey the Polkadot Data Ecosystem.*

**It always fascinated me how tens of thousands of people rush into Polkadot** parachains to test them out and experience the cutting edge of crypto, while at the same time, they have no clue how they are going to file their Polkadot taxes at the end of the year. Sure, taxes work differently for everyone. Depending on where on this beautiful planet they reside and what legal structure they have set up for themselves, they pay 50%, 20%, 10%, 2%, 0.2%, or 0% in crypto taxes. Some pay zero, but most have to pay something.

**It’s tax season in many parts of the world.** For some businesses that are deep into Polkadot, this means they have 50 or more accounts for all the parachains they use. And they need to report on all of those for their tax filings. The most common questions they need to get answered are: Which assets and how many did we have at the start of the year and at the end of the year? How much did we earn through staking?

**I was sure that someone would take that opportunity** and build a reporting tool that helps all those Polkadot community members get this problem solved. But after 1.5 years of waiting, it still didn’t happen. So I decided to take the engine I built to uncover the secrets of the chain ([including the 1337Riddle of Kusama](https://www.youtube.com/watch?v=gy-DNSpyROs)). I picked up the challenge to develop a tool that fully explains everything that happened on an account: Polkalytics Account Reports.

**After the official** [**announcement of the Polkalytics Closed Alpha Program**](https://polkaverse.com/10716/polkalytics-a-google-scale-analytics-service-for-polkadot-37079)**,** over 30 people applied to participate. 8 were able to get into the program so far and I worked personally with them to generate personalized reports and to file their taxes on time. After validating the product and getting feedback that it actually helps people, it’s time to share some details.

## How does Polkalytics Account Reports work?

Polkalytics holds a complete Google BigQuery (Big as in Big Data) database of all blocks, transactions, and events that ever happened on Polkadot and Kusama. When Polkalytics Account Reports gets tasked with generating a report for an address (or many addresses), it

1. analyzes all historical transactions and balance changes for that account.
2. It then classifies all account actions into potential tax categories according to what happened, e.g. transfers, staking rewards, etc. You then can use this report to apply the rules of your tax jurisdiction to it.

### Types of Transactions

The Polkadot and Kusama relay chains are already supported by Polkalatics Account Reports with the following classifications:

* Transfers
* Crowdloan participation
* XCM transfers
* Staking Rewards
* Fees
* Other minor stuff (index reservations, reserve repatriations, dust lost for deleting accounts)

## Apply for the Closed Alpha

After having successfully helped the first few users, Polkalytics is opening up for more participants. The fee to participate is 50 USD and will work on a first-come, first-served basis as capacity is available. Work in the coming months will focus on adding more chains and making reports available to as many people as possible at affordable prices.

If you want to skip the line, the current asking price is 125 USD.

There will be some promotional offers from time to time. Make sure to get them by subscribing to the [Polkalytics Newsletter](http://www.google.com/url?q=http%3A%2F%2Feepurl.com%2FihmNQ5&sa=D&sntz=1&usg=AOvVaw0nePZNUu6mJSYizfyZqqw3) and following [@Polkalytics on Twitter](https://www.google.com/url?q=https%3A%2F%2Ftwitter.com%2Fpolkalytics&sa=D&sntz=1&usg=AOvVaw2fHM8QbM5d%5FHTZj5U6OBGU).

This article gives the first details on Polkalytics Account Reports, follows the path of an on-chain riddle, and begins the quest to survey the Polkadot Data Ecosystem.

It always fascinated me how tens of thousands of people rush into Polkadot parachains to test them out and experience the...

Introducing Polkalytics Account Reports

bafyreiekzcieqyn4zlmlbe6y4xbnwd5bm37gzwh3kb74hfoibwxswjie3y

bafyreibi7ne2hl5f4dqie36ec7fadi3vpo5uanx6fk5qzldqehzz6y23fu

bafyreibbry5lqdwmsg7e52wjhhvkph3l2o56sykgjs4v376h5uwtcbtota

bafyreihn2xoie7hhnkk5zzh4jrsopnpitcorkr7zob66yhsivn3ubtfms4