Skip to content

Recruitment Budget Template

Every dollar, on plan.

We're Hireloud, a recruitment marketing agency. We fill interview seats and keep job-ad budgets on plan. Here's the template, free.

Guide · Last reviewed November 2026 · Sources linked below

Short answer

Give each role group its own cap. Plan to date is the cap × days elapsed ÷ days in the period, so day 15 of 30 means about half spent. Within ±5% is on plan. Spend no group owns gets its own row.

Month-to-monthNo long-term contractsProcurement-friendly

The template

One job: control the ad budget.

Most hiring-cost sheets lump salaries, agency fees, job ads and recruiter time into one total. That helps with headcount planning. It can't tell you whether this month's job ads are on plan.

This template does one job. It controls your recruitment advertising budget: paid search, paid social, job sites and programmatic job ads. Each role group gets one row, with its own cap, pace and status. A role group is a set of roles you budget together, such as retail, warehouse or healthcare.

ColumnWhat goes in itWhere it comes from
Role groupA set of roles you budget together.You type it
CapThe most the group can spend this period.You type it
Days in periodCalendar days in the period, such as 30.You type it
Days elapsedToday's day number in the period, such as 15.You type it
Plan to dateWhat the group should have spent by today.Cap × days elapsed ÷ days in period
Spent to dateWhat the group has spent so far.Each platform's spend report
VarianceHow far spend is from plan.Spent − plan to date
StatusOn plan, Ahead, Behind or Over cap.On plan within ±5% of plan to date. Over cap once spend passes the cap.
Daily spend to finishWhat each day left can spend to land on the cap.(Cap − spent) ÷ days left
ChangesThe date, what changed and who approved it.You type it

Two rows sit under the named groups. Unassigned holds spend that isn't tied to a group. Total adds it all up. Salaries, agency fees and background checks stay with payroll and finance. What happens after the click (applications, interviews, offers) stays in your applicant tracking system.

Caps

Set a cap for each role group.

A cap is the most a group can spend in the period. You don't need new budget to set caps. They split the job-ad budget you already have, group by group.

  1. Step 1

    Start from last period's spend.

    Pull last period's ad spend by role group. Only have one blended total? Split it by the roles each campaign ran for.

  2. Step 2

    Count open roles by location.

    A group with more open roles, or roles open in more places, usually needs a bigger share.

  3. Step 3

    Mark the seasonal peaks.

    Note the months a group staffs up for a busy season. Raise its cap for those periods only.

  4. Step 4

    Write the caps down. Then hold them.

    Change a cap only with a dated entry in the Changes column. The record then shows who moved what, and when.

If the caps add up to more than the total budget, cut before the period starts. Cutting halfway through leaves some groups short just when they need it.

Pacing

Even pacing, in one formula.

Calendar-even pacing means a group spends its cap at a steady rate. The share of the cap spent matches the share of the period gone. Day 15 of 30 means about 50% spent.

The formula

Plan to date = cap × days elapsed ÷ days in period

HypotheticalA $6,000 cap over a 30-day month. On day 10, plan to date is $6,000 × 10 ÷ 30 = $2,000. Spent $2,600? The group is $600 ahead.

The template marks a group On plan within ±5% of plan to date. Beyond that, it's Ahead or Behind. The band lives in one cell, so finance can change it.

Each row works like one run of our budget pacing calculator. The same cap, days and spend give the same plan to date, variance and status.

Why one day over budget is normal.

On the big ad platforms, a daily budget is an average, not a daily limit. That's why the template judges each group on its whole period, never on a single day.

Google Ads

What Google says

A campaign can spend up to twice its average daily budget on a given day. By the end of the month, it has spent no more than 30.4 times that budget.1

In the template

For a monthly cap, set the average daily budget to the cap ÷ 30.4 and keep it there all month. Since January 2026, Search, Performance Max and Shopping campaigns can also take a campaign total budget for a set 3 to 90 days. Google says you'll never be charged more than that total.2

Meta (Facebook, Instagram)

What Meta says

On days with better opportunities, up to 25% more than the daily budget may be spent. With ad set budget sharing on, it may spend up to 75% over.3

In the template

For a monthly cap, set the daily budget to the cap ÷ days in the period. Then judge the group on plan to date, not on one day.

Indeed (Sponsored Jobs)

What Indeed says

The daily budget is "an average, not a strict cap." A 15- or 30-day plan can spend up to the daily budget × its days. A plan with no end date can spend up to 7.5 × the daily budget in a week.4

In the template

For a 30-day plan, set the daily budget to the cap ÷ 30. Indeed bills on the 1st of the month or when spend reaches $500, whichever comes first.5 So take spend from the report, not from invoice dates.

So one day over budget is normal. A group that stays ahead several days in a row is your signal to act.

Unassigned

Give stray spend its own row.

Some spend won't belong to one group. A careers search campaign that covers every role. A hiring-event ad for several groups. A test campaign nobody tagged.

Put it on its own row, called Unassigned. It has no cap and no plan. Don't spread it across the named groups. Do that and no group's figure is its own any more, and nobody can say what a group really spent.

When you can tie the spend to a group, move it there with a dated entry in the Changes column. The total doesn't change: named groups plus unassigned equals all spend.

Good naming keeps this row small. Give each role group one campaign name, and carry it into your tracking tags. Our job link UTM builder sets one campaign name per group.

Worked example

The template, in action.

Round numbers for illustration, not results. It's November, day 15 of 30, and the five caps add up to $40,000.

November · Day 15 of 30

Hypothetical example
  • Retail & hospitalityOn planSpent $7,800 of $16,000 · plan $8,000 · −$200
  • Warehouse & distributionAheadSpent $5,300 of $10,000 · plan $5,000 · +$300 · slowed
  • Skilled tradesOn planSpent $1,950 of $4,000 · plan $2,000 · −$50
  • HealthcareOn planSpent $3,000 of $6,000 · plan $3,000 · $0
  • CorporateBehindSpent $1,700 of $4,000 · plan $2,000 · −$300 · adjusting
  • UnassignedOwn rowSpent $150 · no cap
  • TotalBudget: on planSpent $19,900 of $40,000 · plan $20,000 · −$100

Yellow tick = plan to date. Hypothetical figures, no real employer. It shows how spend is controlled, not results.

How to read it.

Halfway through November, $19,900 of $40,000 is spent. That's $100 under the $20,000 plan. Three groups are on plan. Warehouse & distribution is $300 ahead, 6% over its plan, so it's slowed for the rest of the week. Corporate is $300 behind, 15% under, so the gap is spread over the rest of the month. $150 isn't tied to a group yet, so it sits on its own row.

Check the sums the way finance will. Named groups ($19,750) plus unassigned ($150) equal $19,900 spent. $19,900 minus the $20,000 plan is −$100.

Download

Take the template. It's free.

No email. No sign-up. Your browser builds the file on the spot.

  • XLSXThree tabs: a blank Budget sheet with live formulas, the hypothetical example and How to use. Opens in Excel or Google Sheets.
  • CSVThe same columns and formulas on one sheet, for any tool that imports CSV.

Columns match the pacing calculator. In the XLSX, shaded cells are the ones you fill in.

Finance

Take it to finance.

Finance doesn't need the ad platforms' dashboards. It needs three answers for every role group.

Where did each dollar go?

A named role group

One row per group answers it.

Is it on plan today?

Calendar-even pacing

Plan to date, variance and status answer it.

Was the job still open?

Ads on open jobs only

A spreadsheet can't answer this one. It takes your ads checked against your open jobs.

Send the sheet with a short note on how it works. This one is written to forward as it is.

For finance · copy and forward

Our recruitment ad budget is split into role groups. Each group has a cap for the period. Plan to date is the cap × days elapsed ÷ days in the period, so day 15 of 30 means about 50% spent. A group is on plan within ±5% of that figure. Spend that isn't tied to a named group is reported on its own row, not spread across the others. Every cap change is logged with its date and who approved it.

Looping in procurement too? Here's how we work with procurement teams: we sign your NDA first, with an MSA, W-9 and certificate of insurance on request.

Budget size

How much should you spend?

This template won't tell you what to spend. It keeps what you do spend under control. Start from last period's spend by group, then test it against outside cost data for the roles you hire.

Our guide to recruitment advertising cost benchmarks collects third-party cost-per-click figures by occupation, each with its source and date. On Indeed, each sponsored job comes with a recommended budget. You can set a different amount, as long as it meets that job's minimum.5

Decide what you'll count before you decide what to spend. Spend and pacing are control figures, not results. Our guide to recruitment marketing metrics covers what to track, and who can measure it.

Rather hand it over?

Get a budget plan built for you. Free.

Your free hiring plan: where your job ads run now and what to fix, a channel and budget plan for your hardest role, and a sample ad in your brand. In your inbox within 3 business days. No call needed. Then we run it all for you: more people in your interview seats, each budget kept on plan, live for you to see.

Month-to-monthNo long-term contractsProcurement-friendly

Quick answers.

Anything else? A person replies within one business day.

  • One row per role group, each with a cap, days in the period, plan to date, spend to date, variance, status and a log of changes. Add one unassigned row for spend that isn't tied to a group. Salaries, agency fees and other hiring costs belong in a separate sheet.

  • Split by role group first, then by location inside each group. Weight each location by its open roles and its seasonal peaks. Point each location's ads at that location's open job listings, so the spend and the jobs match.

  • Compare it with plan to date, not with one day. Platforms can spend above a daily budget on a single day. If the group stays ahead for several days, lower its daily budget to the daily spend to finish. Then log the change with its date.

  • Usually not. Caps split the job-ad budget you already have. You can start with one role group and add the others later.

Sources

  1. 1Google Ads Help, "About overdelivery and your average daily budget" (answer 2375423). Up to twice the average daily budget on a given day; no more than 30.4 times it by the end of the month. Checked Nov 2026. support.google.com/google-ads/answer/2375423
  2. 2Google, "Campaign total budgets expands to more campaign types", Jan 15, 2026 (Search, Performance Max and Shopping, in open beta). Google Ads Help, "About campaign total budgets" (answer 10486938): 3 to 90 days; "you will never be charged more than your total budget." Checked Nov 2026. blog.google · support.google.com/google-ads/answer/10486938
  3. 3Meta for Developers, Marketing API, "Budgets" (up to 25% more than the daily budget) and "Ad Set Budget Sharing" (up to 75% over). Checked Nov 2026. Budgets · Ad set budget sharing
  4. 4Indeed Help Center, "Managing Sponsored Job Budgets" (article 360026629712). "Your daily budget is an average, not a strict cap"; daily budget × days for set running times; 7.5 × daily budget per week with no end date. Checked Nov 2026. indeed.com/help/employers/articles/360026629712
  5. 5Indeed for Employers, "Pricing". Billed on the first day of the month or at $500 of spend, whichever comes first; a recommended budget per job, and a minimum each job must meet. Checked Nov 2026. indeed.com/hire/pricing

Last reviewed November 2026. Platform budget rules were checked on Google's and Indeed's help pages and Meta's developer docs that month. Example figures are hypothetical.

Let's fill your interview seats.

Tell us who you're hiring and where. We'll email you:

  • A sample ad for your hardest role, in your brand
  • Where we'd run it, and the budget we'd use
  • What to fix in the job ads you run now

In your inbox within 3 business days.

Free Hiring Plan

Required

Who are you hiring? (required)

Pick all that apply.

How many locations? (required)

For example: forklift operator, 2nd shift, Dallas

We'll send your plan here.

Free. No call needed. Your plan lands in your inbox within 3 business days.

Month-to-monthNo long-term contractsProcurement-friendly

By sending this you agree to our privacy notice.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.