Free TimeTrex resource
See how much of your hiring comes from within. Compare two periods, understand the change, and export your results.
Use the same organization boundary and counting rules in both periods. Every filled position belongs in exactly one category below.
Blue = internal · pale blue = external. Text values remain available without color.
Current period
Earlier period
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.
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.
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.
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.
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.
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.
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.
Copy this CSV if your browser blocks the download.
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.
Trusted By
Join our ever-growing community of satisfied customers today and experience the unparalleled benefits of TimeTrex.
Strength In Numbers
Time To Clock-In
Experience the Ultimate Workforce Solution and Revolutionize Your Business Today
Saving businesses time and money through better workforce management since 2003.
Copyright © 2026 TimeTrex. All Rights Reserved.