Managing product expiry ensures that you track perishable items effectively, avoid selling expired products, and optimize inventory turnover. BillBook allows you to enable expiry tracking, set alerts, and display expiry dates on invoices. 🚀📆
🔹 Enabling Expiry for Products #
✅ Go to → Settings → Business Settings → Product Section
✅ Check the “Enable Product Expiry” checkbox ✅
Now, you can choose how to manage expiry:
1️⃣ Add Item Expiry (Direct Expiry Entry) #
- You can enter the expiry date manually in the Purchase Screen for each batch.
2️⃣ Add Manufacturing Date & Expiry Period (Auto-Calculate Expiry) #
- Enter the Manufacturing Date & Expiry Period when adding purchases.
- BillBook auto-calculates the expiry date based on these details.
- The expiry date can be edited later if needed.
✅ Set Expiry Period in: Add/Edit Product Screen
✅ Set Manufacturing Date in: Add Purchase Screen
⚙️ What Happens When a Product Expires? #
✅ Go to → Settings → Business Settings → Product Expiry Settings
✅ Choose one of these options:
1️⃣ Keep Selling (No Restriction) 🚀 #
- The system continues selling expired products without restriction.
2️⃣ Stop Selling “n” Days Before Expiry ⏳ #
- Automatically prevents selling an item n days before expiry.
- You must specify “n” (number of days before expiry).
📦 Stock Accounting Method (FIFO vs. LIFO) #
Stock movement can be managed using FIFO (First In, First Out) or LIFO (Last In, First Out).
✅ Go to → Settings → Business Settings → Product Section
✅ Select Stock Accounting Method:
📌 FIFO (First In, First Out) – Recommended for Expiry-Based Products #
- The oldest stock is sold first before using newer stock.
- Example:
- Purchased 20 pcs on March 20 (Expiry: April 10)
- Purchased 20 pcs on March 23 (Expiry: April 8)
- If you sell 22 pcs, it first deducts from March 20 batch (20 pcs), then March 23 batch (2 pcs).
📌 LIFO (Last In, First Out) – Opposite of FIFO #
- The most recent purchase stock is sold first.
- Stock from the latest batch is deducted before older batches.
📌 Important: The accounting method must be set BEFORE selling for it to be applied correctly.
📊 Viewing Stock Expiry Reports #
✅ Go to → Reports → Stock Expiry Reports
✅ Filter by:
- Category 🏷️
- Brand 🏭
- Stock Expiry Date ⏳
✅ Click “Edit” to modify expiry details or adjust remaining stock.
📌 If the stock quantity is adjusted, the unit purchase price will also be updated accordingly.
🔔 Stock Expiry Alerts #
✅ Stock expiry alerts appear on the homepage (bottom section).
✅ To customize alert timing:
- Go to → Settings → Business Settings → Dashboard Section
- Set the number of days before expiry for alerts.
💡 This ensures you get notified before stock expires, preventing wastage!
🧾 Displaying Product Expiry Date on Invoices #
✅ Ensure “Enable Product Expiry” is activated in Business Settings.
✅ Go to → Invoice Layout Settings
✅ Enable “Show Product Expiry” ✅
✅ When making a sale, select the expiry date of the batch being sold.
✅ The expiry date will be printed on the invoice for customer reference.
🚀 Why Use Product Expiry Tracking in BillBook? #
✅ Avoid selling expired products ❌
✅ Get expiry alerts before products go bad 🔔
✅ Choose FIFO or LIFO stock management for better inventory control 📦
✅ Track expiry dates in sales reports for compliance & forecasting 📊
✅ Display expiry dates on invoices for transparency 🧾
With BillBook’s Expiry Management, handling perishable and time-sensitive inventory is now easy & efficient! 🚀⏳
Let me know if you need any refinements! 😊