Best Practice - Moving to New Chart of Accounts

SHayes

We are currently looking at migrating ledger providers and as part of this, there will be a full remapping of our existing chart of accounts to a new chart of accounts. This will likely break large parts of the model where we do lookups of specific account codes and the structure of our overall P&L and Balance Sheet will be changed to align to the new system. Does anyone have experience of this sort of process and what best practices look like for the Anaplan side of this implementation?

My current proposal is that we have 2 parallel versions of the model that are both updated and that at some point we transition to the new one but this would be very difficult for other model development and changes in the interim

vanreign

@SHayes,

Instead of duplicating the general parameters, old accounts attribute module would have Maps to New Account line item. Account Type line item would be on the old and new account attribute modules. New accounts attribute module would have line item Booleans like Is Revenue Acct, Is COGs Acct, etc. Caveat here that new ledger classification structures would need to be checked if identical or changed (i.e.. Operating Revenue being split Operating and Non-Operating). If not 1:1, little more work on splitting. Then references to general parameters would change to filtering or summing by the new accounts attributes. New accounts attributes would ultimately replace the general parameter module. Then downstream formulas would reference the new list attributes.

-James