Introduction:
NetSuite provides many features and reporting capabilities inherently but depending on the user’s familiarity with NetSuite and certain limitations, the end user might be frustrated to learn a highly utilized report in their previous NetSuite ERP (Enterprise Resource Planning) system may not be available without some customizations.
Overview:
This post will look specifically at the Balance Sheet Report and some pain points that may need to be overcome. The approach discussed will detail how to customize the balance sheet report to gain a consolidated report with custom periods as the columns.
When using a NetSuite Instance with multiple subsidiaries, a common request is to generate a consolidated balance sheet of all the subsidiaries. NetSuite, however, does not allow the Balance Sheet columns to be set to Accounting Period when the subsidiary context is set to Consolidated, despite allowing this while viewing the Balance Sheet for a single subsidiary. Currently, the ability to run a consolidated balance sheet by Accounting Period is a system limitation being tracked under Enhancement #130536.
There is a workable solution that will require a user who has permission to create and customize a balance sheet report. The steps listed below can be repeated as many times as necessary to achieve the desired reporting.
Steps:
- Navigate to the following path: Report > Financial > Select Balance Sheet
- Once viewing the Balance Sheet Select the Customize button on the bottom left
- Select the Edit Columns bubble to the right of the edit layout
- Under the Add Field section on the left side, expand the financial section and Select “Amount”
- Once the column has been added, scroll down to customize the attributes of the column
- Change to column label from amount to a more detailed title
- Mark Grand Total checkbox
- Set Alternate Date Range Type to Relative to today’s date (This will unlock the next steps)
- Mark the Cumulative Value checkbox
- Set Alternate Date Range to the Desired period
- Preview the report to check the output
- Save the report
If you are facing any issue in these steps, then feel free to connect with NetSuite experts, they will be happy to assist you in every way possible.
Conclusion:
Though the purposed solution will take some time and include repetitive tasks, it will provide the end user with the ability to view and leverage a consolidated balance sheet by period. Many variables can be explored to tailor the report further, but this will certainly provide a great starting point.
About Us
We are a NetSuite Solutions Partner and reseller with 30+ years of combined experience. We specialize in implementation, optimization, integration, rapid project recovery and rescue as well as custom development to meet any business need. If you would like more information on NetSuite or are in need of consultation for your project or implementation, feel free to contact NetSuite support.
To Contact Us Click Here