Skip to main content

Overview: Generate the Trial Balance Report

ExtendInsights FRE | Generate report for every account’s Debit, Credit, and Total for the period

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

  1. Open the ExtendInsights Financial Reporting task pane in Excel, and select Quick Start.

  2. Select Reports.

  3. Go to the Trial Balance section.

  4. Choose the period.

  5. 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?

Did this answer your question?