របៀបបូកដកទំនិញបានលក់និងសល់ក្នុងស្តុកក្នុង Excel - How to Calculate Daily Stock Sales & Stock Left in Excel (Video in Khmer)

Hello everyone! In today's video tutorial, you will learn how to track daily stock sales, stock in, stock out, and calculate remaining inventory in Excel step-by-step.

This simple inventory tracking method is perfect for small shops, retail stores, or warehouse businesses!

📚 Related Tutorial: Want to master Excel keyboard shortcuts? Check out Learn All Excel Keyboard Shortcuts!

🛠️ Key Inventory Calculation Formulas

1. Calculate Remaining Stock (Balance):

To calculate current remaining stock quantity in cell E2:

= Beginning_Stock + Stock_In - Stock_Out

Example: =B2 + C2 - D2

2. Calculate Total Revenue / Sales Amount:

To calculate total revenue earned from sold items in cell F2:

= Stock_Out * Unit_Price

Example: =D2 * 5.00

💡 Pro Tips for Inventory Tracking

1. Highlight Low Stock Alerts (Conditional Formatting):
   • Select your remaining stock column (E2:E50).
   • Go to Home tab ➔ Conditional Formatting ➔ Highlight Cells Rules ➔ Less Than...
   • Type 5 and choose Light Red Fill. Now any item low on stock highlights red automatically!
2. Lock Price Range ($): Always use absolute reference (e.g. $H$1) if multiplying sales by a fixed tax rate or price unit!