Create Reporting Data
3 minute read
Reporting in funds is done based on dimensions to provide more detailed and flexible analysis of fund performance and financial status. Dimensions are attributes or characteristics of a fund, such as asset class, investment type, geographic region, or time period, that can be used to slice and dice data in various ways to gain insights into different aspects of the fund’s performance.
By organizing data based on dimensions, you can create custom reports and dashboards that are tailored to specific needs and goals. For example, you might want to see how the fund’s performance varies by asset class, so you would use the asset class dimension to group data and generate a report that shows the fund’s returns and risk metrics for each asset class.
In addition, reporting based on dimensions can help complying with regulatory requirements and provide investors with more transparent and meaningful information about fund performance
Fund Management has extended Cash Flow Module to enable reporting based on fund ledger entries and dimensions.
Create new Cash Flow Accounts
Create new accounts for each type of fund ledger entries.
- Choose the 🔎 icon, enter Chart of Cash Flow Accounts, and then choose the related link.
- Select New and create new accounts for funding, respectively for commitment, reservations and usage.
- On the created Cash Flow Account Card, select the Source Type, which can be commitment, reservation or usage.
Cash Flow Setup
Assign newly created accounts on the Cash Flow Setup.
- Choose the 🔎 icon, enter Cash Flow Setup, and then choose the related link.
- Under Accounts fast tab, set the previously created accounts, for each type of entry.
Cash Flow Worksheet
For reporting purposes, it is important to get the fund ledger entry lines of different types, and post them through the Cash Flow Worksheet.
- Choose the 🔎 icon, enter Cash Flow Worksheet, and then choose the related link.
- Open from Actions -> Process -> Suggest Worksheet Lines. Select the type of the funding ledger entries you want to load on the worksheet.
- Register the retrieved lines from action Process -> Register.
Financial Reports
Setup a financial report to use for the reporting, and filter based on dimensions and required results to achieve.
- Choose the 🔎 icon, enter Financial Reports, and then choose the related link.
- Choose New to create a new financial report.
- Setup the rows layout, by filtering on dimensions and totaling.
- Setup the columns layout by setting entries, dimensions and formulas for totaling.
- Generate reporting data by selecting Overview on the newly created financial reports.