Structured Reports 

Based on the SPUD schema, several structured reports can be provided as part of the standard agreement. The following is an overview of the available reports:

• Sales/Transfer Agency: Dealings and Holdings reports and analysis by client / intermediary / channel / product or product group.
• Investment Accounting: Valued holdings by sector, region, currency or any other analysis with drill through to trades, capital events, income, fx or any other transaction type. Detailed enquiry reports for trades, income and entitlement, Spot and Forward FX, Cash / deposit / loans transactions. Trial Balance break down with drill through to account postings/transactions. Reports are per fund or aggregated into fund groups as required.
• Fund reference: Reports and analysis on funds, fund structures, related parties such as fund managers, advisors etc.
• Net Asset Value NAV or NAV price reports from inception or user defined period. Drill through to corresponding holdings (if available) for each NAV point, together with corresponding analysis approach (sector etc.)
• Exposure analysis by various analysis categories.
• Trade reports including soft, confirmed, failed and late trades.
• Assets under Management including current period, historic NAV points and comparisons of period / period.
• See through reports for Fund of Funds, baskets, index futures or other portfolio related synthetic securities.
• Broker / counterparty commissions analysis.
• IFA commissions analysis including production of rebates / retrocession calculations and ledger postings.
• Cash projections / ladders can be provided as an optional extra provide the underlying data can be provided.
• Compliance Reports for FSA and other regulatory bodies.

Ad-hoc Reports and End-user Business Intellignece 

Most Database and BI vendors produce ad-hoc report designers. We have extensive experience in optimising database designs to support these tools.