Skip to main content

Overview: Generate the Budget Report

ExtendInsights FRE | Retrieve NetSuite budget data for a selected year

A 12-month budget report that pulls budget amounts directly from NetSuite through XAVI formulas. It lists each budgeted GL account by month, groups the accounts by type, and shows a full-year total. Values update when the report refreshes, so nothing needs to be typed in by hand.


Generate the Report

  1. Open the ExtendInsights Financial Reporting task pane in Excel.

  2. Select Quick Start.

  3. Select Reports.

  4. Go to the Budget Report section.

  5. Add a budget year.

  6. Select Generate.


How to Use It

Every formula in the report reads from the filter block at the top. Change a filter and the whole report recalculates.

  • Year: The budget year. The report title and month headers follow it.

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

  • Department, Location, Class: Optional. Leave them blank to include everything, or pick a value to narrow the report.

  • Acct Book: The accounting book to report from (usually the primary book).

  • Budget Category: The NetSuite budget category to use, for example, a specific budget version or scenario. Leave it blank to use the default.

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


What the Report Includes

  • Account # / Account Name: Each budgeted account. Names are looked up live from NetSuite with XAVI.NAME, so only the account number needs to be entered.

  • Monthly columns (Jan–Dec): The budget amount for each account and month, from XAVI.BUDGET.

  • YTD Total: The sum of the 12 months.

  • Sections by account type: Income, COGS, Expense, Other Income, Other Expense, Fixed Asset, and Other Asset. Each section ends with a subtotal row.

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


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?