Excel Inventory Inward-Outward Tracking -- 2

I need a streamlined way to record every inward and outward movement of stock so that my running balance is always accurate. The only details I want captured are the product name and its quantity; anything more slows my team down.

My preference is to work in MS Excel because everyone here already uses it daily, yet the final sheet must be formatted so it can feed data into our existing custom billing software that issues GST invoices and e-way bills for wholesale orders. A clean CSV export or a lightweight macro that pushes the figures across will do the job—whichever you feel is the quickest to maintain.

Deliverables
• A ready-to-use Excel workbook with clearly separated inward, outward, and live-stock sheets, plus built-in checks that flag negative or mismatched quantities.
• Back-entry of recent movements (exact period to be agreed) so the file opens with current, accurate stock.
• A short, plain-language guide for my staff explaining daily data entry and the export or sync process.
• One revision round after we test the workbook inside our billing-and-e-way-bill workflow.

Acceptance criteria
The closing stock in Excel must match the physical count I provide at hand-over, and the exported file must import into our custom software without adjustment.