Batch and Expiry Date Tracking Sheet
Manage perishable or batch-tracked stock.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
Build a sheet to manage batch-tracked and perishable stock. Products and requirements: [PRODUCTS_AND_REQUIREMENTS]. Storage locations: [LOCATIONS]. Rules or customer requirements I know of: [RULES]. Spreadsheet app: [SPREADSHEET_APP]. Design the workbook and check each item: [ ] Batch register: Batch ID | Product | Supplier | Received date | Expiry date | Quantity received | Quantity on hand | Location | Status (available, quarantined, expired, recalled, disposed) [ ] Days to expiry formula and flags at 90, 60, and 30 days with colors [ ] First-expired-first-out pick suggestion: formula or sorted view that lists the batch to pick first for each product [ ] Movement log: Date | Batch | Type (in, out, adjustment, waste) | Quantity | Order or reason | Person [ ] Quantity on hand reconciled from the movement log, with a check against physical counts [ ] Customer and order linkage so I can trace every batch to the customers who received it [ ] Recall lookup: enter a batch ID and list the orders, customers, and quantities [ ] Disposal log with method, date, and approval [ ] Monthly expiry report: items expiring in the next 90 days and waste value last month [ ] Access control and a record of changes Provide formulas for my app, six sample batches in different states (including one near expiry and one recalled) with expected results, and a labeling guide. Regulations vary by product; list what I must verify [VERIFY]. Use the result as a draft; it does not provide legal or compliance advice. Run legal, regulatory, consent and contractual points past a qualified professional who works in [JURISDICTION] first.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.