Recruiter Commission Tracking vs Spreadsheets in 2027

A spreadsheet works until splits, clawbacks and volume multiply

Recruiter commission tracking is the running record of each placement, the fee it produces, how that fee is split among recruiters, and when each payout or clawback is due.

TL;DR: A spreadsheet is a sound choice for a firm with one or two recruiters, a single split rule and a monthly reconciliation. Once you add team pools, tiered rates or guarantee-period clawbacks, the spreadsheet starts to hide errors, and a commission tool or an applicant tracking system (ATS) commission feature starts to earn its cost.

The decision turns less on feature lists than on two questions. The first is who checks the numbers each pay cycle. The second is what happens when a placed candidate leaves early and the fee has to be partly returned. A spreadsheet can answer both questions if one person owns it and the rules are written down. A dedicated tool helps when the rules are too many for one person to hold, or when the owner needs a record that someone else can audit.

Key Takeaways

• A spreadsheet is cheap to start and fails quietly as split rules and placements multiply. Research on spreadsheet errors describes them as common and non-trivial.

• Of the four vendors checked, only Bullhorn and Recruiterflow publish list prices. Core Commissions and Ceipal publish none on the pages reviewed.

• Core Commissions documents splits, team pools, accelerators, bonuses and spiffs on its recruiter commission page. The Bullhorn and Recruiterflow pricing pages do not list commission tracking as a feature.

• Clawbacks depend on your written guarantee terms. No tool replaces the rule you apply to them.

• A proposed workflow can draft commission rows and flag clawback dates, but a person should approve every change to a payout.

Who this is for

This guide is for owners and operations leads at small recruiting businesses who are deciding between keeping commissions in a spreadsheet and paying for a tool. It assumes you already place candidates and pay recruiters a share of each fee, whether that share is a flat rate or a tiered schedule.

Red flags: you have no written split or clawback rules, placements are recorded in several places with no single source of truth, or you expect software to decide pay without a person signing off.

How we evaluated these options

We weighted six criteria by how much each one decides outcomes for a small firm. The weights are our judgment, not vendor data. The sources are public vendor pages, an academic review of spreadsheet errors, an industry association's compensation survey page, and one vendor-published study that we label as such. The pages checked describe each named product as current, and none says it was renamed, merged or discontinued. We did not verify ownership history beyond what those pages state.

The American Staffing Association's 2026 compensation survey lists "commission formula and calculation components" as a topic, which makes it relevant to this decision. Its published page gives no recruiter commission rates, and the full results sit behind a paywall: Full ASA results cost $200 for members according to American Staffing Association (2026). Nonmember access is listed at $500, and results open only after data collection closes, so a firm needing numbers this quarter will not get them from that source.

Where the spreadsheet holds up and where it breaks

The strongest academic source in this guide is Raymond Panko's review of spreadsheet errors, which concludes: "Fifteen years of research studies have concluded unanimously that spreadsheet errors are both common and non-trivial" according to arXiv. The paper was first presented in 2000 and posted to arXiv in 2008, so it describes spreadsheets in general, not recruiting firms in particular.

A more specific number comes from a vendor. Everstage, which sells sales compensation software, ran a 2026 study with 400-plus revenue operations and compensation leaders. Vendor survey: 60% still run commissions on homegrown spreadsheets according to Everstage (2026). That sample was US and UK B2B software companies with 200 to 2,000 employees, so the figure describes software sales teams, not staffing firms. Read it as a directional signal, not a staffing benchmark.

The spreadsheet's strongest case is simple: one owner, one split rule, a handful of placements each month, and a reconciliation against the placement list before every pay run. It breaks in three predictable places. The first is clawbacks, because a guarantee window needs someone to remember a date months after the placement. The second is split changes, because a rule change has to be applied to every open row and rarely is. The third is key-person risk. When one operator holds the only working copy of the formulas, the firm depends on that person's availability.

If your real problem is per-recruiter activity reporting rather than payouts, the weekly pipeline reports playbook covers that side of the work, and it is a separate decision from commission calculation.

What each option publishes, side by side

The matrix below records what each page says. An entry marked "Not listed" means the page checked did not mention the feature. It does not prove the product lacks the feature, so confirm each gap in a demo.

Two rows matter most for a small firm. The first is split and pool support, since that is where spreadsheets fail first. The second is whether the vendor publishes a price, since that decides whether you can compare total cost before a sales call.

Pricing and total cost

Pricing checked October 30, 2026. Only two of the four vendors publish list prices on the pages checked, and their figures are per user, so total cost scales with the number of people who need access.

Starter list price: $99 per user per month according to Bullhorn (2026). Bullhorn's Core plan carries a higher list price, and its Pro and Max plans are quote-based. The same page says prices exclude applicable sales tax, that there are no setup fees, and that free implementation is included with Starter, Core and Pro but not with Max.

Core list price: $165 per user per month according to Bullhorn (2026). Onboarding and Middle Office are optional and priced separately, so the number above is a starting point, not the full cost.

Platform list price: $149 per user per month according to Recruiterflow (2026). Recruiterflow's AIRA plan is custom-priced, and the same page lists API access as part of the Platform plan.

Ceipal's site and Core Commissions' recruiter commission page publish no prices, so those cells read "Not published." The five-seat column below multiplies each published list price by five users and twelve months. It is arithmetic on list prices, not a quote.

The spreadsheet's direct cost is usually small, but its real cost is the hours someone spends each pay cycle and the cost of corrections after an error. The worked example below puts a rough figure on that time. The number of seats is the main driver of subscription cost, so a firm that needs commission visibility for only the operations lead can price very differently from one that needs every recruiter logged in.

Vendor profiles

Bullhorn

Best fit: a firm that already needs a full applicant tracking and candidate-management system for many users and wants to add commission handling later. Choose it when the ATS is the main purchase and commissions are secondary.

Limitations: the pricing page does not list commission or placement fee tracking in any plan, so confirm in a demo that split rules and clawback dates can be recorded before you buy. Pro and Max are quote-based, and onboarding is optional and priced separately.

Implementation: free implementation is included with Starter, Core and Pro. The vendor says it does not currently offer a free trial, so plan a demo with your own split rules. Evidence: the Bullhorn pricing page.

Disqualifier: if your commission rules are complex and the demo cannot show them, the subscription buys an ATS you still need to pair with a spreadsheet.

Recruiterflow

Best fit: a firm that wants an applicant tracking system and a CRM on one per-user plan, with API access, and can accept commission rules built around it. It is a simpler choice than Bullhorn when the goal is a clean record of candidates and placements.

Limitations: the pricing page does not mention commission tracking, per-placement fees or a free trial. The AIRA plan is custom-priced. White-glove data migration is priced by data volume, while self-serve import from Excel or CSV is free.

Implementation: self-serve import is free, so a firm moving from a spreadsheet can bring its placement list over without a paid migration. Evidence: the Recruiterflow pricing page and the Platform price cited above.

Disqualifier: if you need commission splits calculated automatically and the vendor cannot show them, the platform will still need a commission process next to it.

Core Commissions

Best fit: a firm with complex commission math, such as several recruiters on one placement, team pools, accelerators, bonuses and spiffs. Its recruiter commission page lists these rule types directly, which makes it the most specific of the four vendors on commission mechanics.

Limitations: the page names no applicant tracking or accounting platform, so you must confirm which systems it connects to. It publishes no price, only a low-cost proof-of-concept program called Quick Start.

Implementation: the Quick Start program is the only evaluation path named on the page, so ask for a trial run on your real split rules before signing. Evidence: the Core Commissions recruiter page.

Disqualifier: if your ATS or accounting system must connect directly and the vendor cannot confirm the connection, a spreadsheet export will be the bridge, and that bridge brings the error risk back.

Ceipal

Best fit: a firm that wants commission tracking to start at placement, inside a wider recruiting system. Its module describes tracking that starts when a placement is secured, with reports showing whether each commission is payable and whether it has been paid.

Limitations: the module page names no API or integration, and Ceipal publishes no prices on the pages reviewed. The page offers demos rather than a trial.

Implementation: you add the commission package and conditions once a placement is secured, so the setup work sits in the first placement record. Evidence: the Ceipal commissions module article.

Disqualifier: if you need the price before a sales call or need to see clawback handling written down, the public pages will not answer either question.

Spreadsheet (Google Sheets or Excel)

Best fit: one owner, one split rule, a few placements each month and a reconciliation before each pay run. It is the lowest-cost option for a firm that can hold the rules in its head and write them into a locked template.

Limitations: a spreadsheet has no built-in clawback timer and no audit log a reviewer can rely on without a written process. Key-person risk is the largest limitation, because the formulas often live with one operator.

Implementation: you design the template yourself. If you want a script to add one row per placement, the Google Sheets API reference lists ten methods on its values resource, including the spreadsheets.values.append method, according to Google for Developers (2026). That gives you a programmatic route, but it does not calculate splits or check clawback dates.

A worked example for a five-recruiter firm

Assume an illustrative firm with five recruiters that closes 12 placements a month. These are assumed numbers for the arithmetic, not a benchmark. If each placement takes 30 minutes to look up the split rule, enter the fee, check the guarantee date and record the payout, the work is 6 hours a month (12 × 0.5 = 6), or 72 hours a year (6 × 12 = 72). At an assumed $40 an hour for an operations lead's time, that is $2,880 a year (72 × 40 = 2,880) before any correction of errors. A script that adds one row per placement through spreadsheets.values.append cuts the typing, but a person still has to check each split and each clawback date, so the 72 hours shrink rather than disappear.

Two proposed US Tech Automations workflows

A proposed US Tech Automations design for this case is a configurable plan, not a live deployment or a measured result. US Tech Automations describes building and supporting custom workflows, with integrations listed for Gmail, Google Sheets, HubSpot, QuickBooks and Stripe. Whether any of this works for your firm depends on whether your ATS exposes the placement fields the workflow needs.

The first proposed workflow handles commission drafts. The trigger is a placement record moving to "started" in your ATS. The workflow reads the fee, the recruiter split and the start date through an API or a scheduled export, applies the split rules you have written down, and calculates each share. The output is a draft commission row in a Google Sheet and a summary email to the operations lead. Prerequisites are read access to placement records, the split rules in writing, and a sheet the owner controls. The human review point is the operations lead approving every draft before payroll, with any custom split routed to manual review.

The second proposed workflow handles clawback watch. The trigger is a scheduled check at intervals you set, plus the end of each guarantee window. The workflow compares the candidate's status in the ATS with the placement record and flags any candidate who has left. The output is a flagged list in the sheet and a draft clawback note. The human review point is that no deduction reaches a payout without a person's approval, because a deduction changes pay and may need review against your own employment terms.

Building it yourself with n8n, Zapier or Make

The reader's real alternative is often stitching the workflow together in a no-code tool or building it in-house. Those routes can be strong. n8n documents error workflows that "run if an execution fails," and its Error Trigger receives the execution ID, the error message, the stack trace and the last node run, according to n8n. Zapier and Make can also keep run histories and route failures when they are configured that way.

The buyer still designs and owns the rest. That includes observability, so someone can see what ran and what failed. It includes idempotency, so a rerun does not pay the same commission twice. It also includes escalation paths, access controls for payroll data, and maintenance when the ATS changes a field name. A DIY stack gives full control over every rule and avoids a vendor subscription, but the firm carries all of those obligations.

A proposed US Tech Automations design would configure the run history, the error branch and the approval step for you, and the sample output could be a draft sheet plus a reviewer queue. You would still supply the split rules, the API or export access and the reviewer, and those review points do not disappear under either approach.

Common mistakes

• Treating a spreadsheet as finished because it adds up correctly once.

• Forgetting the clawback date until a candidate has already left and the fee is paid out.

• Buying a tool before writing down the split rules, so the tool gets configured around guesses.

• Judging a vendor on its pricing page alone, when the feature you need may sit in a demo.

• Keeping the only working copy of the formulas with one person.

Decision checklist

• Do you have split rules for every recruiter type, written down and dated?

• Can one person reconcile the commission sheet against the placement list in under an hour each pay cycle?

• Do you have a clawback rule and a guarantee window in writing that a reviewer can check?

• Do you need the commission record to be auditable by someone other than the owner?

• Can your ATS export placement records or expose them through an API?

• Have you asked each vendor to show split rules, clawbacks and reporting in a demo using your own rules?

When NOT to use US Tech Automations

Skip a proposed workflow when you have one or two recruiters, a single split rule and only a few placements a month, because a locked spreadsheet with a monthly reconciliation is the simpler answer. Skip it also if you need a full applicant tracking system with candidate sourcing and job boards, where a platform like Bullhorn or Recruiterflow fits the job better. And skip it if you want a tool you run entirely yourself with no outside team, because even a managed design still needs your review points and your ownership of the split and clawback rules.

Frequently asked questions

Is a spreadsheet enough for recruiter commissions?

Yes, for a small firm with one split rule, a few recruiters and a monthly reconciliation against the placement list. It stops being enough once you add team pools, tiered rates or guarantee-period clawbacks that one person must track by date.

Do I need a commission tool if my ATS already tracks placements?

Check first whether your ATS can record split rules and clawback dates. The Bullhorn and Recruiterflow pricing pages do not list commission tracking as a feature, so that is a question for a demo, not something to assume.

Which of these vendors publishes prices?

Only Bullhorn and Recruiterflow publish list prices on the pricing pages checked, and Bullhorn's Pro and Max plans are quote-based. Core Commissions and Ceipal publish no prices on the pages reviewed.

What is a clawback in recruiter commission tracking?

A clawback is a reversal of part of a recruiter's commission when a placed candidate leaves within the guarantee window. The length of that window depends on your own written terms, so set it before you choose any tool.

Can Zapier, Make or n8n replace a commission tool?

They can, if you build and own the split logic, the review step and the access controls. n8n documents how error workflows receive failure data, but it does not decide your split rules or approve a payout.

Conclusion

Keep a spreadsheet while the rules fit on one page and one person can reconcile them each month. Move to a dedicated tool or an ATS commission feature when splits, pools or clawbacks need a record that someone other than the owner can audit. Check each vendor's gaps in a demo using your own split rules, not the pricing page. To see how a proposed design would handle the draft and clawback steps, see how US Tech Automations configures this.