What is in the template
This stock adjustment form is a log of manual corrections to your on-hand inventory: shrinkage, damage, expired goods, count corrections and found stock. Each row records the item, location, quantity before, quantity after, the difference, a reason code and who approved it.
Use it after a cycle count or whenever someone needs to change a quantity by hand. The point is accountability: an unexplained adjustment is either a mistake or a leak, and the log lets you tell which. Review the reason codes every month to see which causes repeat.
The sample rows are fictional and can be deleted. The file is plain comma-separated text, so it opens in Excel, Google Sheets and Numbers; add formulas for any calculated columns after you import it.
Columns explained
| Adjustment_ID | Unique reference for the adjustment. |
| Date | Date the change was made. |
| SKU | Item code that was adjusted. |
| Product_Name | Name of the item. |
| Location | Bin or shelf where the change applies. |
| Quantity_Before | On-hand quantity before the adjustment. |
| Quantity_After | On-hand quantity after the adjustment. |
| Difference | After minus before; negative means a reduction. |
| Reason_Code | Standard reason such as DAMAGED, EXPIRED or COUNT_CORRECTION. |
| Approved_By | Person who authorised the change. |
| Notes | Free text for context. |
Where a spreadsheet template breaks down
A spreadsheet log does not change your stock: the adjustment still has to be entered in the inventory record, which means two steps that can get out of sync. It also has no approval workflow, so nothing stops a row from being added without sign-off.
Over time the log grows long and is hard to search by item or by date range, and there is no automatic link to the stock count that triggered the change.
Related resources
Trusted by small businesses
What our customers say
“Super Kind! Quick replies from their support and very easy fixes, changed the dashboard a bit and customized it. Also gave me 450 items extra on the free plan just for me. Highly recommend and again great service!”
“Best customer service! Stockflow's customer support is fast and extremely helpful. They assisted me with customization of the software to improve my experience as a user.”