Using Excel for Critical Business Processes: Why Transfer Pricing Shouldn’t Be Left to Spreadsheets
Many companies still use Excel for a range of tasks, and, while it is a versatile tool, it definitely shouldn’t be relied on for critical business processes, such as intercompany accounting. Even some of the world’s most prestigious brands manage essential operations through Excel, leading to potential risks and inefficiencies. One notable example is the Williams Formula 1 team, which, despite its cutting-edge image, was found to be using Excel to manage 20,000 car parts.
Don’t let transfer pricing become your weak link by managing it with sub-standard tools. In this article, we’ll look at the potential pitfalls lurking in those Excel sheets — and introduce a much safer alternative.
The Problem with Using Excel for Transfer Pricing
Transfer pricing is a critical process that impacts everything from profitability to tax compliance. As such, it needs to be managed with the utmost accuracy, transparency, and consistency.
Given the complexity and volume of transactions made within multinational entities (MNEs) – often running into millions per month – using Excel to manage transfer pricing introduces several risks.
An Error-Prone Environment
Human error is an inherent risk when using Excel; even the smallest mistake can lead to significant discrepancies, and, when it comes to transfer pricing, these errors can result in substantial financial and compliance risks. To make things worse, estimates state that around 88% of spreadsheets contain errors.
People don’t usually notice spreadsheet errors until the damage is done. In the case of JP Morgan Chase and the famous London Whale incident, for example, the company’s loss of more than $6 billion was a sign to take a look at what could have gone wrong in their spreadsheets. The same applied to Canadian power company, TransAlta, when it lost $24 million. Both incidents were due to copy-and-paste errors.
Typical Spreadsheet Errors
Aside from copy and pasting incorrectly, here are some more common errors that can compromise your operations.
Hidden Cells
Rows and columns can be hidden unintentionally, meaning that the data within those cells is not accounted for, leading to incorrect conclusions.
Missing Zeroes
Some users may not realize that the system will interpret a blank cell not as a zero but as a null value. This can affect the correctness of calculations.
Incorrect Formulas
A mistype in a formula obviously leads to incorrect calculations, and there isn’t always time to go back and check the correctness of every formula in every sheet.
Version Control
Excel’s great strength in being easy to edit becomes a drawback when the document needs to form historical evidence for financial accounting entries. When used for transfer pricing, the raw data and calculations are just as important as the resulting accounting entries. If strong version control and access policies are improperly implemented, there is a danger that the evidence base can be amended by mistake.
Formatting
Formatting improves readability, but only for users. For Excel, it has the opposite effect because it may be unable to properly interpret associations between the data stored in different tabs.
Broken Links
Sheets that take in data from other sources run the risk of containing broken links. Given the vast scale of intercompany accounting and all the disparate sources that data tends to come from, this is a significant risk – one that leads to incomplete conclusions.
Unlike specialized intercompany accounting software, Excel lacks the robust error-checking and validation features needed to ensure data integrity.
Lack of Scalability
Excel is inadequate for handling the huge volumes of data that multinationals deal with daily. When managing millions of financial transactions, the sheer size of Excel files can become unmanageable, leading to performance issues and an increased risk of data corruption. And nobody likes dealing with a file that keeps freezing or crashing, wasting everyone’s time.
Transfer pricing requires the ability to process and analyze large datasets efficiently; something Excel struggles with at scale.
Limited Audit Trail
Transparency and accountability are a must in IC accounting. Excel has limited audit trail capabilities, making it difficult to track changes, verify data accuracy, and ensure compliance. Again, using tabs incorrectly makes this even more challenging.
Inefficiency and Time Consumption
Manual data entry and manipulation in Excel are time-consuming and inefficient activities, especially for processes as complex as transfer pricing. Automating these tasks through specialized software can save significant time and resources, allowing finance teams to focus on more impactful activities.
Security Concerns
Sensitive financial data requires robust security measures. Excel files, especially when shared via email or stored locally, are vulnerable to breaches and unauthorized access.
Case Study: Use of Excel by Formula 1
The case of Williams F1 is a prime example of how even organizations at the cutting-edge can fall into the trap of relying on Excel for critical processes.
As mentioned, the company was discovered to be managing 20,000 racing car parts using Excel spreadsheets. This reliance on Excel led to inefficiencies and potential risks that could have been mitigated with more robust systems.
James Vowles, the new team principal, who went on to replace Excel with a more effective solution was quoted saying that the “colossal” file was impossible to navigate and update, and that vital information on pricing and other details was missing. He said that for tracking hundreds of thousands of components that are moving around within an organization, Excel is “useless.” Essentially, the use of spreadsheets made it impossible for the company to carry out the tasks at hand in any way.
There was also a knock-on effect. Early pre-season testing was missed in 2019, and parts were poorly managed – some arrived late, some were overstocked, and others were difficult to locate.
When you compare the 20,000 items in this case with the millions of IC transactions that some MNEs manage, the margin for error increases significantly.
The Importance of Using Specialized Intercompany Accounting Software for Transfer Pricing
To avoid the pitfalls of Excel, MNEs should invest in specialized software designed to handle the complexities and demands of this critical process. Here’s why.
Eliminates Human Error
Purpose-built solutions enable standardization when managing intercompany transaction processes. As a result, the types of errors you get with Excel are bypassed and nobody can accidentally overwrite anyone else’s input. Everything is automated.
We mentioned earlier that Excel is risky because of disparate data sources used when managing intercompany transactions, which increases the risk of broken links and missing data. This risk is further exacerbated when an MNE runs multiple ERP systems. With Virtual Trader, however, broken links are never an issue because it operates across ERPs, ensuring consolidated financial data.
Enhanced Accuracy and Compliance
Transfer pricing software has built-in features that ensure data accuracy and compliance with international tax regulations. In addition, it provides detailed logs of all actions taken, ensuring a clear audit trail for reporting purposes and for producing accurate financial statements.
Scalability and Performance
Specialized cloud-based software can handle large volumes of data efficiently, providing the scalability needed to process millions of transactions. This ensures your transfer pricing processes remain efficient and reliable, regardless of the scale of your operations and no matter how fast they grow.
Advanced Security Features
Software such as Virtual Trader offers advanced security measures to protect sensitive financial data. Features like encryption, access controls, and secure storage ensure that your information is protected.
Conclusion
Excel is unsuitable for critical processes like transfer pricing. The risks involved far outweigh the convenience it offers. And due to its inefficiency, it wastes a lot of time.
Multinational enterprises, dealing with millions of internal transactions each month, can’t afford to have their processes compromised by the limitations of Excel.
Investing in IC accounting software enables you to manage intercompany transactions with the precision and reliability it demands. Such tools also offer scalability and superior security.
Don’t let transfer pricing be the weak link in your business — contact us today to request a demo of Virtual Trader Intercompany Cloud.
