Tracking Performance: The Item Sales Trend Report 📈☕

Ever wonder if a sudden drop in a dish's sales is just a temporary slow day or part of a bigger problem? The Item Sales Trend Report is designed to answer one crucial question: "How is each menu item performing right now compared to this week, this month, and this year?"

This report gives you an instant performance snapshot for every single item on your menu, letting you cross-reference today's numbers with your long-term averages. It takes the guesswork out of your sales volume so you can make informed decisions on the fly. 🎯

📊 What You'll See on the Report

The data is cleanly organized to help you compare short-term performance against long-term historical trends side-by-side.

• Sales Category Grouping: All items are neatly grouped by their designated sales categories (e.g., Hot Beverages, Bakery).

• Four-Tier Matrix: Next to each item, you will see four distinct time periods tracking both the Quantity (Qty) sold and the Gross Revenue ($) generated.

• The Anchor Date: The Day column always reflects the single most recent business date in your selected data. The Week, Month, and Year columns automatically roll up all dates within those respective calendar boundaries to give you an accurate, direct comparison.

📝 Report Example

🔍 How the Time Periods Work

To keep your data perfectly aligned, the report uses your most recent business date as a solid anchor point, calculating backwards using standard calendar rules:

💡 Remember: These periods naturally overlap! The Week column already includes your Day numbers, the Month includes the Week, and the Year includes everything. Reading from left to right lets you see exactly how today fits into the bigger picture.

🛠️ Strategic Ways to Use This Data

This report is a goldmine for managing your menu and training your staff. Here is how to put these trends to work:

• Daily Check-ins: Quickly spot items that are underperforming today compared to their usual weekly or monthly baseline. If an item has a low day count but a strong week, it's just a slow day. But if the day and week counts are both dropping, it might signal an inventory shortage or a quality issue. 🚨

• Spotting Seasonal Trends: Compare your month-to-year ratios to easily identify items with seasonal demand spikes or declines (like iced coffee surging in July or hot cider spiking in October). 🍂☀️

• Menu Pruning: Items that show consistently low numbers across all four time periods are your prime candidates for removal, a recipe makeover, or a price adjustment. ✂️

• Staff Focus & Incentives: If an item has incredible year-to-date numbers but recent weeks look weak, it’s a perfect target for your next pre-shift meeting. Encourage your servers to give it a renewed promotional push on the floor! 🗣️

• New Item Tracking: When you add something new to the menu, it will naturally have very low Year numbers. A healthy sign of customer adoption is seeing those Week and Month counts grow steadily over time. 🚀

🎛️ Filters Available

You can customize your view using the built-in filters in the NX Portal to zero in on specific data sets:

• Sales Categories: Limit your results to focus on one or more specific categories (e.g., viewing only Liquor or Appetizers).

• Include Items with No Sales: Toggle this on to display items that exist on your menu but haven't sold at all during the selected periods—perfect for identifying dead weight.

• Include Zero-Priced Items: Choose whether to show or hide complimentary, promotional, or $0.00 items on your trend lines.

Need Help? 💡

My "Day" column is showing yesterday's date instead of today's.

The report anchors itself to the most recent closed business date available in your selected data pool. If your current shift is still active and open, the system will use your last fully finalized business day as the anchor point.

An item I know we sold isn't showing up on the report.

Double-check your filter settings! If the item is a promotional giveaway or a zero-priced modification, it may be hidden. Make sure the Include Zero-Priced Items filter is toggled on.

Still fine-tuning your back-office data analysis?

Reach out to your local NX Restaurant Support Team or check out our guide on Understanding the Product Mix (P-Mix) Report to master your inventory volume! 🆘✨