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
Open the XAVI task pane and select Quick Start.
Select Reports.
Go to the Budget vs. Actual section.
Set the From and To period parameters.
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?
🔍 Visit the Help Center: https://www.cloudextend.io/support/
💬 Use the in-app chat
✉️ Email cloudextend-support@celigo.com




