Softwiro
Free Excel template

Car workshop job orders tracker (Excel)

A free Excel sheet for car workshops. You open a job order for each car and record the labor fee and the spare parts used, with their purchase price and the price you sell them to the customer for, and follow the car's status from inspection to delivery. The sheet calculates each order's total, what was paid and what remains, each customer's balance and the profit on parts, and shows a list of customers who still owe, largest first.

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

Example from the “أوامر الشغل” tab (Arabic), with the numbers and formulas that are in the file.
رقم الأمركود العميلالحالةاسم العميلإجمالي الأمرالمدفوعالمتبقي
J001C01سُلّمتأحمد سالم1,850.001,850.000.00
J002C02سُلّمتمحمود عادل2,010.001,500.00510.00
J003C01سُلّمتأحمد سالم900.00900.000.00
J004C03جاهزةسيد رمضان2,800.001,000.001,800.00
J005C04تحت التنفيذكريم حسن5,170.002,000.003,170.00
J006C05بانتظار قطعةهاني فؤاد1,800.00500.001,300.00
J007C02قيد الفحصمحمود عادل0.000.000.00
J008C04ملغيكريم حسن0.000.000.00
J009C05سُلّمتهاني فؤاد2,350.002,350.000.00

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

What is inside

  • "العملاء" (Customers): Customer code, name and phone, then the sheet calculates the number of their orders, the total they owe, what they paid, their balance and their status (owes, settled, paid in advance or no orders).
  • "أوامر الشغل" (Job orders): One row per order: number, date, customer code, plate number, model, status (under inspection, in progress, waiting for a part, ready, delivered, cancelled), labor fee and discount. The sheet calculates the customer's name, parts sales, the order total, paid and remaining, and a warning for ready or delivered orders that still have a balance.
  • "القطع" (Parts): Each spare part on an order: quantity, purchase price and sale price per unit. The sheet calculates the sales total, the cost, the profit on the part and the order's status.
  • "الدفعات" (Payments): Each amount the customer pays with its date, order number and payment method; the customer's name appears automatically.
  • "المديونيات" (Balances due): Customers who owe, largest balance first, with code, phone, balance and number of orders. It holds the first 50 customers.
  • "الملخص" (Summary): The number of orders and of cars in the workshop and ready, labor fees, parts sales, discounts, total of orders, paid and customers' balances, parts cost, profit and margin, and orders broken down by status.
  • "ابدأ هنا" (Start here): How to use the sheet, what the colours mean and notes on the calculations.

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

What makes it different

Open the job orders and you know where each car stands and how much its owner still owes. Open "المديونيات" (Balances due) and you find who to call first. And the summary tells you how much you made on parts across the orders that were not cancelled, instead of working it out from paper invoices.

What a car workshop job order is and what it contains

A job order is the file for one car in the workshop: who owns it, what was requested, what was used, and how much the customer still owes. In this sheet a job order has four parts:

  • A row in "أوامر الشغل" (Job orders): order number, date, customer code, plate number, model, status, labor fee and discount.
  • Spare parts in "القطع" (Parts): part name, quantity, its purchase price and the price you sell it to the customer for.
  • Amounts paid in "الدفعات" (Payments), with the date and payment method.
  • The customer's details and phone in "العملاء" (Customers).

The sheet links these parts by order number and customer code, so write them in the same format on every sheet.

How to track a job order from inspection to delivery

Change the "الحالة" (Status) column as the car moves forward: under inspection, then in progress or waiting for a part, then ready, then delivered. "الملخص" (Summary) shows orders broken down by status and the number of cars in the workshop and ready, and "أوامر الشغل" (Job orders) warns you about any ready or delivered order that still has a balance.

Worked example: labor fee 500, two parts of quantity 1 each with purchase price 300 and sale price 400 per part, and a discount of 50. Parts sales are then 800 and the order total is 1250. If the customer pays 600, the remaining balance is 650, and the profit on parts is 200.

For a printed invoice with VAT, try the sales invoice sheet, and for details see the guide.

How to use it

  1. In the "العملاء" (Customers) sheet, enter a code, name and phone for each customer.
  2. In the "أوامر الشغل" (Job orders) sheet, open a row for each car that enters the workshop: order number, date, customer code, plate number and model, then the status, labor fee and any discount.
  3. In the "القطع" (Parts) sheet, record each spare part on the order: order number, part name, quantity, purchase price and the price you sell it to the customer for.
  4. In the "الدفعات" (Payments) sheet, record each amount the customer pays with the order number and payment method.
  5. Change the "الحالة" (Status) column of the job order as the car progresses: under inspection, in progress, waiting for a part, ready, delivered.
  6. The sheet calculates each order's total and remaining balance and each customer's balance. Open "المديونيات" (Balances due) to see who owes, largest first, and "الملخص" (Summary) for the number of orders, revenue and profit on parts.

Before you start:

  • Order total = labor fee + parts sales − discount. An order with the status "cancelled" counts as zero and its parts do not enter revenue.
  • Order remaining balance = order total − its payments. A negative number means the customer paid more than the order.
  • Customer balance = total of their orders − total they paid on them, so a payment above one order's total is deducted from the balance of another order of the same customer.
  • Profit on parts = (sale price − purchase price) × quantity for each part. The labor fee is counted as full revenue with no labor cost, so the profit here is not the workshop's total profit.
  • Write the order number and customer code in the same format on every sheet. If you enter a code that is not recorded, "code not found" or "order not found" appears in red.
  • The sheet holds 200 customers, 1000 job orders, 2000 parts and 2000 payments, and the "المديونيات" (Balances due) list shows the first 50 customers.

Excel file (.xlsx) · 281 KB · 8 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: car workshop job orders (1/3)Cheat sheet: car workshop job orders (2/3)Cheat sheet: car workshop job orders (3/3)
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 sheetIn 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 · Ask for a demo

Frequently asked questions

How is a job order total calculated?

Order total = labor fee + parts sales recorded on the order − discount. An order with the status "cancelled" counts as zero, and its parts do not enter revenue or cost.

What is the difference between an order's remaining balance and a customer's balance?

The order's remaining balance is its total minus its own payments only. A customer's balance is the total of all their orders minus everything they have paid, so a payment above one order's total is deducted from the balance of another order of the same customer.

Is the profit on parts the workshop's profit?

No. Profit on parts is the sale price minus the purchase price, times the quantity. The labor fee is counted as full revenue without deducting technicians' pay, rent or other costs, so it is not the workshop's net profit.

What happens if I enter a code or order number that is not recorded?

"Code not found" appears in red in the job orders, or "order not found" in parts and payments, so you can correct it before the calculation goes wrong.

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

More free templates for: Workshops and maintenance

More free templates

All templates · Free tools