Skip to content
SheetCompare is in private beta.Join the beta →
SheetCompare
Menu
← All use cases

Find stock changes between two inventory counts

Two inventory snapshots, one clear list of what changed in between.

How it works here

Keep each count in its own tab. With the item code as the key, the report lists items with a different quantity or location, plus items that appeared or disappeared.

Good key column: Item code or SKU.

StatusKeyWhat changedOld valueNew value
changedITEM-014Stock12096
changedITEM-077LocationA2B4
addedITEM-190New row—Label roll · 60
Example rows with sample data

Tips

  • Rows don't need to be in the same order. They are matched by key.
  • A number stored as text (for example '120') still matches the number 120.

Want to try it on sample data first? Download the sample files.