At the end of the month you want to know two things for every worker: how much they earned at piece rate, and how well their working time was used. Done by hand from tally sheets, this takes an evening and still ends in arguments. This free Excel sheet does both from one daily output log.
The sheet and its page are in Arabic: piece-rate pay and efficiency sheet. All free sheets are listed at /templates (in Arabic). If you want to understand what "efficiency" does and does not tell you, read how garment factories calculate production efficiency first.
What is inside the sheet
- Start here: how to use it and the colour key.
- Settings: the year and month of the statement, and the working minutes in a day.
- Operations: each operation with its standard minutes (SAM) and its piece rate.
- Workers: worker code, name and department.
- Daily output: one line per worker, day and operation: date, code, operation, quantity, and optionally the working minutes. The sheet fills in the name, the standard minutes, the productive minutes, the efficiency and the pay.
- Monthly statement: for the month you chose, each worker's total pieces, productive minutes, working minutes, average efficiency and total pay.
- Why still on Excel?: when a sheet stops being enough.
The formulas
Pay for a line = quantity x the operation's piece rate. Productive minutes = quantity x the operation's standard minutes. Efficiency = productive minutes divided by working minutes. The working minutes default to the day length in Settings.
A worked example (sample data)
These are the sample numbers in the sheet, not a real factory. The month is October 2026 and the day is set to 540 minutes. Operations include neck (1.8 standard minutes, 0.90 per piece), sides (2.0 minutes, 1.00 per piece), hem (1.0 minute, 0.50) and buttons (0.8 minute, 0.40).
- Ahmed Mahmoud did mostly neck work, with 1,385 pieces over five working days. Productive minutes are 2,518 against 2,700 working minutes, so efficiency is 93.3% and pay is 1,259.00. On one day he did two operations (130 necks and 125 side seams) and the minutes were split, 270 each, so the day was not counted twice.
- Souad Ali sewed sides, 1,000 pieces. Productive minutes are 2,000 of 2,700, efficiency 74.1%, pay 1,000.00.
- Mohamed Hassan has 900 pieces, 1,173 productive minutes out of 2,640, efficiency 44.4% (shown red, below 60%), pay 586.50. One of his days was entered with 480 minutes instead of 540.
- Mona Ibrahim did 2,350 hems: 87.0% efficiency, pay 1,175.00.
- Youssef Khaled attached buttons, 3,200 pieces: 94.8% (green, 90% or more), pay 1,280.00.
For the whole month that is 8,835 pieces, 5,300.50 in pay and an average efficiency of about 78.9%. Two September lines are in the log as well; they do not appear in October's statement, which is how the month filter is meant to work.
Notice how different the pay and the efficiency stories are. Souad earns more than Mohamed, but a red figure for Mohamed is not proof he is slow: it could be the operation, waiting for work, a machine problem, or missing minutes in the log. Treat red as a question to ask on the floor.
Why these features matter
- Pay and efficiency from one log. You write the output once.
- No month-end adding up. Change the month in Settings and the statement shows that month.
- Choice from lists. Worker and operation are picked from lists, so a misspelling cannot split a worker in two.
- Colour for the extremes. Under 60% red, 90% or more green.
- Free, no sign-up, and it works in Excel 2016 and later, Google Sheets and LibreOffice.
Using the online version
The template page opens directly on the worked example above. You edit the white (input) cells right in the page and the grey calculated cells update immediately. You can import your own .xlsx file made from this template, export your work to .xlsx, or download the original Excel file. Your data stays in your browser and is not sent to the server.
Start by entering your operations with their standard minutes and rates, then your workers, then a few real days of output.
Common mistakes
- Entering an operation's standard minutes you have not measured. Efficiency is only as good as the SAM behind it.
- Two operations in one day without splitting the minutes.
- Judging a worker from a single month or a single operation.
Where a sheet stops being enough: someone must collect the daily numbers from the floor and type them in. If you want each worker to record their own output with a simple code on their phone, and you want to see the current stage of every order, Softwiro's production management system is built for that.
Next step
Take one week of your tally sheets, enter your six most common operations with their rates, and type in that week's output. Compare the pay to what you actually paid, and look at the lowest efficiency on the statement.