Internal Fill Rate Calculator

Free TimeTrex resource

Internal Fill Rate Calculator

See how much of your hiring comes from within. Compare two periods, understand the change, and export your results.

Enter completed vacancy fills

Use the same organization boundary and counting rules in both periods. Every filled position belongs in exactly one category below.

Current period

Earlier comparison period

Your internal hiring mix

Current internal fill rateInternal fills ÷ all completed fills × 100
Current internal fills
Current external fills
Current total fills
Earlier internal fill rate
Change in internal share
Relative change in internal rate
Change in total fill volume

Internal versus external share

Blue = internal · pale blue = external. Text values remain available without color.

Current period

Earlier period

What is internal fill rate?

Internal fill rate is the proportion of completed vacancy fills made by people who already work within your chosen organization boundary. It describes where successful appointments came from. It is useful for reviewing career movement and the balance between internal and external recruitment. It does not measure the percentage of all employees who moved roles, the speed of recruitment, or the share of open jobs that have been filled.

Prepare the counts in five steps

  1. Set the reporting boundary. Choose a company, business unit or location and write it down. An employee transferring between two departments can be internal to the company but external to a department-only boundary. Apply the same rule in both periods.
  2. Choose one event date. This worksheet uses the effective start date in the filled role. Count fills whose role start date falls within each reporting period, even when recruitment began earlier. Keep the date basis consistent; do not mix offer dates, acceptance dates and start dates. Exclude accepted offers that never started.
  3. Classify each fill once. Use promotion first, then lateral move, then other internal fill, or external fill. The internal categories are mutually exclusive. For example, a promotion that also transfers departments belongs in promotions only. Other internal fills may include a move to a lower-level role if it fills an actual vacancy. Decide how to treat returners, agency conversions and temporary assignments, and record that policy before counting.
  4. Reconcile the denominator. Internal promotions + lateral moves + other internal fills + external fills must equal all completed fills in the selected scope. Resolve unknown classifications first. Exclude unfilled or cancelled requisitions, applications, rejected offers, and title-only changes that do not fill a vacancy. A requisition for five positions can produce five fill events; count positions filled, rather than requisition documents.
  5. Compare like periods. Equal-duration periods make volume comparisons more useful. Keep role families, employee coverage and organizational boundaries consistent. Note reorganizations, acquisitions and changed data definitions alongside the report. Enter aggregate counts, without names or personal information.

Formulas and worked example

Internal fills I = promotions + lateral moves + other internal fills. Total fills T = I + external fills. Internal fill rate R = I ÷ T × 100. External share = external fills ÷ T × 100. The change in internal share is current R − earlier R, expressed in percentage points. Relative rate change = (current R ÷ earlier R − 1) × 100, when the earlier rate is positive. Fill-volume change = (current T ÷ earlier T − 1) × 100, when the earlier total is positive.

In the example, 8 promotions + 5 lateral moves + 2 other internal fills = 15 internal fills. With 35 external fills, the total is 50 and internal fill rate is 30.00%. The earlier period has 8 internal and 32 external fills: 8 ÷ 40 × 100 = 20.00%. Internal share increased by 10.00 percentage points. Its relative increase is 50.00%, while total fill volume increased 25.00%. These example counts illustrate the arithmetic; they are not targets or typical results.

Why percentage points and percent change differ

Moving from 20% to 30% is an increase of 10 percentage points. It is also a 50% increase relative to the earlier 20% rate. Both can be valid, but they answer different questions. Use percentage points to describe the shift in hiring mix and show counts beside the rates, especially when there are few fills.

When the earlier internal rate is zero, relative rate change is N/A. A move from 0% to 30% still has a defined increase of 30 percentage points. No infinite growth rate is displayed.

What happens with no hiring or no internal fills?

With no completed fills in a period, the denominator is zero and its rate is N/A, rather than 0%. The mix bar is marked unavailable. A comparison of rates requires a nonzero total in both periods. With positive total fills and zero internal fills, the rate is exactly 0%. With only internal fills, it is 100%.

When the earlier total is zero, volume change is N/A. When the current total falls to zero from a positive earlier total, volume change is −100%, even though the current internal rate is undefined. A zero earlier internal rate makes relative rate change undefined; it does not make a defined percentage-point change undefined.

Is a higher internal fill rate always better?

No universal target is supplied. The appropriate hiring mix depends on role requirements, available skills, organizational growth and business needs. A high rate by itself does not prove better quality, fairness, retention, cost or performance. Internal movement may also create a backfill vacancy in the employee's former role. This worksheet does not forecast those vacancies or calculate savings.

Review this ratio alongside time to fill, skills coverage, new-hire retention and recruitment costs. Compare matched roles and periods before interpreting a change. Do not use aggregate results to rank candidates or determine an individual employee's opportunity.

Does one employee moving twice count twice?

This worksheet counts completed fill events. If the same employee starts in two distinct filled vacancies during the period, count two events under the stated convention. If you need the share of employees who moved, deduplicate employee records and use a separate employee-based mobility analysis. Do not mix event counts in the numerator with unique employees or average headcount in the denominator.

Exports, input limits and privacy

Each field accepts a whole number from 0 to 1,000,000. Blank, negative, fractional, exponent and comma-separated entries are rejected. The tool calculates with unrounded ratios and rounds displayed percentages to two decimals. Rounded internal and external shares may differ slightly from a displayed 100% total. CSV includes unrounded numbers, aggregate inputs, formulas and counting assumptions.

Calculations run in your browser with no application storage or connection to employee records. The CSV and print report contain your entered aggregate values. Store your organization boundary, actual period dates, classification policies and source records with the downloaded report. Browser settings can affect downloading and printing.

Primary sources and measurement scope

Primary definitions checked October 28, 2026. The formulas, date basis and categories above are this independent worksheet's stated conventions. No industry target or external benchmark data is loaded.

Disclaimer: This aggregate planning worksheet measures internal vacancy fills divided by all classified completed fills for each reporting period. It counts fill events rather than unique employees, headcount, applicants or currently open vacancies. Results depend on consistent scope, dates, classification and complete records. It does not assess individual candidates, establish an ideal hiring mix, predict retention or savings, or recommend employment decisions. Verify all inputs, results and assumptions against appropriate records and obtain qualified advice before relying on them. To the fullest extent permitted by applicable law, this resource is provided “as is” without warranties of accuracy, completeness or fitness for a particular purpose, and TimeTrex and its affiliates disclaim liability for losses, damages, costs or claims arising from its use, inability to use, or reliance on it, including errors or omissions. Nothing in this disclaimer excludes or limits liability or rights that cannot lawfully be excluded or limited.

Found our Free Internal Fill Rate Calculator useful? Bookmark and share it.

Facebook
X
LinkedIn
Email
WhatsApp
Print
Blue employee figurines moving between an office doorway and a role podium beside a hiring mix chart

Trusted By

Trusted by 3.4M+ Employees: 23 Years of Service Across Startups to Fortune 500 Enterprises

Join our ever-growing community of satisfied customers today and experience the unparalleled benefits of TimeTrex.

Logo for H&R Block
Hilton Hotels and Resorts logo
HP computers logo
Oracle logo black and white
PWC brand logo
Texas A&M University logo
Mcdonald's brand logo
New York Stock Exchange Logo black and white
Walmart brand logo
London Drugs logo black and white

Strength In Numbers

Join The Companies Already Benefiting From TimeTrex

Users
0
Companies
0
Years
0

Time To Clock-In

Start your 30-day free trial!

Experience the Ultimate Workforce Solution and Revolutionize Your Business Today

TimeTrex Mobile App Hand