Quick answer: Piece-rate wages are worked out like this:
Wages = (pieces done − pieces rejected) × rate per piece
Add this up for each item and day in the period, then deduct any advance. A wage sheet shows each karigar’s pieces, gross wages, advance cut and net pay, with a column for their signature.
Download a free piece rate wage sheet in Excel below. You enter the daily work; the wages add up by themselves.
Key takeaways
- Rate list for up to 30 items or operations: kurta, salwar, suit, blouse, embroidery, kaj-button, press.
- Daily Work sheet for up to 3,000 lines, with rejected pieces not paid.
- Wage Sheet for any period: days worked, pieces, rejected, gross, advance due, advance cut and net pay.
- A warning when the cut is more than the advance due.
- Up to 30 karigars.

Daily work entry

How to use the template
- Setup: type your unit name, the items with rates per piece, and your karigars with a code and any advance due.
- Daily Work: when work comes in, enter the date, karigar code, item, pieces and any rejected pieces.
- Wage Sheet: set the From and To dates, type the advance to cut, then print it and get it signed.
Tips for piece-rate wages
- Enter work the same day. Counting a fortnight of pieces from memory is how disputes start.
- Agree rates before the season. When a rate changes, add a new item name so old work stays at the old rate.
- Cut advances in small parts. A karigar who takes home nothing on pay day often doesn’t come back.
Download the free Karigar Piece Rate Wage Sheet
There are three sheets: Setup, Daily Work and Wage Sheet. Fill in the yellow cells; everything else is worked out.
Get updates and new free templates
Your download below doesn’t need this. Leave your WhatsApp number or email and I’ll send you fixes for this file and new free templates. No spam, unsubscribe anytime.
Was this template useful?
Related free templates Free Excel files people download with this one
FAQs
Does piece-rate pay have to meet minimum wages?
In general, yes. Piece-rate earnings should not fall below the minimum wage for the time worked. Check your state’s rates.
Can I make a weekly wage sheet?
Yes. Set the From and To dates to the week.
Can a boutique use it?
Yes. It works for any shop that pays tailors per piece.
More free templates
- Garment Costing Sheet
- Tailor Order Book & Measurement Chart
- Attendance Sheet with Salary
- All Excel templates









Leave a Review