Table of Contents

Trial Balance Template

The Trial Balance Template makes it easy to return the full list of GL Accounts and their balances based on parameters of Subsidiary, Fiscal Year, Fiscal Period, and Period Range.

There are two ways to view the Trial Balance Template: Trial Balance and Grouped Trial Balance.

Trial Balance Options

Trial Balance: This template returns a flat list of all accounts and their balances for the specified parameter inputs.

Grouped Trial Balance: This template returns the full list of accounts and balances organized using your company's NetSuite chart of accounts structure given the specified parameter inputs. Refer to the GL Accounts list for more information about this grouping structure.

Utilizing the Trial Balance Template

  1. Select Standard Reports > Trial Balance > Grouped Trial Balance
  2. View the new sheet that has been created called Trial Balance
  3. Fill in all required parameters (asterisks by the names)
  4. Select Load Accounts under the Templates and Actions section to call NetSuite data and return the GL Account Balances for all account numbers in the selected subsidiary.
  5. Scroll down to the Total row to immediately understand if your numbers are balancing correctly in NetSuite.
Note

The Cumulative Translation Adjustment summarizes Assets, Retained Earnings, Net Income and Liabilities & Equity to produce its total, matching NetSuite.

Customize the Trial Balance Template

After the initial creation of the template, any changes that are made will be saved only in the current Excel Workbook. This template makes it easy to analyze accounts, but it also allows users to analyze segmented information like Subsidiary.

Let's say a user wants to analyze all of their accounts for each of their four Subsidiaries, they can do this by highlighting all of column D and copying it. Then, pasting that column into column E, F and G will create copies of that column's values.

By simply changing the Subsidiary, the GLAccountBalance functions will automatically update to review balances for those subsidiaries.

View the example final result below:

Trial Balance for different subsidiaries