Table of Contents

Income Statement Template

The Income Statement Template makes it easy to consume gl accounts (Revenue, Cost of Goods Sold, etc.) and their balances based on parameters of Subsidiary, Fiscal Year, Fiscal Period, and Period Range.

Utilizing the Income Statement Template

  1. Select Standard Reports > Income Statement Template
  2. View the new sheet that has been created called Income Statement
  3. Fill in all required parameters (asterisks by the names)
  4. Select the button in the ribbon under Actions of Load Accounts (Only active after filling in required parameters). Finsyte will go to NetSuite to return the appropriate list of GL Account numbers and balances based on the identified Subsidiary input.

Remarks

  • Review the GL Accounts list to understand what accounts will be available for the income statement. Every account that falls under the system generated account of FSN_L0_INC will be returned. The Parent column in this table also helps to determine the tree structure seen in the template.
  • Review the Subsidiary column in the GL Accounts list to understand which accounts utilize which subsidiaries. The SubsidiariesHasAccess column generated by Finsyte can also be insightful for this.
  • If a change is made to the subsidiary input field in your template, please select Load Accounts again to properly return the correct account list as it may change.
  • Aggregate functions are utilized on the totals for groups in the financial statement to ensure proper totaling.
  • The accounts under Income have reversed signs for totaling purposes.

Example Income Statement

  1. Select Standard Report Templates > Income Statement Template to get the initial template
  2. Fill in the parameters (required with *) at the top of the sheet and select Load Accounts to get full account list with account balances and totals.
  3. Adjust parameters as needed. If subsidiary is adjusted, account list may change which means the Load Accounts action should be selected again after subsidiary adjustment.
  4. The Switch Signs operation has already been applied to corresponding account sections.

IncomeStatementGif