Raw Materials Tracker | Inventory Management Spreadsheet (Excel, Google Sheets)

📝 Description
📦✨ Take full control of your raw materials with a tracker built to look premium and work hard.
Stop guessing how much stock you have, when to reorder, which materials are close to expiry, or how much your inventory is really costing you.
The ELDON-Digital Raw Materials Tracker is a complete, beautifully designed Excel and Google Sheets inventory management system created for businesses that need a smarter, clearer, and more professional way to manage raw materials. Whether you run a manufacturing business, bakery, cosmetics brand, candle business, soap business, food production setup, packaging operation, workshop, or any product-based business, this spreadsheet helps you stay organized and in control.
This is not a basic stock list.
This is a complete raw materials command center with a colorful dashboard, supplier tracking, reorder alerts, expiry monitoring, transaction logs, storage location tracking, settings, drop-down menus, professional instructions, and clean navigation throughout the workbook.
💼 Designed by ELDON-Digital with a polished, Etsy-ready interface that is both practical and visually impressive.
________________________________________
🌟 WHAT THIS TEMPLATE HELPS YOU DO
✅ Track all raw materials in one place
✅ Monitor available quantity and stock value
✅ Record suppliers and supplier details
✅ Set reorder points and lead times
✅ Identify low-stock items quickly
✅ Monitor expiry dates and quality grades
✅ Organize materials by storage location
✅ Log inventory transactions and usage
✅ Review supplier spend and receipt history
✅ View clear dashboard KPIs and charts
✅ Customize drop-down lists through the settings sheet
✅ Use in Microsoft Excel and Google Sheets
________________________________________
📁 INCLUDED SHEETS
1. 📘 Instructions
A detailed guide that explains how to use every part of the workbook step by step, making the tracker beginner-friendly and easy to set up.
2. ⚙️ Settings
A dedicated setup sheet where users can customize:
• business preferences
• workbook year
• dates and warning thresholds
• supplier lists
• units of measure
• storage locations
• quality grades
• material categories
• repeated items used in drop-down menus
3. 📊 Dashboard
A professional main interface with:
• clickable navigation buttons
• inventory summary KPIs
• visual charts
• stock status overview
• category-based analytics
• fast access to all workbook sections
4. 🧱 Materials Tracker
The main raw materials database with fields such as:
• Material Name
• Material Code / ID
• Category
• Supplier
• Quantity Available
• Unit of Measure
• Cost per Unit
• Total Inventory Value
• Reorder Point
• Suggested Reorder Quantity
• Lead Time
• Expiry Date
• Days Until Expiry
• Quality Grade
• Storage Location
• Status
• Average Daily Usage
• Days of Cover
• Notes
5. 🔄 Transactions Log
Track every material movement, including:
• receipts
• usage
• returns
• adjustments
• damaged stock
• transfer notes
• transaction dates
• related suppliers
• quantities in and out
6. 🏭 Suppliers
A structured supplier management sheet to record:
• supplier names
• contact persons
• emails
• phone numbers
• lead times
• materials supplied
• spend overview
• last receipt date
7. 🚨 Reorder Alerts
An organized alert system that highlights materials that are below reorder level or approaching shortage based on current stock and settings.
8. ⏳ Expiry & QA Monitor
A dedicated monitoring area for:
• materials nearing expiry
• expired stock
• quality tracking
• recommended action notes
9. 📍 Locations
A clear inventory-by-location view to help users understand where materials are stored and how much is held in each area.
________________________________________
🎨 DESIGN FEATURES
✨ Beautiful colored layout
✨ Organized sheet-by-sheet structure
✨ Different color styling across sheets
✨ Professional business-focused design
✨ Large readable typography using Arial / Times New Roman
✨ Clickable Dashboard navigation buttons
✨ Clean formatting and aligned cells
✨ Mock data already included to show how the finished tracker works
✨ Stylish charts and infographic-style visuals
✨ Designed for a premium digital product feel
________________________________________
💻 COMPATIBILITY
✔ Microsoft Excel
✔ Google Sheets
This workbook is designed to work in Excel and can also be uploaded for use in Google Sheets.
________________________________________
🎯 PERFECT FOR
🧴 Cosmetics businesses
🕯️ Candle makers
🧼 Soap makers
🍰 Bakers and food prep businesses
🏭 Small manufacturers
📦 Packaging businesses
🛠️ Workshops and production teams
🧵 Handmade product sellers
🧪 Lab and materials-based operations
📈 Any business that manages raw material stock
________________________________________
📌 WHY BUY THIS TEMPLATE
Because raw materials management should not be messy, stressful, or confusing.
This system helps you make better purchasing decisions, avoid stockouts, reduce waste, monitor expiry risk, and keep your inventory records clean and professional. It saves time, improves visibility, and gives your business a more organized workflow.
If you want an inventory tracker that is functional, beautiful, and made to sell at a premium standard, this is it.
________________________________________
📥 PLEASE NOTE
📌 This is a digital download
📌 No physical item will be shipped
📌 Colors may vary slightly depending on screen settings
📌 For personal or business use only. Not for resale or redistribution
________________________________________
💛 ELDON-Digital
Created with care for entrepreneurs, makers, and businesses who want smart systems with beautiful design.