Recruitment Tracker 2020 – Free HR Excel Template for Recruiters

Posted on
Recruitment Tracker Excel Template

Are you in the process of recruiting for an open job/position? If you are looking for a simple and effective solution to manage the recruiting process and truly understand its performance via effective Recruiting metrics, I have good news for you.

Download this simple Excel template to track status of the applicants (candidates) in an organized way. Get an instant view of how many applicants are in the pipeline and where in the funnel applicants are dropping off. You can also easily view the top reasons why candidates were not selected.

Recruitment Tracking – Simple & Effective.

This Excel template is designed for Microsoft Excel, but if you are looking for a Google Sheet template, please visit Recruitment Tracker in Google Sheets.

Recruitment Dashboard Report - Summary after Hiring
Recruitment Dashboard Report – Summary after Hiring

Download Recruitment Tracker Excel Template 2020

Download Recruitment Tracker Excel Template 2020 with Sample data

If you are looking for a Google Sheets version, please see Recruitment Tracker for Google Sheets.

VIDEO DEMO

To manage multiple jobs with more features, please see the new Recruitment Manager Excel Template.

This template is very easy to use. Please follow the steps below.

STEP 1: Enter Job Details

Start by entering the Job Title, Recruiter Name and Job posted date.

Recruitment Dashboard Report - Summary after Hiring
Recruitment Dashboard Report – Summary after Hiring

STEP 2: Enter the four stages of recruiting

The four stages of hiring are Application, Phone Screen, Interview and Offer. the fifth stage not mentioned in the offer acceptance (hire) stage. You can change the names of these four stages. If you only have three stages, then leave a blank in the fourth stage name.

STEP 3: Enter Applicants’ information

Enter Applicants or Candidates Information - Recruitment Tracker 2020
Enter Applicants or Candidates Information – Recruitment Tracker 2020
  • Enter Applicant (Candidate) name and dates when the applicant reached each of the four stages. If the applicant does not reach a stage, leave it blank.
  • When a decision is made to not proceed with an applicant, enter CLOSED in the STATUS column.
  • Enter ‘decline reason’ for candidates who were not selected.
  • Enter Comments if needed.
  • STAGE is a calculated field that tells which stage an applicant is.
Enter Applications’ Status and Comments – Recruitment Tracker 2020
Enter Applications’ Status and Comments – Recruitment Tracker 2020

STEP 4: Enter Hired Applicant Name

After a candidate accepts the offer, then enter Hired Applicant and Hired Date information.

Recruitment Tracker 2020 - Enter Hired Applicant and Date
Recruitment Tracker 2020 – Enter Hired Applicant and Date

SUMMARY DASHBOARD

As you enter data, the summary section on the top right updates automatically with the key metrics.

When the job is not filled yet, the metrics will display as below.

Hiring Tracker - Report - Summary During Hiring Process
Hiring Tracker – Report – Summary During Hiring Process

The status will be displayed on the top left as HIRING.

Number of Applications and Days to Hire (or Days in Hiring) will be displayed at the top.

Hiring Tracker – Number of Applications and Days in Hiring
Hiring Tracker – Number of Applications and Days in Hiring

Recruitment/Candidate Pipeline

You can see the active pipeline (applicants or candidates whose application status is not CLOSED). For example, in the image below, there is 1 candidate in APPLICATION stage, 4 in PHONE SCREEN, 1 in INTERVIEW and 1 in OFFER stages.

Active Pipeline - Recruitment Pipeline
Active Pipeline – Recruitment Pipeline

Recruitment Funnel

As you are hiring, the funnel will represent only applicants whose status is CLOSED.

Recruitment Tracker Excel Template – Recruitment Funnel
Recruitment Tracker Excel Template – Recruitment Funnel

After a candidate has been hired, the Summary Dashboard changes slightly automatically to reflect the recruiting metrics. You can record that hiring is complete by entering the Hired Applicant name and Hired Date information.

Recruitment Dashboard Report - Summary after Hiring
Recruitment Dashboard Report – Summary after Hiring

The summary will display the status as HIRED and will show the Recruitment metrics – Number of Applications and Days to Hire.

Recruitment Tracker – Number of Applications and Days to Hire
Recruitment Tracker – Number of Applications and Days to Hire

After hiring, the recruiting funnel represents all applicants (not just Closed status). This will help identify where the candidates fell off in the funnel stages.

Recruitment Tracker Excel Template – Recruitment Funnel after hiring
Recruitment Tracker Excel Template – Recruitment Funnel after hiring

The top 3 decline reasons are shown along with %. This is based on applicants where status is CLOSED.

Top Decline Reasons - Recruitment Tracker
Top Decline Reasons – Recruitment Tracker

Do you find this template useful? Are there any additional scenarios that would be good to incorporate? Is there anything obvious I have missed? Please share your thoughts in the comments below.

If you like the template, please share with your friends.


Do you need to manage recruiting of multiple jobs in one file?

If you are looking to manage multiple jobs and get advanced reporting, please try Recruitment Manager Excel Template

Recruitment Manager Excel template
Recruitment Manager Excel template

How do you keep track of Recruitment in Excel?

After publishing the free template, I received many requests for step by step instructions/tutorial on how to build this recruitment tracker template and track recruiting in Excel? I developed a 4-part video series explaining every single step of creating this recruitment template.  Please watch the video playlist below.

Watch on YouTube

How do you keep track of an Employee joining a company using Excel?

Recruitment process of an employee doesnt stop at receiving the offer, it can only complete if the employee successfully joins for work in the company. During the initial stage every employee has to go through a defined process before joining office. Use a simple checklist to track the employee process.

You may also be interested in...

New Employee Checklist
Leave Tracker & Vacation Tracker
Employee Vacation Planner

Manufacturing Inventory & Sales Manager Excel Template – Migrating from v1 to v2 in 10 mins

Posted on

This post explains how to migrate data from v1 of Manufacturing Inventory and Sales Manager Excel Template (Product page) to v2.  Please read about the Enhancements in v2

You can migrate your data from v1 file to the new v2 file in less than 10 minutes. Please watch the video below where I demonstrate how to do it.

  1. PRODUCTS Sheet
    1. Copy all the five columns and paste
    2. If you had chosen YES for ‘Do you Hold Finished Goods Inventory’ setting in v1, then type YES in the HOLD PRODUCT AS FINISHED GOOD? column in v2.
  2. RAW_MATERIALS Sheet
    1. Copy all the four columns and paste
  3. MANUFACTURING_DETAILS Sheet
    1. Copy the first three columns and paste
  4. PARTNERS Sheet
    1. From v1 ORDER DETAILS sheet, select the PARTNER column data and then paste in PARTNER NAME field
    2. Click on DATA Ribbon –> Remove Duplicates. This will create the unique list of Partner names
  5. ORDERS Sheet
    1. Copy (Order Number, Order Type and Order Date) and paste
    2. Copy PARTNER column and paste in PARTNER NAME column
    3. Click on DATA Ribbon –> Remove Duplicates. This will create the unique list of Orders
  6. ORDER_DETAILS Sheet
    1. Copy ORDER NUMBER column data and paste
    2. Copy EXPECTED DATE column data and paste
    3. Copy PRODUCT NAME, QUANTITY and UNIT PRICE columns and paste
  7. From the DATA Ribbon, please choose Refresh All. This will update all the calculations in the Template. Now, The Product Report, Raw Materials report and Sales report will have updated numbers.
Manufacturing Inventory and Sales Manager Excel Template - Refresh Data
Manufacturing Inventory and Sales Manager Excel Template – Refresh Data

After migrating, please review the template and make sure that everything is according to your expectations.

If you have any questions, please leave a comment.

 

Upgrades to Manufacturing Inventory and Sales Manager Excel Template

Posted on

I am glad to announce that the Manufacturing Inventory and Sales Manager Excel Template has been upgraded from v1 to v2.  Customers who have already purchased receive the v2 for free. Please create an account with indzara.com and you can log in to access all your files anytime. If you would like to continue using the v1 file, please do so. This is an optional upgrade if you are interested in receiving the enhancements. The following are the key changes in v2 from v1.

 

Holding as Finished Goods

v1 of the template allowed only products of one kind, either holding as finished goods or not. The v2 of the template allows mix of products that are manufactured and held as finished goods and products that are assembled on demand (without holding as finished goods). You can indicate this for each product in the PRODUCTS sheet.

Manufacturing Inventory and Sales Manager - Excel Template - v2 - Products
Manufacturing Inventory and Sales Manager – Excel Template – v2 – Products
  • Choose Yes if you hold finished goods in inventory. If you choose Yes, then while entering orders, you should enter Purchase, Manufacturing and Sale orders.
  • Leave it blank if you do not hold finished goods in inventory (i.e., you manufacture on demand and sell immediately), then you can just enter Purchase and Sale orders. Manufacturing orders are not required.

Create Invoices

You can create invoices instantly by typing just the order number.

Manufacturing Inventory and Sales Manager - Excel Template - Invoice
Manufacturing Inventory and Sales Manager – Excel Template – Invoice

Tax Calculations

Now you can calculate tax on your orders easily. You will indicate tax rate for each product in the PRODUCTS sheet and the tax calculations will be made automatically. They will also appear on the invoice.

 

Discounts

You can enter discounts on orders. In the ORDER DETAILS sheet, while entering order line items, you can enter discount in the UNIT DISCOUNT column. The template will automatically apply discounts to the amount calculations.

Manufacturing Inventory and Sales Manager - Excel Template - Order Details Entry
Manufacturing Inventory and Sales Manager – Excel Template – Order Details Entry

 

Re-Order Point for Raw Materials

Raw Materials can also have re-order points. You will enter them in the RAW_MATERIALS sheet.

Manufacturing Inventory and Sales Manager - Excel Template - Raw Materials
Manufacturing Inventory and Sales Manager – Excel Template – Raw Materials

Raw Materials report can now be used to identify which raw material should be ordered. Please use the last column TO ORDER to filter on raw materials that need to be ordered.

Manufacturing Inventory and Sales Manager - Excel Template - Raw Materials Report
Manufacturing Inventory and Sales Manager – Excel Template – Raw Materials Report

Store Partner Information

Partner (Suppliers and Customers) information can be stored. This will be used in the invoice. By entering partner information once, you can re-use them automatically in the invoice for all future orders.

Manufacturing Inventory and Sales Manager - Excel Template - Partners
Manufacturing Inventory and Sales Manager – Excel Template – Partners

Manufacturing Inventory and Sales Manager v1 – Excel Template – ARCHIVED

Posted on

The v1 of the Manufacturing Inventory and Sales Manager was retired in July 2015.  Latest version is Manufacturing Inventory and Sales Manager Excel Template v2 (released in July 2015). This post contains information related to v1. If you are still using v1, please see below for help.

 

ABOUT THE EXCEL TEMPLATE

This Excel template helps in managing inventory at a manufacturing/assembly business. If you buy raw materials and convert them to products by assembling or manufacturing, then you can use this template to manage inventory of products and raw materials. You can save time by the automatic calculation of current inventory levels of products (finished goods) and also products (in the form of raw materials). All the order details will be managed in one place and you can see purchase and sales trends instantly in this Excel template.

REQUIREMENTS:

Windows: Microsoft Excel 2010, Microsoft Excel 2013

 

PRODUCT TOUR VIDEO:

PRODUCT DEMO VIDEO:

 

 

SETTINGS

The template can handle two different scenarios.

  1. Scenario 1: Buy raw materials from suppliers, receive customer orders and manufacture products and sell them.
  2. Scenario 2: Buy raw materials from suppliers, manufacture products and hold them, and sell them to customers when you receive orders.
Manufacturing Inventory and Sales Manager Excel Template Settings
Manufacturing Inventory and Sales Manager Excel Template Settings

In the first scenario, you are not holding finished goods. In the second one, you are. Before you begin using the template, choose the setting that is appropriate for your business.

Manufacturing Inventory and Sales Manager Excel Template Settings
Manufacturing Inventory and Sales Manager Excel Template Settings

1. PRODUCTS

Enter products in the PRODUCTS sheet. Each line should be a separate product.

  • Description of the product for your reference.
  • Product Category: This allows you to categorize products. If you have numerous products, categorizing similar products together can help in understanding product performance.
  • Re-order point. Quantity that you set for each product, where when the current inventory level hits that amount, you will place a new purchase order to replenish inventory. (For more, read Wikipedia article https://en.wikipedia.org/wiki/Reorder_point)
  • Starting Inventory: Quantity of Product that you have as finished goods when you begin using this template. Enter only once.
Manufacturing Inventory and Sales Manager Excel Template Products Table
Manufacturing Inventory and Sales Manager Excel Template Products Table

2. RAW MATERIALS

Enter list of raw materials in the RAW MATERIALS sheet. Each line should be a separate raw material.

  • Name of the Raw material. Unique Raw Material names required.
  • Description of the Raw Material for your reference
  • Raw Material Category: This allows you to categorize Raw materials. If you have numerous raw materials, categorizing similar ones together can help in understanding performance.
  • Starting Inventory: Quantity of Raw material that you have when you begin using this template. Enter only once.
Manufacturing Inventory and Sales Manager Excel Template  Raw Materials Table
Manufacturing Inventory and Sales Manager Excel Template – Raw Materials Table

3. MANUFACTURING DETAILS

Enter details on how raw materials are converted to products. In the image below, please see rows 1 to 3. You can see that 1 Banana, 5 Strawberries and 10 Blueberries are needed to make 1 unit of Banana Berry Shake (L). See rows 4 and 5. 2 Apples and 2 Bananas are needed to make Apple Banana Shake (L). The Excel template can now understand how inventory needs to be calculated for raw materials and products.

Manufacturing Inventory and Sales Manager Excel Template  -Manufacturing Details
Manufacturing Inventory and Sales Manager Excel Template -Manufacturing Details

4. ORDER DETAILS

It’s time to enter the order details. If you hold finished goods inventory, then there are three types of Orders. Purchase, Sale and Mfg.

  • Purchase Order: When you place an order to acquire raw materials from suppliers.
  • Sale Order: When your customer places an order to buy products from you.
  • Mfg Order: When you manufacture goods and store as finished goods, choose Mfg as Order Type. If you don’t hold finished goods inventory, please do not use Mfg order type.
Manufacturing Inventory and Sales Manager Excel Template - Order Details
Manufacturing Inventory and Sales Manager Excel Template – Order Details
  • ORDER NUMBER: Order number is not used in the template to calculate anything. This has been provided for you to track your orders easily. You can filter the Orders table by choosing specific order number to see all the items in that order. If your systems generate any order numbers, you can enter them here. If you don’t have any such systems, you can create your own. The only recommendation is that you should have a unique order number for each order.
  • ORDER DATE:
    • For Purchase orders, this is the date when the order is placed by you to your supplier.
    • For Sale orders, this is the date when the order is placed by your customer to you.
    • For Mfg orders, this is the date when you placed an internal order to manufacture.
  • EXPECTED DATE:
    • For Purchase and Mfg orders, this is the date when the inventory becomes available for you to sell.
    • For Sale orders, this is the date when the inventory will leave you to the customer.
  • PARTNER:
    • For Purchase orders, your supplier is the Partner.
    • For Sale orders your customer is the Partner.
    • For Mfg orders, you can choose ‘Self’ as the Partner name, since you are manufacturing and holding the finished goods yourself.
  • PRODUCT NAME:
    • For Purchase orders, enter raw material name.
    • For Sale and Mfg orders enter product name.
  • QUANTITY: Number of units of products. The unit can be any numeric value. Even if your unit is not whole numbers, you can still use the Quantity field.
  • UNIT PRICE:
    • In Purchase orders, this is the cost of buying one unit of the product. In Sale orders, this is the revenue from selling one unit of the product. For Mfg orders, it is the cost of manufacturing one unit of product.
  • AMOUNT (Calculated field): (Unit Price X Quantity) = represents the amount of money. In Purchase orders this would be money leaving you and in Sale orders, this would be money that customers pay you. In Mfg orders, this is the amount it spent to manufacture.

REFRESH DATA

After entering any data in the template, please refresh. You can do so by pressing ‘Refresh All’ from DATA Ribbon.

Manufacturing Inventory and Sales Manager Excel Template - Refresh Data
Manufacturing Inventory and Sales Manager Excel Template – Refresh Data

INVENTORY LEVELS

You can instantly view overall current inventory levels (Products available, Quantity and also number products to be re-ordered).

Manufacturing Inventory and Sales Manager Excel Template - Overall Inventory Levels
Manufacturing Inventory and Sales Manager Excel Template – Overall Inventory Levels

CHECK INVENTORY AVAILABILITY

You can see availability of any product by selecting it from the drop down menu.

Manufacturing Inventory and Sales Manager Excel Template - Check Inventory Availability
Manufacturing Inventory and Sales Manager Excel Template – Check Inventory Availability

5. PRODUCT REPORT

View the product report (fully automated) which provides all the inventory information at the product level. The report by default shows the first 1000 products, but you can extend the table by filling down.

  • STARTING INVENTORY: This is the information you provided in Products sheet at the beginning.
  • SALES: Units of the product sold until (and including) today
  • CURRENT INVENTORY (FG) Units of the product currently in inventory as finished goods. = Starting inventory + Manufactured quantity – Sales quantity
  • CURRENT INVENTORY (RM) Units of the product that can be manufactured based on currently available raw materials
  • TOTAL INVENTORY: Units of product that are either available as finished goods or as raw materials. CURRENT INVENTORY (FG) + CURRENT INVENTORY (RM)
  • TO ORDER?: If total inventory is less than or equal to Re-Order Point of product, then ORDER, else NO. You can choose only products to order by selecting ORDER in the filter.
  • SALES RANK: This is the sales rank of the product.
    • Please note that if you have applied filters in SALES_REPORT sheet (which we will see in a few minutes), then SALES RANK will update accordingly.
Manufacturing Inventory and Sales Manager Excel Template - Product Report
Manufacturing Inventory and Sales Manager Excel Template – Product Report

6. RAW MATERIALS REPORT

View the report (fully automated) which provides the inventory information for each raw material. The report by default shows the first 1000 products, but you can extend the table by filling down.

  • STARTING INVENTORY + PURCHASES: Units of raw materials in Starting Inventory + Units purchased until (and including) today
  • USED (TILL NOW): Units of raw materials used in manufacturing products until (and including) today
  • AVAILABLE NOW: Units of raw material available today for use
Manufacturing Inventory and Sales Manager Excel Template - Raw Materials Report
Manufacturing Inventory and Sales Manager Excel Template – Raw Materials Report

7. SALES REPORT

Sales report (fully automated) allows drilling down into the purchase and sales trends overall and also for each product or category.

Manufacturing Inventory and Sales Manager Excel Template - Sales Report Filters
Manufacturing Inventory and Sales Manager Excel Template – Sales Report Filters
Manufacturing Inventory and Sales Manager Excel Template - Sales Report Filters
Manufacturing Inventory and Sales Manager Excel Template – Sales Report Filters

Purchase and Sales (Qty and Amounts) in the last 36 months.

Manufacturing Inventory and Sales Manager Excel Template - Purchases Chart Report
Manufacturing Inventory and Sales Manager Excel Template – Purchases Chart Report
Manufacturing Inventory and Sales Manager Excel Template - Sales Chart Report
Manufacturing Inventory and Sales Manager Excel Template – Sales Chart Report

Amount contribution % by product category

Manufacturing Inventory and Sales Manager Excel Template - Contribution by Product Category
Manufacturing Inventory and Sales Manager Excel Template – Contribution by Product Category

Identify the top 10 products by Sales Amount

Manufacturing Inventory and Sales Manager Excel Template - Top 10 Products
Manufacturing Inventory and Sales Manager Excel Template – Top 10 Products 

 

Announcing Manufacturing Inventory Manager – Excel Template

Posted on
Manufacturing Inventory Sales Manager Excel Template

Friends, I am glad to announce that I have published a new Excel template. The Retail Inventory and Sales Manager is the most popular premium Excel template at indzara.com. It is applicable to retail businesses, but not for manufacturing type of businesses.

Retail Inventory and Sales Manager - Excel Template
Retail Inventory and Sales Manager – Excel Template

 

The new Manufacturing Inventory and Sales Manager Excel template can be used in scenarios where you purchase raw materials from suppliers, manufacture products and then sell to customers. The template is simple and very easy to use. If interested, please see the product page. Early adopters will receive a discount. For a limited time, you can get a 40% discount.

Manufacturing Inventory and Sales Manager - Excel Template
Manufacturing Inventory and Sales Manager – Excel Template

This is the first version of this product. Please provide your feedback in the product support page so that I can understand what upgrades to make in the next version. Thank you for the support.

 

Manufacturing – Inventory and Sales Manager – Excel Template Support

Posted on

This is the Support page for the Manufacturing – Inventory and Sales Manager – Excel Template. Please post any questions related to this template in the comments below.

Product Page:

Manufacturing – Inventory and Sales Manager – Excel Template

Version History:

  • v2 published July 24, 2015
  • v1 published Apr 25, 2015

Useful Links: