1. Navigate to “Items Report” #

1. Log in to your restaurant management system.
2. In the sidebar, click Reports.
3. Under Reports, select Items Report.
4. The Items Report page will open showing:
   • A “Items Report” header at the top of the page.
   • A ▼ Filters section with multiple filtering options.
   • Export buttons for CSV, Excel, Print, Column Visibility, and PDF.
   • A comprehensive data table with product transaction details.
   • Total summary row showing aggregate values (AED 0.00 when no data).

2. Understanding the Items Report #

The Items Report is a powerful analytical tool that provides comprehensive insights into product transactions across your restaurant operations:

• Complete Transaction History – Track every product purchase and sale transaction in one place.
• Purchase and Sales Integration – View both purchase and selling activities for each item.
• Profitability Analysis – Compare purchase prices with selling prices to calculate margins.
• Supplier Performance – Analyze which suppliers provide which products and at what cost.
• Customer Insights – Track which customers purchase specific items.
• Inventory Movement – Monitor product flow from purchase to sale.
• Multi-Location Tracking – Analyze item performance across different business locations.

3. Configure Items Report Filters #

1. Click the ▼ Filters dropdown to expand filtering options.
2. Configure the following filter parameters:
   • Supplier – Filter by specific supplier:
     • Select “All” to view items from all suppliers.
     • Choose specific supplier to analyze their product performance.
     • Useful for supplier comparison and evaluation.
   • Purchase Date – Set purchase date range:
     • Format: DD/MM/YYYY – DD/MM/YYYY (e.g., 02/07/2026 – 03/07/2026).
     • Filter items based on when they were purchased.
     • Analyze purchasing patterns over specific periods.
   • Customer – Filter by customer:
     • Select “All” to view sales to all customers.
     • Choose specific customer to analyze their purchase history.
     • Track customer preferences and buying patterns.
   • Sell Date – Set sales date range:
     • Format: DD/MM/YYYY – DD/MM/YYYY (e.g., 04/07/2026 – 05/07/2026).
     • Filter items based on when they were sold.
     • Analyze sales performance over specific periods.
   • Business Location – Select location:
     • Choose “Please Select” to view all locations.
     • Select specific location for location-based analysis.
     • Compare performance across different restaurant branches.
   • Only manufactured products – Checkbox filter:
     • Check this box to show only manufactured/prepared items.
     • Useful for analyzing in-house production items.
     • Separate manufactured items from purchased goods.
3. Apply filters to generate customized report view.

4. Understanding Report Columns #

The Items Report displays comprehensive information across multiple columns:

5. Using Date Range Filters Effectively #

The dual date range system allows sophisticated analysis:

• Purchase Date Range:
  • Track when inventory was acquired.
  • Analyze procurement timing and frequency.
  • Identify seasonal purchasing patterns.
  • Monitor supplier delivery schedules.
• Sell Date Range:
  • Track when products were sold to customers.
  • Analyze sales velocity and turnover rates.
  • Identify peak sales periods.
  • Calculate inventory holding periods.
• Combined Analysis:
  • Compare purchase and sell dates to calculate inventory turnover time.
  • Identify slow-moving items with long holding periods.
  • Optimize ordering schedules based on sales patterns.

6. Supplier and Customer Analysis #

The report provides powerful supplier and customer filtering capabilities:

1. Supplier Analysis:
   • Filter by specific supplier to view all items purchased from them.
   • Compare purchase prices across different suppliers for same items.
   • Evaluate supplier reliability and product quality.
   • Identify preferred suppliers for specific product categories.
2. Customer Analysis:
   • Filter by specific customer to view their purchase history.
   • Identify customer preferences and buying patterns.
   • Track high-value customers and their favorite items.
   • Personalize marketing and inventory based on customer data.
3. Relationship Mapping:
   • Connect supplier products to customer preferences.
   • Optimize procurement based on customer demand.
   • Identify opportunities for direct supplier-to-customer value chains.

7. Manufactured Products Filter #

The “Only manufactured products” checkbox provides specialized filtering:

• What are Manufactured Products?
  • Items prepared or assembled in-house from raw ingredients.
  • Finished dishes created from recipe components.
  • Value-added products made from purchased ingredients.
• Use Cases:
  • Analyze profitability of in-house prepared items.
  • Track production efficiency and costs.
  • Compare manufactured vs. purchased product performance.
  • Calculate true cost of goods for prepared dishes.
• Analysis Benefits:
  • Identify most profitable manufactured items.
  • Optimize recipes and production processes.
  • Make informed decisions about make vs. buy.

8. Pagination and Display Controls #

Manage how data is displayed in the report:

• Show Entries Dropdown:
  • Default setting: 25 entries per page.
  • Options typically include: 10, 25, 50, 100 entries.
  • Adjust based on screen size and analysis needs.
  • Larger values reduce pagination but may slow loading.
• Navigation Controls:
  • Use “Previous” button to go to earlier pages.
  • Use “Next” button to advance to later pages.
  • Entry counter shows: “Showing 0 to 0 of 0 entries” when no data matches filters.
• Search Function:
  • Use search box in top right to quickly find specific items.
  • Searches across all visible columns.
  • Real-time filtering as you type.

9. Export and Print Options #

The report provides multiple export formats for data analysis and sharing:

10. Understanding the Total Row #

The report includes a summary total row at the bottom of the table:

• Total Label – Appears in the leftmost column.
• Aggregate Values – Shows totals for numeric columns:
  • Total purchase quantities across all filtered items.
  • Total sales quantities across all filtered items.
  • Total subtotal values (shows “AED 0.00” when no data).
• Dynamic Updates – Totals recalculate automatically when filters change.
• Multi-Currency Support – Displays in configured currency (AED in this example).
• Analysis Use:
  • Quick overview of total transaction values.
  • Compare purchase costs vs. sales revenue.
  • Calculate gross profit margins.

11. Profitability Analysis Using Items Report #

Use the Items Report to calculate and analyze product profitability:

1. Gross Profit Calculation:
   • Formula: Selling Price – Purchase Price = Gross Profit per Unit.
   • Multiply by Sell Quantity to get total gross profit.
   • Export to Excel for automated calculations.
2. Margin Analysis:
   • Calculate profit margin: (Gross Profit ÷ Selling Price) × 100.
   • Identify high-margin vs. low-margin products.
   • Optimize menu pricing based on margin analysis.
3. Product Performance Ranking:
   • Rank products by total profit contribution.
   • Identify star performers and underperformers.
   • Make data-driven decisions about menu composition.
4. Cost Trend Analysis:
   • Track purchase price changes over time.
   • Identify cost inflation or deflation trends.
   • Adjust selling prices to maintain margins.

12. Inventory Turnover Analysis #

Use purchase and sell dates to analyze inventory movement:

• Turnover Time Calculation:
  • Calculate days between purchase date and sell date.
  • Identify fast-moving vs. slow-moving items.
  • Optimize inventory levels based on turnover rates.
• Freshness Management:
  • Critical for perishable food items.
  • Ensure products are sold before expiration.
  • Reduce waste through better turnover management.
• Ordering Optimization:
  • Order fast-moving items more frequently in smaller quantities.
  • Reduce order frequency for slow-moving items.
  • Balance inventory holding costs with ordering costs.
• Lot Number Tracking:
  • Use lot numbers to track specific batches.
  • Implement FIFO (First In, First Out) inventory management.
  • Trace products for quality control and recalls.

13. Best Practices for Items Report Analysis #

• Regular Review Schedule – Run weekly or monthly reports to stay informed about product performance.
• Comparative Analysis – Compare current period with previous periods to identify trends.
• Multi-Dimensional Filtering – Combine multiple filters for deeper insights (e.g., specific supplier + date range + location).
• Export for Advanced Analysis – Use Excel exports to create pivot tables, charts, and custom calculations.
• Supplier Performance Reviews – Regularly analyze supplier data to optimize procurement relationships.
• Customer Preference Tracking – Use customer filters to understand buying patterns and preferences.
• Location Comparison – Compare item performance across different restaurant locations.
• Profitability Focus – Prioritize high-margin items in menu planning and promotions.
• Inventory Optimization – Use turnover data to optimize stock levels and reduce waste.
• Data Validation – Regularly verify that all transactions are properly recorded in the system.

14. Troubleshooting Common Issues #

15. Done! 🎉 #

Congratulations! You now have a comprehensive understanding of the Items Report feature. This powerful analytical tool enables you to:

• Track complete product lifecycle from purchase to sale
• Analyze profitability and margins for each item
• Evaluate supplier and customer relationships
• Optimize inventory turnover and reduce waste
• Make data-driven decisions about menu composition and pricing
• Monitor performance across multiple business locations

Use this report regularly to maintain control over your product operations and maximize profitability! 📊💰