Neha-Hafeez/Excel-based-Inventory-Management-System-with-Dashboards-and-POS-System — reverse-engineered prompt

Build me a simple Excel based inventory and shop management workbook for a small stationery business. I want it to feel easy to use for someone who is not technical, with a clean dashboard and buttons to move between sections.

It should have stock management for purchases and sales, including stock inward, stock outward, and a net stock view. Show item name, quantity, buy price, sale price, purchase date, total spent, total earned, and a profit or loss view. Please include a low stock alert when an item reaches the minimum level.

I also want a point of sale screen where I can enter or scan an item, set quantity and price, save the sale, and generate a receipt on a separate sheet.

Please add a customer section to store name, phone number, purchased items, total bill, and whether they paid or took credit. Make the dashboard show useful summaries and charts for stock and sales. Use Excel formulas and VBA if needed, and look up current Excel macro best practices online if you need to.