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
Open the Financial Reporting task pane and select Quick Start.
Select Reports.
Go to the Balance Sheet.
Turn on Compare periods and enter the compare month in the same format.
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?
đ Visit the Help Center: https://www.cloudextend.io/support/
đŹ Use the in-app chat
âď¸ Email cloudextend-support@celigo.com




