Most OTP is done on worksheets and that’s fine up to a point

After more than 20 years working mostly in-house in transfer pricing, one recurring theme has become very clear to me: operational transfer pricing is still largely driven by spreadsheets.

At the core of operational transfer pricing is the need to test whether controlled transactions meet the arm’s length standard. In practice, this typically involves building segmented profit and loss statements that isolate the financial results of the relevant tested transactions.

These segmented P&Ls rarely come neatly packaged from a company’s ERP system. While the ERP environment usually contains all the underlying financial information needed, extracting and transforming that data into a transfer pricing-ready format requires significant effort.

In many organizations, this process involves pulling financial data from multiple ERP sources, cleaning and mapping the data, tagging transactions, and combining numerous extracts into a consolidated Excel model. These models ultimately become the foundation for implementing transfer pricing policies and calculating the adjustments required to achieve arm’s length outcomes.

In many cases, these Excel models effectively become the “single source of truth” for operational transfer pricing. They support the implementation of adjustments, feed into transfer pricing documentation, and may ultimately serve as supporting evidence during tax audits.

Given their importance, these files often grow into extremely complex models.

Excel is, of course, a powerful and flexible tool. But it also has its limitations. Operational TP models can span enormous workbooks, sometimes spread across multiple files: working files, cleaned datasets, intermediate calculations, and “final” versions. Depending on who originally built the model, some files are intuitive and easy to follow, while others can be difficult to interpret.

It is also common to encounter models where formulas have been replaced with hard-coded values, making the calculation logic difficult to trace. Reviewing these files can quickly become cumbersome. Many of us have probably worked with Excel models containing well over 100 or even 200 columns, requiring extensive scrolling just to understand how the calculations flow.

Even with materiality thresholds in place, reviewing and maintaining these models can be time-consuming and operationally burdensome. This complexity is one of the key reasons organizations increasingly look to automation in operational transfer pricing.

Over the past several years, a growing number of tools have emerged to support the automation of operational TP processes. These solutions range from internally developed systems built by tax or finance teams to sophisticated software platforms that integrate directly with ERP environments. Many of these tools aim to automate key elements of the workflow, including data extraction, profitability analysis, adjustment calculations, and journal entry generation.

However, implementing automation in operational transfer pricing is not always straightforward.

Building a fully integrated system often requires significant upfront effort. Data must first be cleaned and standardized. ERP account structures must be mapped to transfer pricing categories. Transformation layers need to be developed to convert raw financial data into segmented profitability analyses.

These implementation efforts can require substantial investments of time, internal resources, and consulting costs.

For many organizations, this level of integration can be difficult to justify, particularly when the goal is simply to automate a repeatable operational workflow. In such cases, a more pragmatic approach may be to leverage existing ERP outputs and connect them to a lighter and more agile system that can automate the operational transfer pricing process without requiring a complete redesign of the ERP environment.

This idea ultimately led to the development of TP Workbench.

The goal behind the tool was to create a practical and flexible platform that automates operational transfer pricing while minimizing implementation complexity. Instead of requiring companies to rebuild ERP structures or undertake heavy system integrations, TP Workbench focuses on leveraging existing ERP outputs and transforming them into structured inputs that support transfer pricing calculations.

By converting ERP data into standardized formats, the system can quickly build segmented P&Ls, compare actual profitability against target margins, calculate the required transfer pricing adjustments, and generate the journal entries needed to implement those adjustments. This structured workflow helps ensure that transfer pricing policies are applied consistently across entities and reporting periods.

Another key advantage of TP Workbench is its flexibility.

Transfer pricing models vary significantly across organizations depending on transaction flows, tested party structures, and business models. As a result, operational tools must be able to adapt to different configurations. TP Workbench was designed with this flexibility in mind, allowing tax and finance teams to customize how data is mapped, how segmented P&Ls are constructed, and how adjustments are calculated.

This level of customization allows organizations to automate their existing operational processes rather than forcing them to redesign those processes to fit a rigid system. In practice, this means companies can implement automation more quickly while maintaining transparency and control over their transfer pricing calculations.

As global supply chains continue to evolve and regulatory scrutiny increases, operational transfer pricing is becoming an increasingly important area of focus for multinational groups.

Moving away from manual spreadsheet-based processes toward structured and automated workflows can significantly improve consistency, strengthen governance, and reduce the operational burden associated with maintaining transfer pricing compliance.

If you’re interested in learning more or would like to see a short demo of TP Workbench, feel free to DM me directly or reach out at info@tpright.com.