Skip to main content

Overview: Generate the Comparative Balance Sheet

ExtendInsights FRE | Generate a comparative report of assets, liabilities, and equity

The balance sheet shows account balances at two points in time side by side, plus the dollar and percent change between them. Balances come live from NetSuite through XAVI formulas and update each time the report refreshes.


Generate the Report

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

  2. Select Reports.

  3. Go to the Balance Sheet.

  4. Turn on Compare periods and enter the compare month in the same format.

  5. Select Generate.


How to Use It

Every formula in the report reads its settings from the filter block at the top. Change one filter and the whole report updates.

  • As Of: The main balance sheet date, such as Jan 2026. The report title and the Amount column header update automatically.

  • Compare Period: The date you want to compare against, such as the same month last year or the prior month.

  • Subsidiary: The entity or consolidation level to report on.

  • Department, Location, Class: Optional. Leave them blank to include everything.

  • Acct Book: The accounting book to use, usually the primary book.

  • Structure Sync: Keeps the report layout in sync with XAVI.

Use the XAVI task pane's filter selector to fill in these cells.


What the Report Includes

  • Account # / Account Name: The GL account. Names come live from NetSuite through XAVI.NAME.

  • Amount: The balance as of the As Of period, from XAVI.BALANCE.

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

  • Variance: Amount minus Comparative Amount.

  • % Variance: The change as a percentage of the comparative balance. It shows 0% when the comparative balance is zero.

Balance sheet accounts are cumulative, so each figure is the ending balance as of that period, not activity during the period.

Report layout

  • Assets: Current assets (bank, accounts receivable, prepaids and other current assets, deferred expense), then fixed assets and other assets, ending in Total Assets.

  • Liabilities: Current liabilities (accounts payable, credit card, other current liabilities), ending in Total Liabilities.

  • Equity: Equity accounts, plus these calculated lines:

    • Net Income: Current-year earnings, from XAVI.NETINCOME.

    • Retained Earnings: Prior years' accumulated earnings, from XAVI.RETAINEDEARNINGS.

    • Cumulative Translation Adjustment: The currency translation effect for consolidated, multi-currency reporting, from XAVI.CTA.

    • These lines end in Total Equity.

Subtotals and totals are standard Excel formulas, so they recalculate instantly without calling NetSuite.


Limitation

  • The Balance Sheet reports do not support custom segments or Fields filters.


Notes

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

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


Related Articles


Need Help?

Did this answer your question?