Blog
Grip on your EVE SOT
Over the past decades, banks significantly increased their efforts to implement adequate frameworks for managing interest rate risk in the banking book (IRRBB). These efforts typically focus
Find out moreAt Inmarsat, intercompany netting is gross amount based and settled via their SAP In-House bank solution, however, the current setup made intercompany reconciliation difficult and intercompany funding needs less transparent. We offered a solution.
In the current setup, credit/debit balances are building up on multiple intercompany payables/receivables accounts with the same entity, reflecting various business transactions (intercompany invoicing, cash concentration, POBO payments, intercompany settlement). This situation makes intercompany reconciliation more difficult and intercompany funding needs, less transparent.
As part of the Zanders Treasury Technology Support contract, Inmarsat asked Zanders to define and implement a solution, which would reduce the build-up of multiple intercompany receivables/payables from cash concentration, and instead, reflect these movements in the in-house bank accounts of the respective entity.
During the initial set-up of in-house cash (IHC), it was our understanding that all intercompany netting inflows should auto-match with open invoices, if both the Vendor and customer invoices carried the same reference. “Netting” in Inmarsat terms means a settlement of intercompany customer/vendor invoices through IHC.
Unfortunately, a very small percentage of IHC intercompany inflows auto-matched with open customer invoices (14% achieved in May 2020). Sample cases reviewed show that the automatic matching was happening where references on both vendor and customer invoices are same. However, for most cases, even where references were the same, no auto-matching happened.
In phase 1, the intercompany netting issues were addressed. Intercompany netting is an arrangement among subsidiaries in a corporate group where each subsidiary makes payments to, or receives payment from, a clearing house (Netting Centre) for net obligations due from other subsidiaries in the group. This procedure is used to reduce credit/settlement risk. Also known as multilateral netting, netting and multilateral settlement.
FINSTA Bank statements are internal bank statements for internal Inhouse Cash Accounts and these statements post to the GL and subledger of the participating company codes, so that the inhouse cash transactions are reflected in the Balance Sheet.
Any Intercompany transactions posted through the FINSTA bank statements, should be able to correctly identify the open items on the Accounts Receivable (AR) side to post and clear the correct line items.
We found that a payment advice segment present in FINSTA was overriding the clearing information found as per interpretation algorithm ‘021’. As such this was forcing the system to rely on the information in the payment advice notes to find a clearing criterion.
The documents should be cleared based on the information passed to the payment notes table FEBRE.
As a solution, we set the variable DELETE_ADVICE with an ‘X’ value in user exit EXIT_SAPLIEDP_203, so that SAP relied on the interpretation algorithm via a search on the FEBRE table and not the payment advice, for identifying the documents uniquely, and then clearing them. Information from the FEBRE table that includes the document reference, feeds into the interpretation algorithm to uniquely identify the AR open item to clear. This information is passed on to table FEBCL that has the criteria to be used for clearing.
With the above change maintained, SAP will always use the interpretation algorithm maintained in the posting rule for deriving the open items.
Prior to the fix, the highest percentage auto-match for 2020 was 16%. Post fix, we increased the automatch to 85%.
Table 1: interpretation algorithm
Christopher Killick, ERP Functional Consultant at Inmarsat, expressed his gratitude for the solution offered by our Treasury Technology Support services in a testimonial:
“In the autumn of 2019, Inmarsat was preparing for takeover by private equity. At the same time, our specialized treasury resources were stretched. Fortunately, Zanders stepped in to ensure that the myriad of complex changes required were in place on time.
Inmarsat’s relationship with Zanders has continued through a Treasury Technology Support Contract, that is administered with the utmost professionalism and care. In the past six months or so, a large number of changes have been implemented. Most of these have been highly complex, requiring real expertise and this is where the true benefit of having an expert treasury service provider makes all the difference.”
Since the start of the TTS support contract, Zanders has been intimately engaged with Inmarsat to help support and provide expert guidance with usage and continuous improvement of the SAP solution. This is just a small step in optimising the inter-company netting, but a big steps towards automation of the core IHB processes.
If you want to know more about optimising in-house bank structures or inter-company netting then please get in contact with Warren Epstein.
Over the past decades, banks significantly increased their efforts to implement adequate frameworks for managing interest rate risk in the banking book (IRRBB). These efforts typically focus
Find out moreWhile SAC is a planning tool to be considered, it requires further exploration to evaluate its fit with business requirements and how it could unlock opportunities to potentially streamline
Find out moreAfter the collapse of Credit Suisse and the subsequent orchestrated take-over by UBS, there are widespread calls for increasing capital requirements for too-big-too-fail banks to prevent
Find out moreThis article provides a thorough comparison of the Survival Analysis and Migration Matrix approach for modeling losses under the internal ratings-based (IRB) approach and IFRS 9. The optimal
Find out moreThe Zanders purpose Our purpose is to deliver financial performance when it counts, to propel organizations, economies, and the world forward. Recently, we have embarked on a process
Find out moreTo fully leverage the benefits of this technology, it’s essential to understand and address security threats when implementing blockchain solutions. As a decentralized distributed
Find out moreThe start of the migration from the SWIFT FIN format to the new ISO 20022 XML format, which is a banking industry migration that must be completed by November 2025. Whilst at this stage
Find out moreIn today’s world, supply chain disruptions are consequences of operating in an integrated and highly specialized global economy. Along with affecting the credit risk of impacted
Find out moreLarge systemic financial institutions have to show that they are resolvable during times of great stress. In this article, we discuss a specific requirement for resolution planning: the
Find out moreA 19th century book on Indian proverbs1 contains a story about a man who went on a journey with his son: “He came to a stream. As he was uncertain of its depth, he proceeded to sound
Find out moreWith the potential of Blockchain technology to transform businesses, we aim to guide our clients through the complexities of this technology and help them leverage it to improve their
Find out moreLate last year, ChatGPT emerged online as the next phase in this fast-growing and exciting technological space. Many of us tried it out already, and I have yet to meet anyone who is not left
Find out moreThis article may help SAP system owners re-think or change their approach towards bespoke custom solutions in the system. Over the past 14 years, my colleagues and I
Find out moreThe Federal Council in Switzerland wants to make sure that the Swiss financial sector will play a leading role in sustainability. To help accomplish this, it published an action plan in
Find out moreAn increasing number of policy makers and regulators have embedded the recommendations in industry guidance and laws. In this article we summarize the TCFD recommendations, taking into account
Find out moreToday’s interest rates are positive, the yield curve relatively flat and, in some currencies, even (slightly) inverse. The rise in interest rates poses a significant challenge for banks.
Find out moreWith every improvement, fraudsters look for and find new opportunities to exploit. When the opportunity arises, some people see a big incentive or pressure to commit fraud, and most will be
Find out moreMore simply put, the EBA was asked to investigate whether the current prudential framework properly captures environmental and social risks. In response, the EBA published a Discussion Paper
Find out moreThese risks stem from the transition towards a low carbon economy and from the physical risks of damages due to extreme weather events. To address climate-related financial risks within the
Find out moreIn the below overview, we present an overview of the main ESG-related publications from the European Commission (EC), the European Central Bank (ECB), and the European Banking Authority (EBA).
Find out more