Daily Bar Stock Control Sheet — Stop Guessing, Start Tracking.

Every bar owner in Kenya knows the feeling — closing stock doesn't match what it should, and you have no idea if it's theft, free pours, breakages, or just bad counting.

This ready-to-use Excel sheet fixes that. Just fill in your opening stock, purchases, and transfers — it automatically calculates what your closing stock should be. Compare that to your actual count at the end of the day, and the sheet flags every variance in red or green so you know exactly where stock is walking out the door.

What's inside:

✅ Automatic stock ladder (Opening → Purchases → Transfers → Sales → Expected Closing)

✅ Instant variance flagging (red = shortage, green = surplus)

✅ Variance valued in KES so you see the real cost, not just the count

✅ Built-in example row + step-by-step "How To Use" tab

✅ Works in Excel and Google Sheets — no formulas to learn, just type numbers

No accounting degree needed.

If you can count bottles, you can run this.

Instant digital download. Use it from tonight's closing count.