Table of Contents

Standard Report Templates

Standard Report Templates are pre-built Excel sheets that are specifically designed and formatted to allow users to easily view financial balance information referenced in NetSuite using a Subsidiary's GL Accounts structure for the grouping structure displayed in the outputs.

The Standard Report Templates include...

  • Balance Sheet Template: Consume gl accounts (assets, liabilities, equity) and their balances based on parameters of Subsidiary, Fiscal Year, Fiscal Period, and Period Range.
  • Comparative Balance Sheet Template: Consume gl accounts (assets, liabilities, equity) and their balances across two or more periods displayed side by side based on standard parameters. This template also enables variance analysis of the two periods for balance amount and percentage.
  • Income Statement Template: Consume gl accounts (Revenue, Cost of Goods Sold, etc.) and their balances based on parameters of Subsidiary, Fiscal Year, Fiscal Period, and Period Range.
  • Comparative Income Statement Template: Consume gl accounts (revenue, cost of goods sold, etc.) and their balances across two or more periods displayed side by side, based on standard parameters. This template also enables variance analysis of the two periods for balance amount and percentage.
  • Cash Flow Template: Consume gl accounts (operating activities, investment activities, net change in cash, etc.) and their balances based on parameters of Subsidiary, Fiscal Year, Fiscal Period, and Period Range.
  • Comparative Cash Flow Template: Consume gl accounts (operating activities, investment activities, net change in cash, etc.) and their balances across two or more periods displayed side by side, based on standard parameters. This template also enables variance analysis of the cash movements over time.
  • Trial Balance Template: Returns the full list of GL Accounts and their balances based on parameters of Subsidiary, Fiscal Year, Fiscal Period, and Period Range. The Grouped Trial Balance template will also include the Excel outlining based on accounts.
  • Comparative Trial Balance Template: Consume all gl accounts and their balances across two or more periods displayed side by side, based on standard parameters. This template also enables variance analysis of the two periods for balance amount and percentage.
  • Budget vs Actual Template: Returns an Income Statement template that includes Budget Amounts, Budget Amount Variance and Budget Percent Variance.

Selecting any of these options will result in a new Excel Sheet being added to the existing workbook with a list of required and optional parameters at the top to be filled in before selecting Load Accounts from actions. For more information on each template, refer to the links on each template type.

Note

The Book input field will default to Primary Accounting Book in all templates. This is interchangable with the Book ID which, for Primary Accounting Book, is 1. Either option will work as a function argument for this field.

Cell Styles

When Standard templates get created, there are certain custom Cell Styles that get applied. Users can adjust Cell Styles to ensure default formatting for reports gets changed all at once or apply styles to specific cells as needed. To learn more about this, visit the Cell Styles documentation.