Comparative Balance Sheet Report
The Comparative Balance Sheet report compares the category and worth of each account across two or more specified time periods. You can use this report to compare your company's performance with previous years. This comparison helps you to measure your company's progress and to make future projections.
This report includes an Amount column that defaults to the current date range or period, and a Comparison Amount column that defaults to the last year or last fiscal year. You select a value in the As Of list in the report footer to change the date or period for Amount column data. The date of the Comparison Amount column changes automatically because it is defined by a alternate range that is relative to the Amount column date. For more information about comparison columns, see Adding Time-Based Comparison Columns to Reports.
The standard Comparative Balance Sheet includes the following rows:
-
ASSETS (header row)
-
Current Assets (header row)
-
Bank (financial section)
-
Accounts Receivable (financial section)
-
Unbilled Receivable (financial section)
-
Other Current Asset (financial section)
-
-
Total Current Assets (summary row)
-
Fixed Assets (financial section)
-
Other Assets (financial section)
-
-
Total ASSETS (summary row)
-
LIABILITIES & EQUITY (header row)
-
Current Liabilities (header row)
-
Accounts Payable (financial section)
-
Credit Card (financial section)
-
Other Current Liability (financial section)
-
-
Total Current Liabilities (summary row)
-
Long Term Liabilities (financial section)
-
Equity (header row)
-
Equity (financial section)
-
Retained Earnings (header row)
-
Total Retained Earnings (summary row)
-
Net Income (referenced row from Income Statement)
-
- Cumulative Translation Adjustment (financial section)
- (OneWorld accounts with multi-currency enabled only)
-
-
Total Equity (summary row)
-
-
Total LIABILITIES & EQUITY (summary row)
Header and summary rows are linked. Each summary row is calculated either through a sum of child row amounts or through a specified formula. Standard section data are selected based on account type and are grouped by accounts. The date you select in the footer is used to filter the column you want to compare.
To see the Comparative Balance Sheet report:
Go to Reports > Financial > Comparative Balance Sheet.
A message appears indicating that your report is loading. The status bar in the footer of the report indicates the progress as your report loads. You can click Cancel Report next to the status bar to stop the report from loading.
In the footer of the report, you can select from lists to refilter report data. You also can select from the Column list to display report amounts by an additional dimension, including class, department, location, or if you are using NetSuite OneWorld, subsidiary. Click the More arrow button to display all footer lists. After you change values in the lists, click Refresh to see the changes. For more information, see Setting Report Footer Options. The Allow Web Query option is not available for this report.
Inactive classes, departments, locations, and subsidiaries are available as filters to provide historical reporting and to avoid unbalanced totals.
For information about the permissions required to view and customize financial statements, see Permissions and Roles.
The Report by Period user preference determines whether report data is calculated by date range or by period. This preference is available at Home > Set Preferences on the Analytics subtab. To display this report's data by date range, set this preference to Never. To display this report's date range by period, set this preference to All Reports, or to Financials Only. For more information, see Choosing a Date or Period Range for a Report.
Click Customize to open the Financial Report Builder. Using the Financial Report Builder, you can add, reorder, and change the hierarchy of rows. You can group section data by class, department, location, and if you are using NetSuite OneWorld, subsidiary. You can set formatting options for each row. To change the date for your comparison column, select the column in the Edit Columns view and select a different Alternate Period Range. For example, to use the previous period in the comparison column, select Last Period for the Alternate Period Range. For more information about customizing the report, see Financial Report Builder.