Softwiro
Free Excel template

Metal workshop job sheet in Excel (free): job orders, materials and labour

Know what each job really cost, which ones are late, who owes you and what to pay each worker this week.

5 min read

You run a metal or turning workshop and for every job you want three answers: what it really cost, how much you earned, and whether it will be delivered on time. At the end of the week you also want to know what to pay each worker and who still owes you money. The free metal and turning workshop sheet (the page is in Arabic) answers all of that from things you type while working: the job order, the materials issued to it, the workers' hours on it, and what the customer paid.

The problem: the price is agreed by estimate and the cost is known late

In most workshops the price of a door, a fence or a frame is agreed on day one. Then iron leaves the store, paint is bought from the shop and workers come and go, and nobody adds up the cost except from memory. You hear «that job paid well» when it may have lost money, a job runs past its date and nobody notices until the customer calls, and balances pile up with several customers without one page that lists them. The sheet puts each job on one row that pulls in everything about it from the other sheets.

How the sheet works, step by step

  1. In الإعدادات (Settings) type today's date (or =TODAY()), the first day of the wage week and the first month of the summary table.
  2. In الخامات (Materials) write your price list: code, name, unit (kg, metre or litre) and price per unit. In العمال (Workers) write each worker and his hourly rate. In العملاء (Customers) write each customer with a code, name and phone.
  3. For every new job open a row in أوامر الشغل (Job orders): number, date, customer code, description, quantity, agreed price, deposit, due date and status.
  4. Whenever a material is issued to a job, write it in استهلاك الخامات (Materials used): job number, code and quantity. At day end write in ساعات العمل (Labour hours) who worked on which job and for how many hours.
  5. Every payment after the deposit goes in الدفعات (Payments). Change the status in the job order as the job moves on.
  6. Open المتأخرة (Late jobs) every morning, الأجور الأسبوعية (Weekly wages) at the end of the week, and الملخص (Summary) at the end of the month.

What each sheet does

  • Job orders: materials cost + labour cost = total cost, profit = price − cost, paid = deposit + payments, and the balance. A late job turns red and says how many days.
  • Materials and Workers: show how much of each material was used and how many hours each worker put in.
  • Customers: each customer's balance, ranked so you chase the biggest first.
  • Weekly wages: each worker's hours day by day in a week whose first day you set; wage = hours × hourly rate.
  • Late jobs: what is past its date and not delivered, most overdue first.

Walk-through on the numbers in the sheet

The numbers below are sample data inside the sheet, not a real workshop: 9 jobs created in October and November 2026, with today's date set to 10 November.

  • A profitable job: the iron door (J001) is priced at 11,500. Its materials cost 5,670 (24 m of square section at 2,880 and 60 kg of 2 mm sheet at 2,280, plus paint and hinges). Its labour is 1,760 (16 hours of the senior smith at 70, 8 hours of the helper at 35, and 6 hours of the welder at 60). Cost is 7,430 and profit 4,070, a 35.4% margin.
  • A losing job: the turned bushings (J005) are priced at only 8,000, with materials of 5,040 (120 kg at 42) and labour of 3,840 (48 hours of the turner at 80). Cost is 8,880, so the result is −880. This stays hidden if you never add up the cost.
  • Lateness: the stairs job (J007) was due on 4 November and is «waiting for material», so it is 6 days late with 7,500 still owed. The bushings job (J005) is 5 days late. These two are the rows in the late list.
  • Totals: value of non-cancelled jobs is 123,500, materials 67,690 and labour 18,130, so profit before fixed expenses is 37,680, a 30.5% margin. Collected so far: 89,500.
  • Customers: 34,000 is still owed by five customers, the largest being Al-Amal Contracting (13,000) and Al-Nil School (7,500).
  • Wages: for the week starting Saturday 7 November: 74 hours and wages of 4,550, including 1,280 for the turner (16 hours) and 1,120 for the senior smith (16 hours).

Common mistakes

  • Forgetting to log a material or a worker's hours, which makes the profit look bigger than it is.
  • Pricing extra work the customer asked for later without logging its cost.
  • Changing an hourly rate in Workers without realising it re-prices the old jobs.
  • Not updating the status, so lateness and ready-but-undelivered jobs never show.
  • Treating job profit as the workshop's profit: subtract rent, electricity and tools from the total using your own figures.

When to move to a system

The sheet suits a workshop where the owner or one person types each day. When several people type at once, or you want each worker to log hours from his phone and the customer to get an automatic alert, that is the work of a custom program, not one file. If your workshop is for cars, use the car workshop job sheet.

Your next step

Download the sheet, write ten of the materials you buy most in Materials and your workers' rates in Workers, then open the job you are working on right now and log its materials and hours so far. You will see its profit before you deliver it.

Common questions

Do I log every worker's hours every day? Yes, one row per worker, job and day. If a worker is on two jobs in one day, log two rows.

What if I buy a material only for one job? Add it to Materials at its purchase price and log it on the job.

Does it work on a phone? Yes, in Excel, Google Sheets and LibreOffice.

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: metal and turning workshop (1/3)Cheat sheet: metal and turning workshop (2/3)Cheat sheet: metal and turning workshop (3/3)
0 downloads · 3 pages

Questions this raises

How do I calculate the cost of a job in a metal workshop?

Log the job's materials in Materials used and the workers' hours in Labour hours. Job cost = sum of (quantity × price) of materials + sum of (hours × hourly rate). Profit = agreed price − cost.

When does the sheet treat a job as late?

When its status is new, in progress or waiting for material and its due date is earlier than today's date in Settings. It appears in Late jobs with the number of days.

Does it work out weekly worker wages?

Yes. Type the first day of the week in Settings and the Weekly wages sheet adds each worker's hours day by day from Labour hours and multiplies by his hourly rate.

Is the job profit the whole workshop's profit?

No. It is profit after the materials and labour you logged only. Rent, electricity and tool wear are not in it, so subtract your fixed expenses from the total.

Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project