1. Navigate to “Service Staff Report” #

1. Log in to your restaurant management system.
2. In the sidebar, expand the Reports section.
3. Locate and click on Service Staff Report.
4. The Service Staff Report page will open showing:
   • A ▼ Filters section with filter options.
   • Filter fields for:
     • Business Location – Select location (dropdown showing “All locations”).
     • Service Staff – Select specific staff member (dropdown showing “All”).
     • Date Range – Set start and end dates (e.g., 02/01/2026 – 02/26/2026).
   • Two tabs for different views:
     • Orders – Summary view of staff performance.
     • Line Orders – Detailed line-item view of orders.
   • Export buttons: Export to CSV, Export to Excel, Print, Column Visibility, and Export to PDF.
   • A data table with columns:
     • Date – Transaction date and time (e.g., 02/01/2026 20:50).
     • Invoice No. – Order reference number (e.g., 1240, 1236).
     • Service Staff – Staff member who served (e.g., John, Mike Driver, Mohammed Al Tamimi).
     • Location – Business location (e.g., Restaurant).
     • Subtotal – Order subtotal before discounts and tax (e.g., 28.00, 50.00).
     • Total Discount – Discounts applied (e.g., AED 0.00).
     • Total Tax – Tax amount (e.g., 0.00).
     • Total Amount – Final order total (e.g., 35.00, 65.00).
   • Search functionality and pagination controls (Show 25 entries).

2. Understanding Service Staff Report #

Service Staff Report is a comprehensive performance tracking tool for monitoring and analyzing individual staff member contributions:

• Performance Measurement – Track sales, orders, and revenue generated by each service staff member.
• Commission Calculation – Calculate commissions and incentives based on individual sales performance.
• Productivity Analysis – Measure staff efficiency, average order value, and customer service metrics.
• Accountability – Assign orders to specific staff members for accountability and quality control.
• Training Needs Identification – Identify staff members who need additional training or support.
• Scheduling Optimization – Optimize staff schedules based on performance and sales patterns.
• Incentive Programs – Support performance-based incentive and recognition programs.
• Customer Service Quality – Monitor discount usage and order patterns to assess service quality.

3. Configure Service Staff Report Filters #

1. Click the ▼ Filters dropdown to expand filtering options.
2. Configure the following filter parameters:
   • Business Location – Select reporting scope:
     • Choose “All locations” to view staff performance across all locations.
     • Select specific location to analyze staff at individual restaurant.
     • Useful for:
       • Multi-location chains to compare staff across branches.
       • Location-specific performance reviews.
       • Identifying top performers at each location.
   • Service Staff – Select specific staff member:
     • Choose “All” to view all staff members’ performance.
     • Select specific staff name (e.g., “John”, “Mike Driver”, “Mohammed Al Tamimi”).
     • Useful for:
       • Individual performance reviews.
       • Commission calculations for specific staff.
       • Investigating specific staff member’s orders.
       • Training and coaching sessions.
   • Date Range – Set the reporting period:
     • Enter start date in format: DD/MM/YYYY (e.g., 02/01/2026).
     • Enter end date in format: DD/MM/YYYY (e.g., 02/26/2026).
     • Common date ranges:
       • Daily – Single day for shift performance review.
       • Weekly – 7-day period for weekly performance tracking.
       • Bi-weekly – 14-day period for payroll cycles.
       • Monthly – Full month for monthly performance reviews.
       • Custom – Any specific period for special analysis.
3. Apply filters to refresh the report data.
4. The table will update to show staff performance for your selected criteria.

4. Understanding the Orders Tab #

The Orders tab provides a summary view of each order handled by service staff:

5. Understanding the Line Orders Tab #

1. Click the Line Orders tab to view detailed line-item breakdown.
2. The Line Orders view shows:
   • Individual items within each order.
   • Product names and quantities.
   • Item-level pricing and discounts.
   • Detailed breakdown of what each staff member sold.
3. Use Cases for Line Orders View:
   • Analyze product mix sold by each staff member.
   • Identify upselling effectiveness (add-ons, premium items).
   • Track specific product sales by staff.
   • Verify order accuracy and item-level details.
   • Calculate product-specific commissions.

6. Calculate Staff Performance Metrics #

Use the report data to calculate key performance indicators for each staff member:

7. Analyze Staff Performance #

1. Top Performers Identification:
   • Export data to spreadsheet for analysis.
   • Sort by Total Amount to identify highest revenue generators.
   • Calculate metrics for each staff member.
   • Rank staff by:
     • Total sales revenue.
     • Number of orders served.
     • Average order value.
     • Sales per hour worked.
   • Recognize and reward top performers.
2. Upselling Effectiveness:
   • Compare Average Order Value across staff members.
   • Staff with higher AOV are more effective at upselling.
   • Identify best practices from top upsellers.
   • Train other staff on successful upselling techniques.
   • Use Line Orders tab to see which products top sellers recommend.
3. Discount Usage Analysis:
   • Review Total Discount column for each staff member.
   • High discount usage may indicate:
     • Unauthorized discounting.
     • Customer service recovery efforts.
     • Promotional activity participation.
   • Verify discounts are properly authorized.
   • Investigate excessive or unusual discount patterns.
4. Productivity Comparison:
   • Compare number of orders served by each staff member.
   • Consider factors affecting productivity:
     • Shift timing (lunch vs. dinner rush).
     • Day of week (weekday vs. weekend).
     • Location traffic patterns.
     • Staff experience level.
   • Set realistic productivity targets based on context.

8. Commission and Incentive Calculation #

• Sales-Based Commission:
  • Export staff report for commission period (weekly, bi-weekly, monthly).
  • Calculate total sales for each staff member.
  • Apply commission rate: Commission = Total Sales × Commission %
  • Example: If John generated AED 10,000 in sales with 3% commission rate:
    • Commission = AED 10,000 × 0.03 = AED 300
• Tiered Commission Structure:
  • Set different commission rates for different sales levels:
    • 0-5,000: 2% commission
    • 5,001-10,000: 3% commission
    • 10,001+: 4% commission
  • Motivates staff to achieve higher sales targets.
• Product-Specific Incentives:
  • Use Line Orders tab to track specific product sales.
  • Offer higher incentives for:
    • High-margin items.
    • New menu items requiring promotion.
    • Slow-moving items needing push.
• Performance Bonuses:
  • Set monthly or quarterly sales targets.
  • Award bonuses for exceeding targets.
  • Recognize top performers with additional incentives.
  • Create friendly competition among staff.

9. Export and Print Service Staff Report #

1. Export Options – Use the export buttons above the table:
   • Export to CSV – Comma-separated values format:
     • Opens in Excel, Google Sheets, or any spreadsheet application.
     • Ideal for commission calculations and analysis.
     • Easy to manipulate and create custom reports.
   • Export to Excel – Microsoft Excel format:
     • Preserves formatting and includes formulas.
     • Professional format for performance reviews.
     • Enables advanced Excel analysis (pivot tables, charts).
   • Export to PDF – Portable Document Format:
     • Professional format for performance documentation.
     • Suitable for employee files and HR records.
     • Maintains consistent formatting for sharing.
   • Print – Direct browser printing:
     • Quick physical copy for performance discussions.
     • Use for posting top performer rankings.
     • Handy for shift manager reference.
2. Column Visibility:
   • Click the Column Visibility button to customize displayed columns.
   • Show or hide specific columns based on your needs.
   • Simplify report for specific purposes (commission vs. performance review).

10. Search and Pagination #

1. Search Functionality:
   • Use the Search box on the right side above the table.
   • Search by:
     • Staff name (e.g., “John”, “Mike Driver”).
     • Invoice number (e.g., “1240”).
     • Location name.
     • Date or amount values.
   • Search is real-time and filters results as you type.
   • Clear search to return to full list.
2. Pagination Controls:
   • Show entries – Select number of rows per page:
     • 25 entries (default) – Good for quick review.
     • 50 or 100 entries – Better for comprehensive analysis.
     • Adjust based on data volume and screen size.
   • Previous/Next – Navigate between pages using buttons at bottom.
3. Column Sorting:
   • Click column headers to sort data.
   • Useful sorting options:
     • Sort by Total Amount to identify highest-value orders.
     • Sort by Service Staff to group orders by staff member.
     • Sort by Date to view chronological order.
     • Sort by Total Discount to identify high-discount orders.
   • Toggle between ascending and descending order.

11. Staff Performance Review Process #

1. Prepare for Review:
   • Run Service Staff Report for review period (monthly, quarterly).
   • Calculate all performance metrics for the staff member.
   • Compare with previous periods to identify trends.
   • Prepare specific examples of strong and weak performance.
2. Conduct Performance Discussion:
   • Share report data with staff member.
   • Discuss strengths:
     • High sales achievements.
     • Excellent upselling performance.
     • Consistent productivity.
   • Address areas for improvement:
     • Low average order value.
     • Excessive discount usage.
     • Below-target productivity.
   • Set specific, measurable goals for next period.
3. Create Action Plan:
   • Identify training needs based on performance gaps.
   • Set clear performance targets for next review period.
   • Provide resources and support to achieve goals.
   • Schedule follow-up check-ins to monitor progress.
4. Document Review:
   • Export report and save with employee file.
   • Document discussion points and action items.
   • Have staff member acknowledge review.
   • Maintain records for HR and compliance purposes.

12. Service Staff Report Best Practices #

• Regular Monitoring – Review staff performance weekly to identify issues early and provide timely feedback.
• Fair Comparison – Consider shift timing, day of week, and location when comparing staff performance.
• Transparent Metrics – Share performance metrics with staff so they understand how they’re evaluated.
• Positive Recognition – Publicly recognize and reward top performers to motivate entire team.
• Constructive Feedback – Provide specific, actionable feedback to help staff improve performance.
• Training Investment – Use report insights to identify training needs and invest in staff development.
• Incentive Alignment – Ensure incentive programs align with business goals (profitability, not just sales).
• Discount Control – Monitor discount usage closely and require authorization for significant discounts.
• Team Collaboration – Encourage top performers to mentor and share best practices with colleagues.
• Continuous Improvement – Regularly review and adjust performance targets based on business conditions.

13. Advanced Analysis Techniques #

• Time-Based Performance Analysis:
  • Compare staff performance across different time periods:
    • Lunch shift vs. dinner shift.
    • Weekday vs. weekend.
    • Month-over-month trends.
  • Identify optimal scheduling for each staff member.
  • Assign high performers to peak periods.
• Product Mix Analysis:
  • Use Line Orders tab to analyze what each staff member sells.
  • Identify staff who excel at selling:
    • High-margin items.
    • Premium products.
    • Add-ons and modifiers.
  • Train other staff on successful selling techniques.
• Customer Satisfaction Correlation:
  • Correlate staff performance with customer feedback and reviews.
  • Identify staff who generate positive customer experiences.
  • Address service quality issues with underperforming staff.
• Predictive Scheduling:
  • Analyze historical performance to predict future staffing needs.
  • Schedule optimal mix of high and developing performers.
  • Balance labor costs with service quality and sales targets.

14. Troubleshooting Common Issues #

15. Done! 🎉 #

You can now effectively track service staff performance, calculate commissions, conduct fair performance reviews, identify training needs, optimize scheduling, motivate your team, and drive sales excellence across your restaurant operations!