1. Navigate to “Stock Adjustment Report” #

1. Log in to your restaurant management system.
2. In the sidebar, click Reports.
3. Under Reports, select Stock Adjustment Report.
4. The Stock Adjustment Report page will open showing:
   • A “Stock Adjustment Report” header at the top of the page.
   • A location filter dropdown showing “All locations” with blue icon.
   • A “Filter by date” button (purple) in the top right corner.
   • Summary cards displaying key metrics:
     • Total Normal: AED 0.00
     • Total Abnormal: AED 0.00
     • Total Stock Adjustment: AED 0.00
     • Total Amount Recovered: AED 0.00
   • A “Stock Adjustments” data table section.
   • Export buttons for CSV, Excel, and PDF formats.

2. Understanding Stock Adjustment Report #

The Stock Adjustment Report is a critical inventory management tool that tracks all inventory corrections and adjustments:

• Inventory Accuracy – Monitor and document all changes to inventory levels outside of normal transactions.
• Loss Prevention – Track abnormal adjustments that may indicate theft, waste, or errors.
• Financial Impact – Understand the monetary value of inventory adjustments.
• Audit Trail – Maintain complete records of who made adjustments and why.
• Accountability – Track which staff members are responsible for adjustments.
• Recovery Tracking – Monitor amounts recovered from inventory discrepancies.
• Operational Insights – Identify patterns in inventory adjustments to improve processes.

3. Understanding Summary Metrics #

The top section displays four key summary metrics that provide an overview of stock adjustments:

4. Configure Location Filter #

1. Location Dropdown:
   • Click the location dropdown (shows “All locations” by default).
   • Blue icon indicates filter is active.
   • Select specific location to view adjustments for that branch only.
   • Choose “All locations” for consolidated view across all branches.
2. Multi-Location Analysis:
   • Compare adjustment patterns across different locations.
   • Identify locations with higher adjustment rates.
   • Investigate location-specific inventory issues.
   • Benchmark performance across branches.
3. Strategic Use:
   • Use “All locations” for executive-level overview.
   • Use specific location for operational management.
   • Compare locations to identify best practices.
   • Allocate resources based on location-specific needs.

5. Using the Date Filter #

The “Filter by date” button allows you to specify the reporting period:

1. Accessing Date Filter:
   • Click the “Filter by date” button (purple) in top right.
   • Date picker will open for selection.
   • Choose start and end dates for analysis period.
   • Apply filter to refresh report data.
2. Common Date Range Strategies:
   • Daily – Monitor adjustments in real-time for immediate action.
   • Weekly – Regular operational review and pattern identification.
   • Monthly – Comprehensive analysis for management reporting.
   • Quarterly – Strategic review and trend analysis.
   • Yearly – Annual audit and long-term pattern identification.
3. Comparative Analysis:
   • Compare same period year-over-year.
   • Analyze month-over-month changes.
   • Identify seasonal adjustment patterns.
   • Track improvement after implementing corrective measures.

6. Understanding the Stock Adjustments Table #

The main data table displays detailed information about each adjustment:

7. Normal vs. Abnormal Adjustments #

Understanding the distinction between adjustment types is crucial for effective inventory management:

• Normal Adjustments:
  • Definition: Expected, routine inventory corrections.
  • Examples:
    • Food spoilage and expiration.
    • Customer sampling and tastings.
    • Staff meals and consumption.
    • Minor counting errors.
    • Cooking waste and trim loss.
    • Breakage of small items.
  • Management: Monitor for trends but generally acceptable as cost of doing business.
• Abnormal Adjustments:
  • Definition: Unexpected, significant inventory discrepancies.
  • Examples:
    • Theft or pilferage.
    • Major counting errors.
    • Supplier delivery discrepancies.
    • Damage from accidents or equipment failure.
    • Unexplained inventory shortages.
    • System errors or data corruption.
  • Management: Require immediate investigation and corrective action.

8. Pagination and Display Controls #

Manage how adjustment data is displayed:

• Show Entries Dropdown:
  • Default setting: 25 entries per page.
  • Options typically include: 10, 25, 50, 100 entries.
  • Adjust based on analysis needs and screen size.
  • Larger values show more data but may slow loading.
• Navigation Controls:
  • Use pagination buttons to browse through pages.
  • Entry counter shows current view (e.g., “Showing 1 to 25 of 100 entries”).
  • Jump to specific pages if available.
• Search Function:
  • Use search box to quickly find specific adjustments.
  • Search by reference number, reason, or staff name.
  • Real-time filtering as you type.

9. Export and Documentation Options #

The report provides multiple export formats for analysis and record-keeping:

• Documentation Best Practices:
  • Export monthly reports for permanent records.
  • Maintain audit trail for accounting and compliance.
  • Share with management for review and approval.
  • Archive reports for year-end audits.

10. Analyzing Adjustment Reasons #

The “Reason” column provides valuable insights into why adjustments occur:

1. Common Adjustment Reasons:
   • Spoilage/Expiration – Food items past their usable date.
   • Breakage – Damaged items (dropped, broken, spilled).
   • Theft – Missing inventory due to theft or pilferage.
   • Counting Error – Mistakes in physical inventory counts.
   • Waste – Cooking waste, trim loss, or preparation waste.
   • Staff Consumption – Employee meals or tastings.
   • Customer Sampling – Free samples or tastings.
   • Supplier Error – Delivery discrepancies or shortages.
   • System Error – Data entry or software issues.
2. Pattern Analysis:
   • Group adjustments by reason to identify trends.
   • Calculate percentage of total adjustments by reason.
   • Identify top 3-5 reasons for adjustments.
   • Develop targeted solutions for common reasons.
3. Corrective Actions:
   • High Spoilage → Improve inventory rotation, reduce order quantities.
   • Frequent Breakage → Improve handling procedures, staff training.
   • Theft Issues → Enhance security measures, access controls.
   • Counting Errors → Improve counting procedures, use technology.

11. Tracking Amount Recovered #

The “Total amount recovered” metric is crucial for accountability and loss mitigation:

• Recovery Sources:
  • Staff Reimbursement – Employees pay for lost or damaged items.
  • Insurance Claims – Recovery from insurance for major losses.
  • Supplier Credits – Refunds or credits for delivery errors.
  • Customer Charges – Charges for damaged or lost items.
  • Salvage Value – Partial recovery from damaged goods.
• Recovery Rate Analysis:
  • Calculate: (Total Amount Recovered ÷ Total Stock Adjustment) × 100.
  • Higher recovery rate indicates effective accountability measures.
  • Track recovery rate trends over time.
  • Set recovery rate targets and goals.
• Accountability Measures:
  • Implement clear policies for staff responsibility.
  • Document recovery agreements and payments.
  • Track individual staff member recovery records.
  • Balance accountability with fair treatment.

12. Staff Accountability and “Added By” Tracking #

The “Added By” column is essential for maintaining accountability:

1. Individual Performance Tracking:
   • Monitor which staff members create most adjustments.
   • Identify employees who may need additional training.
   • Recognize staff with low adjustment rates.
   • Track patterns by shift or department.
2. Training and Development:
   • Provide targeted training for high-adjustment staff.
   • Share best practices from low-adjustment staff.
   • Conduct refresher training on inventory procedures.
   • Implement mentoring programs for new staff.
3. Fraud Prevention:
   • Monitor for suspicious adjustment patterns.
   • Implement dual-approval for large adjustments.
   • Regular audits of adjustment records.
   • Segregation of duties for inventory management.
4. Performance Reviews:
   • Include adjustment data in employee evaluations.
   • Set individual goals for reducing adjustments.
   • Reward staff with excellent inventory management.
   • Address chronic issues through performance improvement plans.

13. Best Practices for Stock Adjustment Management #

• Regular Monitoring – Review stock adjustment report daily or weekly to catch issues early.
• Immediate Documentation – Record adjustments as soon as discrepancies are discovered.
• Detailed Reasons – Require specific, detailed explanations for all adjustments.
• Approval Workflows – Implement manager approval for adjustments above certain thresholds.
• Physical Counts – Conduct regular physical inventory counts to verify system accuracy.
• Root Cause Analysis – Investigate patterns and implement corrective actions.
• Staff Training – Provide comprehensive training on proper inventory handling and recording.
• Security Measures – Implement appropriate security controls to prevent theft and loss.
• Technology Use – Utilize barcode scanners and inventory management tools to reduce errors.
• Benchmark Targets – Set acceptable adjustment levels (e.g., <2% of inventory value).
• Audit Trail – Maintain complete records for accounting and compliance purposes.
• Continuous Improvement – Regularly review and refine inventory management procedures.

14. Troubleshooting Common Issues #

15. Done! 🎉 #

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

• Track all inventory adjustments with complete audit trail
• Distinguish between normal and abnormal inventory discrepancies
• Monitor financial impact of inventory corrections
• Maintain staff accountability through detailed tracking
• Identify patterns and implement corrective actions
• Track recovery efforts and minimize losses
• Ensure compliance with accounting and audit requirements

Use this report regularly to maintain inventory accuracy, prevent losses, and ensure operational excellence! 📊✅