Hotel Employee Recognition Program Planner: Employee of the Month and Staff Awards Spreadsheet
Full description
For hotel HR managers, general managers and department heads who run Employee of the Month and other staff awards. You design the programme once, log nominations and peer thanks cards by staff code, and let a weighted scoring matrix rank the candidates for each award and period. The workbook keeps a winners register, tracks spending against a monthly plan, shows which departments take part and builds certificate and announcement wording for any award.
Save with a bundle: this template is also in the Hotel People & Leadership Bundle, 10 templates for $29 instead of $69. All 141 templates are in the All-Access Hospitality Template Library for $79.
What is inside
- Hotel_Employee_Recognition_Program_Planner.xlsx: 9 tabs, 5,309 formulas, 3 native charts, 23 drop-down or number rules.
- Settings: year, annual budget, report month, reach target, budget tolerance, 10 departments with headcount and all drop-down lists.
- Programme_Design: 9 award types (monthly, quarterly, annual and peer thanks) with frequency, winners, who nominates, eligibility, prize, value and planned annual cost. Budget check, programme calendar and 8 programme rules.
- Nominations: room for 600 nominations and peer thanks cards (258 sample rows). Period, panel score and checks for repeat winners, missing scores and late decisions calculate.
- Scoring: scoring matrix with 5 weighted criteria and descriptions for scores 1, 3 and 5. Panel sheet for 300 scored nominations (95 sample rows) with weighted score, rank and a recommendation.
- Winners: register for 120 winners (24 sample rows) with prize, value, certificate and prize status, and a check against the nominations log.
- Budget: 12-month plan against actual spend with status flags, spend by 7 categories and a spend log for 300 entries (50 sample rows), plus 1 chart.
- Certificate_Wording: certificate builder for any award and a wording bank with a headline, citation and announcement for each of the 9 awards.
- Dashboard: 8 KPI tiles, department participation table with reach %, monthly activity and 2 charts on one page.
- README.txt and LICENSE-and-Terms.txt.
How it works
- Enter the year, budget, report month and departments with headcount on Settings.
- Edit the award types, prizes and values on Programme_Design and check the plan against the budget.
- Log nominations and peer thanks cards, then score each award period in Scoring.
- Record winners, log every spend and print certificates from the builder.
- Read the Dashboard each month to see reach by department and spend against plan.
Details
- Format: Excel workbook (.xlsx). No macros.
- Language: English. Currency is a label you choose.
- Software: Excel 2016 or later, or a spreadsheet program that opens .xlsx files.
- Delivery: instant digital download. Nothing is shipped.
Good to know
- All sample nominations, scores, winners and spending are illustrative. Replace them with your own data.
- Use staff codes in the logs. Names appear only on printed certificates and announcements.
- Prizes and vouchers may be taxable for staff. This is not tax or HR advice; verify local requirements.
- Single-user license. Do not share or resell the files.
FAQ
Can I change the awards?
Yes. Rename awards, change the frequency, winners per period, prize and value on Programme_Design. Every drop-down and the budget plan update.
How does the scoring work?
Panel members score each nomination 1 to 5 on 5 criteria. The weights you set turn the scores into one weighted score, and the sheet ranks nominations within each award and period.
Can I print certificates?
Yes. Choose the award, type the recipient, department and period, and print the certificate area. Wording for all 9 awards is editable.
Does it work in Google Sheets?
It opens in Google Sheets and the formulas calculate. Check the drop-downs and charts after import.
Is this a physical product?
No. It is a digital download. Refund terms follow the store policy at the time of purchase.
