Module: General Ledger / Period Close / Financial Statement Reporting
Priority: Medium (reporting accuracy impact, no transaction blocker)
Description:
At fiscal year-end, NetSuite does not post an actual closing journal entry to zero out Income Statement account balances against Retained Earnings. Instead, Retained Earnings is computed live, at report run-time, as a rolling plug of net income — with no location, department, class, or custom segment allocation attached to it.
In our entire transaction history, not a single journal line has ever actually posted to the Retained Earnings account. It exists purely as a report-time calculation, never as a physical GL entry.
As a direct consequence, when a Trial Balance or custom Financial Report is generated with Location (or Department, Class, or a custom segment) in the column/filter section, Income and Expense accounts continue to display their cumulative since-inception balance for each location — the balance never resets to zero at the fiscal year boundary within that dimensional context, because there is no closing entry, tagged or otherwise, to net it out per location.
Business Impact:
- We operate a multi-subsidiary, multi-location manufacturing environment where location-wise and department-wise P&L and cost-level analysis is a core, recurring reporting requirement.
- Because RE is untagged and never physically posted, any Trial Balance or Financial Report sliced by Location/Department/Class/Segment shows income accounts accumulating year-over-year rather than resetting — this distorts current-year cost/performance comparisons at the location level, even though consolidated (no-location) reporting nets correctly.
- The distortion compounds annually — the longer an account has been live, the further removed the location-tagged balance is from true current-year activity.
Steps to Reproduce:
- Run a Trial Balance or Income Statement with Location in the column section, across multiple fiscal years.
- Observe that Income/Expense account balances under a given location keep accumulating rather than resetting at each year-end.
- Query transactionaccountingline for account (Retained Earnings) — confirm zero posted lines exist, dimensional or otherwise.
- Compare to consolidated-level reporting (no location breakdown), where the balance nets correctly at each year-end — confirming the gap is specific to dimensional rollup, not the underlying accounting.
Expected Behavior:
NetSuite should provide a configurable option (at the accounting preference or period-close level) to generate an actual, dimension-aware year-end closing journal entry that:
- Zeroes out Income Statement balances at fiscal year-end for each combination of Subsidiary, Location, Department, Class, and applicable custom segment values.
- Posts the offsetting entries to Retained Earnings tagged with those same dimensional combinations, so location-wise/department-wise/class-wise/segment-wise Trial Balance and Financial Reports reset correctly at each fiscal year boundary.
- Remains compatible with existing multi-book and multi-subsidiary structures, without disrupting consolidated-level RE computation for entities that don't require dimensional reporting.
Requested Resolution:
Please confirm whether any existing feature, accounting preference, or SuiteApp addresses dimension-aware year-end closing.