1. Background
NetSuite’s standard Trial Balance (TB) report does not currently support subsidiary-wise segmentation, which is a common reporting requirement in OneWorld environments. This limitation is tracked under Enhancement #174031.
To address this reporting gap, we implemented a workaround by customizing the Balance Sheet report to replicate the Total view of the Trial Balance for individual subsidiaries.
2. Approach Overview
The customized report uses the Balance Sheet structure but is redesigned to behave like a Trial Balance. This is achieved by:
- Clearing all layout rows
- Adding a Financial Section containing all accounts
- Applying specific display settings
- Filtering by Subsidiary to produce subsidiary-wise outputs
While this approach replicates the Total view of TB, it cannot reproduce the Debit/Credit split, which remains a limitation.
3. Customization Steps
3.1 Base Report
We begin by customizing the Balance Sheet report.
3.2 Layout Changes
- All pre-existing layout rows are removed.
- A Financial Section is added that includes all account types (Assets, Liabilities, Equity, Income, and Expenses).
3.3 Display Settings
- Display Row → Unchecked
Ensures only accounts with balances appear. - Reverse Sign → Checked
Aligns the sign conventions with the Trial Balance totals.
6. Data Validation
The balances produced by the custom report were cross-verified with the Standard Trial Balance to ensure accuracy.
This included checking:
- Accounting period
- Subsidiary context
- Consolidated vs non-consolidated view
- Include/Exclude Children
- Currency settings
7. Known Limitations
- Debit/Credit columns cannot be reproduced in this method.
- The approach mimics the Trial Balance only in terms of ending balances (Total view).
8. Summary
Although NetSuite’s standard Trial Balance report does not support subsidiary-level segmentation, the customization of the Balance Sheet report provides an effective alternative. With the right layout, filters, and display options, the subsidiary-wise Trial Balance totals can be reliably reproduced to meet business reporting needs, with the exception of the Debit/Credit view.
