Excel Retail Profit & Expense Tracker

I’d like an Excel-based workbook that lets me log sales and expenses for my retail operation and instantly see my profit or loss. The file should do more than just total columns—I need meaningful sales analytics and clear expense categorization so I can spot trends without manual number-crunching.

Core requirements
• Simple data-entry sheets for daily sales and for each expense type, with drop-down categories I can edit later.
• Automated calculations that roll into a clean Profit & Loss summary.
• Interactive sales analytics: charts, pivot tables or a small dashboard that highlights best-selling items, daily/weekly revenue, and margins.
• Built-in expense categorization so I can filter or pivot by cost type.
• All formulas locked from accidental edits, with a brief “how-to” tab explaining where to input data and how to refresh reports.

I’m fine with standard Excel functions, Power Query or light VBA—as long as everything runs inside a single workbook and works on current Microsoft 365. Please deliver the finished .xlsx (plus macro-enabled version if VBA is used) populated with a small set of sample data so I can verify everything calculates correctly.