Resources & guides Stock & costs
Count your stock
Do a full or partial stock count with a printed sheet, then bring the numbers into Batcher in one import.
Why count
Batcher keeps a running count as you receive deliveries, start batches and log scrap. Real shelves drift: a spill nobody logged, a miscount on a delivery, a few labels used for samples. A count every month or two puts Batcher back in line with what's actually there.
What you need
- The stock count sheet. It opens in Excel, Google Sheets or Numbers.
- About 30 minutes for a small workshop, longer for a big one. You don't have to count everything at once.
Step by step
- List what you're counting. Type the names of the materials and products into the Name column, spelled the way they are in Batcher. Adding the SKU too makes matching certain.
- Print it, or open it on a tablet. The Where it lives column helps you walk the shelves in order.
- Count and write what you find in On hand (counted), in the item's own unit: 11.5 yards, 46 labels, 3 sides. Use numbers only.
- Leave a row blank if you didn't count it. Blank rows don't change anything.
- Import it. In Batcher go to Inventory, tap Import or update from a spreadsheet, and choose the file. Batcher matches On hand (counted) to On hand on its own.
- Check the preview. Every item you counted shows its old and new stock, like On hand 40 → 46 units. Tap Import when it looks right.
What Batcher records
Each difference is saved as a stock adjustment with the note "Stock count (spreadsheet import)", so the item's history shows when the count happened and by how much it changed. Your activity log shows who imported the count.
Tips
- Count when nothing is moving: before you start for the day, or after a market.
- Count partly made work separately. If you track parts you make (like cut panels), count those too, or finish the batch first.
- Big gaps are worth a look. A material that's always short might have more offcut than its recipe allows. Raise its scrap % in the recipe so your costs stay honest.