This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

_RE: Retained Earnings with a Split CoA._ I have a company that wants, for all intents and purposes, to have a separate CoA for each Subsidiary. I know that NS sees all of the accounts as a single CoA, so we've set up accounts that pertain only to the specific Subsidiaries, and used a numbering convention to avoid duplicate numbers between them. My question is around Retained Earnings. Of course there is a system-generated RE account which NS wants to post to at each period end. I just want to confirm: it would require a manual journal entry at the end of each period to debit system-generated RE and split out the amounts to the multiple user-created RE accounts. Am I on the right track?

That's probably how I'd accomplish the goal. As pointless as it is.

Should be noted - people backdating stuff/editing historical stuff is gonna fudge with that journal regularly.

Also - your dynamic calculation on balance sheet will still show up for the current year in a single line

I'd probably push back as hard as I think I could get away with.

"this one account isn't gonna play nice with that idea"

I'd be more inclined to add subsidiary as a grouping on the financial report definition

which would effectively still give them their desired result, (while viewing consolidated income) without having to have actual different accounts.

For dynamic calculation on the balance sheet that you mentioned: You're meaning that the system generated RE account will show as the only RE unless you modify it to show both?

No - your balance sheet retained earnings is made up of two parts - net income (from current year) and retained earnings from prior years.

Your net income section *wont* split out - no matter what you try.

But if we add Subsidiary as a grouping in the Financial Report Row Definition, then they should be able to see their RE amount when they filter for their Subsidiary, correct? So the biggest inconvenience would be 1) manual JEs to RE every month to maintain the separation between companies, and 2) having to adjust RE every time transactions in closed periods are posted/changed?

At that point though - why bother with a seperate RE account per sub - when customizing your report accomplishes same goal?