Generating financial reports for funds

Prev Next

You can generate a variety of financial reports for a fund NAV type.

The simplest way to access reporting is to navigate to the Fund Accounting menu in the LUSID web app:

  • The Fund Grid is the primary report and represents a valuation of the share classes in a fund. More information.

  • The Reports menu hosts a number of subsidiary reports. See the table below.

By default, every report requires a To Calender Entry (closed period) signifying the end of an accounting period. You can optionally specify:

  • An earlier closed period signifying a start in order to generate a report spanning multiple accounting periods. To do this, turn on Display range and select a From Calendar Entry (in yellow).

  • A date range instead of calendar entries. To do this, turn on Ad-Hoc Mode (in green) and then select from and to dates.

Report

Explanation

Underlying API

Fund Grid

Valuation of the share classes in a fund.

GetValuationPointData

Reports > Balance Sheet

Trial balance for general ledger accounts of type Asset, Liabilities and Capital.

GetValuationPointTrialBalance

Reports > Holdings Report

Aggregated instrument holdings in source portfolios.

GetHoldingsForFund

Reports > Performance Attribution

Calculated P&L total from trial balance for general ledger accounts of type Income, Expense and Revenue. Also calculates a percentage return as calculated total / (previous NAV + dealing).

  1. GetValuationPointTrialBalance

  2. GetValuationPointData

Reports > Profit and Loss Statement

Trial balance for general ledger accounts of type Income, Expense and Revenue.

GetValuationPointTrialBalance

Reports > Statement of Net Assets

Trial balance for general ledger accounts of type Asset and Liabilities.

GetValuationPointTrialBalance

Reports > Transaction Report

Aggregated output transactions in source portfolios contributing to holdings.

GetValuationPointTransactions

Reports > Trial Balance

Opening and closing balances for all general ledger accounts. More information.

GetValuationPointTrialBalance

Reports > Valuation Report

Aggregated valuation of instrument holdings in source portfolios. This is not the same as the Fund Grid.

GetValuationForFund

Journal Entry Lines

Audit log of journal entry lines representing the financial impact of economic activity in source portfolios. More information.

GetValuationPointJournalEntryLines