The Recruitment Agency CRM Spreadsheet: Dual-Pipeline & Placement Guide

For boutique recruitment agencies, independent executive search consultants, and solo headhunters, running a successful recruitment practice requires managing two interconnected sales pipelines simultaneously: Client Job Orders (securing open job reqs from hiring companies) and Candidate Placements (sourcing, interviewing, shortlisting, and placing qualified professionals).

According to a benchmark report by the Staffing Industry Analysts (SIA), agency recruiters spend over 35% of their working hours manually updating spreadsheets, organizing candidate resumes, and tracking interview stages across disjointed email threads. More critically, up to 15% of earned placement fee invoices (typically 15% to 25% of a candidate’s starting salary) suffer from delayed billing because recruiters fail to track candidate start dates and guarantee rebate period expirations.

While enterprise Applicant Tracking Systems (ATS) and recruitment CRMs like Bullhorn, Vincere, Loxo, or Cinch7 exist, their monthly software fees ($900 to $2,400 per recruiter per year) represent an unnecessary overhead expense for solo headhunters and lean 2-to-5-person recruitment agencies.

In this ultimate guide, we will show you step-by-step how to build a production-ready Recruitment Agency CRM Spreadsheet in Google Sheets or Microsoft Excel. You will learn how to manage dual-sided pipelines, index candidate skill matrices, track interview stages, calculate placement fee commissions, and monitor time-to-fill metrics without monthly software fees.

Why Independent Recruiters Need a Spreadsheet CRM

Agency recruitment operates differently from corporate internal HR. Agency recruiters manage multi-client fee agreements, candidate availability statuses, placement rebate guarantee periods (e.g. 90-day replacement clause), and commission splits between sourcing and account management.

Here is why independent headhunters choose Google Sheets or Excel over complex ATS software:

Zero Recurring Seat Costs: Recruitment revenue is deal-based. Eliminating $100/month per seat software costs protects agency cash flow during quiet hiring months.
Instant Mobile Sourcing Access: Storing candidate contact details, target salary requirements, current notice periods, and resume links in a cloud Google Sheet allows recruiters to review candidate files on smartphones or tablets while attending industry networking events.
Flexible Placement Fee Calculations: Recruitment fee agreements vary widely—perm placement contingency fees (15% to 25% of annual salary), retained search milestones (1/3 upon kickoff, 1/3 upon shortlist, 1/3 upon placement), or contract day rates. Spreadsheets allow custom formula ledgers for every fee structure.
Data Ownership & Candidate Privacy: Keeping candidate records and client contacts in your private Google Workspace account ensures complete administrative control without storing confidential executive resumes in third-party SaaS cloud databases.

Architecture of a Dual-Sided Recruitment CRM

To keep your recruitment agency organized, fast, and profitable, structure your spreadsheet into six core tabs:

[1. Client Job Orders] ➔ [2. Master Candidate Database] ➔ [3. Interview & Selection Tracker] ➔ [4. Placement & Fee Ledger] ➔ [5. Candidate Skill Matrix] ➔ [6. Agency Analytics Dashboard]

Tab 1: `Client Job Orders`

Tracks active client hiring requirements (Job Title, Client Company, Hiring Manager, Target Salary Range, Agreed Fee %, Job Order Stage).

Tab 2: `Master Candidate Database`

Indexes candidates by Name, Primary Skill Set, Current Title, Years Experience, Target Salary, Notice Period, Availability, Resume Link, and Status.

Tab 3: `Interview & Selection Tracker`

Monitors candidates moving through client interview stages: Shortlisted ➔ 1st Interview ➔ 2nd Interview ➔ Final Round ➔ Offer Extended ➔ Accepted.

Tab 4: `Placement & Fee Ledger`

Logs completed placements, candidate start dates, calculated placement fee amounts, invoice issuance dates, and 90-day rebate guarantee expiration dates.

Tab 5: `Candidate Skill Matrix`

Indexes candidates by tech stack, industry sector, language skills, and geographic location for instant keyword filtering.

Tab 6: `Agency Analytics Dashboard`

Displays high-level executive analytics: total placement fee revenue YTD, open job order counts, average time-to-fill (days), and fee realization by recruiter.

Step-by-Step: Building Your Recruitment CRM Spreadsheet

Let’s build the Client Job Orders and Placement & Fee Ledger tabs in Google Sheets or Excel.

1. Structure the Client Job Orders Tab

Create a tab named Job Orders and set up the following headers in Row 1:

Column	Header Name	Data Type	Description / Formula
A	Req ID	Formula	`=IF(ISBLANK(B2), "", "JOB-" & TEXT(ROW()-1, "0000"))`
B	Job Title	Text	Position title (e.g. `Senior Software Engineer`)
C	Client Company	Text	Hiring company name
D	Target Salary ($)	Currency	Base annual salary budget
E	Agreed Fee (%)	Percentage	Contracted placement fee split (e.g. `20%`)
F	Expected Fee ($)	Formula	`=D2 * E2`
G	Job Order Stage	Dropdown	`1. Briefed`, `2. Sourcing`, `3. Shortlist Sent`, `4. Interviewing`, `5. Offer Stage`, `6. Placed`, `7. Cancelled`
H	Target Start Date	Date	Projected start date
I	Assigned Recruiter	Text	Lead recruiter name
J	Req Alert Status	Formula	Visual alert checking job order staleness

2. Automating Placement Fee Invoicing & Rebate Expiration

Calculating placement fees and tracking 90-day rebate guarantee expiration dates protects agency revenue:

A. Expected Placement Fee Calculation (Column F)

In cell F2, calculate projected recruitment fee revenue:

=IF(OR(ISBLANK(D2), ISBLANK(E2)), 0, D2 * E2)

Example: Placing a Senior Engineer at a $130,000 base salary with a 20% agreed fee yields a $26,000 placement fee.

B. 90-Day Guarantee Rebate Expiration Alert

On the Placement & Fee Ledger tab, calculate when a placement’s 90-day guarantee period expires:

=IF(ISBLANK(Candidate_Start_Date), "", Candidate_Start_Date + 90)

In cell G2, write a conditional logic check:

=IF(TODAY() > Guarantee_Exp_Date, "✅ REBATE EXPIRED (Fee Secure)", "⚠️ IN GUARANTEE PERIOD (" & (Guarantee_Exp_Date - TODAY()) & " Days Left)")

Explanation: If the 90-day start date milestone has passed, flags as ✅ REBATE EXPIRED (Fee Secure). Otherwise, displays days remaining in the guarantee period.

3. Sourcing & Candidate Skill Matrix Queries

When a client briefs a new Senior DevOps Engineer role, finding qualified candidates instantly within your database is critical.

Use FILTER or QUERY on your Candidate Skill Matrix tab:

=QUERY(Candidates!A:I, "SELECT A, B, C, D, H WHERE C CONTAINS 'DevOps' AND G = 'Available Immediately' ORDER BY D DESC")

This formula instantly filters your entire candidate database for available DevOps engineers, sorted by years of experience!

5 High-Margin Productivity Hacks for Headhunters

Store Direct Resume Drive Links: Include Google Drive share links for candidate resumes in Column K for instant one-click access during client submission calls.
Log Notice Periods for Rapid Placement: Tag candidates by notice period (Immediate, 2 Weeks, 1 Month, 3 Months). When a client demands an urgent fill, filter for Immediate or 2 Weeks availability.
Track Sourcing Channel ROI: Log candidate sourcing origins (LinkedIn Recruiter, Referral, Job Board, Direct Outreach) to identify your highest-yielding candidate channels.
Log Interview Feedback Standardized: Record client interview feedback (e.g. “Strong technical skills, candidate requested $120k salary, client moving to final round”) in your Interview Tracker tab.
Audit Unpaid Placement Invoices: Set conditional formatting to highlight completed placements where candidate start dates have passed but invoice status remains Unpaid.

Frequently Asked Questions (FAQ)

Can a recruitment agency manage both perm placements and temp/contract billing in this sheet?

Yes! In your Job Orders tab, set the Fee Structure dropdown to Permanent Contingency, Retained Executive Search, or Contract Day Rate. The spreadsheet applies appropriate fee math based on the selected hiring model.

How do I track candidate submissions to multiple client companies?

In the Interview & Selection Tracker tab, each row links a specific Candidate ID to a specific Job Req ID. One candidate can have multiple active interview rows across different client companies simultaneously.

Is Google Sheets secure for storing confidential executive candidate CVs and salary details?

Yes. Google Sheets uses enterprise Google Cloud encryption. Ensure your Google account uses Two-Factor Authentication (2FA), restrict spreadsheet edit permissions to authorized agency recruiters, and avoid sharing candidate sheets publicly.

Upgrade to the ViaSheet Recruitment Agency CRM Spreadsheet

Building a dual-sided recruitment database with job req pipelines, candidate skill matrices, placement fee calculators, and 90-day rebate radars requires hours of formula design.

If you want a pre-built, battle-tested spreadsheet engineered specifically for boutique recruitment agencies and solo headhunters, explore our Recruitment Agency CRM Spreadsheet.

The ViaSheet Recruitment Agency CRM features:

Agency Executive Dashboard: Real-time stats on open job reqs, total placement fee revenue YTD, placements completed this month, and recruiter time-to-fill averages.
Dual-Pipeline Architecture: Manage client job orders on one side and active candidate submission pipelines on the other.
Master Candidate Database: Store candidate profiles, primary skill sets, target salary expectations, notice periods, and resume drive links.
Interview & Selection Tracker: Monitor candidate progress through shortlist, 1st round, final round, and offer extended.
Placement & Fee Ledger: Automatically calculates placement fees (% of salary), tracks invoice clearing dates, and monitors 90-day rebate guarantee expirations.
Candidate Skill Filter Engine: Instantly query your database by skill stack, availability, and location.
One-Time Purchase: Pay just €39 once for lifetime access in Google Sheets and Microsoft Excel—no monthly fees or subscriptions ever.

Fill roles faster, protect your placement fee invoices, and scale your recruitment practice. Download the ViaSheet Recruitment Agency CRM today!