📦 Store Inventory Guide

Complete workflow for tracking purchases, sales, stock & profit

Created for Hala Asaad

target What Store Owners Need

Enter products they bought (quantity + purchase price)
Track what they sold (quantity + selling price)
Know current stock (what's left in shop)
Calculate profit (selling price - purchase price)

repeat Complete Workflow

1️⃣ Purchase Products

Go to Inventory Page → Enter product details

Example:

Product: Biscuits
Quantity: 10 boxes
Purchase Price: ₹50/box
Total: ₹500

→ Stock: +10 boxes
→ Cost: ₹50/box

2️⃣ Collect Products (Optional)

Go to Collection Page → Record milk OR other products

Example:

Milk: 50L @ ₹60/L = ₹3,000
OR
Paneer: 5kg @ ₹300/kg = ₹1,500

→ Stock: +50L milk OR +5kg paneer

3️⃣ Convert Products (Optional)

Milk → Paneer/Ghee/etc.

Example:

10L milk → 1kg paneer

→ Milk stock: -10L
→ Paneer stock: +1kg

4️⃣ Sell Products

Go to POS Page → Click product → Auto-deducts stock

Example:

Sold: 3 boxes biscuits @ ₹70
Total: ₹210

→ Stock: -3 boxes (auto-deducted!)
→ Revenue: ₹210
→ Profit: ₹60 (₹20/box × 3)

5️⃣ View Reports

Go to Stock & Profit Report → See everything

Report Shows:

Purchased: 10 boxes @ ₹50 = ₹500
Sold: 3 boxes @ ₹70 = ₹210
In Stock: 7 boxes (₹350 value)
Profit: ₹60 (28.6% margin)

calculate Key Formulas

In Stock = Purchased Quantity - Sold Quantity

Stock Value = In Stock × Purchase Price

Profit = (Sold Quantity × Sell Price) - (Sold Quantity × Purchase Price)

Profit Margin % = (Profit / Revenue) × 100

task Daily Checklist

Morning: Check Stock Report → See what's low
Purchase: Go to Inventory → Enter new stock
During Day: Use POS → Sell products (stock auto-deducts)
Evening: Check Stock Report → See profit & remaining stock
Weekly: Export report for accountant (CSV)
Monthly: Review top profit products

receipt_long What Report Shows

Product: Biscuits

├─ Purchased: 10 boxes (what you bought)
├─ Sold: 3 boxes (what customers bought)
├─ In Stock: 7 boxes (what's left in shop)
├─ Buy Price: ₹50 (what you paid)
├─ Sell Price: ₹70 (what you charged)
├─ Profit: ₹60 (money earned)
└─ Status: ✅ In Stock

Stock Status Colors:

🟢 In Stock = More than 10 units
🟡 Low Stock = Less than 10 units (reorder soon!)
🔴 Out of Stock = 0 units (reorder now!)

sync How Data Works

Good news: It doesn't matter where you enter data!

The Stock Report automatically reads from ALL sources:

Inventory page purchases
Collection page entries
POS page sales
Any other sales records

Example: If you enter biscuits in Inventory and sell them in POS, the report will show: Purchased (from Inventory) - Sold (from POS) = In Stock + Profit ✅

Need Help? Each page has simple forms - just fill in the blanks!

Last updated: February 23, 2026 | MilkRecord POS System