Skip to content
Workflow · Match two lists · Opening soon

NetSuite budget vs actual by department

Export your NetSuite quarter actuals and budget views, then load them into the workflow. It totals actuals and budget by department and expense account, brings in budget amounts, and flags the variance cases you asked for.

Early access opens shortly. Check back soon.

Someone typed

“compare netsuite actuals with budget by department and expense account for the quarter, and flag departments more than ten percent over budget, actuals posted with no department, and accounts with actuals but no budget”

The agent read it as

Compare NetSuite actuals by department and account with NetSuite budget by department and expense account for the quarter, and flag departments more than ten percent over budget, actuals posted with no department, and accounts with actuals but no budget, using these views as quarter figures.

What the agent built

4 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    NetSuite actuals by department and account
    CSV export · 22 rows
  2. File
    NetSuite budget
    CSV export · 20 rows
  3. Step
    Total actuals by department and account
    Step 1
  4. Step
    Total budget by department and account
    Step 2
  5. Join
    Bring in budget amounts
    19 of 22 paired
  6. Step
    Flag department and account variances
    Step 4
  7. Result
    Quarter Budget Flags
    23 rows
  8. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 23 rows.

What you get back

The result of that run, the rows to look at first.

Quarter Budget FlagsSample data23 rows
DepartmentExpense accountDepartment statusAccount statusActualBudgetVarianceDepartment actualDepartment budgetDepartment variance
MarketingAdvertisingOver budgetBudgeted18,00015,0003,00059,00050,0009,000
MarketingContractorsOver budgetBudgeted3,5004,000-50059,00050,0009,000
MarketingEventsOver budgetBudgeted10,0008,0002,00059,00050,0009,000
MarketingSalariesOver budgetBudgeted24,00020,0004,00059,00050,0009,000
MarketingSoftwareOver budgetBudgeted3,5003,00050059,00050,0009,000
·Miscellaneous ExpenseNo departmentNo budget5,40005,4009,00009,000
·Travel ReclassNo departmentNo budget3,60003,6009,00009,000
SalesSales ToolsWithin budgetNo budget8,20008,200121,000110,00011,000
G&AInsuranceWithin budgetNo actuals03,000-3,00079,20080,000-800
EngineeringCloud HostingWithin budgetBudgeted15,50015,000500102,000100,0002,000
EngineeringContractorsWithin budgetBudgeted7,6008,000-400102,000100,0002,000
EngineeringSalariesWithin budgetBudgeted62,00060,0002,000102,000100,0002,000
23 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Quarter Budget Flags workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Quarter Budget Flags: questions

How do you compare NetSuite actuals with budget by department?
Export your NetSuite quarter actuals and budget views, then load them into the workflow. It totals actuals and budget by department and expense account, brings in budget amounts, and flags the variance cases you asked for.
What export should you use from NetSuite?
Use exported quarter views for actuals by department and expense account, and a quarter budget export with the same department and expense account fields. The workflow matches rows on those shared fields.
What happens to rows that do not match?
Rows that do not match are still checked against the rule you set. For this workflow, that includes actuals with no department, and expense accounts that have actuals but no budget.
How do you change the rules in words?
Edit the rule text to describe the new threshold or match conditions, such as a different over budget percentage or a different department or account grouping. Then rerun the workflow on the exported files.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.