restaurant opening checklist excel free download pdf

Daily Restaurant Operations Opening Protocol

This document serves as the standardized operational framework for ensuring [Company Name] locations meet health, safety, and service readiness standards prior to the first customer arrival. This checklist should be completed daily by the [Shift Lead/Manager] and reviewed weekly by the [General Manager] to ensure consistency and compliance.

Column Definitions

• Item Category: (Text) The functional department responsible for the task.
• Task Description: (Text) Specific actionable instruction to be performed.
• Priority: (Dropdown) Validation: {Critical, High, Medium, Low}.
• Status: (Checkbox) Logical boolean; true if checked, false if empty.
• Verified By: (Text) Employee initials or name of the individual completing the task.
• Notes/Defects: (Text) Free-form entry for reporting maintenance issues or exceptions.

Essential Formulas

Task Completion Percentage Use this formula to track the overall readiness of the shift:

=COUNTIF(D2:D6, TRUE) / COUNTA(B2:B6)

Critical Item Alert Use this formula to flag if any "Critical" tasks remain incomplete:

=IF(AND(C2="Critical", D2=FALSE), "ACTION REQUIRED", "OK")

Formatting and Validation Rules

1. Data Validation (Dropdown): Highlight the "Priority" column. Go to Data > Data Validation > Criteria: List of items > Enter: Critical, High, Medium, Low.
2. Conditional Formatting (Alerts): Highlight the "Status" column. Set rule: If cell is empty, change background color to light red. If cell is checked (TRUE), change background color to light green.
3. Conditional Formatting (Highlight Critical): Highlight the entire row if "Priority" equals "Critical". Set rule: Formula is =$C2="Critical", style: Bold text with a light orange fill.