Redesigning and converting a Chart of Accounts (COA) is always a complicated process, but having a framework to work with can help make things simpler. Ironically, conversion is often significantly more costly and time-consuming than the design phase. However, with the right tools, it’s possible to cut the total cost by 50% or more. This quick overview covers how we typically guide clients through the steps involved in a software-driven COA conversion that standardizes, simplifies, and automates much of the process.
A systemized and efficient software-based approach ensures a compliant conversion. This starts with gathering all relevant information for the scope of change:
With a standardized approach to gathering the RIGHT information, the project team (typically consisting of enterprise IT and operations department members) know exactly which tasks need to be completed. The right software platform also facilitates communication between IT, Accounting, and other business stakeholders facilitating agreement on the target concept in terms of content. Having a firm grasp on the definition of success is critical at this stage.
Next, accounting will prepare the mapping documents between the existing COA and the new COA. A detailed mapping of each COA segment must be created. Scenarios for many-to-one and one-to-many should be considered when designing the structure of the mapping tables.
Agreement must be reached on how much historical data should be converted. By converting historical data, users will be able to find all necessary data in the new system as if the new chart of accounts was always in place. This reduces IT costs and increases user acceptance.
IT’s role in this process is ensuring the COA solution is aligned with the specifics of the project. The conversion software itself helps drive the configuration process by:
A successful software solution will include functionality needed to manage, execute, monitor, and log the conversion progress. At this point in time, the software takes over and automatically executes all of the conversion work in a controlled and repeatable process by following business rules:
The software logs all the important data, such as runtimes, record counts, mapped/unmapped data and error messages of previously completed jobs. The software then supports the planning, control, and documentation of testing and checks to see whether the technical transformation has been performed correctly. It analyzes all defined checklists and supports the company’s IT group in performing all necessary steps before and after each conversion.
The integration tests verify the validity of all the important process scenarios in the Chart of Accounts. The Go-Live only begins after all processes in the new Chart of Accounts are working as in the former one. This involves checking that balances and record counts are correctly designated in the new COA structure.
Automated software-driven conversion makes it possible to take the new COA live very rapidly. Usually, it’s possible to go live over a weekend, even for very large volumes of data. This applies to nearly all change scenarios, including the Chart of Accounts conversion within one cost center.
A transparent software-based approach includes a comprehensive documentation of all steps, thus helping all project members to standardize the process of Chart of Accounts conversion within their organization. They can access existing business rules at any time and reuse them in other projects. In this way, a “transformation memory” is built up within the corporate IT with every single Chart of Accounts conversion project. This allows for a substantial and sustainable contribution to reducing time and costs of future projects.
Data migration usually adds significant complexity to a COA conversion. However, our team at ACBM leverages proprietary conversion tools in JDE to reduce costs by 60-75% in some cases.
Whether you’re on JD Edwards or another ERP and Accounting system, we can help you with redesign and conversion. Talk to our team about your project today.