Automated Godown Inventory Tracker

I need a VBA-driven Excel workbook that keeps a live count of every kilogram of material flowing in or out of my godown. The core of the file will be a normalized table; all data should be fed through a simple text-based entry form so my shop floor staff can type, hit “Save”, and move on without hunting through sheets.

For every transaction the sheet must, at minimum, store the batch number. I’d like the structure to remain open to later add party or purchase-order fields without redesigning the database.

The workbook has to compile a clear daily summary report automatically at the click of a button (or on open). Weekly and monthly roll-ups would be nice to have, provided they don’t complicate the daily view.

Automation specifics
• VBA procedures should handle all calculations, pathing, and refresh actions—no manual recalc, no broken links after the file is moved.
• Running balances must update instantly so stock levels are always accurate.
• Navigation should be fool-proof: one button to enter data, one to view the latest report, and one to archive/roll over periods.

Acceptance criteria
– Entering a test batch adjusts stock totals correctly.
– The daily report matches manual calculations for the same sample day.
– No hidden references break when the file is copied to a new folder.

Tools & keywords to keep in mind: Excel 365, VBA, dynamic tables, PivotTable or Power Query (if helpful).

Once the workbook passes those checks, I’ll consider the project complete and ready for hand-off to my non-technical team.