**Proposer:** derek // metaspan

\
**Short description:** The goal of the project is to create easy-to-use tools for managing & reporting - in aggregate - across multiple chains, tokens & wallets. 
\
By providing features, and following a style that is familiar to web2 users, this site will drive web3 adoption by making it easy to manage groups of wallets as a single fund or reporting unit.

\
**Requested Allocation:**  Phase 1: 1730 KSM (~£48k, 1 KSM = £28, 31-jan-2023)

\
**Problem Statement**

- Multi-chain, multi-wallet
\
Wallet holders & fund managers do not have affordable multi-chain, multi-wallet tools focused on financial management, reporting and planning.

- New processes
\
There are no solutions providing (aggregated) tracking and accounting for funds locked in validating, staking, nomination pools, lending & governance processes.

- Lagging tools slow adoption
\
Web2 tools are focused on fiat with 2-decimal computation & reporting.

- Affordability
\
Existing crypto accounting tools are charging large fees:

- Parachains
\
None of the existing solutions cater for parachains

\
**Target Audience**

- Project Managers, Curators, Accountants
- DAOs, Clubs, Societies
- Fund Managers
- Businesses using crypto

\
**About Subledgr**

\
Subledgr would like to develop a *quickbooks style* accounting & reporting platform, integrating with third party vendor tools for the purposes of tax calculation and compliance.

\
Subledgr would also provide portfolio management and reporting features for working with multiple chains and multiple wallets. We are inspired [and frustrated] by similar features from quickbooks/xero for web2 SME businesses.

\
**Full details and costing available in the draft proposal here**: 
[https://docs.google.com/document/d/15F79YMx5B5qGB3N8AlPD9r7UYW4WcH-AECFNIb6BmnA/edit?usp=sharing](https://docs.google.com/document/d/15F79YMx5B5qGB3N8AlPD9r7UYW4WcH-AECFNIb6BmnA/edit?usp=sharing)

I would appreciate your review and comments (either here or on the draft proposal itself).
\
Thanks


Treasury Proposal: subledgr - a site for aggregated, cross-chain fund management and reporting

Hi all,

I am pleased to post the first update on the subledgr project.
- https://docs.google.com/document/d/1emkYuo3M6Wg3FJExLRq03UgzDEItPpg46A0cCZfU2K0/edit?usp=sharing

References:
- referenda: https://kusama.subscan.io/referenda_v2/105
- proposal: https://docs.google.com/document/d/15F79YMx5B5qGB3N8AlPD9r7UYW4WcH-AECFNIb6BmnA/edit


subledgr: Phase 1, Project Update 1

### General Project Information

**Short description**: Subledgr is a platform for multi-token fund management, accounting & reporting (Phase 1)

**Project Category / Type**:
- Software development (applications, tools)
- Miscellaneous (research, services)


**Proponent**: derek // metaspan.com

**KSM address:** HyLisujX7Cr6D7xzb6qadFdedLt8hmArB6ZVGJ6xsCUHqmx METASPAN

**Requested allocation**: 1,430 KSM (~£50k @ £35/KSM 21-Feb-2023, EMA7 for KSM/USD, EMA7 for USD/GBP, ref. Budget section for full details)

**Discussion date**: 31 Jan 2023 (discussion)

### Problem Statement

- **Multi-chain, multi-account** - Most users hold and manage tokens across multiple chains, and use different accounts for custody and control (e.g. stash & controller for staking/nomination). Account holders & fund managers do not have affordable tools focused on financial management, reporting and planning.

- **New processes** - Fund and Grant Management is a niche area requiring specialist attention. Managing a fund-in-a-fund is common practice, and we need a toolset to support this.
\
Governance processes are evolving fast, with new features and capabilities being added all the time. We need aggregated tracking and accounting for funds locked in validating, staking, nomination pools, lending & governance processes (proposal, bounty, childBounty).

- **Lagging tools slow adoption** - Users are mostly dependent on web2 tools and spreadsheets for financial management and reporting. These tools are focused on fiat with 2-decimal computation & reporting.

- **Affordability** - Existing crypto accounting tools are charging large fees.

- **Parachains** - None of the existing solutions cater for parachains.

### Proposal

The goal of the project is to create easy-to-use tools for managing & reporting - in aggregate - across multiple chains and tokens.

Subledgr would like to develop a quickbooks style accounting & reporting platform that can be tied-in with third party vendor tools for the purposes of tax calculation and compliance.

Subledgr would also provide portfolio management and reporting features for working with multiple chains and accounts. We are inspired [and frustrated] by similar features from quickbooks/xero for web2 SME businesses. Following a style that is familiar to web2 users, this site will drive adoption of substrate-based tokens by making it easy to manage groups of wallets as a single fund.

### Key deliverables

- The MVP (Minimum Viable Product) Phase 1 of Subledgr's roadmap includes the following features:
Report on all transactions/extrinsics: Subledgr will provide a report on all transactions and extrinsics that have occurred on the blockchain, giving users a complete view of their cryptocurrency activities.

- Categories: Transactions such as transfers between accounts, staking rewards, bond amounts, and fees will be allocated based on the user’s defined Chart of Accounts. This will help users better understand and analyse their cryptocurrency activities.

- Categorisation - the basic feature that enables “bank” reconciliation and subsequent reporting 

- Profit & Loss: Subledgr will produce a Profit & Loss report for a specified period (e.g. week, month, year), including information on the movement of tokens earned and spent, as well as changes in exchange rates (e.g. GBP/USD).

- Exchange rates: integration with an oracle for exchange rates

- Export to CSV/spreadsheet: Subledgr will allow users to export their data to a CSV or spreadsheet format. This will provide a basis for any tax reporting or other financial analysis.

### Success Criteria

A user of the system will be able to execute the following processes:
- Login, User management & password recovery
- Create portfolio(s)
- Add accounts to a portfolio
- Review all transactions for the accounts from chain / indexer
- Allocate transactions and fees to categories
- Report on
  - Fund (Portfolio) Value
- Extract transactions to CSV

### Additional info
\
==> see original polkassembly posting and discussion [here](https://kusama.polkassembly.io/post/2413)
\
==> LINK TO FULL PROPOSAL [HERE](https://docs.google.com/document/d/15F79YMx5B5qGB3N8AlPD9r7UYW4WcH-AECFNIb6BmnA/edit#heading=h.d1jf1dgpau8)


Subledgr is a platform for multi-token fund management, accounting & reporting

For creating a GraphQL Endpoint for Kusama.

This endpoint combines data from onchain, 1KV stats and ONE-T performance stats.

Opensource: https://github.com/metaspan/dotsama-grapql
Endpoint: https://gql.metaspan.io/graphql

For creating a GraphQL Endpoint for Kusama.

I am creating a point-of-sale POS module for merchant to accept KSM/DOT for goods & services.

Goals of the project:
- merchant enters amount and generates QR-code
- scan-to-pay from mobile wallet
- easy to use for non-technical users
- configurable via UI or locked in kiosk mode
- show prices in KSM / DOT / USD / GBP / EUR / other...
- configurable / [optional] realtime exchange rate => plugin
- extensible for developers
- integrated for webshops
- open source / hosted options

Please feel free to collaborate here:
\
[https://github.com/metaspan/metapay](url)

**Reference:** There is a reference for Solana here:
\
[https://github.com/solana-labs/solana-pay](url)


Point-of-sale (POS) module for merchant/vendor/web/shop

### please do not vote, this proposal has the incorrect KSM Value. I will re-submit with the correct value.

replaced by [https://kusama.polkassembly.io/referenda/105](https://kusama.polkassembly.io/referenda/105)