Create Reporting Data

Create reporting data based on financial reports and fund ledger entries.

1: Fund Analysis Report

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.

Note

It is possible to create as many financial reports as needed, based on what the user needs to achieve and show through funding reports.

1 - Fund Analysis Report

Analyze fund ledger entries across commitments and allocations.

The Fund Analysis report is a report in the Fund Management module that provides a structured and comprehensive view of Fund Ledger Entry transactions through an Excel-based report. When the report is generated, it produces an Excel file containing the following:

A detailed sheet listing all Fund Ledger Entries, including relevant transaction-level information.
Three additional sheets where these entries are grouped by Fund, Funder, and Project, respectively. These groupings provide a high-level summary, enabling users to quickly assess fund allocations and usage.

Users have full flexibility to customize the Excel file according to their analysis needs. They can:

Create and configure pivot tables to visualize and aggregate data.
Apply filters, formatting, and additional calculations.
Modify the layout to suit specific reporting or auditing requirements.

This report is particularly useful for gaining insights into fund allocation, tracking contributions by funders, and analyzing project-related financial activity.

To run the report, navigate to the Funding menu and select Fund Analysis from the available options.