← All use cases
Example rows with sample data
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.
| Status | Key | What changed | Old value | New value |
|---|---|---|---|---|
| changed | ITEM-014 | Stock | 120 | 96 |
| changed | ITEM-077 | Location | A2 | B4 |
| added | ITEM-190 | New row | — | Label roll · 60 |
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.