Try the sheet here, on the example
The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.
Example from the sheet
| Pay period | 46328 | 46339 | Change the dates, the reject rule and the hourly guarantee on the Settings sheet. | |
|---|---|---|---|---|
| Workers on the list | 10 | Net piece earnings | 8,373.04 | |
| Pieces made | 24,028 | Hourly guarantee top-ups | 521.65 | |
| Pieces rejected | 139 | Workers topped up | 5 | |
| Reject rate | 0.6% | Bonuses | 50.00 | |
| Gross piece earnings | 8,426.27 | Total net payroll | 8,929.69 | |
| Rejects deducted | 53.23 | Net pay per accepted piece | 0.374 | |
| Top 10 by accepted pieces | Accepted pieces | Net piece earnings | Guarantee top-up | Bonus |
| Marcus Reed | 4,711 | 861.00 | 99.00 | 30.00 |
| Sophie Turner | 4,524 | 828.70 | 0.00 | 0.00 |
| Tom Becker | 3,085 | 1,002.69 | 0.00 | 0.00 |
| Aisha Khan | 2,707 | 908.50 | 0.00 | 0.00 |
| Daniel Brooks | 1,986 | 817.65 | 142.35 | 0.00 |
| Oliver Grant | 1,859 | 614.28 | 153.73 | 0.00 |
| Maria Lopez | 1,433 | 1,083.59 | 0.00 | 20.00 |
| James Carter | 1,420 | 991.21 | 0.00 | 0.00 |
| Priya Nair | 1,155 | 808.08 | 103.93 | 0.00 |
| Emily Watson | 1,009 | 457.35 | 22.65 | 0.00 |
Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
What is inside
- Dashboard: The period's pieces made and rejected, reject rate, gross piece earnings, rejects deducted, guarantee top-ups, bonuses and total net payroll, with three charts: output ranking, how the top 10 are paid, and pieces made and rejected by operation.
- Production Log: The daily record: date, worker, operation, an optional quality grade, pieces made and pieces rejected. The pay rate, gross earnings, reject deduction and net earnings fill in by themselves, and a Check column flags an unknown worker, an unknown operation, more rejects than pieces, or a date outside the pay period. Room for 2,000 rows.
- Pay Summary: One row per worker for the pay period: pieces made, rejected and accepted, gross piece earnings, rejects deducted, net piece earnings, hours, earnings per hour, the guarantee top-up, bonus, deductions, net pay, reject rate and output rank.
- Payslip: Pick a worker and get a printable sheet: their pieces and earnings broken down by operation, then the totals down to net pay.
- Ranking: Everyone ordered by accepted pieces, with section, pieces made, rejected, reject rate and net pay.
- Workers: The worker list (up to 60) with section, hours worked in the period, any bonus and any deduction.
- Rates: Your operations with the pay per piece (up to 40) and your quality grades, each a percentage of the operation rate.
- Settings: Business name, currency symbol, pay period dates, how much of the rate is taken back for a rejected piece, the optional hourly guarantee and the reject rate that raises an alert.
The file opens on a start tab (“Start here”) that explains how to use it.
What makes it different
Most piece rate sheets multiply pieces by one rate and stop. This one keeps a rate table by operation and grade, handles rejected pieces with a rule you set, adds an hourly guarantee only if you type one, and ends with a payslip and a ranking you can show on the workshop wall. The sample is a small garment shop with ten workers and two weeks of work in November 2026, so you can see every sheet working before you replace it with your own.
How do you calculate piece rate pay?
Piece rate pay is the number of pieces a worker finishes multiplied by the pay for each piece. When a shop has several operations, each has its own rate, so you add up pieces times rate for every row of work. In the sample, Maria Lopez made 1,442 pieces in the two weeks and the sheet works out 1,089.99 in gross piece earnings from the rates on the Rates sheet.
A grade is a percentage of the operation rate. A rush order can pay 125% and seconds 70%; leave the grade blank for standard work. You change the operations, the rates and the grades on the Rates sheet and every row in the log follows.
How do you handle rejected pieces in piece rate pay?
Every log row has a Rejected column. The Settings sheet sets what share of the piece rate is taken back for each rejected piece: 100% means a rejected piece earns nothing, 0% means it is paid in full, and anything between works too. In the sample the rule is 100%, and 139 rejected pieces take 53.23 off the 8,426.27 gross.
The Pay Summary shows each worker's reject rate and turns it red above the alert level you set, so you can see who needs help before the next period. Decide your rule with your own team and put it in writing; the sheet only applies the number you type.
How do you top up piece rate workers to an hourly guarantee?
Some shops promise a minimum hourly amount to people paid by the piece. Type that amount in Settings and the sheet compares each worker's net piece earnings with the guarantee times their hours worked. If the earnings are lower, the difference is added as a top-up; if not, the top-up is zero. In the sample, with a guarantee of 12.00 an hour, five workers receive a top-up and together they get 521.65. Set the guarantee to 0 and it is switched off.
The number is yours to choose. The sheet does not know your local wage rules, overtime rules or what counts as hours worked, so check your local wage rules before you rely on any figure. If you also need to follow each order through the shop, see Production Manager.
How to use it
- On Settings type your business name, currency symbol and the pay period dates. Set how rejected pieces are treated (the share of the piece rate taken back for each rejected piece) and, if you use one, an hourly guarantee. Leave the guarantee at 0 to switch it off.
- On Rates list your operations with the pay per piece, and edit the quality grades: each grade is a percentage of the operation rate (100% = standard).
- On Workers add one row per person with their section and, for the period, the hours worked, any bonus and any deduction.
- Every working day, add rows to Production Log: date, worker, operation, an optional grade, pieces made and pieces rejected. The rate and the earnings fill in by themselves.
- Open Pay Summary for each worker: piece earnings, rejects deducted, the guarantee top-up if any, bonus, deductions and net pay. Rows dated outside the pay period are left out and flagged in the Check column.
- Pick a worker on Payslip to print their sheet, see who produced the most on Ranking, and read the totals and charts on Dashboard.
Before you start:
- Capacity: 60 workers, 40 operations, 2,000 production log rows. The Payslip lists the first 15 operations on the Rates sheet.
- Pieces means everything made; Rejected is how many of those failed inspection. The reject rule on Settings sets how much of the piece rate is taken back for each rejected piece: 100% pays nothing for it, 0% pays it in full.
- The hourly guarantee is a number you type, per hour worked. If a worker's net piece earnings for the period are lower than the guarantee times their hours, the difference is added as a top-up. This sheet does not know your local wage rules, so check them before relying on any figure.
- Worker names must be unique, because the log and the summary match on the name.
- For a new pay period, change the dates on Settings, clear the Production Log and the hours, bonus and deductions on Workers; Rates and the worker list stay.
- Use one currency in one workbook. The currency symbol on Settings is only a label.
Still running this on Excel?
This sheet depends on someone collecting the numbers from each stage and typing them in. In Production Manager every worker logs receiving and handing over with one tap, so the numbers appear the moment they happen.
| In this sheet | In Production Manager |
|---|---|
| You learn the quantities after someone collects them and types them into the sheet. | The worker confirms receipt and hands over to the next stage with one tap, so every piece gets an entry time and an exit time at each stage. |
| You find out about a delay when you review the sheet, often on delivery day. | You see how many days each stage takes, which products are stalled or late, and where the bottleneck is. |
| Workers ask what to work on, or wait for it. | Each worker sees only the products that have reached their stage, with the model photo, quantity and size. |
| Breakdowns and quality problems are passed on by word of mouth. | The worker reports the problem from their screen, it reaches the management dashboard, and it can be shared over WhatsApp. |
Frequently asked questions
Is this piece rate payroll calculator really free?
Yes. Download it, use it in your business and change anything you like. There is nothing to sign up for to open the file.
Does it work in Google Sheets and LibreOffice?
Yes. It uses only ordinary formulas such as SUMIFS, COUNTIF, INDEX and MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets.
Can I pay different rates for different operations?
Yes. List each operation with its pay per piece on the Rates sheet, then pick the operation on every log row. You can also set quality grades such as rush or seconds as a percentage of the operation rate.
Is the hourly guarantee required?
No. It is a setting you type on the Settings sheet, per hour worked. Leave it at 0 and workers are paid only for the pieces they made, plus any bonus and less any deductions.
How many workers and log rows can it hold?
60 workers, 40 operations and 2,000 production log rows. For a new pay period, change the dates, clear the log and the hours on the Workers sheet, and keep the rest.
Is the template free?
Yes, with no sign-up and no email address. Use it, edit it and share it as you like.
Does it work in Google Sheets and on mobile?
The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.
What is the difference between the white and the gray cells?
You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.
Can I use the sheet from an AI assistant?
Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html
All the templates in this group: Factory management sheets: production, cost and quality
More free templates for: Garment factories
More free templates
- Garment Costing Sheet for Excel
- Fabric requirements and marker sheet
- Garment printing shop sheet in Excel: DTF and screen print orders and cost
- Poultry Flock Tracker for Excel: Eggs, Feed, Mortality and Profit
- Dental Practice Treatment Plan Tracker for Excel
- Travel Agency Booking Tracker for Excel
- Generator Maintenance Log Template for Excel
- Equipment Inspection Log Template for Excel
- Coffee Roasting Log and Costing Spreadsheet for Excel
- Hotel Guest Folio Template for Excel (Rooms, Reservations, Billing)
- Auto Parts Inventory and Sales Spreadsheet for Excel