pub » Page 26 of 70 » excelguru.io

applicant tracking template that follows every candidate from application to hire, with a live hiring funnel and time-to-hire metrics.

Applicant Tracking

Manage your hiring process with this free Applicant Tracking Excel Template. Track candidate details, job roles, application dates, interview stages, recruiter notes, hiring status, feedback, and final decisions in one simple Excel file. Ideal for HR teams, recruiters, hiring managers, startups, and small businesses that need an easy way to organize applicants and monitor recruitment progress.

demand forecasting template that turns sales history into a clear next-month forecast.

Demand Forecasting

Forecast future demand and plan inventory more effectively with this free Demand Forecasting Excel Template. Track historical sales, demand patterns, forecast periods, expected quantities, seasonal trends, variance, and stock planning needs in one simple Excel file. Ideal for inventory managers, procurement teams, retailers, supply chain teams, and small businesses that need an easy way to estimate demand, reduce stockouts, avoid excess inventory, and improve purchasing decisions.

consignment tracker that follows consigned stock, sales and the amounts owed to each consignor.

Consignment Inventory Tracker

Track and manage consignment stock with this free Consignment Inventory Tracker Excel Template. Monitor consignor details, item codes, product names, consigned quantities, sold quantities, returned stock, remaining balances, locations, settlement amounts, and payment status in one simple Excel file. Ideal for retailers, distributors, suppliers, inventory managers, and small businesses that need an easy way to control consignment inventory and maintain accurate stock records.

A free Excel report that classifies items by sales activity and flags dead and slow-moving stock.

Dead & Slow Moving Stock Report

Identify dead stock and slow-moving inventory with this free Dead Slow Moving Stock Report Excel Template. Track item codes, product names, categories, last movement dates, stock age, available quantities, inventory value, movement status, and action priorities in one simple Excel file. Ideal for inventory managers, warehouse teams, finance teams, auditors, retailers, and small businesses that need an easy way to reduce excess stock, improve inventory turnover, and free up working capital.

A free Excel stock transfer log that tracks moves between locations and measures transit time.

Stock Transfer Log

Record and manage inventory transfers across locations with this free Stock Transfer Log Excel Template. Track transfer numbers, item codes, product names, source locations, destination locations, transfer dates, quantities, approval status, received status, and remarks in one simple Excel file. Ideal for warehouse teams, inventory managers, retail stores, operations teams, and small businesses that need an easy way to monitor stock movement between locations and maintain accurate inventory records.

batch and expiry tracker that flags expired and expiring stock and the value at risk.

Batch & Expiry Tracking

Track batch-wise inventory and expiry dates with this free Batch Expiry Tracking Excel Template. Monitor batch numbers, item codes, product names, received dates, expiry dates, remaining shelf life, stock quantities, supplier details, expiry status, and action notes in one simple Excel file. Ideal for inventory managers, warehouse teams, retailers, pharmacies, food businesses, and small businesses that need an easy way to prevent expired stock, reduce waste, and improve inventory control.

A free Excel inventory KPI dashboard that calculates turnover, DSI and fill rate per item and overall.

Inventory KPI Dashboard

Monitor inventory performance in one place with this free Inventory KPI Dashboard Excel Template. Track key metrics such as total stock value, inventory turnover, stock accuracy, low stock alerts, ageing inventory, reorder status, stock movement, and category-wise performance in one simple Excel dashboard. Ideal for inventory managers, warehouse teams, procurement teams, finance teams, and small businesses that need an easy way to review inventory health and improve stock control.

A free Excel supplier tracker that manages vendor contacts, scores performance, and tracks spend.

Supplier & Vendor Tracker

Organize and manage supplier information with this free Supplier Vendor Tracker Excel Template. Track vendor names, contact details, product categories, payment terms, delivery performance, contract status, ratings, notes, and key supplier records in one simple Excel file. Ideal for procurement teams, inventory managers, finance teams, operations teams, and small businesses that need an easy way to maintain vendor data and improve supplier management.

A free Excel low-stock alert dashboard that ranks at-risk items by urgency and estimates days of stock left.

Low Stock Alert Dashboard

Identify low-stock items before they become stockouts with this free Low Stock Alert Dashboard Excel Template. Track item codes, product names, available quantities, reorder levels, safety stock, suppliers, stock status, priority alerts, and replenishment needs in one simple Excel dashboard. Ideal for inventory managers, warehouse teams, procurement teams, retailers, and small businesses that need an easy way to monitor stock levels and take timely reorder action.

A free Excel template that values inventory using both FIFO and weighted average and compares the results.

Inventory Valuation (FIFO & WAC)

Value your inventory accurately with this free Inventory Valuation FIFO WAC Excel Template. Track purchases, sales, quantities, unit costs, remaining stock, cost of goods sold, FIFO valuation, weighted average cost, and closing inventory value in one simple Excel file. Ideal for inventory managers, accountants, finance teams, auditors, retailers, and small businesses that need an easy way to calculate inventory value and support accurate financial reporting.

A free Excel EOQ calculator that finds the order quantity with the lowest combined ordering and holding cost.

Economic Order Quantity (EOQ) Calculator

Calculate the ideal order quantity for your inventory with this free Economic Order Quantity EOQ Calculator Excel Template. Estimate EOQ using annual demand, ordering cost, holding cost, unit cost, and inventory assumptions in one simple Excel file. Ideal for inventory managers, procurement teams, warehouse teams, retailers, and small businesses that need an easy way to reduce ordering costs, avoid excess stock, and improve inventory planning.

A free Excel ABC analysis template that ranks items by value and classifies them into A, B and C automatically

ABC Analysis

Prioritize inventory control with this free ABC Analysis Excel Template. Classify items into A, B, and C categories based on consumption value, stock value, sales value, or inventory importance. Track item codes, product names, quantities, unit costs, total value, cumulative percentage, and ABC category in one simple Excel file. Ideal for inventory managers, warehouse teams, procurement teams, finance teams, and small businesses that need an easy way to focus on high-value stock and improve inventory decisions.