Technology

Managing Corporate Treasury with Spreadsheets

Report date: 
13 Mar 2025

Commentary

Technology. Treasurers love it – and love to hate it. We depend on it, and appreciate the help it provides. But the treasury technology landscape is complex and changing fast. Treasurers have very different views on the best tools and approaches: it can be a real challenge knowing where to turn.

This call was a departure from the usual discussions on the pros and cons of robots, different TMSs and ERP treasury modules, or how AI can improve your cash forecasting. Instead, we had some very motivated peers who passionately defended the benefits of the second oldest treasury technology (after calculators!): spreadsheets. These peers’ comments bore out the conclusion from our ongoing Treasury Technology Benchmark: spreadsheets are very much alive.

Everyone understands the drawbacks with spreadsheets: they are prone to error, they are often not properly documented and can be changed too easily. They do not automatically provide sophisticated reporting tools, data is often entered manually (and potentially incorrectly), and access control can be a challenge. 

All these issues can be addressed – more below. But the peers stressed that...

 

Please LogIn /Register to access the full commentary and a further 150+ similar commentaries. If you receive our newsletter - use your email to LogIn / Request Password Reset
Topics covered in this report: 

Please log in, or create a free account, to read the whole report summary.

Corporate Treasury's relationship with their IT department

Report date: 
10 Feb 2025

Commentary

“In every company, we all share the same objectives and work together to achieve them.” 

This statement is obvious – but we all know that the reality is more complicated: apart from genuine – healthy – differences of opinion, the need to prioritise the use of scarce resources can generate heated debates which do not always end well.

The reality of corporate teamwork is especially challenging for treasurers. We rely on data and input from many sources, and we need IT systems to manage this process. But many treasurers are reluctant to be part of the corporate IT structure: it usually does not provide the functionality we need, treasury is often not a high priority for budgets and investment, and there is a strong feeling IT does not understand our needs. At the same time, as good corporate citizens, we should not be heading off in a separate direction.

So – how do treasurers manage this conundrum?

  • Have a specialised IT team in treasury, or rely on central IT?
  • Use the treasury module of the major ERP systems, or install a bespoke TMS?
  • Download all the data manually and use spreadsheets?
  • Where to get the budgets? Where does treasury stand in the pecking order?

There was a surprising consistency in the approach: 

  • Whoever they actually report to, everyone felt a specialised IT team was needed
  • Whether treasury runs its own IT team or not, treasury’s needs have to be addressed separately
  • Most participants agreed treasury is not a top priority for the business or budgets. One took a very different view: using value at risk as an argument, they had obtained “gold standard” prioritisation.
  • A different approach is to frame treasury business cases in terms of....
Please LogIn /Register to access the full commentary and a further 150+ similar commentaries. If you receive our newsletter - use your email to LogIn / Request Password Reset
Topics covered in this report: 

Please log in, or create a free account, to read the whole report summary.

Future-proofing Global Treasury Teams

Report date: 
9 Dec 2024

Commentary

“When I do interviews, I typically focus more on the communication, the style, how people fit in the team, more than on actual knowledge.”

What are treasurers doing to prepare their organisations for the many challenges they face?

This quote is one of many insights contained in our detailed report on managing treasury organisations. More and more, treasurers are telling us that the people side of the role is key: you can have the best technical solution, but treasury’s contribution and importance will not be understood if you can’t communicate with the business.  

At the same time, we are becoming ever more dependant on IT. Routine tasks are being automated, and the holy grail of becoming the strategic advisor to the business requires the ability to analyse huge amounts of data. Ironically, when treasurers need to make sure they have a key skill in the team, it is more likely to be an IT capability than being good at discounted cash flows – it is easier to teach the traditional treasury skills.

Change management is also key. New technologies, and shifting organisation structures such as shared service centres, are re-defining roles and organisation structures. The task a person has been successfully performing for years may no longer exist, or may move to a different function or location: career development may mean moving outside treasury. 

As usual, the full report brings many insights. The main points:  

  • Change management: jobs are moving from processing transactions (increasingly automated) to more strategic, higher level analysis – especially improved cash forecasting. Buy-in is essential: these changes can be discomforting. Transparency is important: team members need to see the benefits of improving the processes and systems, and to have individual development plans to equip them for the new reality. It is best to involve them in projects which expose them to the new areas.
  • Everyone is under constant pressure...
Please LogIn /Register to access the full commentary and a further 150+ similar commentaries. If you receive our newsletter - use your email to LogIn / Request Password Reset
Topics covered in this report: 

Please log in, or create a free account, to read the whole report summary.

Corporate Treasury : Kyriba TMS User Experiences

Report date: 
10 Jun 2024

In the CXC Treasury Technology Benchmark we gather unfiltered feedback from treasurers who actively use major TMS platforms. Unlike insights shaped by vendors' marketing materials, our approach is akin to independent product reviews, offering candid user experiences in a confidential setting.

This session focused on Kyriba, one of the most frequently discussed TMSs in treasury circles. Given the sensitivities around corporate relationships with providers, we have taken extra precautions to ensure anonymity.

The discussion provided valuable insights into user satisfaction, areas of strength, and recurring challenges. While some features received consistently positive feedback, perspectives varied widely on others. Certain factors emerged as significant concerns for multiple participants, influencing their long-term outlook on the system.

For those considering a TMS or evaluating their current setup, this report delivers a nuanced view of Kyriba from the perspective of experienced users. The full version contains detailed, practical insights that could be instrumental in shaping treasury technology decisions.

Please Login / Register to access this commentary

 

Topics covered in this report: 
Service providers discussed in this report: 

Please log in, or create a free account, to read the whole report summary.

Corporate Treasury Technology Roadmaps

Report date: 
1 Sep 2023

Commentary

Technology is changing the way many businesses work: with online commerce, many traditionally B2B businesses are moving to B2C. Logistics and supply chains are being transformed. Ride hailing and food delivery services operate real time payment systems. Assets we used to buy are increasingly available as a service, often linked to the internet of things.

Where are our banks in this turmoil? And how are treasurers adapting? We wanted to get a first view. Judging by the response we received, we are clearly not alone in being very interested.

This report is long – even the summary takes several pages, and it does not capture all the nuances. It is well worth reading the detail – it clearly lays out the challenges treasurers are facing.

Business transformation

For the time being, treasurers are adopting a wait-and-see approach to business changes. When the business moves to B2C, or becomes a full asset as a service enterprise, treasury will adapt accordingly. In the meantime, treasurers see no need to get ahead of the business, or even necessarily be a change agent.

On the other hand, CXC members who are in the new, online enabled industries are, of necessity, proving to be early adopters of the new technologies.

Communicating with banks

Over the years, centralised global and regional treasury management has been enabled by online banking tools with balance reporting, remote account management and payment initiation.

This has brought enormous benefits to treasury management. But it is not perfect:

  • Mostly, the data is not real time. It is often yesterday’s balance and transactions
  • There are many different tools: host to host, e-banking systems, SWIFT reporting, APIs
  • Security protocols remain a conce

Please Login or Register to access the rest of this free commentary.

If you haven't previously Logged in but receive commentaries via email, simply use your email address to change your password to Log in.

Topics covered in this report: 
Service providers discussed in this report: 

Please log in, or create a free account, to read the whole report summary.

AI & Robotics in Corporate Treasury

Report date: 
9 May 2023

Commentary

This call was organised in the midst of media hype about AI (Artificial Intelligence), with several banks having banned the use of ChatGPT, and highly convincing fake videos being created and going viral. The first question was whether our members share the banks’ concern over the danger of tools such as ChatGPT running out of control and executing highly credible frauds. The answer was “No” - in the sense that it was not on anyone’s radar screen.

The second question was about the adoption of robots to automate treasury processes: these typically execute pre-defined processes, with no decision-making function. There are high levels of interest in this, and increasing levels of adoption. 

AI is of interest for areas such as forecasting, where an increasing number of applications are available which look at historical data and use it to predict future patterns. However, only one participant is currently using it for cash forecasting. But:

  • Banks are increasingly using AI to screen transactions, and highlight unusual ones. This is good – but one participant saw valid, but unusual, transactions fail to execute on time as a result.  
  • AI’s ability to handle large data lakes or oceans inside companies is a positive - but it is hard to be sure all the relevant data has been included. 
  • One participant is concerned that the questions being asked on ChatGPT could potentially be tracked, leading to confidentiality breaches.
  • The same participant is also concerned that the inability to track and verify the source of data in this tool could lead to unintentional copyright infringements. Usage rules are being put in place to manage these risks.

On the other hand, most participants are actively using robots for various tasks:

  • Allocation of
Please Login or Register to access the rest of this free commentary.
If you haven't previously Logged in but receive commentaries via email, simply use your email address to change your password & LogIn
Topics covered in this report: 

Please log in, or create a free account, to read the whole report summary.

Pages