BCR Publishing
We are the leading provider of news, market intelligence, events and training for the global receivables finance industry.
Working with industry leading organisations, experts, governments and universities, BCR Publications delivers expertise in factoring, receivables and supply chain finance to a global audience.
BCR has long been a beacon of innovation and excellence in the realm of receivables finance, playing an instrumental role in shaping the industry’s international landscape. Through its comprehensive conferences, insightful publications, and thought leadership, BCR has facilitated crucial dialogues and connections among industry professionals, driving forward the development of receivables finance globally.
Spreadsheet risk: the silent killer of FX performance
07-09-2021 | treasuryXL | Kantox
Imagine a perfectly designed currency hedging program for a company that seeks to protect its annual budget. Given the specific features of that company —especially its pricing dynamics— such a program would allow the finance team to systematically achieve a hedge rate that would be equal or better than the FX budget rate, avoiding overhedging all the while. The hedging strategy would also consider the firm’s degree of forecast accuracy, as well as the forward discount or premium of the currencies in which it trades.
Now imagine that this optimal FX hedging program was implemented on perfectly designed spreadsheets. Armed with super-efficient spreadsheets, the finance team would project forecasted revenues and expenditures, calculate the firm’s exposure to currency risk and set a time frame for the execution of hedges.
A treasurer’s dream come true? Not so fast.
Any reasonably well-designed currency hedging program goes through a process in three phases: the pre-trade phase, the trade phase and the post-trade phase. Each of these phases, in turn, comprises several intricate steps. And here’s where a wholly unexpected risk would sneak in, with potentially devastating consequences: spreadsheet risk, the silent killer of performance.
Spreadsheet risk is omnipresent
Spreadsheet risk comprises a series of errors stemming mostly from the requirement of data to be manually inputted into each cell. Manual management not only takes up much of the financial team’s resources and time — it makes human error inevitable. The most commonly observed errors and risks comprise:
Despite all the efforts in spreadsheet risk management, the problem is not going away. In fact, more risk is being created as economies grow and businesses become more complex. The truth is that spreadsheets were originally designed for small pockets of data. They were never designed to handle large amounts of data in an interconnected environment.
Experts know well that the world’s most famous business spreadsheet saw the light of day before the World Wide Web and the internet browser — that is, before the explosion of interconnectedness. And interconnectedness lies at the heart of modern FX hedging programs.
Spreadsheets traveling back and forth
The most prosaic element of a FX program is the seemingly innocuous process of sourcing currency rates for multi-currency pricing purposes. Quite apart from the fact that many firms undertake it with irrelevant time-based criteria, the reality is that, once currency rates are sourced —for example, from the European Central Bank’s website— the commercial team receives the information on a spreadsheet.
Next, the FX exposure needs to be collected and processed. Budgeting, as we know, is a process that involves commercial and production teams, purchasing managers, economists, human resources departments and treasury teams. In other words: the cornerstone of the hedging program is the result of dozens, or more likely, hundreds of spreadsheets traveling back and forth across the enterprise. At this point, spreadsheets risk is only in its initial stages.
Depending on the forward discount/premium of the currencies involved, conditional FX orders are set. The information must be provided by the relevant commercial teams/purchasing managers — on a spreadsheet. Then the trade phase kicks in. If manually executed, several processes take place: approval request, first review, second review, final approval. Yet more spreadsheets are transferred in the process.
And what about the FX payments and collections process? And the FX accounting and performance analytics stages? You guessed it: critically important information is subject, once more, to data input errors, copy & paste errors, formula errors and formatting errors. These are the ingredients of a potentially nightmarish scenario. Even for the best-designed currency hedging programs. And even for programs implemented on brilliantly designed spreadsheets.
FX Automation: taming spreadsheet risk
In an increasingly interconnected world with more complex business models, spreadsheet risk can be a silent killer of performance. Business managers face enough risks in the day-to-day management of their operations, and treasurers in particular have enough on their plates to worry about the spreadsheet risk in their FX hedging programs.
It’s high time they work to better manage this risk. Here, Currency Management Automation is your company’s best antidote. These software solutions use Application Programming Interfaces to ensure that data can flow seamlessly between different systems (ERP, TMS) and software without any need for spreadsheets.
The time to act is now.
Strategic Treasurer’s Analyst Report Series: Treasury and Risk Management Systems
06-09-2021 | treasuryXL | Kyriba |
This document contains a comprehensive illustration of the current state of treasury technology and the exciting future direction using new tools that are already with us. This FinTech analyst report from Strategic Treasurer takes a look at the current health of the TMS space and what benefits can come from implementing a treasury management system in your operations. Additionally, this report covers emerging technologies within treasury, such as the use of robotic process automation, artificial intelligence, and more.
Understand the current TMS space and its benefits
The Treasury and Risk Management Systems Analyst Report offers a thorough evaluation of the TMS space by covering the emerging uses of AI/ML (artificial intelligence and machine learning), RPA (robotic process automation), and API (application programming interface) technologies in treasury.
It also discusses:
Download it now!
#6 Not having a Grip on Compliance (Dutch Item)
02-09-2021 | XE |
Regulatory compliance must be an absolute priority for all organisations involved in foreign exchange transactions with foreign customers and suppliers. You must implement robust procedures to generate the information that your foreign exchange providers must legally have in order to carry out transactions on your behalf.
Als u dat niet doet, loopt u het risico dat betalingen niet op tijd worden verwerkt, waardoor uw relatie met leveranciers en klanten onder druk komt te staan of zelfs uw toeleveringsketen verstoord wordt. Ook uw cashflow kan in gevaar komen. Ondanks deze noodzaak is vertraging door regelgeving een veelvoorkomend probleem bij vreemde valuta. Financiële instellingen moeten zich aan strikte regels houden wanneer zij valutatransacties uitvoeren namens hun klanten. Volgens wetgeving om witwassen en andere verdachte praktijken tegen te gaan, moeten zij de identiteit controleren van alle partijen waarmee ze zaken doen, waaronder de buitenlandse partijen waarmee uw bedrijf contact heeft. Vertragingen in het verificatieproces kunnen de uitvoering van uw transactie vertragen.
“Bescherm uw cashflow, uw toeleveringsketen en uw relatie met leveranciers en klanten.”
U moet ook oppassen dat u niet verstrikt raakt in onbekende buitenlandse bankgegevens. Bankgegevens in eigen land zijn gestandaardiseerd, maar internationaal kan dat van land tot land
verschillen en kunt u te maken krijgen met internationale rekeningnummers (IBAN), bankidentificatiecodes (BIC) en andere gegevens.
Uw valutaprovider moet u kunnen helpen deze potentieel verwarrende variaties te verwerken en tegelijkertijd de geldende regels na te leven. Worden er bijvoorbeeld online systemen gebruikt om de invoer van gegevens te automatiseren, waardoor fouten of ontbrekende gegevens snel ontdekt kunnen worden die anders uw betaling zouden kunnen vertragen? Geeft uw provider eenvoudig advies zonder gebruik van jargon over de gegevens die u nodig hebt van buitenlandse partijen en waar u die kunt vinden? Kan uw provider betaalgegevens in zijn systemen bewaren zodat u ze niet bij elke volgende transactie opnieuw hoeft in te voeren?
Als u niet precies weet hoe u ervoor zorgt dat u de regelgeving naleeft, bespreek dat dan met een gespecialiseerde valutaprovider.
Klik hier voor meer Info en Download WhitePaper