Free TimeTrex resource
Reconcile internal and external recruiting spend, calculate cost per hire and compare your chosen budget for the same hire count.
Use the same period, population and currency throughout. All defaults are invented example amounts.
Internal subtotal I = recruiting labor + other internal costs. External subtotal E = agencies + advertising + screening + other external costs. Total T = I + E. Cost per hire = T / H, where H is completed hires in the matching scope and period. This is a currency amount per hire, not a percentage.
The example has internal costs of 14,000 and external costs of 16,000: T = 30,000. With 10 hires, cost per hire is 3,000. The external share is 16,000 / 30,000 × 100 = 53.33%. A chosen budget of 2,500 per hire allows 25,000 for the same 10 hires, so the amount above that budget is 5,000.
Total comparison budget = chosen budget per hire × H. Amount above chosen budget = max(0, T − comparison budget). This gap is an arithmetic comparison with a fixed hire count; it does not promise savings or justify adding hires to improve a ratio.
With zero hires, cost per hire, total comparison budget and budget gap show N/A. Included cost still appears: recruiting activity can incur costs before a hire is completed. With positive hires and zero costs, cost per hire is zero. When total cost is zero, external share is N/A.
Each money field accepts 0 through 1,000,000 with up to two decimal places. Hires must be a whole number from 0 through 1,000,000. Do not use currency symbols, thousands separators or scientific notation in inputs. Totals and budget comparisons use integer cents. Displayed money and percentages round to two decimals; CSV retains the unrounded per-hire ratio. A tiny amount above budget can exist even if two rounded per-hire values look equal.
This worksheet measures included recruiting costs only. Exclude new employees' ongoing pay, post-hire onboarding/training and vacancy opportunity loss. It does not implement a certified accounting standard or the separate cost-per-hire-comparable metric. Category placement is a worksheet convention; use your own consistent accounting policy.
Costs incurred in one period may support hires completed in another. This period-based ratio cannot automatically match invoices to particular hires. If you use a cohort allocation method instead, document it and apply it consistently to both costs and hires. Define treatment of rehires, transfers, contractors and acquisition hires before comparing periods.
Lower cost alone does not establish hiring quality or recruiting effectiveness. Role mix, geography and allocations can change the ratio. Review alongside time to fill and retention, using consistent definitions; do not use it to assess an individual's worth or make an employment decision.
Calculations run in this browser without sending or storing your inputs. Enter aggregate costs only. The tool does not connect to invoices, payroll or candidate records. Downloads contain the entered amounts and calculated results; handle them according to your organization's records policy.
Copy this CSV if your browser blocks the download.
Checked October 23, 2026. The worksheet implements the arithmetic above; it imports no benchmark, recommended budget or legal threshold.
Disclaimer: This aggregate recruiting-cost worksheet uses user-entered costs, allocation choices and hire counts. It cannot verify invoices, payroll allocations, hiring dates, currency consistency or accounting treatment. It excludes post-hire employment and training costs and does not measure quality of hire, vacancy loss, return on investment or an individual’s value. The chosen budget is a scenario, not an industry benchmark or a recommendation for a hiring or employment decision. Display rounding and inconsistent populations or periods can distort comparisons. 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.