A Review of EBICS & One of Its Most Unique Payment Features for Corporates

08-11-2021| treasuryXL | TIS | LinkedIn

In the early 2000s, a team of German banks began collaborating on a project to simplify and harmonize corporate payment processes across Europe. After several years of development, the Electronic Banking Internet Communication Standard (EBICS) was released and has since become a critical component of Europe’s broader corporate payments infrastructure — particularly within Germany, France, Austria, and Switzerland. With regards to the EBICS protocol, one feature of particular interest to corporates is VEU – meaning “Verteilte Elektronische Unterschrift”. In English, the abbreviation EDS is used, which stands for Electronic Distributed Signature. In this blog, a technical summary and sample use case of EDS are provided in order to demonstrate the security and data quality-related benefits for corporates and banks. For more information on EDS, you can also download EBICS’ recent technical whitepaper, which is linked here (download the PDF marked “Final” and see page 148). 

A Recap of EBICS: 16+ Years of Bringing Structure to European B2B Payment Standards  

For those who may be unfamiliar, the Electronic Banking Internet Communication Standard (EBICS) is a German-based transmission protocol that helps regulate the standards and formats that many European banks (including those in France, Switzerland, Germany, Austria, and other regions of the Single Euro Payments Area (SEPA)) use for transmitting corporate financial and payments information between one another.    

When the EBICS standard was first launched in 2005, it aimed to create a more secure way for banks to manage corporate payments and data workflows across Europe. Although several other standards already existed at the time, EBICS has since proven to be a superior standard and has become the leading protocol for conducting corporate payments in Europe. Today, EBICS is also widely considered as the role model for progress towards standardized corporate SEPA payments.  

In the years following its formation, EBICS has continued releasing updates to their financial messaging and payment standards as the European business and banking landscape evolves. This is done in order to provide the highest level of data quality, security, and privacy for all the participants in a transaction, including the financial institutions, their corporate clients, and any associated vendors, suppliers, and partners.  

As part of these updates, EBICS introduced the Electronic Distributed Signature (EDS) – also known as Distributed Electronic Signature (DES) – to allow orders and transactions to be authorized by multiple users and participants, even if they are operating at different companies or in unique locations and time-zones.  

Using EDS, an order or transaction remains stored in an initiating bank’s processing system until either the necessary number of signatures with suitable authorization have been received, a time limit set by the bank’s computer system has been exceeded, or the order is cancelled by the responsible parties.  

This process was introduced by EBICS in order to strengthen the controls used by organizations and institutions for initiating and approving large or complex payments within Europe. Today, it enjoys broad usage throughout the SEPA region and is considered a standard practice when conducting B2B payments.   

Who Benefits from Using the EDS Capability?  

EDS is most helpful for organizations that have users and personnel working remotely, or from offices in diverse locations and regions. It is also advantageous for companies that routinely pay hundreds or thousands of suppliers and business partners and that are subsequently at a higher risk of payments fraud. In practice, EDS enables a broader degree of control and oversight on payments by allowing signers from any company, location, or branch to each independently verify and approve an order before it is processed by the bank. At the same time, using EBICS provides a greater level of underlying remittance data for each transaction compared to other payment standards, which aids the participating banks and corporates in confirming the exact nature and status of each order.  

Integrating EDS to a company’s banking and payment landscape is usually handled directly within the payment platform used for transmitting payment instructions to the bank. For instance, a corporate that uses a TMS for executing Euro payments could access the EDS standard directly in the TMS, but they would also be able to rely on the initiating bank for additional oversight. For each payment initiated through EDS, the rules of submission can also be customized, and the fulfillment can be tracked automatically by each party and signer. While processing the order, there are also designated pathways for viewing the order status and alerting inactive signers that the transaction requires their approval.  

Utilizing the EBICS EDS Capability Through TIS   

When combined with TIS’ other data, system, and payment security measures, using EDS adds an additional layer of control for our banks and enterprise customers, as well as their suppliers and partners. For organizations that maintain an active presence in Europe, utilizing the EDS capability is also recommended in order to remain compliant with EBICS’ latest standards for payment processing, data quality, and information security.  

More information about other security and data privacy tactics employed by TIS can be found here. 

For TIS customers, the EDS capability is available for EBICS payments as a standard service. This means that multiple users, even those from different organizations, can view and authorize one single order. It also enables the provision of the first and/or second signature for electronic payment transactions to take place from completely separate locations. The authorized signatory is thus able to check and authorize the payment transaction orders provided from other branches or systems directly within the TIS platform. Authorized users can find the Distributed ES (VEU) option under Administration > Bank Transaction Manager Settings > EBICS > Download Configurationthe orders will be visible in the BTM Monitor. 

The EDS-specific data available through TIS includes the number of outstanding signatures required before an order is processed, the list of approved and pending signatures, and also details regarding the timeframe for signatories to approve the payment before it is automatically halted by the bank. The underlying remittance information on each order is also provided to users through TIS as a standard service.  

However, this information will only be visible to authorized users that are responsible for overseeing and executing the relevant orders; these settings can be configured by admins in the TIS system.  

For our enterprise and multinational clients, EDS is particularly helpful in instances where the payment approvers are globally distributed (such as with remote finance and treasury teams), or when making supplier payments to a diverse range of beneficiaries. This is because signatories from all parties and locations can authenticate and verify each transaction before it is processed, thereby adding an additional layer of security to the standard payment approval process. These benefits have been particularly important for organization in the real estate industry, as the parties in a transaction are often distributed across multiple regions and there are commonly numerous stakeholders involved in each payment. An overview of how EDS has impacted real estate can be found in our recent whitepaper, attached here 

About TIS

TIS is reimagining the world of enterprise payments through a cloud-based platform uniquely designed to help global organizations optimize outbound payments. Corporations, banks and business vendors leverage TIS to transform how they connect global accounts, collaborate on payment processes, execute outbound payments, analyze cash flow and compliance data, and improve critical outbound payment functions. The TIS corporate payments technology platform helps businesses improve operational efficiency, lower risk, manage liquidity, gain strategic advantage – and ultimately achieve enterprise payment optimization.

Visit tis.biz to reimagine your approach to payments.

 

GTreasury Announces 2021 Cash Forecasting & Visibility Survey Report, Which Covers Key Trends in Corporate Treasury

03-11-2021 | treasuryXL | GTreasury |

The new report provides in-depth insight into cash reporting, cash forecasting, and technology practices and expectations across hundreds of treasury teams

CHICAGO, Ill. – November 3, 2021 – GTreasury, a treasury and risk management platform provider, and Strategic Treasurer, which delivers consulting services for treasury management, security, technology, and compliance, today announced the release of the 2021 Cash Forecasting & Visibility Survey Report.

The survey of nearly 250 treasury professionals from across industries and continents sheds light on the current state of corporate treasury’s cash reporting practices, cash forecasting methods, technology strategies, and expectations around technology spend.

Highlights from the 2021 Cash Forecasting & Visibility Survey Report include:

  • Treasurers want real-time global cash position updating. The majority of treasurers are seeking global cash positions that can update on a real-time or intraday basis, but many report being stuck with weekly (or less frequent) updates. Just seven percent of survey respondents are currently achieving real-time cash position updates.
  • Generating cash positions is three times harder without a TMS. Only 10% of treasurers using a treasury management system report difficulty generating their cash position, compared to 33% of those who use other methods.
  • The use of AI and ML in cash forecasting is nascent but accelerating. While just 6% of respondents are currently using AI/ML for forecasting, the report indicates that number should swell to 27% of organizations within the next two years.
  • More budget is being allotted for treasury and forecasting technology. Over the next year, more than 35% of companies plan “extremely heavy spending” on treasury systems and forecasting.
  • Generating cash forecasts is difficult for half of all treasurers. Just 23% of treasurers report that building cash forecasts is a simple process within their organization, compared to the 48% of respondents indicating difficulty with this task.
  • Excel forecasters are more dissatisfied than their TMS/ERP-using peers. Compared to treasurers relying on TMS/ERP technologies, treasurers using Excel spreadsheets for forecasts are more than three times as likely to be dissatisfied with their forecasting output: 23% of those relying on Excel report discontent, compared to 8% leveraging TMS/ERP solutions.

“The findings in this year’s Cash Forecasting & Visibility Survey Report provide a clear view into what matters to corporate treasury right now, and the areas that are particularly ripe for modernization,” said Craig Jeffery, Managing Partner at Strategic Treasurer. “AI and ML is arguably the biggest sea change coming to treasury teams, and it will move quickly. Treasury teams are realizing the challenges of building AI/ML-infused capabilities internally, and are instead adopting AI/ML forecasting capabilities within their existing systems. The rapid anticipated adoption here will empower corporate treasurers with transformative new practices and approaches, from treasury management to FX to payments.”


“The treasury ecosystem is constantly evolving, and this survey illuminates not just how treasury operates today, but how treasurers want – and expect – it to tomorrow,” said Michele Marvin, VP, GTreasury. “From CFOs to treasury and accounting teams, the results of this report are revelatory when it comes to navigating the current treasury technology landscape, adopting best practices, and capitalizing on the most advantageous opportunities going forward.”

Those interested in further results and analysis from the 2021 Cash Forecasting & Visibility Survey Report can view a recorded webinar, hosted by GTreasury and Strategic Treasurer, analyzing the results of this report: https://resources.gtreasury.com/Cash-Forecasting-Report-On-Demand-Webinar-Request.html

The downloadable report is available at: https://resources.gtreasury.com/Cash-Forecasting-Visibility-Report-Request.html

About GTreasury

GTreasury is committed to connecting treasury and digital finance operations by providing a world-class SaaS treasury and risk management system and integrated ecosystem where cash, debt, investments and exposures are seamlessly managed within the office of the CFO. GTreasury delivers intelligent insights, while connecting financial value chains and extending workflows to third-party systems, exchanges, portals and services. Headquartered in Chicago, with locations serving EMEA (London) and APAC (Sydney and Manila), GTreasury’s global community includes more than 800 customers and 30+ industries reaching 160+ countries worldwide.

About Strategic Treasurer

Strategic Treasurer provides consulting services for treasury management, security, technology and compliance. Corporate clients, banks and fintech providers throughout the world rely on their advisory services and industry-leading research. Strategic Treasurer is headquartered in Atlanta, with consultants based out of Atlanta, Cleveland, Detroit and Washington D.C. To learn more, visit strategictreasurer.com.


 

 

Refinitiv case study | How Haier Group uses a one-stop FX Management solution to mitigate currency volatility

1-11-2021 | treasuryXL | Refinitiv | LinkedIn

Haier Group Corporation is a Chinese multinational consumer electronics and home appliances company, designing, manufacturing and selling a full range of smart appliances, whilst also focusing on channel integrated services. Read more about how Haier Group treasury has succeeded in establishing an intelligent risk management model, covering their whole workflow by connecting with their internal accounting and funds settlement system and externally linking financial data resources (such as Refinitiv) and more than ten global banks.

Haier Group Corporation is a Chinese collective multinational consumer electronics and home appliances company headquartered in Qingdao, China. The FX risk management function under Haier Group’s treasury now controls 22 countries and areas and 20 currency pairs. Their centralised management is difficult due to the wide range of regions and currencies, while the traditional analysis and management from manual booking does not keep up with the current business development demand. Haier Group treasury has succeeded in establishing an intelligent risk management model, covering the whole process by connecting with the internal accounting system and funds settlement system and externally linking the financial data resources (such as Refinitiv) and more than ten global banks.

 

 

 

How Can Treasurers Gain from an Intercompany Netting Strategy?

18-10-2021 | treasuryXL | Gtreasury |

As a treasury tactic proven to deliver significant workflow efficiency and clear cost savings, intercompany netting is implemented far less common than its benefits merit. With a netting process, payables and receivables between multiple entities are no longer handled one at a time, but all at once. Furthermore, with intercompany netting, all the transactions between the subsidiaries are replaced with singular transfers between a Netting Center and each subsidiary, in the home currency of the subsidiary. For what kind of businesses is intercompany netting beneficial, and what are the key pain points that are leading organizations to consider intercompany netting strategies?

Read the full Article


About GTreasury

For more than 30 years, GTreasury has delivered the leading digital Treasury and Risk Management System (TRMS) to corporate treasurers across industries. With its continually innovating Software-as-a-Service platform, GTreasury provides customers with a single source of truth for all their cash, payments, and risk activities. The TRMS solution offers any combination of Cash Management, Payments, Financial Instruments, Risk Management, Accounting, Banking, and Hedge Accounting – seamlessly integrated, on-demand worldwide and fully secured. Headquartered in Chicago with offices serving EMEA (London) and APAC (Sydney and Manila), GTreasury’s global community includes more than 800 customers and 30+ industries reaching 160+ countries worldwide.

 

 

A 360 Degree View On Security

| 13-10-2021 | treasuryXL | Nomentia |

One would think data protection and security measures are baked into our identity as digital people, especially in a year where we are working remote more than ever. But is it though? The breaches show that security is too often seen as something to kind of ‘wing it’. And there is an eternal question whether the best way to a secure IT environment is to educate the employees to make the right decisions or to put measures into place.

We personally believe that security and combatting Fraud is a combination of people, processes, and tools. Security literacy is a skill everyone should have and constantly develop, and companies can further support this by making use of tools such as multi-factor authentication to mitigate risks and implementing processes to keep their corporate environments safe. We think security deserves a 360 degrees view in an organization that is implemented throughout their solution landscape.

Login & User access control

This is a simple thing organisations can implement either with Single-Sign-On and/or multi-factor authentication. Multi-factor authentication (MFA) is a method of authentication that requires the use of more than one verification method and adds a critical second layer of security to user logins. A user is only granted access after successfully passing all authentication phases. The different factors are based off of different things as opposed to a simple password which bears some vulnerability. The first authentication phase is based on knowledge. A person needs to know their username and password, and this can also be initiated through single sign on with corporate credentials for a further security increase. The second authentication phase is based on possession. A person must possess and have access to a mobile phone to for example receive a code per text message or a phone call to double authenticate the log-in.

In practice this means, even if a username and password get compromised, cyber criminals will still not be able to login to the account protected with multi-factor authentication. And neither does a stolen mobile phone as both phases are required for a successful login.

One of the potential downsides to multi-factor authentication is that it adds one extra step in the process. And I can admit myself, every time I am going through the process of logging into our internal tools, we are sometimes a bit impatient while waiting for the text message. But it’s a small trade-off for security. Especially since single-sign on also adds convenience.

Single sign on means that people can log into systems with their corporate credentials and just speed up the process on that end. It’s fast and adds an additional security layer which is extremely powerful if paired with MFA.

Integrations

This is a crucial part in terms of security. We believe that monolithic enterprise platforms are dead and best-of-breed solutions that are highly integrated are the future. This best-of breed approach however also ads emphasis on the need to ensure the integrations are safe. Which data is travelling via which channels from where to where? How is the data in transit being secured from theft and man-in-the-middle attacks?

The first step is to map out all needed integrations and systems and create a use case scenario and based on this define the needed setup. For instance, in the context of cash management you might for instance end up protecting payment information with a higher security standards than a simple accounts payable extract that is used to cash forecasting only. The key is to have a companywide and regularly maintained risk analysis process that recognizes risky areas, measures the levels of set controls (preferably audited by external experts) and constantly comes up with better and better controls.

User access control

Understanding and carefully designing which user has access to which data and processes is not bullying your employees but is a crucial step in setting processes in place that further support security. In our case, our customers need to answer questions such as: which user can approve payments, who can add a new account number to the system, who can manipulate user rights, who can make a manual payment, or who can view balance information from banks and the likes.

Infrastructure and Platforms

Making sure that you run your IT infrastructure and solutions on secure platforms is a crucial control point. One would think that in this day and age that shouldn’t be a question anymore, yet we would recommend checking this anyway. How is the user access to databases and servers or other backend artifacts controlled? Are your administrators using multi-factor authentication? Have you segregated the so-called privileged access and user accounts? Do you keep a list of such accounts? Do you collect logs from your systems and store them securely?

Many industry standards come handy here. For us relevant standards are for instance ISO 27001 and ISAE 3402 auditing framework. In our domain particularly relevant is SWIFT Customer Security Program (CSP) which is a security framework developed and derived for financial industry from such international standards such as NIST and PCI DSS. All these standards should not be considered just as acronyms but a toolbox that can help you to build a company culture that takes security seriously in every step and by every employee in every role.

Security comes from within

Above are the steps that each organization can take to ensure that their set-up is secure. Let’s face it, there is no such thing as absolute security. But by establishing a strong security culture in your organization we believe you can make it really hard for criminals to gain access to our systems.

If you want to reach have an assessment of your security measures in terms of people, processes and tools for your cash management, please get in touch with us and we will assess your set-up and provide you options how you can further tighten your security. Cash is king, but hopefully a well-protected king.

CONTACT US 

 

 

 

 

WEBINAR ALERT | How to achieve cash forecasting excellence – challenges and strategies

treasuryXL | Nomentia |

 

Date & time: October 20, 2021 at 3.00 pm CET | Duration 45 minutes

Cash forecasting remains one of the most challenging topics in treasury management. With the knowledge and years of experience of our experts within TreasuryXL and Nomentia, we will discuss cash forecasting in more depth. We’ll tackle the challenges that are paired with cash forecasting, and strategies to overcome challenges to achieve cash forecasting excellence.

Join the webinar to learn more about: 

  • Brief introduction to TreasuryXL and Nomentia
  • Short introduction to cash forecasting
  • Why many companies have sub-optimal cash forecasting
  • The challenges with cash forecasting
  • Managing the cash forecasting process
  • Steps to create cash forecast excellence

Click on the banner for registration.

Meet the speakers

Francois de Witte (1)

François de Witte

Seasoned Treasury Expert
TreasuryXL

Huub Wevers

Huub Wevers

Senior Sales Manager
Nomentia

Jouni Kirjola

Jouni Kirjola

Head of Solutions and Presales
Nomentia


 

 

Partner Interview | CEO Nicolas Christiaen about how and why they built Cashforce NextGen, the ‘next generation’

05-10-2021 | treasuryXL | Cashforce

 

Why did Cashforce create the ‘NextGen’? What’s the vision behind this great concept? We have asked CEO Nicolas Christiaen 10 questions regarding the creation of the NextGen platform.

Find out why Cashforce created NextGen, what makes it unique and what solution the platform offers to treasurers.

Introduction Nicolas

Nicolas Christiaen is the CEO and Co-founder of Cashforce, an industry leading cash forecasting and working capital insights system. Nicolas has an extensive background in finance analytics, cash management and cash forecasting. He has led the effort to bring Cashforce to multi-national firms in distribution/retail, manufacturing and logistics/services industries. Nicolas uses his experience to drive both product development and thought leadership within Cashforce, resulting in a user base that benefits, not only from the system, but also the best practices that helped design it. Prior to Cashforce Nicolas worked as a management consultant at PwC and was a serial entrepreneur, founding two other software companies. He is frequently a guest speaker in the FinTech community and you will often find him on panels at international treasury conferences.

 

Introduction NextGen

Cashforce is a “next generation” cash forecasting and working capital analytics solution focused on automation and integration. By using Cashforce’s cloud-based Software-as-a-Service (SaaS) platform, corporates can unlock the potential for their data to help make smarter decisions, saving time and money in the process. Cashforce can consume a large variety of data, process that data using machine learning and get insights into cash flows and working capital. Cashforce NextGen eliminates the manual and cumbersome treasury tasks around cash forecasting, enabling its users to take advantage of AI-powered scenarios and a strong workflow for distributed treasury teams. The Cashforce system serves mid-to-large-sized corporates and is currently being used at over 70 companies and as many countries.

INTERVIEW

1. Can you remember your “A-ha!” moment that made you realize Cashforce NextGen needed to be built?

Yes, I can remember it well. We were working on a proof-of-concept exercise with a huge dataset, imagining ways to manage this large amount of complex data. We have always tried to challenge ourselves to look for ways to do things better. Our technical team of UX and system performance specialists began laying out the case to use the latest technology to provide, not only the functionality, but also the scalability and performance we would need to meet projected commitments and fulfill the product vision. The team did a fantastic job and really showed me the “art of the possible”. That did it for me and we immediately switched gears to figure out how we could make this happen.

2. What critical issue does the Cashforce NextGen immediately resolve for the treasurer?

Right now, treasurers struggle to provide their stakeholders with accurate forecasts. This is due to the difficulty of consolidating data into one place, and dealing with complexities like intercompany payments, various payment behaviors and overdues. Treasury practitioners want to be able to drill into the data and to use the output to make important decisions from “how much excess cash do I have to invest for the short term?” to “how much cash will we have in three months when our planned acquisition closes”? It is hard to do that when your forecast is sub-par. Cashforce helps you pull data from every location where it resides so you can start with a complete picture. Then we layer our analytics on top of that, so that you have a clear picture of what is coming in and going out. The result is that the forecasted cash positions become meaningful enough that you can incorporate them into strategic plans.

3. How does the new platform differentiate from the other players in the market?

Cashforce began its journey from a working capital analysis point-of-view and we built our cash forecasting capabilities on top of that by linking to ERP systems. This had the effect of enriching the quality of the forecasts that we could generate and made them more useful. The ERP connectors themselves are a large differentiator: they ensure a seamless flow of granular, system-based data. This creates a fully transparent view into cash. On top of that, Cashforce applies smart forecasting logic (including AI-based algorithms, P&L-to-Cash logic, payment behavior analysis…) to build highly accurate and automated forecasts for the short, mid & long term. An intelligent simulation engine allows the Treasury department to evaluate different scenarios, analyze their impact and calculate the forecast/actuals variance.

4. Can each ERP system work with the Cashforce NextGen also when you work with multiple ERP’s located in different countries?

Yes, we have many clients that use Cashforce to pull in data from multiple ERP’s. Sometimes it is different instances of the same ERP, and sometimes it is a different ERP altogether. Either way, we configure Cashforce to pull in the needed data automatically, so that the end-users can start using the system with the data already loaded.

5. What is the biggest challenge you experienced while creating this new platform?

When you are trying to build a really remarkable product, there is always a tension between the ideal vision, the dream state, and what development can realistically deliver to meet market and client expectations and keep our overall momentum. On top of that, the pandemic struck while we were in the middle of our efforts, and this put an enormous strain on our timelines, productivity and ability to collaborate in real-time in the way you need to make something special. Doing that through web meetings can slow things down quite a bit, but luckily we already had a solid plan, an established process and an effective line of communication. This enabled us to keep going and now that we are moving back to normal, we are positioned to get out there and show what NextGen can do.

6. What is, in your perception, the biggest benefit of working with Cashforce NextGen?

As we brought Cashforce NextGen to market, we found that several benefits jumped out to our clients: Time-savings, Money-savings and the ability to use knowledge of your current and future cash positions to elevate forecasting to a strategic level. Many of our clients need to actively manage cash to invest or borrow properly, as needed and to make acquisitions. But they are using old tools and forecasting modules that simply didn’t give them what they needed. With NextGen, we have the highest degree of automation, the best workflow, the latest AI and machine learning models to improve forecasting and it all sits in a great user interface that is so easy to use. Sorry to not say one benefit, but the truth is the benefits are many.

7. What is the overall feeling of your customers about NextGen?

Our customers are very excited about the new product, just as we are. Prior to development, we made sure to meet with our clients, share the vision and gather their feedback, especially pain points. It was a great feeling when we went back to them to show our first demonstration of NextGen, you could feel the excitement in the air.

8. Can you give us an outlook on the product developments and tell us a bit more about your vision?

Cashforce’s vision has always been to save time and money for finance and treasury departments. Over the years, we have accumulated expertise around different approaches to short- mid-and long-term forecasting, connectivity with different ERP’s and TMS’s, designing sustainable workflows and integrating technologies such as artificial intelligence and machine learning. We want to leverage this knowledge alongside future-facing technologies, such as APIs, to create a new platform that is state-of-the-art and capable of consuming billions of transactions in real-time. However, we don’t plan to stop at consolidation and analysis of the data. We are working with our clients to build out the system to take the “next action”in their treasury processes. By linking with trade execution platforms and Treasury Management Systems (TMS), Cashforce will be a decision-making engine that drives our customers’ workflows.

9. The world is always changing, how does Cashforce stay one step ahead of its competitors?

The treasury world is always changing and will always be changing. It’s up to us to change with it and keep up with shifting consumer needs. Companies that focus on the past tend to stay in the past. So you must know what technology is out there, what is possible, what is available, what works and what doesn’t. For example, AI and machine learning will become ubiquitous and woven into the fabric of finance and treasury. That is why we want to lead the charge to use new methods and new technology. The better informed our clients are, the better prepared they will be to handle these changes as they happen.

10. Looking back on your Cashforce career, what is ‘the thing’ you are most proud of?

I have had the opportunity to work with some very talented people at Cashforce. I am most proud of our ability to create an environment that empowers our people to be as successful as they can. To see these talented people bring Cashforce NextGen to life has been an amazing experience.

 

 

 

Refinitiv case study | How Mercuria manages risk across assets with a single platform

04-10-2021 | treasuryXL | Refinitiv |

Mercuria is a global energy and commodity group, operating in more than 50 countries with over 1,000 employees and offices worldwide. Read more about why Refinitiv Eikon was selected to fulfill the complex cross-asset requirements from pre-trade, trade, through to post-trade and credit screening.

Mercuria’s business lines cover a diverse range of commodities trading as well as large-scale infrastructure assets. For that reason, they searched for a cross-asset platform to manage credit, pre-trade, trade and post-trade  to quickly, efficiently and accurately access global market insights, trusted market data and ‘best-of-breed’ industry analytics to help price-up derivative products.

Refinitiv Eikon platform was selected to fulfil the complex cross asset requirements from pre-trade, trade, through to post-trade and credit screening.

 

 

Why You Should Say Goodbye To Spreadsheets

| 29-09-2021 | treasuryXL | Nomentia |

A recent Cash management survey that we did showed that 43 percent of respondents continue to experience issues with their Cash flow forecasting. Unsurprisingly, more than half of the market still use spreadsheets to execute this business-critical function. The million-dollar question is, why?

According to the European Spreadsheet Risks Interest Group, the reliability of a spreadsheet is essentially the accuracy of the data that it produces and is compromised by the errors found in approximately 94% of spreadsheets.

If accurate cash flow forecasting remains one of the key priorities for treasury and finance professionals alike and the market has easy access to affordable, cutting edge forecasting applications, why do we continue to rely on outdated, ineffective forecasting tools?

Common myths prevail that spreadsheets save money, are easy to use & flexible. In the spreadsheet’s defence, it’s a nifty tool, that ticks many of the aforementioned boxes and can work very well with cash forecasting solutions. But, for a growing business looking to mitigate risk and plan for the future, risks run high if you’re relying on a system that’s almost surely flawed, demands hours of manual input effort, prone to human error, exists largely undocumented and which no one really knows how it works.

“After the clever intern, who developed the nifty macros and formulas is no longer around……nobody knows how the application generates the numbers.”

Penny wise, pound foolish 

Spreadsheeting is, by and large, the manual process of gathering, inputting and administrating data. Typically, spreadsheets have been built up and added to over a period of years, becoming cumbersome to manage and share. In an eye-watering number of cases, the person originally responsible for constructing the spreadsheet has long since left the department. No one knows the algorithm behind the macros and no one assumes responsibility for its maintenance, let alone documenting changes and adaptations. The whispered precedent remains, “if it’s not broken, then leave it alone”……… Ouch!

Alternatives are perceived to be more expensive. Excel, for example, is cheap to acquire whilst Treasury Management Systems are expensive with lots of added features that SME’s in particular, don’t require.

Busting the myths

Cost is no longer a plausible reason to rely on spreadsheets for cash flow forecasting. Cloud-based solutions such as Nomentia Cash Forecasting, offer competitive pricing. Modular, on-demand, SaaS solutions have revolutionised application choice. Simply choose the modules you need, pay by the month and no IT involvement required. Free up more departmental time by reducing the number of resource hours required to maintain a spreadsheeting process and the cost-saving just got bigger.

Spreadsheet errors and inaccuracy are by far the most compelling reasons to consider a move to a specialist cash forecasting application. Finance and treasury cannot afford to make mistakes. Inaccurate cash flow forecasts can literally lay to ruin to a company’s business reputation and/or result in a financial loss or penalty. No scare tactics needed.

Mini Case-Study: Conviviality a ‘Spreadsheeting Horror Story’

(Source: The Guardian UK, 21 March 2018)

At first, the drinks retailer Conviviality said profits would be 20% lower than the £70m expected by the City, with £5.2m of the £14m hole that had opened up in its forecast, down to a spreadsheet error. The remainder was a reflection of weakening profit margins.

On 21 March 2018, the Guardian (UK) reported “Firm issues third profits warning; says it will meet investors to raise funds via a share placing’’. The company, in a stock exchange announcement, said it was holding meetings with investors to raise £125m via a share placing that would help it pay a £30m tax bill due at the end of the month, fund overdue payments to creditors and repay a £30m loan.

The company blamed the first shock profit warning on a spreadsheet arithmetic error made by a member of its finance team and weakening profit margins, and then admitted it had not budgeted for the £30m tax bill due this month.”

Conviviality has since gone into administration

Whether or not the use of spreadsheets was the sole cause of this bankruptcy is not clear, but it seems to have been a major contributor. Such cases are exceptional, but they do illustrate how relying on spreadsheets is not a sensible course of action for any finance & treasury team anywhere.

Many spreadsheets also contain, quite clever but complex, macros and apart from keeping these up to date, finance & treasury is responsible for ensuring their integrity. This is something that is not always feasible. Even when errors are spotted it is often very difficult to decode them, especially given the sheer size of the spreadsheets many finance and treasury folk utilise.

Embracing future-proof change

Readily available and affordable cash forecasting applications have, for those organisations who have embraced the benefits of technology, reduced risk exposure exponentially, facilitated real-time & accurate cash visibility, minimised human resource demand, and liberated finance leaders to take a more strategic role across the business. No-brainer.

Sometimes taking a leap of faith, moving away from the old and onto the new, can be a daunting decision. Historical hang-ups, ranging from less than favourable experiences with legacy systems, pre-conceived assumptions around cost implications, and work-flow disruption make it all too easy to decide to ‘leave well enough alone’. Before you take the decision to stick with the spreadsheet that’s done what it apparently ‘says on the tin’ for many years – let’s consider the following:

Back to the future

In a world where cyber security is of the utmost concern and data privacy, e.g., GDPR, is a regulatory requirement, can finance and treasury really afford to run their operations on spreadsheets? Spreadsheet security cannot and does not compare to the advantages of specialist systems that have been built with security in mind. Indeed, some spreadsheet applications lack even basic authentication security, can be easily copied and distributed outside the confines of the business without the knowledge or prior agreement of management.

Spreadsheets were built for convenience-only in a pre-internet world where cyber-attacks and data security were unknown and of no consideration. Spreadsheets were not built with security in mind.

Square peg in a round hole

Spreadsheets don’t grow with your treasury and finance needs. Organisations often try to adapt their spreadsheets to a growing business but soon realise that the complexity of doing so is almost impossible. Adding new accounts and deleting old accounts becomes challenging at the best of times, but managing this critical process in a spreadsheet, whilst trying to drive the business forward, is often a step too far, leading to errors and oversights.

Treasury and finance, by its very nature, consists of a number of different individuals performing a variety of activities, sometimes at the same time. This results in the sharing of valuable company information between several people and departments in any one day. Managing this process on spreadsheets can be difficult and nigh on impossible, even if some automation is achieved. Typically, only one person can update a spreadsheet at any one time so the workload that needs to be shared becomes inefficient and confusing. Maintaining full transparency around additions, edits, and alterations are off the table. Once an edit, or error, is made on the spreadsheet, it remains invisible and untraceable until something goes wrong. In addition, identifying the point of error-impact is often a time-consuming, futile, and frustrating exercise for some unfortunate departmental executive, even if they have the necessary investigative skills.

Doomed to repeat the same mistakes

Spreadsheets are not that good at quantifying or qualifying historical data, and treasury & finance needs this data regularly. That is not to say data cannot be stored in earlier spreadsheet versions, but due to the way they work, it is not a simple task to access, view, assess, and report this data as efficiently and effectively as modern cash management applications. Losing valuable historical data for comparison and variance purposes is a high-risk consideration. Accidentally saving over historic files, or indeed losing files altogether, is a terrifying experience we’ve probably all experienced at some stage in our careers. Notifying management of a spreadsheet faux pas is just as bone-chilling, remaining undisclosed and causing further inaccuracy to forecast outputs.

As alluded to in an earlier blog ‘Five expensive myths in Cash Forecasting’, there is a very real chance that the person who created the original spreadsheet has moved on and left the company. How many finance and treasury departments have found themselves in a position where a mega spreadsheet, long lauded as a ‘work of art,’ is no longer sufficiently supported and documented with non-existent instructions on how to maintain or update the worksheet.

Cassette recorders, big hair, leg warmers, the Rubik’s cube, Walkman, and mobile phones the size of small suitcases are all legacies from the 1980’s. Technology and hairstyles have moved on….. so should cash forecasting applications.

 

 

 

Use gamification techniques in the checkout process

27-09-2021 | treasuryXL | EcomStream | Ramon Helwegen |

Gamification aims to increase engagement and create more loyalty through positive user experiences. Loyalty drives returning customers. It’s a loyalty risk if your checkout process is hard to complete.

The least exciting part of the online customer journey must be the checkout process, for sure. However, in a relatively simple way you can gain a lot here, limit abandoned shopping carts and drive loyalty of your visitor.

Imagine: Your customer has already chosen the product and has already agreed on the price. Isn’t it important to secure that conversion as quickly and as simply as possible?

What is the problem of a boring checkout process with all kinds of input fields? It is just not fun to do. Combine the pleasant with the useful. A gamified process is simply more pleasant to complete. With subtle adjustments, you can already achieve a lot and fortunately you do not have to reinvent the wheel yourself.

With a gamified checkout you set a goal, offer control, reward good behavior and deliver speed. By adding a gamified twist to the checkout process, you improve the necessary focus from your customer and limit the chance that he or she will be distracted and never finish the transaction again.

The checkout process is task-oriented and a number of things can be improved during this process. In the visual below you can see a number of thoughts and considerations that take place during the checkout process in the hearts and minds of your customers. By gamifying certain tasks you quite easily make checking out more pleasant. This also makes the overall customer experience just better as you remove friction.

A shopper who leaves the site even after the checkout has started? Make sure to avoid such a costly event.

A gamified checkout works. Just try it.

 

About EcomStream

EcomStream is an independent consultancy and is specialized in optimization of online, omnichannel and marketplace payment solutions, and optimization of checkout flows.

The goal is to achieve much lower costs for you while creating a much better customer experience for your customers.

Thanks to its lean organisational model, EcomStream will help you to reduce the cost of ownership of your payment solution and to improve your ROI, fast.

 

Interested to know more about what gamification can mean for your business? I am ready to help!

 

 

 

Ramon Helwegen

 

 

 

 

About EcomStream

EcomStream is an independent consultancy and is specialized in optimization of online, omnichannel and marketplace payment solutions, and optimization of checkout flows.

The goal is to achieve much lower costs for you while creating a much better customer experience for your customers.

Thanks to its lean organisational model, EcomStream will help you to reduce the cost of ownership of your payment solution and to improve your ROI, fast.