Excel Tracker for Grocery Finances

I need a single, well-structured Excel workbook that lets me keep my grocery shop’s day-to-day numbers in one place. The file should contain three linked sheets:

• Inventory – captures each product name, current quantity on hand and cost/retail price.
• Vendor Payments – records every payment date, the amount paid, the vendor’s running balance and the next payment due date.
• Payment List – shows upcoming payment due dates alongside what has already been received and any outstanding balances.

Formulas must automatically update stock totals as I enter new purchases or sales, adjust vendor balances after each payment, and flag items that reach low stock or bills that approach their due date. A dashboard or simple summary at the top that highlights low inventory and overdue payments will make daily checks faster.

Clean layout, drop-down data validation for vendors and products, conditional formatting for expiry alerts (where relevant) and protection on formula cells will keep the workbook fool-proof for my staff. Please deliver the finished .xlsx file, ready for me to start entering data, along with a short set of instructions so I can add new vendors or products later without breaking any formulas.