PORTFOLIO ACCOUNTING & MANAGEMENT FEATURES

Portfolio accounting, management and reporting tasks completion for a Family Office is being made faster, easier and more accurate within the X-Office portfolio module.

Reporting

- Over 50 standard reports & charts on any date or date range.
- Portfolio Attribution, Asset Allocation, Exposure and Net Worth Statements.
- Aggregate cross-entities reporting of financials, portfolio and performance items by Family Member(Investor), Family, Generation, Branch, Strategies, Asset Type, Custom Portfolios (include/exclude any item filter), etc. .
- Save reports to HTML, Excel, PDF, XML; charts to GIF files, for email or web sites.
- Create integrated custom reports in MS Excel or in a third-party package supporting ODBC, like Microsoft® Access or Crystal Reports®.
- Multi-language capability let you report in any language to the partners. Easy to set up a new language.
- Publish reports & charts in your family password protected web site (FC Client Portal) with one mouse click.

Performance & Risk Measurement

- View total or annualized rate of return for a Family Member, Family, Branch, Generation, Managed Account, Partnership Account, Sector, Instrument, Portfolio, Broker Account, etc on a chart or report.
- Internal Rate of Return (IRR), Time Weighted Return (TWR), Simple Rate of Return, Flat Simple Rate of Return.
- Compare performance against specified indices (standard or custom).
- Performance by industries, strategies, geography and any other user-definable sectors.
- Portfolio statistics: standard deviation, Sharpe ratio, Sortino, Corellation, Alpha, Beta, Treynor, Composite monthly return, etc.

Family Members Management

- Track family members and their related contacts information.
- Easy & automated distribution of a member and other report sets by e-mail, or uploading to the web (vith our FC Client Portal product)
- Track all communications with clients and related documents in FC CRM (Client Relationship Management) product.

Instruments

Equities
Derivatives: Options, Futures, Sec. 1256 contracts, Spot FX, Forwards, Forex, Contract For Difference(CFD), Credit Default Swap (CDS), Interest Rate Swap (IRS).
Fixed income: Bonds, Time Deposits, Mortgages, Collaterized Mortgage Obligations (CMO), Loans, Mezzanine Loans, REPO, Convertibles, Real Estate, Structured Products, Aircrafts, Collaterized Debt Obligation (CDO), Franchise, Home Equity.
Automatic calculation of accrued interest, accretion and amortization.
Funds: Mutual Funds, Funds/Partnerships (with tracking of gain/loss items from K-1s), Private Equity, Master-Feeder structures and more.
Currency
- New instruments can be added per customer request

Inventory methods

- FIFO, LIFO, specific tax lot, Maximum/Minimum gain, average cost accounting.


Brokers' Data Download & Reconciliation

- Download account transactions from multiple brokers and banks. New brokers/custodians imports can be added by us or user.
- Reconcile portfolio & cash with brokers automatically.
- File Import Wizard and Import Template Manager for importing downloadable broker/custodian files (Excel, CSV, XML, Quicken QFX, OFX)

Multi-currency

- Define base currency and local currencies for an instrument and/or broker/custodian. Track valuations and cash flows in the currency of related instrument.
- Set individual exchange rate for each trade, or for the fund as a whole. Multiple exchange rates for same date.
- Track Market gain and FX gain separately.
- Amounts are tracked both in local and base currencies, in General Ledger.
- Load Exchange rates from custom sources

Features in development

- Add new instruments, reports and charts.
- Development of any feature can be accelerated per customer's request.