1. Navigate to “Stock Report” #

1. Log in to your restaurant management system.
2. In the sidebar, click Reports.
3. Under Reports, select Stock Report.
4. The Stock Report page will open showing:
• A “Stock Report” header at the top of the page.
• A ▼ Filters section with comprehensive filtering options.
• Four key metric cards displaying:
  • Closing stock (By purchase price) with refresh icon
  • Closing stock (by sale price) with refresh icon
  • Potential profit: AED 16,902.87
  • Profit Margin %: 28.44
• Export buttons for CSV, Excel, Print, Column Visibility, and PDF.
• A comprehensive data table with multiple columns for detailed stock analysis.

2. Understanding the Stock Report #

The Stock Report is the most comprehensive inventory analysis tool in your restaurant management system:

• Complete Inventory Overview – View all products with current stock levels and values.
• Profitability Analysis – Calculate potential profit and margins for inventory on hand.
• Valuation Methods – View inventory value at both purchase price and sale price.
• Multi-Location Tracking – Monitor stock across different business locations.
• Category Analysis – Analyze inventory by product categories and subcategories.
• Unit Management – Track stock in various measurement units.
• Financial Planning – Use for budgeting, forecasting, and financial reporting.

3. Understanding Key Metrics #

The top section displays four critical inventory metrics:

4. Configure Stock 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” for consolidated inventory view.
     • Select specific location for location-specific analysis.
   • Sub Location – Narrow down to specific areas:
     • Select “All” for all sub-locations within chosen location.
     • Choose specific sub-location (e.g., kitchen, bar, storage).
   • Category – Filter by product category:
     • Select “All” to view all product categories.
     • Choose specific category for focused analysis.
   • Sub category – Drill down further:
     • Select “All” for all subcategories.
     • Choose specific subcategory for detailed view.
   • Brand – Filter by product brand:
     • Select “All” to view all brands.
     • Choose specific brand for brand analysis.
   • Unit – Filter by measurement unit:
     • Select “All” to view all units.
     • Choose specific unit (e.g., kg, liters, pieces).
   • Product – Search for specific product:
     • Select “All” to view all products.
     • Type product name for specific item analysis.
   • Only manufactured products – Checkbox filter:
     • Check to show only in-house manufactured items.
     • Useful for analyzing prepared vs. purchased inventory.

5. Understanding the Stock Report Table Columns #

The comprehensive data table displays detailed information across multiple columns:

6. Analyzing Profit Potential #

The Stock Report provides powerful profitability analysis capabilities:

• Potential Profit Calculation:
  • Formula: Closing Stock (Sale Price) – Closing Stock (Purchase Price) = Potential Profit.
  • Example: AED 16,902.87 represents maximum profit if all inventory sells.
  • This is gross profit before operating expenses.
• Profit Margin Analysis:
  • Formula: (Potential Profit ÷ Closing Stock Sale Price) × 100 = Profit Margin %.
  • Example: 28.44% indicates healthy markup on inventory.
  • Compare with industry benchmarks (restaurants typically 25-35%).
• Product-Level Profitability:
  • Review “Current Stock Value (Potential profit)” column for each product.
  • Identify high-profit vs. low-profit items.
  • Optimize inventory mix toward higher-margin products.
• Strategic Applications:
  • Focus purchasing on high-margin items.
  • Consider discontinuing low-margin products.
  • Adjust pricing to improve overall margin.
  • Negotiate better purchase prices for low-margin items.

7. Multi-Location Stock Management #

For restaurant chains, location-based stock analysis is essential:

1. Business Location Filter:
   • Select “All locations” for company-wide inventory overview.
   • Choose specific location for branch-level analysis.
   • Compare stock levels across different branches.
2. Sub Location Tracking:
   • Drill down to specific storage areas within locations.
   • Examples: Main Kitchen, Bar, Dry Storage, Walk-in Cooler.
   • Optimize storage space utilization.
   • Improve inventory organization and accessibility.
3. Transfer Analysis:
   • Use “Total Unit Transferred” column to track movement.
   • Identify locations that frequently need transfers.
   • Optimize initial stock allocation to reduce transfers.
   • Balance inventory across locations efficiently.

8. Category and Subcategory Analysis #

Organize and analyze inventory by product groupings:

• Category-Level Insights:
  • Filter by category to analyze specific product groups.
  • Examples: Beverages, Proteins, Produce, Dry Goods, Dairy.
  • Calculate category-specific profit margins.
  • Identify which categories hold most inventory value.
• Subcategory Drill-Down:
  • Further segment within categories for detailed analysis.
  • Example: Beverages → Alcoholic → Wine → Red Wine.
  • Identify best and worst performing subcategories.
  • Make informed decisions about product mix.
• Strategic Applications:
  • Allocate budget based on category performance.
  • Adjust menu offerings based on category profitability.
  • Negotiate category-specific supplier contracts.
  • Optimize storage space by category importance.

9. Export and Column Visibility Options #

The report provides comprehensive export and customization options:

• Column Visibility Tips:
  • Hide unused custom fields to simplify view.
  • Show only relevant columns for specific analysis.
  • Create different views for different purposes.
  • Reduce clutter for better readability.

10. Analyzing Stock Movement #

Track how inventory moves through your system:

1. Total Unit Sold:
   • Shows sales velocity for each product.
   • Identify fast-moving vs. slow-moving items.
   • Calculate inventory turnover rates.
   • Optimize ordering based on sales patterns.
2. Total Unit Transferred:
   • Track movement between locations or sub-locations.
   • Identify products that require frequent transfers.
   • Optimize initial stock allocation.
   • Reduce transfer costs and inefficiencies.
3. Total Unit Adjusted:
   • Monitor inventory corrections and adjustments.
   • Identify products with frequent adjustments.
   • Investigate causes of adjustments.
   • Improve inventory accuracy and controls.
4. Turnover Analysis:
   • Calculate: Total Unit Sold ÷ Current Stock Available.
   • High turnover = efficient inventory management.
   • Low turnover = potential overstocking or slow sales.
   • Adjust ordering to optimize turnover rates.

11. Manufactured Products Analysis #

The “Only manufactured products” filter provides specialized insights:

• What are Manufactured Products?
  • Items prepared in-house from raw ingredients.
  • Finished dishes assembled from components.
  • Value-added products created from purchased goods.
• Analysis Benefits:
  • Calculate true cost of goods for prepared items.
  • Analyze profitability of in-house production.
  • Compare manufactured vs. purchased product margins.
  • Make informed make-vs-buy decisions.
• Strategic Applications:
  • Identify most profitable manufactured items.
  • Optimize recipes and production processes.
  • Determine optimal production quantities.
  • Balance labor costs with ingredient costs.

12. Inventory Valuation Methods #

Understanding different valuation approaches is crucial:

• Purchase Price Valuation:
  • Shows actual cost invested in inventory.
  • Used for financial reporting and tax purposes.
  • Represents cash tied up in stock.
  • Important for cash flow management.
• Sale Price Valuation:
  • Shows potential revenue from current inventory.
  • Used for sales forecasting and planning.
  • Represents maximum possible revenue.
  • Important for revenue projections.
• Potential Profit:
  • Difference between sale and purchase valuations.
  • Shows gross profit potential.
  • Excludes operating expenses.
  • Used for profitability analysis.
• Financial Reporting:
  • Use purchase price for balance sheet reporting.
  • Follow accounting standards (FIFO, LIFO, weighted average).
  • Maintain consistency in valuation methods.
  • Document valuation methodology for audits.

13. Best Practices for Stock Report Analysis #

• Regular Review Schedule – Run stock report weekly or monthly for consistent monitoring.
• Comparative Analysis – Compare current stock levels with previous periods to identify trends.
• Turnover Optimization – Focus on improving turnover rates for slow-moving items.
• Profit Margin Monitoring – Track profit margin percentage and take action if it declines.
• Category Balance – Ensure appropriate inventory distribution across categories.
• Location Optimization – Balance stock levels across multiple locations efficiently.
• Dead Stock Identification – Identify and address items with zero sales and high stock.
• Reorder Point Setting – Use current stock and sales data to set optimal reorder points.
• Seasonal Adjustment – Adjust stock levels based on seasonal demand patterns.
• Cost Control – Monitor purchase prices and negotiate better rates for high-volume items.
• Data Export – Regularly export data for long-term trend analysis and record-keeping.
• Physical Counts – Verify system stock levels with regular physical inventory counts.

14. Troubleshooting Common Issues #

15. Done! 🎉 #

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

• Monitor complete inventory position with detailed stock levels
• Analyze profitability with potential profit and margin calculations
• Track inventory movement through sales, transfers, and adjustments
• Manage multi-location inventory efficiently
• Make data-driven decisions about purchasing and pricing
• Optimize inventory investment and cash flow
• Identify opportunities to improve margins and reduce waste

Use this report regularly to maintain optimal inventory levels, maximize profitability, and ensure efficient operations! 📊💰