Products

Account Translation Utility | CarveOut Utility | Client Builder | QuickBooks Utility
Trade Extract Utility for Moxy® | XProducts
 

Account Translation Utility

“The Account Translation Utility can be included in typical morning automation processes.  Allowing users to reroute transactions for specific custodian/account/security combinations to separate portfolios in Axys®, as well as convert specific custodian/account/security combinations to different symbols in Axys®.” Dale Honabach, CSSI Senior Consultant

The Account Translation Utility 2.1.1(ATU) allows flexible routing of transactions to multiple portfolio files. Regular processing in Dataport is limited because all transactions from one custodian account number must be posted to one portfolio file. Dataport will not allow activity from one account to be split among several cli files. For example, when using Dataport, all activity for custodian account 123456 must go into the same cli file. Maintaining data that does not follow this one-to-one mapping requires manual intervention.

If, for example, you wanted the supervised assets for account 123456 to go into one cli file, and unsupervised assets for account 123456 to go into a different cli file, you would have to manually move the transactions out of the first cli file and into the second cli file.

ATU takes away the need for user intervention. It works as a pre-process to Dataport and translates the portfolio code based on user-defined criteria. The user also has the ability to run this process from an Axys® script or from a batch file which provides additional flexibility.

Product Sheet Download:

Buying Points:

  • ATU lets you translate account numbers based on Security Symbol, Security Type or Asset Class.
  • Because accounts that are not translated by ATU follow normal processing in Dataport, you only need to define the exceptions to the one-to-one, account-to-portfolio mapping.
  • ATU works with any and all Dataport interfaces (Schwab, Fidelity etc).

System Requirements:

  • Axys® version 3.3 or higher.
  • Axys® single user or network version.
  • Windows NT, 2000, XP or 7.
  • Pentium 133Mhz PC.
  • 64MB RAM.

CarveOut Utility

“The Carve Out Utility allows for the complete rerouting or the shadowing of any transaction based on portfolio code/class/type/symbol combinations to other portfolio codes.  The Utility also includes 4 custom reports that help assist in the re-balancing of cash and maintenance of the carved out portfolios.” Dale Honabach, CSSI Senior Consultant

CSSI’s CarveOut Utility can be used by GIPS compliant companies that are affected by the 2010 rule changes for cash allocation. Currently companies have been able to maintain one account for multiple composites and then split out the assets and allocate cash accordingly. Under the new rules, the assets need to be maintained in separate accounts and have their own cash allocation. The CarveOut Utility gives you the ability to do this without setting up additional accounts at the custodian level.

CSSI’s CarveOut Utility works within the portfolio management system. It splits the assets on a daily basis and can be incorporated into your current process. It also gives you the option to shadow accounts.

Product Sheet Download:

How does it do it?

Using three processes:

  1. Rules mapping tool to split assets from one account at the custodian level to multiple accounts on the portfolio management system.
  2. Custom reconciliation report to roll up individual accounts into a combined account for reconciliation purposes.
  3. Re-balancing process that can re-balance cash on a daily or monthly basis.

What else does it do?

Gives you the ability:

  1. To split:
    • Expenses.
    • Management Fees.
    • Cash Receipts.
    • Cash Disbursements based on Allocation Settings.
    • Split Interest on Cash based on current actual balances.
  2. To Check:
    • Cash Allocations settings to make sure they total 100%.

How easy is it to set-up?

  • Included in the purchase price is a WebEx installation of the product by CSSI.
    Note: This does not include mapping, process review or training.

To set-up and use effectively, individuals will need to understand:

  1. The portfolio management system reconciliation process.
  2. Label management.
  3. Composite structure and rules.

Typical Daily Process:

  1. Download transactions and positions from data exchange.
  2. Translate transactions and positions in Dataport.
  3. Export Files.
  4. Run CarveOut Utility on transactions and positions blotters.
  5. Import Files.
  6. Run custom CSSI reconciliation report.

ClientBuilder

“ClientBuilder is employed by user to primarily help with custom Axys® Label population and maintenance, allowing non Axys® users to more easily find and populate Axys® custom labels.” Dale Honabach, CSSI Senior Consultant

ClientBuilder 2.1 allows you to take control of your cli and grp creation and maintenance. Use the ClientBuilder Admin Utility to define meaningful descriptions for your custom labels. Declare specific fields as being “required.” Specify other fields as “dropdowns,” allowing your users to select from among certain pre-defined values for these fields. ClientBuilder dynamically constructs the “front-end” data entry dialog boxes that allow users to easily create and maintain clients and groups in Axys®. New users get up to speed quickly when they use ClientBuilder.

Product Sheet Download:

Buying Points:

  • Custom Labels – Create text descriptions for your custom labels.
  • Data Entry enforcement – Define specific fields as being required.
  • Group Maintenance – Manage groups more easily.

System Requirements:

  • Axys® version 3.3 or higher.
  • Axys® single user or network version.
  • Windows 95/98, NT, Win2000, XP or 7.
  • Pentium 133Mhz PC.
  • 64 MB RAM.

Options: Single User.

QuickBooks Utility

“The CSSI QuickBooks Utility allows users to efficiently import invoices and payments into the system.  Management fees and payments can be read from your portfolio management system such as APX® or Axys®.  Fees can also be read from other systems such as revenue center.”
Trevor Keast, CSSI Senior Consultant

QuickBooks® 2.1 management fee utility allows an Axys® user to post fees and/or payments directly to QuickBooks®. During the posting process the utility creates any new customers, creates invoices and receives payments. A fee reconciliation process displays exceptions between the two systems. Accounts can be linked to existing customers in QuickBooks® or automatically created as new customers in QuickBooks®. Existing Axys® data can be used to populate any field in QuickBooks®, including custom fields.

Product Sheet Download:

Buying Points:

  • Creates new customers in QuickBooks.
  • Processes receivables in Axys®; to payment receipts in QuickBooks®.
  • Creates a Compare Report for auditing results.
  • Custom Axys® fee payment report included.
  • Custom Axys® modified billing report included as part of base cost.
  • Custom Axys® compare report.

System requirements:

  • Axys® version 3.x or higher.
  • Axys® single user or network version.
  • Windows 98, NT, 2000, XP or 7.
  • Requires modified billing report (1 included with package).
  • Works with QuickBooks Pro™.

Trade Extract Utility for Moxy®

“CSSI’s Trade Extract Utility can produce custodial trade confirmations in a variety of formats.  CSSI has a number of pre-coded formats for the larger custodians; however custom formats can be produced upon request.  Custodial trade confirmations can be fully automated using the Trade Extract Utility including delivery by FTP, SFTP, or email (etc.).”
Trevor Keast, CSSI Senior Consultant

The Trade Extract Utility (TEU) establishes a connection with an existing Moxy® database in order to retrieve trade related data. The Utility is capable of writing the data to a variety of file formats. Formats specific to various custodians are available. Additional formats can also be customized if needed. The TEU can be used to upload trade and order information.

Each interface is designed to work with the existing fields available when running the standard Moxy® reports. This should allow the typical Moxy® user to easily adapt to the process of running the utility. Check the list of existing interfaces to see if yours is available. If it is not on the list, contact to see about having one created.

In some cases, custom configuration may be required based on the custodian or Moxy® system settings. In all cases there is a validation process that ensures the quality of data the custodian receives.

Product Sheet Download:

Existing Output Formats:

  • CIBC Mellon
  • Merrill Lynch MMS
  • Morgan Stanley
  • National Penn
  • Northern Trust
  • Smith Barney
  • Wachovia
  • More Coming!

Licensing

  • Each interface is licensed for a year, and at the end of each year a 20% maintenance fee renews the license for another year.
  • The license allows the user to install the utility on any number of computers.
  • The license requires that the interface is used on a version of Moxy® that has an appropriate Advent Copy Number.

System Requirements:

  • Moxy® 6.0 or higher.
  • .NET Framework 2.0.

XProducts

CSSI’s XData –

The web offers a wealth of information that can be used to analyze the portfolios that you manage. The challenge has been to find an efficient way to access that data and integrate it with the accounts on your accounting system. The XData utility has been created to assist firms in this process.

Product Sheet Downloads:

XData can help update:

  • Security Information.
  • Dividend Data.
  • Balance Sheet Data.
  • Profitability Data.
  • Share Information.
  • Valuation Measures.
  • Income Statement Data.
  • Stock Price Data.

XData allows you to track security data from an easy to use and customizable interface.

XData System equirements:

  • Advent Portfolio Exchange (APX®)™ version 2.0 or higher.
  • Windows 98, NT, 2000,  XP or 7.

CSSI’s XEstate –

In the course of managing accounts, the need often arises to step up the basis for securities of an estate. This is usually task that requires an administrator to look up the high and low prices of all equities. The XEstate utility was created to help with this process.

XEstate does the following:

  • Downloads the high and low necessary for estate valuations and step up in basis.
  • Automatically creates a trade blotter to post the long-ins and long-outs.
  • Includes two reports that display an appraisal with the high, the low and the mean prices.

CSSI’s XPerf –

XPerf manages performance file labels from a single location. XPerf allows you to update multiple accounts at once.

XPerf can help:

  • Update performance name labels.
  • Copy labels between performance files.
  • Copy labels from client files to performance files.
  • Update $colx, $rowx and index tab labels.
  • Maintain Blends across multiple performance files.

XPerf automates the redundant task of updating individual performance files, you can now do it all with the single click of a button.

CSSI’s XPrice –

Investment firms sometimes have the difficult task of updating a large number of price files in an Axys® system. The process involves opening and altering each price file individually, which can lead to numerous errors. The XPrice utility has been created to assist firms in this process.

XPrice can help with updating:

  • Prior day prices or historical prices from Yahoo – entire file or just missing prices.
  • A range of missing prices from Yahoo.
  • Index values from Yahoo – both single date and a date range.
  • Daily index values from Russell.

XPrice System requirements:

  • Axys®version 3.x or higher.
  • Axys®single user or network version.
  • Windows 98, NT, 2000, XP or 7.
  • Requires modified billing report (1 included with package).

XPrice has the ability to update Axys® price files and also compare Axys® prices to those found on Yahoo, making it an excellence compliance tool. Users have the ability to review all prices to be imported before the import happens. The utility can also create a backup of your current price files before the import process.

Other CSSI Services

  • Axys®/APX® Custom Quarterly Report Packages – CSSI creates custom quarterly report packages that meet your specific layout and data needs.
  • Axys®/APX® Custom Billing Reports – CSSI creates custom billing reports that handle customers’ complex billing needs.
  • Axys®/APX® Custom Operations Reports – CSSI creates custom reports to help customers with their operation needs.
  • Axys®/APX® Consulting Services – CSSI assists firms by delivering customized consulting services to increase the overall utility of their systems.

How Do I Learn More?

Contact at to learn more about how CSSI can assist your firm with any and all of your Advent needs.