# Polkadot Treasury annual spending in USD & DOT | 2020 - 2023 June **URL:** \ **Category:** Governance\ **Tags:** treasury\ **Created:** [July 6, 2023, 6:11pm UTC](https://forum.polkadot.network/t/polkadot-treasury-annual-spending-in-usd-dot-2020-2023-june/3342 "2023-07-06T18:11:36Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![alice\_und\_bob](https://dub1.discourse-cdn.com/flex005/user_avatar/forum.polkadot.network/alice_und_bob/32/10098_2.png) [@alice\_und\_bob](https://forum.polkadot.network/u/alice_und_bob)\ **Post date:** [July 6, 2023, 6:11pm UTC](https://forum.polkadot.network/t/polkadot-treasury-annual-spending-in-usd-dot-2020-2023-june/3342/1 "2023-07-06T18:11:36Z")
I wanted to understand the total USD & DOT amount the Polkadot Treasury has been spending so far per year. I used the data from DoTreasury as base, which seems to use the daily rate of treasury grants around the time they were awarded - so in-time USD values, which should provide an accurate view on the value spent. To solve the task, I… - fetched all Polkadot Treasury proposals with the status awarded from [DoTreasury](https://www.dotreasury.com/dot/proposals?status=awarded) - manually copied the values over to [this spreadsheet](https://docs.google.com/spreadsheets/d/1k75AVvBHHaPNw9jwBANW_RJW0VjFKpzb0WdlGFpn5o8/edit?usp=sharing) - processed the data with [this Python Notebook](https://colab.research.google.com/drive/1T_fBOM3NBbhPnI2-4MFK67P5KhnGSrWo?usp=sharing) This is the result I arrived at: ```auto year USD DOT 2020 565,629 USD 118,466 DOT 2021 1,805,639 USD 70,585 DOT 2022 16,359,027 USD 2,301,333 DOT 2023 9,106,917 USD 1,464,989 DOT ``` ![image](https://europe1.discourse-cdn.com/flex005/uploads/polkadot2/original/2X/e/e89d810e0212aaba207f82313509e686f0b7f833.jpeg) Disclaimers: - It was a quick & dirty analysis, so please make sure to verify the data for yourself if you need 100% accurate data. - I am relying on DoTreasury - I don’t know which source DoTreasury uses to get DOTUSD multipliers and didn’t thoroughly check if my assumption of in-time data is correct; I just looked at the data and it looks plausible to me. Related work by @rich: [Kusama treasury annual spending analysis - 2020 \> 2023 (june)](https://forum.polkadot.network/t/kusama-treasury-annual-spending-analysis-2020-2023-june/3264) Screenshot of the notebook at the time of processing: ![image](https://europe1.discourse-cdn.com/flex005/uploads/polkadot2/original/2X/c/c0d1fe62c27913e97487eb0625b61eedc10255be.png) ---
**Author:** ![nino\_apillon](https://dub1.discourse-cdn.com/flex005/user_avatar/forum.polkadot.network/nino_apillon/32/9767_2.png) [@nino\_apillon](https://forum.polkadot.network/u/nino_apillon)\ **Post date:** [July 7, 2023, 6:42am UTC](https://forum.polkadot.network/t/polkadot-treasury-annual-spending-in-usd-dot-2020-2023-june/3342/2 "2023-07-07T06:42:26Z")
Would it make sense to compare the spending to development activity before anyone draws any conclusions? For example: [https://app.santiment.net/s/MZI-YBev](https://app.santiment.net/s/MZI-YBev) ![image](https://europe1.discourse-cdn.com/flex005/uploads/polkadot2/original/2X/5/575e213bee9816a6227e55c7b802932fe28bc1c6.png) ---
**Author:** ![Ricosworks](https://dub1.discourse-cdn.com/flex005/user_avatar/forum.polkadot.network/ricosworks/32/2137_2.png) [@Ricosworks](https://forum.polkadot.network/u/Ricosworks)\ **Post date:** [July 10, 2023, 8:24am UTC](https://forum.polkadot.network/t/polkadot-treasury-annual-spending-in-usd-dot-2020-2023-june/3342/3 "2023-07-10T08:24:15Z")
Thank you for sharing. Makes a lot of sense. ---
**Author:** ![alice\_und\_bob](https://dub1.discourse-cdn.com/flex005/user_avatar/forum.polkadot.network/alice_und_bob/32/10098_2.png) [@alice\_und\_bob](https://forum.polkadot.network/u/alice_und_bob)\ **Post date:** [September 15, 2023, 7:14am UTC](https://forum.polkadot.network/t/polkadot-treasury-annual-spending-in-usd-dot-2020-2023-june/3342/5 "2023-09-15T07:14:30Z")
I categorized expenses by hand to get a rough estimate. This is the Polkadot spend in USD. ![image](https://europe1.discourse-cdn.com/flex005/uploads/polkadot2/original/2X/7/79cf0fb2bb969105a9bd496ec695a58f96fea6f4.png) ![Polkadot Treasury Total Spend by Category](https://europe1.discourse-cdn.com/flex005/uploads/polkadot2/original/2X/b/bcf7841943d56354c6877a6ce8920f9f7b8383c2.png) ![Polkadot Treasury Yearly Spend by Category](https://europe1.discourse-cdn.com/flex005/uploads/polkadot2/original/2X/a/a41f0fc97b3320dd67b801fab0392386aa5521ca.png) Data: [Polkadot Treasury Spend till 2023-06.xlsx - Google Sheets](https://docs.google.com/spreadsheets/u/1/d/1BmE-UmnaMgv_q_HBOkkH5pUG-p660AzZ/edit?usp=sharing&ouid=103252132862533952746&rtpof=true&sd=true) - Outreach - Media - Education - Online Events - Offline Events - Hackathons - Education - Software Development - Open Source - Closed Source - Operations - Software - Hardware - Research - Security - Other Share the tweet: [https://twitter.com/alice\_und\_bob/status/1702584854192197703](https://twitter.com/alice_und_bob/status/1702584854192197703) ---
**Author:** ![CoinStudio](https://dub1.discourse-cdn.com/flex005/user_avatar/forum.polkadot.network/coinstudio/32/1297_2.png) [@CoinStudio](https://forum.polkadot.network/u/CoinStudio)\ **Post date:** [September 15, 2023, 9:20pm UTC](https://forum.polkadot.network/t/polkadot-treasury-annual-spending-in-usd-dot-2020-2023-june/3342/6 "2023-09-15T21:20:08Z")
Hey @alice_und_bob, Thanks for starting this interesting and important topic. I am working with @tom.stakeplus on a Treasury Tracker application that will give better visibility into all refs and help with the budgeting process and overview. For this case we have used the existing W3F categories: > 1. Infrastructure (deployment and continued operation). > 2. Network security operations (monitoring services, anti-scam activities, continuous auditing). > 3. Ecosystem provisions (collaborations with friendly chains). > 4. Marketing activities (advertising, paid features, collaborations). > 5. Community (events and outreach - meetups, hackerspaces). > 6. Software development (wallets and wallet integration, clients and client upgrades). > 7. Bounties > 8. Liquidity provision > 9. Others We are mainly focused on time-based tracking to better understand the evolution of the treasury. Here are some weekly charts from the Polkadot OpenGov referenda that may be useful: ![Screenshot 2023-09-15 at 23.23.15](https://europe1.discourse-cdn.com/flex005/uploads/polkadot2/original/2X/3/3f10c501aa8bf5c88342d83a66c79a178e5577b1.png) ![Screenshot 2023-09-15 at 23.01.03](https://europe1.discourse-cdn.com/flex005/uploads/polkadot2/original/2X/5/58f4507d5554ae558ad99f1fb542050ee45c98a4.png) ![Screenshot 2023-09-15 at 23.03.49](https://europe1.discourse-cdn.com/flex005/uploads/polkadot2/original/2X/e/e8c2564af0e09042d321b532a0867cd255bd8f14.png) ![Screenshot 2023-09-15 at 23.04.48](https://europe1.discourse-cdn.com/flex005/uploads/polkadot2/original/2X/6/68a216eb26278d4ecb0ef4a94bc977ed4e557bfd.png) While the given categories may seem too general, I prefer to keep them relatively general. Every proposal in the Treasury is unique and if we spread the categories too thin, it might make analytics less useful because the data set would become too dispersed. While most of this is in Draft version, please let me know if you need data for the category budget work.