Looking for Excel in All the Wrong Places

Take reconciliation, for example. I had a discussion with a software vendor last week who said that millions can be lost inside single businesses due to discrepancies with invoices. Granted, their company now markets software to handle this, so there's an angle in presenting the problem as acute, but it's not the first time that I've heard something like this and it won't be the last, I'm sure. Reliance on manual processes is a dangerous game, particularly when rules and workflow-based systems can so easily marry up values to identify which ones match and which ones don't.
Then there's Excel. Many argue, quite rightly, that the Microsoft bête noire of office workers everywhere can do this. It can. But then it can't pass exceptions onto specific persons for analysis, or use logarithms among multiple documents and values to match to correct numbers, or automatically generate templates, invoices, correction notices and other areas on its own. You need software for that, and realistically, in today's environment, you need automation.
It's not just reconciliation, of course. How many firms still use fax machines to send through confirmations and other essential material? And how many of those are delayed, unnecessarily, when they could easily be generated by a computer program? Straight-through processing (STP), which in vendor speak can sometimes mean a full suite of their programs rather than linked systems, is still a topic worthy of discussion, even if those discussions are seemingly interminable at times.
A lot of this is on the buy side of course, but it definitely affects the sell side as well. The old adage rings true that the buy side has the money and the sell side has the technology, but in modern intertwined markets, that isn't workable. Brokers need connectivity to their clients just as much as markets for this reason; it prevents leakage. Given the pressures on cost bases at the moment, shaving thousands off operational expenditure which are unnecessarily on balance sheets is a golden egg.
Other areas also benefit from enhanced mechanization, like compliance. Even at its simplest level, checking what's reported against internal ledgers and other systems, all linked in a central technological hub, can easily help to make the life of rogue traders and others harder.
The old adage rings true that the buy side has the money and the sell side has the technology, but in modern intertwined markets, that isn't workable.
Perhaps the days of high-profile tech installations and mass proprietary development are waning, but dismissing technology in favor of other areas is false economy. Our society as a whole is powered by it, and the financial services sector in particular lives and breathes off the back of it. Getting ahead of the technology game now will reap dividends in the future.
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: https://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.
As outlined in our terms and conditions, https://www.infopro-digital.com/terms-and-conditions/subscriptions/ (point 2.4), printing is limited to a single copy.
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. As outlined in our terms and conditions, https://www.infopro-digital.com/terms-and-conditions/subscriptions/ (clause 2.4), an Authorised User may only make one copy of the materials for their own personal use. You must also comply with the restrictions in clause 2.5.
If you would like to purchase additional rights please email info@waterstechnology.com
More on Trading Tech
Academic warns of systemic risk from AI-powered trading
Strategies generated by LLMs exhibit “very strange, correlated trading behavior”, says Lopez Lira.
The Model Context Protocol brings agents to life—along with risk
Waters Wrap: From chat to infrastructure modernization, Anthropic’s MCP offers a ‘bridge’ to agentic AI, but its early days may prove disillusioning.
NZX outlines plans to bolster fast-growing dark pool
Since launching one year ago, NZX’s dark book has 5.5% of the exchange’s total turnover, and price improvement per trade on average is 11 basis points, but the exchange has more in store.
Agentic AI comes to Bloomberg Terminal via Anthropic protocol
The data giant’s ubiquitous terminal has been slowly opening up for years, but its latest enhancement represents a forward leap in what CTO Shawn Edwards calls, “the way we should talk to the world.”
M&G Investments braves cost headwinds in pursuit of AI
The UK asset manager’s AI ambitions started with the creation of a data lake to ensure high-quality data is being fed into models.
Asic probe piles pressure on ASX to deliver Chess replacement
But market insiders think late intervention by regulators could even slow down implementation.
Stakes raised for UK bond, EU derivatives tapes after Ediphy clinches win
The pressure is on for TransFICC, Etrading, Finbourne, and Propellant Digital, who are still vying to provide the UK’s fixed income consolidated tape after Esma awarded the EU’s tape to Ediphy and its partners.
Exchange M&A, US moratorium on AI regs dashed, Citi’s “fat-finger”-killer, and more
The Waters Cooler: Euronext-Athex, SIX-Aquis, Blue Ocean-Eventus, EDM Association, and more in this week’s news roundup.