A trial balance that lists every GL account with its balance in Debit and Credit columns, plus totals, so you can confirm the books' balance. Balances are pulled live from NetSuite through XAVI formulas and update each time the report refreshes.
Generate the Report
Open the ExtendInsights Financial Reporting task pane in Excel, and select Quick Start.
Select Reports.
Go to the Trial Balance section.
Choose the period.
Select Generate.
How to Use It
Every formula reads from the filter block at the top. Change a filter and the whole report recalculates.
Start Period: The first period for income statement activity (revenue, COGS, expenses). Set this to the first month of your fiscal year so the trial balance balances.
End Period: The "as of" date. Balance sheet accounts show their ending balance at this period, and the report title updates automatically.
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 report from (usually the primary book).
Structure Sync: Keeps the report's 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 are looked up live with
XAVI.NAME.Debit / Credit: The balance placed on the correct side. A balance on its normal side goes in that column, and an abnormal balance flips to the opposite column.
Total: The account's net balance from NetSuite, from
XAVI.BALANCE:Balance sheet accounts (assets, liabilities, equity) show the cumulative balance as of the End Period.
Income statement accounts (revenue, expenses) show activity from Start Period through End Period.
Normal Balance: Whether the account normally carries a Debit or Credit balance. This decides which column the amount goes in.
Special lines at the bottom
Retained Earnings: Prior years' accumulated earnings, from
XAVI.RETAINEDEARNINGS.Cumulative Translation Adjustment: The currency translation effect for consolidated, multi-currency reporting, from
XAVI.CTA.Total: The sum of all Debits and all Credits. The two totals should be equal.
Limitation
The Trial Balance report does 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 about 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




