Skip to main content

Overview: Generate the Budget vs. Actual Report

ExtendInsights FRE | Compare budgeted and actual amounts from NetSuite

The Budget vs Actual template compares your budgeted and actual amounts from NetSuite side by side.

It is an income statement that puts actual results next to budget for a period you choose, with the variance amount and percent. Actuals and budget amounts are pulled live from NetSuite through XAVI formulas, and the report updates each time it refreshes.


Generate the Report

  1. Open the XAVI task pane and select Quick Start.

  2. Select Reports.
    ​

  3. Go to the Budget vs. Actual section.

  4. Set the From and To period parameters.

  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.

  • From Period / To Period: The date range, which can be a single month, a quarter, year-to-date, or any other range. The title updates automatically.

  • 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 version to compare against, for example, Legacy or a forecast scenario.

  • 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.

  • Amount: Actual results for the period, from XAVI.BALANCE.

  • Budget Amount: The budget for the same period, from XAVI.BUDGET.

  • Amount Over Budget: Actual minus budget.

  • % of Budget: Actual divided by budget. It shows 0% when there is no budget for the account.

Report layout

  • Revenue → Total Revenue

  • Cost of Sales → Total COGS → Gross Profit

  • Operating Expenses → Total Operating Expenses → Operating Income

  • Other Income and Other Expense → Net Income

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

How to read the variances

  • Revenue and other income: A positive Amount Over Budget is favorable, because you earned more than planned.

  • COGS and expenses: A positive Amount Over Budget is unfavorable, because you spent more than planned.

  • % of Budget: 100% means the account came in exactly on budget.


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?