An SAP cockpit for seamless transfer pricing compliance
September 2020
2 min read
Author:
Casimir Leuridan
Share:
Entering an interest rate for an intercompany loan in SAP is simple, but determining the interest rate according to the latest transfer pricing regulation is not as easy.
Therefore, we decided to leverage our cloud-based solution and enable SAP users to determine the arm’s length interest rate with just a few clicks.
The pricing of various treasury transactions, as for all intercompany flows, is subject to transfer pricing regulation. In essence, treasury and tax professionals need to ensure that the pricing is in line with market conditions, i.e. the arm’s length principle. To this end, numerous Zanders clients use the Zanders Inside Transfer Pricing Solution (TPS). Our TPS enables them to set interest rates on intercompany transactions in a compliant and automated way. Since its go-live almost three years ago, clients have priced over 1000 intercompany loans with this self-service solution.
Our TPS has been a stand-alone tool on the Zanders Inside platform, but that is about to change. We have selected SAP as the first treasury management system for online integration. The interface uses APIs between the two systems to pull and push the relevant information. This article will elaborate on how the process flow is designed from an end user perspective.
Automated credit rating assessment
Initially, the necessary static data on the borrowing entities needs to be saved on the Zanders Inside platform. This data is used to determine an entity-specific credit rating, a requirement for a compliant transfer pricing assessment. This can be done via the Zanders Inside template, which gives the user a standard framework to capture the financial statements for all entities. Additionally, the user also saves qualitative rating information. Based on this information, the automated credit rating assessment is run in the background. The borrower credit rating will be used as input to the pricing assessment. This first step is the only manual process in the entire end-to-end flow. In addition, adjustments to the static data only need to occur once per year, i.e. when the new financial statements are published.
Overview
Once the static data is set up, the user enters an intercompany loan in the usual way. In the interest condition, the SAP user will indicate that the interest rate will be determined using the Zanders TPS platform. Using the SAP standard functionality, the user can define if the interest rate has to be updated via the Zanders TPS platform regularly or only initially at deal creation. Once the deal is created, the Zanders TPS cockpit offers an overview of all intercompany loans with outstanding pricing status. From this environment, the user can select the individual deals and raise a pricing request to the Zanders TPS platform. This pricing request will include identification of the lender and borrower, which impacts the rating, and the relevant terms and conditions of the loan, which impact the arm’s length interest rate.
Transferred values
Aside from the rating, the main drivers are the maturity of the loan, the structure of the facility (level of collateral), the currency and the repayment schedule. These values will be transferred into the Zanders Inside TPS. It enables the solution to operate as a calculation engine, i.e. making the necessary calculations in the background.
In the Zanders TPS cockpit, the user is offered the possibility to review the received interest rate and its constituting components. Given the background of the transaction, the user is free to decide which components will be included in the final rate. Additionally, a manual rate adjustment can be added as a separate component, together with an explanatory comment. The manual rate adjustment and its justification is transferred back to the Zanders TPS platform and will be included in the final pricing documentation.
Fully-fledged report
Finally, the output of the transfer pricing solution is twofold. In addition to pulling the interest rate components into SAP, it will automatically create a fully-fledged transfer pricing report. This report will automatically be saved in the solution and includes a reference towards the transaction identifier in SAP. The report contains the methodology as well as all specifics of the calculation and can be used as a reference document later on. This can be used should a tax audit occur, for example.
Determining the interest rate and entering it into the appropriate deal in a TMS system is often a manual and cumbersome process involving different departments. By connecting the Zanders Inside TPS to SAP, the level of straight-through processing (STP) within a treasury department can significantly improve. Additionally, it offers a less error-prone alternative as it removes manual data entry and calculations.
Free Demo
Would you like to learn more on this new initiative or receive a free demo of our solution? Do not hesitate to reach out!
The heightened fluctuations observed in the commodity and energy markets from 2021 to 2022 have brought Treasury's role in managing these risks into sharper focus. While commodity prices
VaR has been one of the most widely used risk measures in banks for decades. However, due to the non-additive nature of VaR, explaining the causes of changes to VaR has always been
The Covid-19 pandemic triggered unprecedented market volatility, causing widespread failures in banks' internal risk models. These backtesting failures threatened to increase capital
Challenges with backtesting Expected Shortfall
Recent regulations are increasingly moving toward the use of Expected Shortfall (ES) as a measure to capture risk. Although ES fixes many
Across the whole of Europe, banks apply different techniques to model their IFRS9 Expected Credit Losses on a best estimate basis. The diverse spectrum of modelling techniques raises the
As organizations continue to adapt to the rapidly changing business landscape, one of the most pivotal shifts is the migration of enterprise resource planning (ERP) systems to the cloud.
While many business and SAP users are familiar with its core functionalities, such as limit management applying different limit types and the core functionality of attributable amount
In brief:
Prevailing uncertainty in geopolitical, economic and regulatory environments demands a more dynamic approach to default modelling.
Traditional methods such as logistic
The recent periods of commodity price volatility have brought commodity risk management to the spotlight in numerous companies, where commodities constitute a substantial component of the
In brief
Prepayment modelling can help institutions successfully prepare for and navigate a rise in prepayments due to changes in the financial landscape.
Two important prepayment
The corporate landscape is continuously reshaped by strategic realignments such as mergers, divestments, and other M&A activities, wherein a company divests a portion of its business
The evolving economic landscape has placed a spotlight on the critical role of treasury in value creation. Our latest roundtable, themed ‘Treasury’s Role in Value Creation,’ delved
This article highlights key points mentioned in our whitepaper: Treasury 4.x - The age of productivity, performance and steering. You can download the full whitepaper here.
Summary:
Whether a corporate operates through a decentralized model, shared service center or even global business services model, identifying which invoices a customer has paid and in some cases,
The final article from Zanders on the DRM model presents the lifecycle of the DRM model over a single hedge accounting period and the prospective and retrospective assessments that are
The corporate treasury agenda continues to focus on cash visibility, liquidity centralization, bank/bank account rationalization, and finally digitization to enable greater operational and
The Basel IV reforms published in 2017 will enter into force on January 1, 2025, with a phase-in period of 5 years. These are probably the most important reforms banks will go through
Dan Delean recently joined Zanders as Managing Director of our newly formed US risk advisory practice. With a treasury career spanning more than 30 years, including 15 years specializing
The productivity and performance of the treasury function within insurance companies have undergone a transformative evolution, driven by the emergence of what is now termed Treasury 4.x.
In the second instalment of the Zanders series on the DRM model, the Risk Management Strategy (“RMS”) and the DRM process are introduced and with it the new concepts that the IASB have