NetSuite Budget vs Actual in Excel
The variance report finance runs every month, live in Excel, beside the budget template that sends updated numbers back to NetSuite.
Screen recording in Excel with on-screen callouts. On the Finsyte ribbon, pointing at Standard Reports shows its ScreenTip, and its menu lists Balance Sheet, Income Statement, Cash Flow, Budget vs Actual and Trial Balance. Callout: Standard Reports → Budget vs Actual. Budget vs Actual adds a Budget vs Actual sheet with a parameter block above an Actual column, D, and a Budget column, E. The Subsidiary list opens and United States is highlighted. Callout: Pick each parameter from Finsyte’s dropdowns. Subsidiary is set to United States, Fiscal Year to FY 2025 and Period Number to 12 from their lists, and the title line updates to As of December 31, 2025. The Period Range list opens and YTD is highlighted. Callout: Period and range come from dropdowns too. Period Range is set to YTD, and column E follows all four. Column D’s Budget Category reads N/A. Column E’s Budget Category starts as Annual_Budget; typing Annual shows Excel’s list of matching budget categories, typing on narrows it to Annual_Budget_Final, and Enter sets it. Callout: Enter the budget category. Load Accounts on the ribbon is highlighted under the pointer. Callout: Load Accounts builds the report. The income statement accounts are inserted with #GETTING_DATA, Cancel appears, and the status bar reads Queuing requests, then Processing Results, until the balances fill in. Callout: Live balances from NetSuite. The headers read Actual Amount, Budget Amount, Amount Over Budget and % of Budget; Sales shows 246,250 actual against a 659,600 budget, (413,350) over budget, 37% of budget. Scrolling down shows Gross Profit of 3,506,152 against a 13,675,211 budget, 26% of budget, then Net Income of $3,106,590 against a $12,112,915 budget, $(9,006,325) over budget, 26% of budget. Callout: Actual, budget and variance by account.

Budget against actual for every income statement account
Load Accounts builds the report from your NetSuite chart of accounts, and every row compares the actual balance with the budget you choose. Each figure is a live formula, so the report is current whenever you refresh.
- Four columns per account: Actual Amount, Budget Amount, Amount Over Budget and % of Budget
- Any NetSuite budget category, from the annual budget to a forecast
- Income, Cost of Sales, Expense and Other Income and Expenses in a collapsible account tree
- Actuals from GLAccountBalance and budgets from BudgetAccountBalance, both purpose-built Excel functions
- Drill down from any actual amount to the transactions behind it
A static snapshot of a finished budget vs actual, so you can see the layout before you connect NetSuite.
From a blank sheet to a NetSuite budget vs actual report in four steps
Insert the template
On the Finsyte ribbon, choose Standard Reports › Budget vs Actual. A new sheet opens with its parameters at the top.
Set the parameters
Fill in the yellow cells: Subsidiary, Fiscal Year, Period Number, Period Range and the Budget Category to compare against. The greyed-out parameters fill in on their own.
Load Accounts
Finsyte returns every income statement account with its actual amount, budget amount and both variance columns.
Refresh as the month closes
Use Refresh Data after new postings or a budget change. The variances update in place.
From budget vs actual variance to an updated forecast
The report shows where you stand against plan. The Budget template, in the same workbook, changes the plan in NetSuite when the numbers say it should move.
Four columns per account
Actual Amount and Budget Amount come straight from NetSuite. Amount Over Budget is the actual amount minus the budget amount, and % of Budget is the actual amount divided by the budget amount, or n/m for a line with no budget. Subtotals and Total - Income roll up the same way, and Gross Profit, Net Ordinary Income and Net Income are calculated in each column, so the variance on net income sits at the bottom of the report.
Read it at any level
Every level of the account tree is an Excel outline group. Collapse to Total - Income, Cost of Sales and Expense for the monthly review, or open a group to every account to find the line that moved. A collapsed group shows its totals in place, for actual and budget alike.
Find what drove a variance
Right-click any actual amount and choose Drill Down. A new sheet lists the transactions behind it, or breaks it down by department, class, location, subsidiary or period, so you can see what moved the number.
Compare against any budget category
Budget Category picks which NetSuite budget the report compares against: the annual budget or a forecast such as Q2_Forecast. Change it and every Budget Amount recalculates automatically. Period Range applies to both columns, so PTD compares one month with that month’s budget and YTD compares the year to date with the budget to date.
Any department, class or location
Department, Class and Location are parameters on every column. Set one for budget vs actual by department, or combine several in one column; actuals and budget filter together, so the variance is always for the same slice of the business.
Send the new numbers back to NetSuite
The Budget template downloads your NetSuite budget into Excel with actuals beside it. Choose Record Edit › Budget on the Finsyte ribbon, edit the yellow cells, and select Upload Budget to update the budget in NetSuite. For teams that prefer to plan in Excel, it’s a simpler option alongside NetSuite Planning and Budgeting.
Screen recording in Excel and NetSuite with on-screen callouts. On the Finsyte ribbon, Record Edit › Budget is chosen. Callout: Record Edit › Budget opens the budget template. A BudgetUpload sheet opens and the Subsidiary list is opened. Callout: Pick each parameter from Finsyte’s dropdowns. Subsidiary is set to United States. Callout: Actuals for FY 2025 … The actual column’s Fiscal Year is set to FY 2025. Callout: … next to the FY 2026 budget. The budget column’s Fiscal Year is set to FY 2026. Callout: Period and range come from dropdowns too. Period Number is set to 12 and Period Range to YTD, with the Annual_Budget budget category. Load Accounts is opened. Callout: Load Accounts › Income and Expense. Callout: Actuals and budget load side by side. Income statement accounts fill in with the FY 2025 actual beside twelve monthly FY 2026 budget columns; Sales shows 246,250 actual and a budget of 20,000 a month. Callout: Actuals are live Finsyte formulas. The formula bar shows the FSN.GLAccountBalance formula behind the Sales actual. Callout: Edit budget amounts right in the cells. 25000 is typed into the first month of the Sales budget. Callout: Fill the new amount across the year. The Sales budget now reads 25,000 in every month. Callout: Upload Budget sends it to NetSuite. Callout: Done · the budget is updated. The Budget as of time at the top of the sheet updates. Callout: Review Budget in NetSuite opens the record. The Review Budget in NetSuite link is clicked and the budget opens in NetSuite: United States, FY 2026, Annual_Budget. Callout: The new Sales amounts, live in NetSuite. Account 4000 Sales shows 25,000.00 for every month from Jan 2026 to Dec 2026.
For a worked example, see how to build a rolling quarterly forecast with live NetSuite actuals and two-way sync.
It’s Excel, so make the variance report yours
The template gets you started. In Excel, you make it your own: every amount is a cell formula, so you can add rows and columns around it: a forecast column, variance commentary or a full-year projection. A refresh updates the amounts, and your calculations follow.
- Variance commentary for the review meeting
- Forecast and full-year columns
- Conditional formatting on % of Budget
- A department or subsidiary per column
- Charts that update on refresh
NetSuite budget vs actual in Excel: FAQ
- QHow do I run a budget vs actual report from NetSuite in Excel?
- Insert the Finsyte Budget vs Actual template, fill in the subsidiary, period and budget category, and choose Load Accounts. Every income statement account fills in with its actual amount, budget amount and variances, live from NetSuite.
- QCan I compare actuals against a forecast instead of the annual budget?
- Yes. Budget Category picks the NetSuite budget to compare against, so set it to a forecast category to see actuals against the forecast. Change it back and the Budget Amount column recalculates automatically.
- QDoes it show both dollar and percent variance?
- It shows Amount Over Budget in currency, the actual amount minus the budget, and % of Budget, the actual amount as a percentage of the budget (n/m for a line with no budget). Each cell is a formula, so you can add a percent-variance column of your own beside them.
- QCan I update the budget from Excel and send it back to NetSuite?
- Yes, with the Finsyte Budget template. It downloads the NetSuite budget into Excel with actuals beside it, and Upload Budget sends your changes back to NetSuite.
- QDo I need NetSuite Planning and Budgeting?
- No. Budget vs actual works with the budgets already in NetSuite, and no extra NetSuite modules are required. For teams that prefer to plan in Excel, the Budget template is a simpler option.
Try the budget vs actual template with your own NetSuite data
30-day free trial with every Finsyte template included. No credit card required.
Related templates
- NetSuite Balance Sheet in Excel
- NetSuite Income Statement Template for Excel
- NetSuite Cash Flow Statement in Excel
- NetSuite Trial Balance in Excel
- NetSuite Budgets in Excel
- Real-time NetSuite actuals in Excel
- Drill Down into NetSuite from Excel
- Refresh NetSuite Data in Excel
- All NetSuite Excel report templates
- Budget vs Actual Template: setup steps in the docs