Google Sheets Stock Tracker

I need a straightforward Google Sheet that lets me record stock-in, stock-out, and keep an up-to-date stock card—all organized by product type. The sheet should:

• Capture each movement (date, product, quantity in, quantity out, balance).
• Auto-update a running balance per product on a dedicated “Stock Card” view.
• Generate a quick summary report—ideally a pivot or dashboard—so I can see current quantities and simple totals at a glance.

I’m aiming for a clean, easy-to-maintain file that I can duplicate whenever a new product line appears. No macros or add-ons are required; native Google Sheets formulas and basic data-validation dropdowns are enough for this first version.