Documentation Index

Fetch the complete documentation index at: https://support.lusid.com/llms.txt

Use this file to discover all available pages before exploring further.

Generating financial reports for funds

Prev Next

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

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 NAV calculation for 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

NAV calculation for the share classes in a fund. More information.

GetValuationPointData

Reports > A2B Report

Aggregated A2B report for transactions in source portfolios.

GetA2BDataForFund

Reports > Balance Sheet

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

GetValuationPointTrialBalance

Reports > Cash Statement

Aggregated settled cash holdings (of type Balance) in source portfolios, in local currency only (not converted to base).

QueryCashStatementLocalCurrency

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 > Unsettled Trades Report

Aggregated report of unsettled transactions in source portfolios.

GetValuationPointUnsettledTransactions

Reports > Valuation Report

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

GetValuationForFund

Reports > VP Inputs

Summary of all the data that has contributed to a NAV calculation.

Various

Journal Entry Lines

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

GetValuationPointJournalEntryLines