Free Google Sheet · not a signup wall
Free staffing commission tracker — a Google Sheet you can start using today.
Log every placement and see who earned what, what’s still pending, and which deals are still inside their guarantee window — before a fall-off eats your commission. Free template, yours to copy. Built by a real person, not a signup wall.
The Dashboard tab
By recruiter
What it is / who it’s for
A commission tracker built for how recruiters actually get paid
Most “commission trackers” are generic sales sheets that don’t know what a placement is. This one does. It handles the two ways staffing money actually comes in — a perm fee (a percent of first-year salary) and a contract margin (the spread between your bill rate and pay rate) — and it tracks the thing that quietly costs recruiters the most: fall-offs inside the guarantee window, where a placement leaves and the fee gets clawed back.
It’s a real Google Sheet. You make a copy, you own it, it’s free.
No trial, no card, no “book a demo to unlock.” Who it’s for:
- Solo recruiters who want to know their real number without building a spreadsheet from scratch.
- Small staffing & search agency owners tracking a few desks, splits, and draws.
- Anyone tired of guessing what’s actually going to clear vs. what’s still at risk.
The honest part: this is the manual version. You type each deal in yourself. That’s on purpose — it’s free, it works, and if you later want it to fill itself in, that’s the paid build.
What’s inside
What’s inside the sheet
Five tabs, ready to use, with sample rows already filled in so you can see it working:
- Placements — one row per deal: candidate, client, role, perm or contract, salary/fee or bill-pay-hours, owner + sourcer split, status, and guarantee days. Type the deal; the money columns calculate themselves.
- Recruiters — your people, their monthly draw, and their default split. Shows each person’s earned-this-month and their draw balance (earned minus draw).
- Settings — your commission rules and all the dropdown lists in one place: default perm fee %, default owner/sourcer split, guarantee days.
- Dashboard — the rollup: total gross, net after fall-offs, pending vs. paid, per-recruiter earnings, and a live clawback-risk list of every deal still inside its 30/60/90-day guarantee.
- Read Me — a 4-step start guide so you’re logging deals in two minutes.
The math it does for you:
- Perm fee — first-year salary × your fee %.
- Contract margin — (bill rate − pay rate) × hours/week × weeks.
- Splits — owner % vs. sourcer %, per deal, overridable.
- Draw reconciliation — commission earned minus the draw you’ve advanced.
- Clawback / fall-off flag — every placement still inside its guarantee window gets flagged ⚠ AT RISK; mark one “Fell Off = Yes” and its commission reverses automatically.
Get the free tracker
Get the free tracker
Drop your email and I’ll send you the copy link (and I’ll tell you when I add to it). No spam, no sequence — one real person, and you can reply to any message and get me.
Prefer to skip the form? Email me at colin@automatedworkflowllc.com and I’ll send the link straight over. Based in Gainesville, FL — working with recruiters everywhere.
The paid version
Want it to fill itself in? That’s the $650 build.
This free sheet is the manual version — every deal is one you key in by hand, on flat starter rules. It’s genuinely useful as-is. But if you’re running real volume, the typing (and the “wait, is this number even right?”) gets old fast.
The paid version fixes that:
- Self-updating — it pulls placements in instead of you re-typing them, so the Dashboard is just true, live.
- Built on YOUR rules — tiered commission, escalators, per-client rates, real draw thresholds — coded to your actual comp plan, not flat defaults.
- An AI weekly commission note — a plain-English Monday summary: who earned what, what cleared, and which deals are about to leave the guarantee window and need watching.
And you don’t buy it blind — I build a working demo on your real numbers first, free, in about a day. See it actually run, then decide.
Who made this
Who made this
I’m Colin McCarthy, and Automated Workflow is me — a real person in Gainesville, FL, building Google Sheets tools for people who’d rather run their business than fight their spreadsheet. I work with recruiters and small agencies all over the US, remotely.
- A free tool with no catch. You copy it and it’s yours — no account, no expiry.
- Your data is yours. This is a template you copy into your own Drive; I never see your deals unless you hire me and choose to share them.
- I answer my own email and phone — colin@automatedworkflowllc.com, (703) 939-1174.
- Trained craft. Anthropic Academy certified in AI-assisted automation, and reviewed publicly on Upwork.
Ready when you are
Grab the free tracker
Get the copy link in your inbox, start logging deals in two minutes, and see your real commission number — clawback risk and all — today.
Get the free tracker →Want it self-updating on your own rules? See the $650 automated dashboard or book a free 1-day demo. Based in Gainesville, working with recruiters everywhere.
Questions people ask