retail store stock audit new style

The video discusses a new method for conducting a stock audit in a retail store, specifically focusing on Suits. The presenter explains the process of using Mobile Phones to capture barcode images and how to transfer this data into an Excel sheet for Inventory Management.

Main Financial Strategies and Methodologies:

• Barcode Scanning with Mobile Phones: Staff take photos of barcodes on Suits using their mobile devices.
• Data Transfer to Excel: The captured barcode images are scanned at the cash counter and transferred into an Excel sheet.
• Physical Stock Management: The physical stock is tracked by entering quantities into the Excel sheet alongside the barcodes.
• System Stock Comparison: The methodology includes comparing the physical stock with the system stock to ensure accuracy.
• Using Pivot Tables: The presenter outlines the steps to create a pivot table in Excel to organize and analyze stock data effectively.

Step-by-Step Guide:

1. Take photos of barcodes using Mobile Phones.
2. Scan the photos at the cash counter.
3. Transfer the barcode data to an Excel sheet.
4. Enter quantities for physical stock in the Excel sheet.
5. Extract barcode data from the system by navigating to the relevant stock category.
6. Create a pivot table in Excel:
   • Insert a new worksheet.
   • Input barcodes, physical stock, and quantities accordingly.
7. Compare the physical stock with system stock to ensure they match.

Presenters/Sources:

The video appears to be presented by an individual overseeing the stock audit process, though specific names are not mentioned in the subtitles.