How to run a comparative income statement in NetSuite

Run a NetSuite comparative income statement and check both period headings before interpreting amount and percentage variances.

The quick answer

To run a comparative income statement in NetSuite, open Reports > Financial > Comparative Income Statement. Confirm the primary range, refresh, then check the period labels on both amount columns before interpreting the variance.

A comparison is only useful when you know what is being compared. This guide checks both column headings before reading the changes in income, expenses, and the net result. The screenshots use sample data and fictional person and operating-company names.

Before you start

Your role needs access to the financial report and intended reporting scope. Decide the primary and comparison ranges you need. The comparison may follow a relative alternate-period setting rather than a separate date field in the footer. Variance columns can depend on the report layout.

01. Open the comparative report

Go to Reports > Financial > Comparative Income Statement. Confirm the report title and wait for the results to load.

Look for Amount, Comparative Amount, Variance, and % Variance. These headings explain how the report presents the comparison.

Open Comparative Income Statement from Financial reports.

02. Confirm the primary period

Check the From and To controls. The example uses Jul 2026 for both. Review any available subsidiary or other scope filters, then Refresh after changes.

Do not assume these footer controls independently set the comparison range. Read that range from the comparison column heading.

Confirm the primary range before reading the comparison columns.

03. Check the comparison before the variance

The recording shows Amount (Jul 2026) beside Comparative Amount (FY 2025). Those are different-length ranges, so this is not a like-for-like monthly comparison. If you need aligned ranges, review the comparative column’s alternate-period settings where your role permits report customization.

The sample Net Income is (11,465.93) in Amount against 1.00 in Comparative Amount. Read the underlying amounts before interpreting the percentage: a tiny comparison value can create a very large percentage change.

The headings reveal that the example compares a month with a full fiscal year.

Check the result

  1. The primary period is the intended range.
  2. The comparison heading identifies the intended comparison range.
  3. Variances are interpreted with both underlying amounts and ranges in view.

Once the ranges answer the same question, use the account rows to explain the change. If the ranges are mismatched, fix the comparison before sharing conclusions.

Common questions

How do I open the Comparative Income Statement in NetSuite?

From the home dashboard, go to Reports > Financial > Comparative Income Statement. Confirm the page title, then wait for the report to finish loading before reviewing values. Availability depends on your role’s financial-report permissions and the reports enabled in your account.

How do I select the reporting period?

Use the report’s visible footer date or period controls to choose the primary report period. Depending on account configuration and the Report by Period preference, NetSuite may calculate results by accounting period or transaction date. Apply the selection, wait for refresh, and verify the displayed period labels.

How do I make the comparison cover the matching prior period?

Check the Amount and Comparative Amount headings, including their period labels. The comparison commonly uses a relative alternate range, such as the prior fiscal year. If the ranges do not align, review the report’s comparison settings or customize the columns, where your role permits.

Why do the Amount and Comparative Amount columns show different ranges?

Amount reflects the selected primary range, while Comparative Amount follows its configured comparison rule. A relative range may be based on the report date or period and can produce an unexpected span. Role restrictions, subsidiary filters, and date-versus-period preferences may also affect the displayed results.