1. Navigate to “Product Stock Transfer History” #

1. Log in to your restaurant management system.
2. In the sidebar, expand the Reports section.
3. Locate and click on Product Stock Transfer History.
4. The Product Stock Transfer History page will open showing:
   • A search bar with ▼ Paratha dropdown for product selection.
   • Filter fields for Product, Location, Sub Location, and Date Range.
   • A detailed product information card showing:
     • Product name and SKU (e.g., “▼ Paratha (3501)”).
     • Quantities In section: Total Purchase, Opening Stock, Total Sell Return, Stock Transfers (In).
     • Quantities Out section: Total Sold, Total Stock Adjustment, Total Purchase Return, Stock Transfers (Out).
     • Totals section: Current Stock with quantity and value.
   • Export buttons: Export to CSV, Export to Excel, Print, Column Visibility, and Export to PDF.
   • Pagination controls (Show 25 entries).

2. Understanding Product Stock Transfer History #

Product Stock Transfer History is a comprehensive inventory tracking tool that provides complete visibility into product movement:

• Complete Movement Tracking – Track every instance of product movement in and out of inventory.
• Audit Trail – Maintain detailed records of all stock transactions for compliance and accountability.
• Reconciliation Tool – Verify current stock levels by reviewing all historical movements.
• Loss Prevention – Identify discrepancies, theft, or waste through detailed transaction history.
• Multi-Location Tracking – Monitor product transfers between different locations and sub-locations.
• Financial Accuracy – Ensure inventory valuation accuracy by tracking all quantity changes.
• Operational Insights – Analyze product usage patterns, transfer frequency, and stock velocity.

3. Configure Product Stock Transfer Filters #

1. Configure the following filter parameters to narrow down your search:
   • Product – Select specific product:
     • Click the dropdown showing product name (e.g., “▼ Paratha – 3501”).
     • Search by product name or SKU code.
     • Select the product you want to track.
     • Essential for viewing movement history of specific items.
   • Location – Select business location:
     • Choose specific location (e.g., “Restaurant (ULO01)”).
     • View transfers specific to that location.
     • Useful for multi-location inventory management.
   • Sub Location – Select storage area:
     • Choose “All” to view all sub-locations.
     • Select specific sub-location (kitchen, storage, bar, etc.).
     • Track product movement within specific areas of a location.
   • Date Range – Set the reporting period:
     • Enter start date in format: DD/MM/YYYY (e.g., 01/01/2026).
     • Enter end date in format: DD/MM/YYYY (e.g., 12/31/2026).
     • View transfers within specific time periods.
     • Useful for monthly reconciliation or audit periods.
2. Apply filters to refresh the product transfer history.
3. The report will display detailed movement information for the selected criteria.

4. Understanding Quantities In Section #

The Quantities In section tracks all transactions that increase inventory levels:

5. Understanding Quantities Out Section #

The Quantities Out section tracks all transactions that decrease inventory levels:

6. Understanding Totals Section #

• Current Stock – The current inventory level:
  • Calculated as: Opening Stock + Quantities In – Quantities Out
  • Shows both quantity and value.
  • Example from image: 25.00 PC(s) valued at a specific amount.
  • This is the real-time inventory balance for the product.
• Stock Valuation:
  • Current Stock Value = Current Stock Quantity × Unit Cost
  • Represents the monetary value of inventory on hand.
  • Important for balance sheet reporting and financial analysis.
  • Used for calculating cost of goods sold (COGS).
• Verification Formula:
  • Current Stock = Opening Stock + Total Purchase + Total Sell Return + Stock Transfers (In) – Total Sold – Total Stock Adjustment – Total Purchase Return – Stock Transfers (Out)
  • Use this formula to verify accuracy of stock calculations.
  • Any discrepancy indicates missing transactions or data errors.

7. Analyze Product Movement Patterns #

1. Sales Velocity Analysis:
   • Review Total Sold to understand product demand.
   • Calculate daily average: Total Sold ÷ Number of Days in Period
   • High sales velocity indicates:
     • Popular product requiring frequent restocking.
     • Need for higher par levels to prevent stockouts.
     • Opportunity for bulk purchasing discounts.
   • Low sales velocity suggests:
     • Slow-moving product; consider menu changes.
     • Reduce order quantities to minimize waste.
     • Potential for promotional activities.
2. Waste and Loss Analysis:
   • Review Total Stock Adjustment for waste patterns.
   • High adjustments indicate:
     • Quality issues with product or storage.
     • Over-ordering leading to spoilage.
     • Potential theft or loss issues.
     • Need for improved inventory management.
   • Calculate waste percentage: (Total Stock Adjustment ÷ Total Purchase) × 100
   • Target: Keep waste below 2-5% for most products.
3. Transfer Efficiency:
   • Review Stock Transfers (In) and Stock Transfers (Out).
   • High transfer activity may indicate:
     • Inefficient initial allocation across locations.
     • Need for better demand forecasting.
     • Opportunity to optimize distribution strategy.
   • Balance transfer costs against stockout prevention.

8. Stock Reconciliation Process #

1. Prepare for Physical Count:
   • Run Product Stock Transfer History for the reconciliation period.
   • Note the Current Stock quantity from the system.
   • Print or export the report for reference during physical count.
2. Conduct Physical Count:
   • Count actual physical inventory on hand.
   • Record the physical count quantity.
   • Ensure accurate counting (use two-person verification for high-value items).
3. Compare and Analyze Discrepancies:
   • Calculate variance: Physical Count – System Current Stock
   • Positive variance = More stock than system shows (possible unrecorded purchases).
   • Negative variance = Less stock than system shows (possible theft, waste, or unrecorded sales).
   • Investigate significant discrepancies:
     • Review recent transactions for errors.
     • Check for unrecorded waste or damage.
     • Verify all transfers were properly documented.
     • Look for potential theft or loss issues.
4. Adjust System Stock:
   • Create stock adjustment to match physical count.
   • Document reason for adjustment.
   • Update system to reflect accurate inventory levels.
5. Implement Corrective Actions:
   • Address root causes of discrepancies.
   • Improve processes to prevent future variances.
   • Train staff on proper inventory procedures.

9. Export and Print Transfer History #

1. Export Options – Use the export buttons above the data:
   • Export to CSV – Comma-separated values format:
     • Opens in Excel, Google Sheets, or any spreadsheet application.
     • Ideal for detailed analysis and data manipulation.
     • Lightweight format for email sharing.
   • Export to Excel – Microsoft Excel format:
     • Preserves formatting and includes formulas.
     • Professional format for management reports.
     • Enables advanced Excel analysis (pivot tables, charts).
   • Export to PDF – Portable Document Format:
     • Professional format for audit documentation.
     • Maintains consistent formatting across all devices.
     • Suitable for archiving and compliance records.
   • Print – Direct browser printing:
     • Quick physical copy for inventory counts.
     • Use for warehouse or kitchen reference.
     • Handy for manual reconciliation processes.
2. Column Visibility:
   • Click the Column Visibility button to customize displayed information.
   • Show or hide specific data fields based on your needs.
   • Simplify report for specific audiences or purposes.

10. Use Cases for Transfer History #

11. Inventory Valuation and Financial Impact #

• Cost of Goods Sold (COGS) Calculation:
  • COGS = Opening Stock + Total Purchase – Closing Stock
  • Use transfer history data to calculate accurate COGS.
  • Essential for profit and loss statement preparation.
  • Impacts gross profit margin calculations.
• Inventory Turnover Ratio:
  • Inventory Turnover = COGS ÷ Average Inventory
  • Higher turnover indicates efficient inventory management.
  • Lower turnover suggests overstocking or slow-moving products.
  • Target: 4-12 times per year for most restaurant products.
• Carrying Cost Analysis:
  • Calculate cost of holding inventory (storage, insurance, spoilage).
  • Typically 15-25% of inventory value annually.
  • Use to justify inventory reduction initiatives.
  • Balance carrying costs against stockout risks.
• Balance Sheet Impact:
  • Current Stock Value appears as inventory asset on balance sheet.
  • Accurate transfer history ensures correct inventory valuation.
  • Affects working capital and current ratio calculations.
  • Important for financial reporting and lending decisions.

12. Best Practices for Transfer History Management #

• Real-Time Recording – Record all inventory transactions immediately when they occur to maintain accuracy.
• Regular Reconciliation – Conduct physical counts and reconcile with system at least monthly.
• Document Everything – Maintain supporting documentation for all adjustments, returns, and transfers.
• Investigate Variances – Always investigate and document reasons for inventory discrepancies.
• Access Control – Limit who can perform stock adjustments and transfers to authorized personnel only.
• Approval Workflows – Implement approval requirements for large adjustments or transfers.
• Trend Monitoring – Regularly review transfer history to identify patterns and anomalies.
• Staff Training – Train all staff on proper inventory recording procedures and importance of accuracy.
• System Integration – Ensure POS and inventory systems are properly integrated for automatic updates.
• Audit Trail Maintenance – Preserve transfer history records for required retention periods (typically 3-7 years).

13. Advanced Analysis Techniques #

• ABC Analysis:
  • Classify products based on value and movement:
    • A Items – High value, high movement (20% of items, 80% of value).
    • B Items – Moderate value and movement (30% of items, 15% of value).
    • C Items – Low value, low movement (50% of items, 5% of value).
  • Apply tighter controls and more frequent counts for A items.
  • Use transfer history to classify products accurately.
• Variance Analysis:
  • Track variance percentage: (Variance ÷ Expected Stock) × 100
  • Set acceptable variance thresholds (e.g., ±2% for A items, ±5% for B items).
  • Investigate all variances exceeding thresholds.
  • Trend variance over time to identify systemic issues.
• Seasonal Pattern Recognition:
  • Compare transfer history across different seasons.
  • Identify seasonal demand fluctuations.
  • Adjust purchasing and stocking strategies accordingly.
  • Plan for peak seasons with adequate inventory.
• Supplier Performance Tracking:
  • Use purchase and purchase return data to evaluate suppliers.
  • Calculate return rate: (Total Purchase Return ÷ Total Purchase) × 100
  • Track delivery accuracy and product quality.
  • Make informed supplier selection decisions.

14. Troubleshooting Common Issues #

15. Done! 🎉 #

You can now effectively track product stock transfer history, reconcile inventory, investigate discrepancies, analyze movement patterns, optimize stock levels, and maintain accurate inventory records for financial reporting and operational excellence!