# Piece-rate payroll and worker efficiency sheet

> Daily output per worker and operation, piece-rate pay, efficiency from standard minutes (SAM), and a monthly statement per worker.

Source: https://softwiro.com/templates/piece-rate-payroll
Language: English
Softwiro, softwiro.com

---

Free Excel template

A free Excel sheet for calculating piece-rate wages and worker efficiency. You record each worker's daily output by operation and quantity. The sheet calculates pay from the piece rate, efficiency from the standard minute value (SAM), and builds a monthly statement for each worker.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-piece-rate-payroll.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-piece-rate-payroll-blank.xlsx)

Excel file (.xlsx) · 125 KB · 7 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## 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

| الاسم | إجمالي القطع | الدقائق المنتجة | دقائق العمل | متوسط الكفاءة | إجمالي الأجر |
| --- | --- | --- | --- | --- | --- |
| أحمد محمود | 1,385 | 2,518.0 | 2,700 | 93.3% | 1,259.00 |
| سعاد علي | 1,000 | 2,000.0 | 2,700 | 74.1% | 1,000.00 |
| محمد حسن | 900 | 1,173.0 | 2,640 | 44.4% | 586.50 |
| منى إبراهيم | 2,350 | 2,350.0 | 2,700 | 87.0% | 1,175.00 |
| يوسف خالد | 3,200 | 2,560.0 | 2,700 | 94.8% | 1,280.00 |

Example from the “كشف الشهر” tab (Arabic), with the numbers and formulas that are in the file.

## What is inside

- "العمليات" (Operations): Each operation with its standard time and piece rate.
- "العمال" (Workers): Worker code, name and department.
- "الإنتاج اليومي" (Daily output): Each worker's output per operation with its date. Pay and efficiency are calculated for every line.
- "كشف الشهر" (Monthly statement): For each worker in the month you choose: total pieces, pay and average efficiency, with low and high efficiency colour-coded.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

## What makes it different

Pay and efficiency sit in one record, so from the same numbers you can see who is owed how much and who is working below the standard time.

## How to use it

1. In the "الإعدادات" (Settings) sheet, enter the year and month you want the statement for, and the working minutes per day.
2. In the "العمليات" (Operations) sheet, enter each operation, its standard time in minutes and its piece rate.
3. In the "العمال" (Workers) sheet, enter each worker's code, name and department.
4. In the "الإنتاج اليومي" (Daily output) sheet, record for each worker each day the operation and quantity, choosing the code and operation from the two lists. Leave "دقائق العمل" (Working minutes) empty to use the full day's minutes.
5. Open "كشف الشهر" (Monthly statement) to see each worker's pieces, efficiency and pay for the selected month.

**Before you start:**

- If a worker does more than one operation on the same day, enter in each line the minutes spent on that operation so the day's minutes are not counted twice.
- Efficiency = produced minutes ÷ working minutes. Produced minutes = quantity × the operation's standard time.
- Efficiency shows in red below 60% and in green at 90% or more.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-piece-rate-payroll.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-piece-rate-payroll-blank.xlsx)

Excel file (.xlsx) · 125 KB · 7 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: piece-rate wages (1/3)](https://softwiro.com/uploads/cheatsheets/piece-rate-payroll/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/piece-rate-payroll/en-1.jpg)[![Cheat sheet: piece-rate wages (2/3)](https://softwiro.com/uploads/cheatsheets/piece-rate-payroll/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/piece-rate-payroll/en-2.jpg)[![Cheat sheet: piece-rate wages (3/3)](https://softwiro.com/uploads/cheatsheets/piece-rate-payroll/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/piece-rate-payroll/en-3.jpg)

0 downloads · 3 pages

## 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. |

[See Production Manager](https://softwiro.com/systems/production.html) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Frequently asked questions

### What is the standard minute value (SAM)?

The number of minutes a trained worker needs to complete the operation at a normal pace, including rest allowance. You can see how to use it in the worker productivity and piece-rate calculator.

### 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](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](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

All the templates in this group: [Factory management sheets: production, cost and quality](https://softwiro.com/templates/for-factories)

More free templates for: Garment factories

## More free templates

- Garment style costing sheet
- Production tracking sheet by stage
- Fabric requirements and marker sheet
- Garment printing shop sheet in Excel: DTF and screen print orders and cost
- Production tracking sheet for home textiles factories
- Clothing shop inventory sheet by colour and size
- Customer accounts, credit sales and customer statement sheet
- Cash book and customer accounts sheet
- Delivery company sheet: shipments and cash collection
- Student attendance sheet
- Study planner and lesson tracker
- Journal entries, trial balance and financial statements sheet

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
