Hi there,
We are working with an external NetSuite partner for the localization of a new subsidiary in a new country and I would like to ask for some tips.
The scenario I would like to discuss is the following:
- New country has a very detailed chart of accounts, with more GL's than what we use in Consolidation at group level. Higher level of detail in the new country is needed for local tax filing.
- We don't want to add unnecessary GL's in Group CoA as they are country specific.
- Some GL's have a mapping of 1 to 1, meaning the GL of the new country corresponds exactly to the same at Consolidated level (no problem here). Possible to do via accounting context.
- Most GL's have more detail in new country and are mapped to only one at Consolidated level (problem).
I spoke with the localization team and they gave me two options on how to create the GL's of the new country:
1 - Create subaccounts from the main GL of group level, with some special country initials or other way of identifying it. I noticed that this creates quite some problems in our reporting. All GL's that have subaccounts will get bold and when you expand it looks quite odd (picture 1 & 2). It adds too many rows that we don't want to see at Consolidated level and doesn't look elegant. It happens the same in P&L/BS/TB.
2- Not creating as subaccounts. The problem here is different. The accounts obviously will not be seen summed together in the reports under the correct group. We want to avoid any manual work after extracting reports from NetSuite (picture 3) and this also doesn't look easy to work with.
I thought about an option 3, which is very manual and I would like to avoid. This option is creating the main GL's as a financial section in the reports. It doesn't seem sustainable to do it if we think about adding more countries with this logic in the future (picture 4). Then I would have to create a financial section per GL.
Any ideas about other options that I am not aware of? I asked the consultant about multi-book function and they told me that also there you cannot map several GL's from a specific entity into solely one of the Consolidated CoA.
Thank you.