This report provides a full overview of the historical balances for each asset per wallet. The report is useful for knowing the evolution of your balance across a time period.
To create a Portfolio Balances report, follow these steps:
- Go to the Report page.
- Click on the + Report button, a drawer will emerge
- Module is Financial reports
- Report is Portfolio Balances
- Asset is optional
- Asset cluster is optional
-
Wallet is optional, you can choose:
a) just an asset or wallet
b) an asset and wallet
c) or leave both blank, which will then take into account everything - Wallet cluster is optional
- Source type is optional
- You can filter out NFT and Spam
- Select your desired date range
- Customize column is optional
- Select the desired file format, excel or CSV
- Click Create
Additionally, you can now select columns for your exports directly from our product workspace. This selection will be saved for your future exports - there is no more need to manually clean up your excel file every time anymore. This feature comes in the form of two new buttons - 'all columns' a 'selected columns' on the export side panel when creating a new report. Follow this link to see how the new feature works.
Column Definitions
Further details on what some of the more complex columns mean:
| Inventory | Sum of the particular asset pool's Cost Basis at that particular time |
|---|---|
| Average Daily Price | The opening price for the day obtained from CoinGecko |
| Assets market value | The asset's balance multiplied by the average daily price |
| Date | Illustrates that the figures shown are the balances at midnight moving into the new month (i.e the balance for the end of the previous month) |