Six Huge Risks Investment Managers Take When Using Spreadsheets for Client Fee Billing

June 05, 2019

 

By Doug Fritz

It’s natural to choose a familiar tool to make tasks easier, and turning to spreadsheet applications for calculations is no exception. In the investment management world, financial services teams, CFOs and operations teams often use spreadsheets for client fee calculation and billing. While the endless formulas, worksheet linking, and cross-tab capabilities may make spreadsheets a good choice at first, firms will quickly realize how much complexity and risk they end up creating. 

Investment managers must be able to prove the accuracy of their calculations and how access to the data is controlled. When selecting the method for calculating fees and billing clients, care should be taken to ensure the platform provides flexible and consistent fee calculation, fee collection capabilities, audit tracking and data security, external system interfaces and analytical reporting. Hands down, spreadsheets offer limited ability to meet these requirements.

Here are six substantial risks investment managers take when they use spreadsheets for client fee calculation, billing and cash flow management.

(read more/comment…)

Electra Blog Posts, Electra Information Systems, fund administrator, fee calculations, Electra Billing, Advisory Fee Billing, Investment Firms, Investment Managers

How Investment Firms Can Rise Above the SEC's Six Most Frequent Issues with Advisory Fee Billing

May 21, 2019

By Doug Fritz

It has been about a year since the U.S. Securities and Exchange Commission announced a risk alert that “Most Frequent Advisory Fee and Expense Compliance Issues Identified in Examinations of Investment Advisers.” Such inappropriate fee billing and expense practices may violate the Investment Advisers Act of 1940 and the rules implementing it, including anti-fraud provisions. Since the SEC announced the risk alert, there have been numerous fines and penalties charged to firms who have overbilled clients, whether intentional or not.

(read more/comment…)

Electra Blog Posts, Buy-Side Technology, Electra Information Systems, fund administrator, fee calculations, SEC Compliance, SEC, Electra Billing, Advisory Fee Billing, Investment Firms, automation

4 Reasons Why Hedge Funds Should Shadow Their Fund Administrator

April 30, 2019

by Todd Sloan

One of the most important responsibilities of the fund administrator is to calculate the fund net asset valuation (NAV). Before calculating the official NAV, the fund administrator must ensure the accuracy of the data by way of reconciling the investment manager’s data against that of the prime broker or custodian. Fund administrators are well-versed in the different ways that a NAV should be calculated and the need to agree with investment managers on the methodology to be used before posting an official NAV.

The question is, why does the investment manager need to reconcile the makeup and accuracy of their NAV if a service provider or fund administrator is already performing reconciliation? After speaking with several operations professionals across the hedge fund space, we identified four main reasons why an investment manager should shadow their service provider or fund administrator:

(read more/comment…)

Electra Blog Posts, Buy-Side Technology, Reconciliation Solution, Electra Information Systems, reconciliation, shadow accounting, Hedge Funds, NAV, fund administrator, Data Reconciliation

Improving Efficiency in the Reconciliation Investigation Process

February 25, 2019

by Todd Sloan, SVP Product Management

Most reconciliation solutions provide the data normalization and matching capabilities needed to identify and categorize exceptions. These features have helped buy-side firms to streamline post processing and improve the quality of financial records. However, the reconciliation process can become cumbersome when an exception is identified, and the investigation process begins. It is at this moment when different data sources (such as corporate actions, failed trades, collateral, missing funds, etc.) need to be accessed to troubleshoot a break and determine the root cause of an exception. The time and effort taken to open different applications and web pages, rummage through the information, and then research and manually compare results diminishes the productivity of the operations team or IT staff.

(read more/comment…)

Electra Blog Posts, Buy-Side Technology, Operations Management, Reconciliation Solution, Electra Information Systems, reconciliation

Bad Recs Can Halt Office Growth: Q&A

August 07, 2018

FTF News by Eugene Grygo

John Landry, CEO of Electra Information Systems, talks to FTF News about industry issues and why the company won the Best Reconciliation Solution award for the third time in a row in 2018.

(Growth can be a double-edged sword for some securities firms as it will bring in new revenues and the potential for more profits. However, incumbent systems and operations will have to be adjusted to meet the new demands of the front office. So says John Landry, CEO of Electra Information Systems, in an interview with FTF News. The need to scale operations to manage the growing demands of portfolio managers and others in the front office has been a big driver for overhauls of reconciliation systems. Landry spoke to us about Electra's selection as Best Reconciliation Solution for three years in a row, and other matters.)

Why did Electra embark upon four major client-driven changes in 2017 — enhancements for pending trades, approval workflow, auditing and historical data accessibility, and event-driven reconciliation? 

Electra views our clients as an extension of our own product management team and the features added in 2017 were the result of that partnership. Our clients identified areas of opportunity that could provide maximum time-saving for their staff and we worked closely with them to enhance Electra Reconciliation to address each.

(read more/comment…)

Electra Blog Posts, FTF News, Reconciliation Solution, Electra Information Systems

Machine Learning vs. Intelligent Integration?

March 14, 2018

During a recent meeting, a prospective client reiterated just how much time they spend every day resolving exceptions. Most of the vendors they met with prior to Electra were touting improvements made to matching rates through machine learning or another technology innovation. This prospect questioned the actual time they would save in the investigation process by increasing match rates for their holdings and transactions data by a few tenths of a percent. Instead, our prospect saw through the buzzwords and noted that the vast majority of their exceptions are true breaks that often require them to leave the reconciliation application to diagnose why the break occurred and what steps are needed for resolution. 

(read more/comment…)

Electra Blog Posts, Reconciliation Solution, Electra Information Systems

1

Leave a suggestion

Client Testimonials

Tammy L. Johnson, Globeflex Capital L.P.
We’ve now been a client for over 11 years and the relationship remains strong. Electra keeps us well informed, continuously innovating and adding functionality. Electra provides information on the latest versions which allows us to take advantage of the latest enhancements as our business requirements change and evolve.
Tammy L. Johnson, Globeflex Capital L.P.

GET MORE INFO

Get more information or schedule a product demo. Someone from our team will contact you promptly.