Anthony Malakian: No Reconciling Dependency on Excel
![anthony-malakian-waters anthony-malakian-waters](/sites/default/files/styles/landscape_750_463/public/import/IMG/216/142216/anthony-malakian-waters.jpg.webp?h=373a525f&itok=zNeqXFEa)
I can’t decide if it’s reprehensible that firms are still struggling with the automation of reconciliations, or whether it makes sense. Perhaps the greatest challenge is that it’s difficult to change people’s behavior. Microsoft Excel and Access databases are familiar to many in the capital markets, and are passable when it comes to risk management. As Matthew Baglio of Greenwich, Conn.-based hedge fund AQR Capital notes in this month’s case study on page 26 on how the firm transformed its reconciliations processes, “Even with how clunky Excel can be, it’s still something where, when you compare two sets of data, it’s reliable.” That’s a hard argument to counter.
AQR, which manages nearly $80 billion, was an early adopter of an automated reconciliations platform and its reliance on Excel is now “minimal,” Baglio says. The greatest challenge wasn’t getting people comfortable with a move away from Excel to a platform from Electra Information Systems, but rather figuring out how best to use the system to fit the firm’s needs.
“When Electra showed us their STaARS platform, they showed us everything available, but we needed it for specific AQR needs,” Baglio says. “We needed to create a lot of rules based on the number of counterparties we use.”
This entailed setting up the right pipes and feeds to deal with the large volume of Swift messages from the fund’s various counterparties. AQR also needed to implement controls to ensure nothing was missed in terms of all the data entering and exiting the system.
Virginie O’Shea, analyst at Boston-based consultancy Aite Group, who has a lot of experience with systems in the reconciliations market, says the technology is applied to a variety of new areas today, and there is no silver bullet for tackling reconciliations. “There’s not generally a one-size-fits-all approach to reconciliations,” she says.
AQR now has a single account manager reconciling 30 portfolios on a daily basis, as opposed to 10 when it relied on Excel.
There are significant gains to be made by becoming more automated. O’Shea points to four areas in a recent report where reconciliations have taken on greater priority: the reduction of operational and key-person risk; cost containment and headcount reduction; opportunities in the market by onboarding new clients quickly and efficiently; and regulatory compliance.
But when it comes to replacing back-office platforms, especially those that have been around for some time, there is no gain without some pain. However, as AQR has shown, it is possible. The firm now has a single account manager reconciling 30 portfolios on a daily basis, as opposed to 10 when it relied on Excel. That has allowed it to turn staff toward new projects, such as building managerial metrics on top of the STaARS platform to better understand discrepancies for breaks between AQR and its counterparties, says Baglio.
Demanding Change
Hopefully, new regulatory demands stemming from the Dodd–Frank Act in the US and from the European Market Infrastructure Regulation (EMIR) will drive increased automation. Funds are now required to demonstrate better organizational controls and more transparency around their investment strategies, which includes security positions and management fees, notes Todd Sloan, product manager at Electra. New regulations also require solutions to be capable of aggregating and reconciling accounting information for both fund-level and investor-level data.
Take new swaps rules as an example. Many hedge funds will be labeled as major swap participants (MSPs), and, according to the Commodity Futures Trading Commission (CFTC), those firms will be required to reconcile their trades at specific frequencies, given their swap-trading volumes. There will, therefore, be regulations implemented mandating such funds to demonstrate that reconciliations have taken place. Another challenge lies within new rules around collateral management and margin calculations.
Pressure is also being exerted on funds from investors. Much in the same way that they are scrutinizing Form PF or risk management compliance, they are now asking more about reconciliations as part of their due diligence studies, demanding greater visibility into hedge funds’ security positions and management fees. Reconciliations, O’Shea notes, is the foundation for that.
Only users who have a paid subscription or are part of a corporate subscription are able to print or copy content.
To access these options, along with all other subscription benefits, please contact info@waterstechnology.com or view our subscription options here: http://subscriptions.waterstechnology.com/subscribe
You are currently unable to print this content. Please contact info@waterstechnology.com to find out more.
You are currently unable to copy this content. Please contact info@waterstechnology.com to find out more.
Copyright Infopro Digital Limited. All rights reserved.
You may share this content using our article tools. Printing this content is for the sole use of the Authorised User (named subscriber), as outlined in our terms and conditions - https://www.infopro-insight.com/terms-conditions/insight-subscriptions/
If you would like to purchase additional rights please email info@waterstechnology.com
Copyright Infopro Digital Limited. All rights reserved.
You may share this content using our article tools. Copying this content is for the sole use of the Authorised User (named subscriber), as outlined in our terms and conditions - https://www.infopro-insight.com/terms-conditions/insight-subscriptions/
If you would like to purchase additional rights please email info@waterstechnology.com
More on Trading Tech
Ace high or busted flush? Digital Asset’s mixed fortunes mirror DLT adversity
The vendor hoped to remodel post-trade using blockchain technology—and it still might—but its bumpy progress raises questions over the future of DLT in finance.
This Week: BlackRock/Preqin, Trading Technologies, FIA Tech and more
A summary of some of the past week’s financial technology news.
Adaptive’s Aeron goes live on Microsoft Azure Marketplace
The messaging software used for building bespoke trading platforms is now available on Microsoft’s marketplace, making it accessible through major cloud providers.
Bloomberg, industry bodies push back on Cboe’s proposed OEMS rule change
Some industry bodies disagree with the options exchange’s proposal to carve its Silexx OEMS out of the SEC’s definition of an exchange facility and place it into a separate business line.
Waters Wrap: CME, Google and the pursuit of ultra-low-latency trading
CME Group and Google have announced Aurora, Illinois, as the location for the exchange’s new co-location facility. Anthony explains why this is more than just the next phase of the two companies’ originally announced project.
WatersTechnology latest edition
Check out our latest edition, plus more than 12 years of our best content.
Natixis refines in-house interoperability model
The French asset manager has refined its canonical data model over the last decade, as the interoperability movement continues to evolve.
Zeros and ones: Industry contemplates T+0 as the next step
With the North American transition to T+1 settlement complete, same-day settlement could be the next goalpost set, though skeptics are many.