Workflow · Stock and products · Opening soon

Cycle count variance

Compare your cycle count results with inventory balances by item and location. See the unit variance and value variance for each row.

Book a demo

Someone typed

“compare the netSuite cycle count results to the netSuite inventory balances by item and location, using counted qty minus on hand, and show the unit variance and value variance for each row”

The agent read it as

Compare the NetSuite Cycle Count Results to the NetSuite Inventory Balances by item and location, using counted qty minus on hand, and show the unit variance and value variance for each row.

What the agent built

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

File

NetSuite Cycle Count Results

CSV export · 12 rows

File

NetSuite Inventory Balances

CSV export · 12 rows

Step

Make count match keys

Step 1

Step

Make balance match keys

Step 2

Join

Bring in inventory balances

12 of 12 paired

Step

Calculate variances

Step 4

Result

Inventory Count Variances

12 rows

Schedule

Runs when you say

Proposed

File
NetSuite Cycle Count Results
CSV export · 12 rows
File
NetSuite Inventory Balances
CSV export · 12 rows
Step
Make count match keys
Step 1
Step
Make balance match keys
Step 2
Join
Bring in inventory balances
12 of 12 paired
Step
Calculate variances
Step 4
Result
Inventory Count Variances
12 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 12 rows came out, and the join paired 12 of 12 rows.

Download NetSuite Cycle Count Results sample (12 rows)NetSuite: Inventory > Physical Inventory > Cycle Count > Results > Export
Download NetSuite Inventory Balances sample (12 rows)NetSuite: Reports > Inventory/Items > Inventory Balance > Customize > Export

What you get back

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

Inventory Count VariancesSample data12 rows

Item	Location	Count number	Count date	Unit variance	Value variance	Counted quantity	On hand	Average cost
Aero Bottle 750ml	central_warehouse	CC-1041	2026-09-18	0	0	120	120	8.40
Boreal Mug 12oz	central_warehouse	CC-1041	2026-09-18	0	0	84	84	5.25
Cinder Notebook A5	east_dc	CC-1044	2026-09-25	0	0	260	260	3.10
Drift Pen Black	east_dc	CC-1044	2026-09-25	5	7	410	405	1.40
Aero Bottle 750ml	north_store	CC-1048	2026-10-02	-4	-33.60	36	40	8.40
Ember Tote	north_store	CC-1048	2026-10-02	0	0	58	58	11.80
Fjord Candle 8oz	south_store	CC-1051	2026-10-09	0	0	72	72	6.95
Glint Water Bottle	south_store	CC-1051	2026-10-09	-3	-28.80	95	98	9.60
Harbor Lunchbox	central_warehouse	CC-1058	2026-10-23	-3	-42.60	47	50	14.20
Iris Keychain	central_warehouse	CC-1058	2026-10-23	0	0	190	190	2.15
Juno Planner	east_dc	CC-1064	2026-11-04	4	48	64	60	12
Boreal Mug 12oz	north_store	CC-1064	2026-11-04	-2	-10.50	79	81	5.25

12 rows in the result. Sample data: illustrative figures, not business results.

How do you compare cycle count results to system quantities?

Export your cycle count results and inventory balances from NetSuite, then upload both files. Match rows by item and location, subtract on hand from counted quantity, and review the unit and value variance for each record.

How it works

How to use the Inventory Count Variances workflow

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

Inventory Count Variances: questions

Which export should you use?

Use the cycle count results export and the inventory balances export. Pick files that include item, location, counted quantity, on hand quantity, and value fields if you want value variance.

What happens when a row does not match?

Rows that do not find a match are left out of the comparison or flagged for review, depending on the workflow rule. You can also keep unmatched rows in the output if you want to see them separately.

How do you change the matching rules?

Edit the rule words for the keys you want to match on, such as item and location. You can also change the calculation text to use a different subtraction order or add other fields.