I can provide your an Excel workbook to manage your Warehouse Inventory with batch & expiry date.
In this workbook includes below mention sheets
Product Master
Supplier Master
Opening Stock
Inbound Stock
Outbound Stock
Damage Stock
Return Stock
Product Report Batch & Expiry Wise
Product Summary
Supplier Summary
Warehouse Occupancy / Allocation Report
Above mention sheets will be change / add as per your business needs.