ANS-0802 · FINANCIAL REPORTING
How to Group Balance Sheet Accounts by Class in NetSuite Reports
Learn how to modify NetSuite's Balance Sheet reports to display account balances grouped by specific classes for enhanced financial analysis.
Short answer
To group Balance Sheet accounts by Class in NetSuite, customize the report layout. Within the Financial Report Builder, configure the accounts for each section. Set the primary 'Group By' option to 'Account', and then apply a secondary grouping by 'Class' to organize financial data by specific business segments.
Scenario
Users often require more granular financial reporting than standard NetSuite Balance Sheet layouts provide. Specifically, there is a need to view account balances not just by account type, but also segmented by different business classes. This customization allows for a more detailed analysis of assets, liabilities, and equity across various operational dimensions.
Solution
To achieve this customization, follow these steps:
To begin, customize the desired Balance Sheet report.
Access the Financial Report Builder and navigate to the Edit Layout view.
Within the layout editor, configure the specific accounts to be included in each section of the report.
Set the primary grouping option to 'Account'.
Subsequently, apply a secondary grouping by 'Class' to organize the data further.
Expert NetSuite Support
Need help with this NetSuite issue?
Financial Reporting consulting and configuration support