One-time purchase · $49

The Google Sheet that does your technician payouts for you.

Log each job once and the payouts calculate themselves, whether you pay by percentage, flat rate, tiered commission or pooled tips. A summary tab totals every technician for whatever pay period you pick. No formulas to write, no software to learn.

Instant download. Refundable within 7 days.

Works in Google Sheets and Excel. Yours to keep and reuse every period.

What you get

  • The spreadsheet as an Excel file, plus a copyable Google Sheets link
  • A one-page setup guide (PDF)
  • Five tabs: Start Here, Setup, Jobs Log, Payout Summary and a filled-in example
  • Four pay rules (percentage, flat rate, flat plus percentage, tiered) plus tip pooling
  • A Check column that flags a job with no date, no technician or a name that isn’t on your roster
  • Room for 500 jobs and up to 30 technicians
  • Instant download, yours to keep, with a 7-day refund
Payout Summary tab: the actual spreadsheet
Screenshot of the spreadsheet's Payout Summary tab for Sep 1 to Sep 14, 2026: four technicians on four different pay rules (percentage, flat rate, tiered, flat plus percentage) with jobs, revenue, commission, own tips, tip pool share and total payout per person; a tip pool block showing $100 pooled split three ways at $33.33 each with $0.01 unallocated rounding flagged in red; company totals; and four self-checks all reading zero.
Pick a From and To date and every technician's total appears. This one shows four different pay rules in one period, the tip pool split, company totals, and the self-checks that catch anyone left out of the run. Swipe sideways to see the whole sheet.
Jobs Log tab: what you type
Screenshot of the spreadsheet's Jobs Log tab with 15 logged jobs: yellow input columns for date, technician, job amount, a one-off commission percent, tip and pool tip, and gray calculated columns for commission, total and a check column, including a refund logged as a negative amount and two jobs at a special rate.
Yellow cells are yours; gray cells calculate themselves. A refund is just a negative row, a one-off rate is one typed number. Swipe sideways to see the whole sheet.

What's inside

Five tabs. Set up your crew once, then it's just logging jobs.

Tabs 1 & 2

Start Here + Setup

A worked-example guide to every pay rule, then one screen to enter your crew and how each person is paid. Everything after this reads from that list.

Tab 3

Jobs Log

One row per job: date, technician (dropdown), amount, tip. Commission calculates itself. A Check column flags any row that would be silently left out of your payout run.

Tabs 4 & 5

Payout Summary + Example

Pick a date range, get every technician's total, company totals and self-checks. Plus a fully worked example period you can compare against.

Handles five pay structures: percentage commission, flat rate per job, a combined flat-plus-percentage rate, tiered rates that change with job volume, and tip pooling split across the crew.

Handles your rules

The usual question is "but we pay people differently." Here's what the sheet does, nothing more.

  • A different deal for each person. One technician on 40% commission, another on $75 flat per job, a third on $20 per job plus 10%. Each is one line on the Setup tab.
  • Tiered commission. Up to five bands by jobs completed in the period (say 35% to 10 jobs, 40% from 11, 45% from 21). The rate applies to the whole period, and the summary works out which band each person landed in.
  • Pooled tips on some jobs, not others. Mark any job "Pool tip? Yes" and its tip goes into one pot, split evenly across everyone who worked a pooled job. Leftover cents are shown, never lost.
  • Add-ons or specials at a different rate. Type a one-off percentage into that row's "Comm % (this job)" column; every other job stays on the normal rule.
  • Cash tips vs card tips. Log only the tips that flow through you. A cash tip the technician already pocketed stays out of the Tip column, so it's never paid twice.
  • Refunds and shared jobs. A refund is a negative row that reverses the original commission. Two technicians on one job are two rows with the amount split.
  • Catches the silent errors. A Check column turns red on any job with no date, no technician, or a name that isn't on your roster, and the summary counts them all in one place.

What it doesn't do: hourly pay, more than one pay rule per person at a time, or tip pools weighted by hours or seniority. It prepares the numbers for W-2 staff or 1099 contractors alike; your payroll provider does the withholding and filing.

Which one is right for you?

Free

The calculator

One period, in your browser, nothing saved. Good for a quick one-off check.

Try it free
$49 once

This spreadsheet

Yours to keep. Five pay structures, running history across every period, per-technician totals and self-checks. You do the data entry. No monthly cost.

From $349/mo

Done for you

Skip the data entry entirely. Send whatever you already have, like an export or a photo of a worksheet, and get a payroll-ready file back in 24 hours, checked by a person.

See pricing

Frequently asked questions

What pay structures does this handle?

Five. Percentage commission on the job amount; flat rate per job; flat + percentage, a fixed amount per job plus a percentage on top; tiered rates that step up with the number of jobs completed in the period; and tip pooling, where selected tips go into one pot split evenly across whoever worked those jobs. Each technician is set to one of the first four rules, and any single job can be overridden with a one-off rate. See how the four commission methods are calculated and how tip pooling works, each with a worked example.

Do I need to know spreadsheet formulas?

No. You only type into the plain columns: date, technician, amount, commission %, tip. Every calculated column fills itself in, and those formula cells are protected so a stray keystroke can't accidentally overwrite one. Nothing else about your file is restricted. Download, print, copy and edit it however you like; only the formulas themselves are guarded.

Google Sheets or Excel?

Yes, both. Every formula uses plain, long-standing functions, with no dynamic-array formulas and nothing that needs a newer version of Excel, and the results were checked against hand-calculated examples. One small difference: in Google Sheets, double-clicking a date cell opens a calendar to pick from, where Excel has you type the date.

How do I know the math is right?

Every formula was evaluated against a spreadsheet engine before release, across all five pay structures, tier-band changes, per-job rate overrides, refunds and date-filtered periods. The spreadsheet also checks itself: it flags any job missing a date or technician, any job logged against someone not on your roster, and any leftover cents from splitting a tip pool. These are the silent errors that otherwise leave someone out of a payout run. See what each column and self-check on the Payout Summary actually means.

Can I use this for more than one pay period?

Yes, that's the point. Keep logging every period into the same Jobs Log tab. The Summary tab filters by pay period, so your full history stays in one file.

How many jobs can the Jobs Log hold?

It holds 500 job rows, set up for up to 30 technicians. If it fills up, you don't need to start over. Just add more rows: copy a row you've already logged (its formulas come along), then insert it just above the last row of the log so the totals still count it. Rows pasted below the log aren't counted.

What if I outgrow the spreadsheet?

Move to the done-for-you service any time. It's the same underlying math; we do the data entry and hand back the finished file every period instead of you maintaining the sheet.

What isn't covered?

One pay rule per technician at a time, and tip pools split evenly rather than weighted by hours or seniority. It also prepares numbers only. It doesn't run payroll, withhold tax or file anything. Hand the totals to your payroll provider.

Get the payout spreadsheet

$49, one time. Instant delivery: a copyable Google Sheet link plus an Excel file, sent to your email.

Instant download. Refundable within 7 days.

Secure checkout via Gumroad. Not what you expected? Email us within 7 days for a refund.

Rather not do it yourself? We'll run one pay period for you for $249: get one payout run