The Road to a Smooth ERP Integration

Today’s treasurers and chief financial officers (CFOs) are increasingly focused on the need to maximise corporate assets and legacy investments, and one of the largest investments that a company makes in this area is its enterprise resource planning (ERP) system.

Older ERP technologies were based on fixed and leased lines of service and software that required costly, specialised maintenance. In the quest for increased efficiency, many treasury operations are moving towards the adoption of host-to-host (H2H) integration technologies with their banks. While the benefits of automation and controls are highly desirable, the complexities of implementation are often challenging. Companies aspire to minimise the effort of implementation without compromising on controls already in place.

Making full use of an ERP system lies in leveraging it to streamline the banking interface and improving integration between the various treasury operations. This can range from using the ERP to generate payment files, automate the reconciliation of bank statements and automate accounts receivables (A/R) reconciliations. The potential hidden costs of integration and the impact a banking interface can have on a company’s processes are significant if the integration is not done using best practices and best-in-class solutions. While there are many approaches and solutions being offered in the market, a bank partner can often identify the pitfalls hidden within various approaches and provide bespoke solutions.

Non-intrusive Solutions

The use of electronic data exchange between banks and corporates has increased rapidly over the past decade. IT policies, however, determine what is allowed in terms of access to internal networks by third parties. While practices vary, most do not allow banks to install proprietary software inside a company’s firewall. Currently most solutions require extensive and intrusive access to the IT network and because the integration initiative may not be led by the corporate’s own IT professionals, these barriers are often not discovered until the integration is underway and significant investments in human resources have been made.

For corporates that allow software installed behind their IT firewall, there are a myriad of serious implications if future changes are required, such as regulatory modifications that affect payments. The company must then contact the bank to make changes to the system rather than have its own IT team carry out the adjustments. An one example of how to avoid this common problem, Citi uses a translation engine installed on the bank’s end that enables it to translate any file format into a format that its system recognises – without any changes on the corporate’s end. The IT department does not have to reconfigure systems or convert file formats when migrating or when changes must be made to payment fields. All conversions, customisation and other integration work are carried out within the bank’s infrastructure, which ensures that no intrusive tools are put in place giving a corporate full control of the integrated system.

Proprietary System Pitfalls Versus Standardised Technology

The two most important factors when it comes to ERP integration are:

  1. Technology should facilitate integration and the quality of the data should be maintained. Unless a company can be assured of data integrity, the entire integration exercise will be seriously undermined and disruptive.
  2. Equally important with integration planning is the need to identify what interruptions system integration will cause to the data centre, as well as understand the level of complexity it will add to the existing data centre structure. Much of the cost of integration is associated with the disruptions a changeover has on normal daily business functions and the resources it takes away from the company’s core operations.

A bank-integration solution is intended to streamline the information flow, but if the wrong choices are made it will instead become a complex and costly IT problem.

Proprietary bank formats lock a corporate into using that bank’s specific formats and increases switching costs. Companies are advised to select integration solutions that support standard, proprietary and custom formats. This enables the treasury operation to remain bank-neutral. It also simplifies and reduces the cost of implementation and ongoing maintenance.

Licensing costs and software upgrades, as well as complex training required of the IT department to service a new technology, are other potential costs that should be considered during the selection process. These costs can become recurring overhead if inappropriate third-party software solutions are chosen. Companies should look to their banking partner for providing a flexible solution that does not introduce new, unapproved technologies into the company’s existing data service centres.

Many solution providers offer to build tailored applications to address differences in file formats or to meet unique needs. These types of customised applications create deficiencies and prevent companies from reaching their goal of streamlining processes.

The ideal solution is one that can take any treasury technology format currently in use and prepare it for ERP integration. For example, some banks work with SAP’s existing strategic modules, rather than requiring new models which require costly licensing fees, training of IT staff and further disruptive integration processes. If a company already has IT staff well-versed in maintaining SAP, they will be able to quickly adjust to the additional technology introduced through the ERP integration process. The goal is to use the technology skills already present in an IT department rather than training or hiring additional staff, and to eliminate third-party software licensing costs.

In the market today, most bank ERP solutions are implemented by bank professionals because the tools are proprietary. Banks’ clients have the option of implementing it themselves because the technology is industry standard. The skills needed for implementation of many banks’ solutions are available from the market and sometimes from within the company itself. Using industry standards generates savings not only during the set-up process but also in daily operations throughout the life of the solution.

To learn more about Citi, visit the company’s gtnews microsite.


Related reading