# Metal and turning workshop job sheet in Excel

> Free Excel job sheet for a metal and turning workshop: job orders, price, deposit and due date, materials, labor hours, profit per job and weekly wages.

Source: https://softwiro.com/templates/general-workshop-jobs
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Metal and turning workshop job sheet in Excel: job orders, materials and labor

A free Excel sheet for a blacksmith and turning workshop. You open a job order for each request with its agreed price, deposit and delivery date, and record the materials taken from your price list and each worker's hours against it. The sheet works out the job's cost and its real profit, alerts you to late jobs and to what each customer still owes, calculates weekly worker wages from their recorded hours, and shows it all in a summary with charts.

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

Excel file (.xlsx) · 389 KB · 13 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

| رقم الأمر | وصف الشغل | السعر المتفق عليه | الحالة | إجمالي التكلفة | الربح | المتبقي | تنبيه |
| --- | --- | --- | --- | --- | --- | --- | --- |
| J001 | باب حديد ضلفتين 2×2.2 م | 11,500.00 | سُلّم | 7,430.00 | 4,070.00 | 0.00 |  |
| J002 | سور حديد وبوابة (12 متر) | 26,000.00 | سُلّم | 15,370.00 | 10,630.00 | 0.00 |  |
| J003 | كراسي ارتكاز بالخراطة، محور 40 مم | 7,000.00 | سُلّم | 5,200.00 | 1,800.00 | 0.00 |  |
| J004 | شبابيك حماية 6 قطع | 8,400.00 | جاهز | 6,830.00 | 1,570.00 | 4,900.00 | جاهز ولم يُسدَّد |
| J005 | جلب وبوشات بالخراطة | 8,000.00 | تحت التنفيذ | 8,880.00 | -880.00 | 3,500.00 | متأخر 5 يوم |
| J006 | هيكل مظلة سيارات 6×3 م | 38,000.00 | تحت التنفيذ | 24,510.00 | 13,490.00 | 13,000.00 |  |
| J007 | سلالم حديد وأرجل مقاعد | 16,500.00 | بانتظار خامة | 14,100.00 | 2,400.00 | 7,500.00 | متأخر 6 يوم |
| J008 | درابزين سلم 9 متر | 8,100.00 | جديد | 3,500.00 | 4,600.00 | 5,100.00 |  |
| J009 | قطع غيار ستانلس بالخراطة | 4,500.00 | ملغي | 0.00 | 0.00 | 0.00 |  |

Example from the “أوامر الشغل” tab (Arabic), with the numbers and formulas that are in the file.

## What is inside

- "الإعدادات" (Settings): Today's date, which is used to work out lateness, the first day of the wage week, and the first month in the summary table.
- "العملاء" (Customers): Customer code, name and mobile number. Beside them: the number of their jobs, their value, what they paid, the balance owed and their status (owing, settled or paid in advance), ranked from the largest for follow-up. It holds 100 customers.
- "الخامات" (Materials): A price list of iron, stainless steel, paint and supplies per kg, meter or liter. Beside each material: how much was used and its cost. It holds 60 materials.
- "العمال" (Workers): Each worker's name, trade and hourly wage, with their total hours and wages. It holds 30 workers.
- "أوامر الشغل" (Job orders): One line per job: description, quantity, agreed price, deposit, delivery date and status. The sheet shows materials cost, labor cost, profit and margin, paid and balance owed, and a late alert. It holds 400 jobs.
- "استهلاك الخامات" (Material usage): Each material issued to a job: job number, material code and quantity. The name, price and cost appear. It holds 2000 lines.
- "ساعات العمل" (Work hours): Each worker's hours on each day on each job, with the cost at the worker's hourly wage. It holds 2000 lines.
- "الدفعات" (Payments): Each amount the customer pays after the deposit, with the job number and payment method. It holds 2000 payments.
- "الأجور الأسبوعية" (Weekly wages): Each worker's hours for each day of the week you choose, with total hours and the wage due.
- "المتأخرة" (Late jobs): Jobs past their due date and not delivered, most overdue first, with the customer and the balance owed.
- "الملخص" (Summary): The number of jobs in each status, the value of jobs, cost, profit and margin, what customers still owe, and the week's wages, with a monthly table and charts.

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

## What makes it different

The sheet links what you sell to what you actually spent: materials from your own price list and hours at each worker's wage. You know the profit of every job after iron and labor, and you spot a job you priced below its cost before it happens again.

## How to use it

1. In the "الإعدادات" (Settings) sheet, enter today's date, the first day of the week whose wages you calculate, and the first month the summary starts from.
2. In the "الخامات" (Materials) sheet, enter your materials price list: code, name, unit (kg, meter or liter) and unit price. In "العمال" (Workers), enter each worker and their hourly wage.
3. In the "العملاء" (Customers) sheet, enter the customer code, name and mobile number. Then in "أوامر الشغل" (Job orders), open one line per request: description, quantity, agreed price, deposit, delivery date and status.
4. Each time a material is issued to a job, record it in "استهلاك الخامات" (Material usage) (job number, material code and quantity). Each time a worker works, record their hours on the job in "ساعات العمل" (Work hours).
5. Record each amount the customer pays after the deposit in "الدفعات" (Payments). Change the status in "أوامر الشغل" (Job orders) as the job progresses, and enter the delivery date when it goes out.
6. The sheet works out each job's cost and profit, the customer's balance owed and lateness. Open "المتأخرة" (Late jobs) to see what is overdue, "الأجور الأسبوعية" (Weekly wages) for the workers' pay, and "الملخص" (Summary) for the figures and charts.

**Before you start:**

- Job profit = agreed price − (materials cost + labor cost). It leaves out workshop rent, electricity and tools, so it is a margin before fixed expenses.
- Labor cost = the worker's hours recorded on the job × their current hourly wage in the "العمال" (Workers) sheet. Changing a wage changes the calculation for all earlier hours, so keep a copy before editing it.
- A job is "late" if its status is new, in progress or waiting for material, and its delivery date is earlier than today's date in "الإعدادات" (Settings). A "ready" job alerts you if a balance is still owed on it.
- Paid on a job = deposit + its payments. Balance owed = price − paid. A "cancelled" job counts as zero, and its materials and hours are not included in cost.
- Weekly wages = each worker's hours from Saturday (or the first day you enter in "الإعدادات" (Settings)) for six days after it × the hourly wage. A single day's hours are added up from all the lines in "ساعات العمل" (Work hours).
- For a workshop that specializes in cars, use the car workshop job order sheet. This sheet holds 100 customers, 400 job orders, 60 materials, 30 workers, and 2000 lines each of usage, hours and payments, and "المتأخرة" (Late jobs) shows the first 30 jobs.

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

Excel file (.xlsx) · 389 KB · 13 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: metal and turning workshop (1/3)](https://softwiro.com/uploads/cheatsheets/general-workshop-jobs/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/general-workshop-jobs/en-1.jpg)[![Cheat sheet: metal and turning workshop (2/3)](https://softwiro.com/uploads/cheatsheets/general-workshop-jobs/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/general-workshop-jobs/en-2.jpg)[![Cheat sheet: metal and turning workshop (3/3)](https://softwiro.com/uploads/cheatsheets/general-workshop-jobs/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/general-workshop-jobs/en-3.jpg)

0 downloads · 3 pages

## Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

| In this sheet | In Custom Software from Softwiro |
| --- | --- |
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |

[See Custom Software from Softwiro](https://softwiro.com/contact) · [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

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

Record the job's materials in "استهلاك الخامات" (Material usage) and the workers' hours in "ساعات العمل" (Work hours). Job cost = the sum of (quantity of each material × its price) + the sum of (each worker's hours × their hourly wage). 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 delivery date is earlier than today's date in "الإعدادات" (Settings). It then appears in "المتأخرة" (Late jobs) with the number of days late.

### Does it calculate weekly worker wages?

Yes. Enter the first day of the week in "الإعدادات" (Settings). The sheet adds up each worker's hours day by day from "ساعات العمل" (Work hours) and multiplies them by their hourly wage in the "الأجور الأسبوعية" (Weekly wages) sheet.

### Is a job's profit the whole workshop's profit?

No. It is the profit after recorded materials and labor only. It leaves out workshop rent, electricity and depreciation of tools, so subtract your fixed expenses from the total profit to find the month's net.

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

More free templates for: Workshops and maintenance

## More free templates

- Car workshop job orders tracker (Excel)
- Spare parts inventory sheet
- Glass and aluminium workshop sheet in Excel: orders by square metre, cutting and waste
- Carpentry workshop sheet: cutting list, boards, cost and delivery
- Garment printing shop sheet in Excel: DTF and screen print orders and cost
- Arabic grammar summary sheet: rules, i'rab and a self-test with examples
- English grammar rules sheet in Excel: tenses and structures with examples
- Taxi, Uber and ride-hailing driver income sheet (trips, fuel, commission, daily net)
- Personal car maintenance log (oil and filter dates by kilometre and months)
- Parking garage management sheet (hourly and monthly)
- Car wash management sheet (packages, cards, workers, materials)
- Food factory sheet in Excel: recipes, batches, cost and shelf life

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