Skip to main content

Comparative Income Statement Template

A Comparative Income Statement is a financial statement that presents a company’s revenues, expenses, and net income for two or more periods side by side. This format allows stakeholders to easily analyze changes in operating performance over time, identify trends, and evaluate profitability through variance analysis.

See the comparative income statement template in action.

Unlike a standard income statement that shows results for a single period, a comparative income statement displays multiple periods (typically two consecutive fiscal years) in adjacent columns, along with variance calculations showing both absolute and percentage changes.

Utilizing the Comparative Income Statement Template

  1. Select Standard Reports > Income Statement > Comparative Income Statement
  2. View the new sheet that has been created called Comparative Income Statement
  3. Fill in all required parameters (asterisks by the names)
  4. Select the now activated button in the ribbon under Actions of Load Accounts. Finsyte will go to NetSuite to return the appropriate list of GL Account numbers and balances based on the identified Subsidiary input.
  5. Adjust parameters as needed. The balances update on their own.
  6. The Switch Signs operation has already been applied to corresponding account sections.

ComparativeIncomeStatementGif

Remarks

  • Choose a Fiscal Year for both column D and column E; column E's Fiscal Year starts blank. Column E's other parameters follow column D until you change them, so you can also compare a different subsidiary, period number or other parameter. Variance is column D minus column E, and % Variance is that variance divided by column E (0% when column E is 0).
  • 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.
  • For a consolidated report, or to compare subsidiaries, select the top-level (Consolidated) subsidiary in column D before you select Load Accounts so the sheet brings in every account. An account a subsidiary can't use returns 0 and can be ignored.
  • Once you've customized the template, don't select Load Accounts again. It rebuilds the account list in the template's own columns only, which undoes your layout.
  • Aggregate functions are utilized on the totals for groups in the financial statement to ensure proper totaling.
  • The accounts under Income and Other Income have reversed signs for totaling purposes.