Skip to main content

Overview: Generate the Comparative Income Statement

ExtendInsights FRE | Compare profit and loss for fiscal year

Use the Income Statement to show your company's assets, liabilities, and equity at two points in time side by side, along with how much each account changed. All numbers come live from NetSuite.


Generate the Comparative Income Statement

  1. Open the Financial Reporting task pane and select Quick Start.

  2. Select Reports.

  3. Go to the Income Statement.

  4. Turn on Compare periods. Choose the fiscal year to compare to. It defaults to the prior fiscal year.

  5. Select Generate.


How to Use It

  1. Set As Of to the period you want to report on.

  2. Set Compare Period to the period you want to compare against, such as the prior month or the same month last year.

  3. Choose a Subsidiary. You can also narrow the report by Department, Location, or Class, or leave those blank to include everything.

  4. The report refreshes automatically. Cells showing #BUSY! are still loading.


What the Report Includes

  • Amount: The balance as of the As Of period.

  • Comparative Amount: The balance as of the Compare Period.

  • Variance and % Variance: How much the balance changed, in actual amount and as a percentage.

  • Sections: Assets, then Liabilities, then Equity, each with subtotals and totals.

  • Earnings lines: Equity includes Net Income, Retained Earnings, and a currency translation adjustment.


Good to know

  • Both periods use the same subsidiary, department, location, class, accounting book, and other filters.

  • To change a year or a filter, update it on the sheet and refresh.

  • Compare periods off gives the regular Income Statement.

  • Comparative reports are based on the report date, not today’s date.

  • If an account did not exist in the earlier period, its comparative cell shows N/A rather than $0.

    ➡️ See Troubleshooting: XAVI Formula Returns N/A


Notes

Pre-built reports are examples, not permanent templates for day-to-day reporting.

📖 Review Working with Pre-Built Reports for guidance about fiscal period compatibility and customization.


Related Articles


Need Help?

Did this answer your question?