# Car wash Excel sheet (free): packages, cards, profit

> Free Excel car wash sheet: package prices by size, subscription cards used and left, worker commission, shampoo and wax stock, revenue, profit and busy hours.

Source: https://softwiro.com/blog/car-wash-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Car wash management in Excel (free): packages, subscription cards, workers and materials

One workbook for wash packages by car size, subscription cards, worker commission, shampoo and wax stock, revenue and profit.

15 November 2026 5 min read

## In short

- The price of each wash is read from the package and car size, and discount and payment method are logged beside it.
- A subscription card shows washes used and remaining and its status; its price counts as revenue once, on the day it is sold.
- Each worker is paid by commission on the wash value or a daily wage, and the sheet totals what is due.
- Shampoo, wax and polish are deducted per wash by package and size factor, with reorder alerts, and the summary gives profit and busy hours.

You run a car wash and you want to know, without scattered notebooks: how much you made this month after shampoo, wax and labour; which hour and which day are busiest; how many washes are left on each subscriber's card; what each worker is owed; and which material is about to run out. The free [car wash management sheet](https://softwiro.com/templates/car-wash) answers these from one log where you type every wash, and from your packages and prices, which you write once. The template is in Arabic.

## The problem it solves

In a car wash the accounts are scattered: the cashier picks a price by car size, the cards are on a paper where the remainder gets lost, the worker asks about his commission at month end, shampoo is bought when it has run out rather than before, and nobody knows what one wash costs. Revenue looks big and you cannot see where it went. The sheet ties each wash to its package, size and worker, so the price, the commission and the material cost come out together.

## How the sheet works, step by step

1. In Settings you type today's date, the summary month, the card validity in days, and the car sizes with a material factor for each.
2. In Materials you type each material, its price per litre, opening stock, what arrives and its minimum.
3. In Packages you type each package, its price for each size and the millilitres of each material one wash uses.
4. In Workers you set each worker as commission (a percentage) or daily wage with his days worked.
5. In Cards you record each subscription card with its number of washes, price and start date.
6. In Washes you record each wash: date, time, plate, size, package, worker, discount and payment method, and the card number if the customer paid with a card.
7. You open Revenue and Summary to see daily revenue, profit and the busy hours.

## What each sheet does

- Packages: the price for each size, the material cost of a sedan wash and its profit before labour.
- Materials: use, balance, status (in stock, reorder or out) and the cost of what was used in the month.
- Cards: expiry date, used, remaining and status.
- Workers: the month's washes, what the worker collected, his commission, his daily wage and his total due.
- Washes: list price, collected, material cost and worker commission, with a warning for a missing package or an expired card.
- Revenue and Summary: daily and cumulative revenue, busy hours and weekdays, costs and profit, and five charts.

## Walk-through on the sample numbers

These numbers are sample data, not a real car wash. Today is 2 November 2026 and the summary month is October.

- An "interior and exterior" wash for a sedan costs 150 and uses 60 ml shampoo, 20 ml glass cleaner and 40 ml interior cleaner, so its material cost is (60×45 + 20×60 + 40×90) ÷ 1000 = 7.5. For an SUV the factor 1.3 raises the use by the same proportion.
- Hassan's 20% commission on an "exterior wash" for a sedan priced at 80: 16.
- Card C-102 holds 4 washes and 3 are used, so 1 remains and its status is "valid". Card C-105 has used all 3, so it shows "used up"; C-101 has used 6 of 8 but ended on 30 October, so it shows "expired"; and C-106 ends in two days, so it shows "ending soon".

In October **94** washes were logged: 15 on subscription cards and 79 paid. Collected was 15,080, an average of 190.89 per paid wash, and five cards sold for 3,330, so revenue is **18,410** after discounts of 730. Costs: materials 890.79, commissions 2,639.50 and Karim's daily wage 6,500 (250 × 26 days), a total of 10,030.29, leaving a monthly profit of **8,379.71**, a margin of 45.5% before rent and electricity.

The busiest hour is 5 pm with 22 washes, the busiest day is Saturday with 26 washes, and the best day for collections was 17 October with 1,550. For materials, shampoo shows "reorder" with 2.07 litres against a minimum of 4, and polish shows "reorder" with 0.29 litres against 0.5.

## Features and why they matter

- The price comes from package and size: the cashier does not guess.
- A card is not counted as revenue twice: its price is revenue on the day it is sold, and its washes show in the count, the cost and the commission.
- Use is worked out for every wash, so the sheet knows the shampoo and wax balance without a daily count.
- Commission or daily wage: each worker on his own pay system.
- Busy hours and days: to place your offers in the quiet hours.
- It works in Excel 2016 and later, Google Sheets and LibreOffice, free and without sign-up. It holds 20 packages, 100 cards and 3000 washes.

## Common mistakes

- Logging a wash on a card as paid in cash, which counts revenue twice and leaves the card's remainder too high.
- Spelling a package or size differently from the sheet, so a warning shows and no price is read.
- Forgetting to enter materials received, so the balance looks lower than real.
- Setting a package's material amount by guess rather than by measurement.
- Forgetting the days a daily-wage worker worked in the month.

Remember the profit here excludes rent, electricity and water, and that workers' rights and taxes follow local law.

## When to move to a system

When you open more branches or cashiers, or want a digital card that deducts itself and shows the customer what is left on his phone, or bookings made by customers themselves. To follow commission the same way in another business see the [beauty salon bookings sheet](https://softwiro.com/templates/beauty-salon-bookings), and for job orders and parts in workshops the [car workshop sheet](https://softwiro.com/templates/car-workshop-jobs).

## Your next step

Download the [car wash management sheet](https://softwiro.com/templates/car-wash), type your packages and prices in Packages, then log the first day's washes. After a week open Revenue to see your busy hours before you decide your workers' shifts.

## 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 wash (1/3)](https://softwiro.com/uploads/cheatsheets/car-wash/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/car-wash/en-1.jpg)[![Cheat sheet: car wash (2/3)](https://softwiro.com/uploads/cheatsheets/car-wash/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/car-wash/en-2.jpg)[![Cheat sheet: car wash (3/3)](https://softwiro.com/uploads/cheatsheets/car-wash/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/car-wash/en-3.jpg)

0 downloads · 3 pages

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

## Questions this raises

### How does the sheet price a wash?

It reads the package price for the car size from the Packages sheet. Collected = list price − discount, and it is zero for a wash paid with a subscription card because the card price was counted when sold.

### How do I know how many washes are left on a card?

Type the card number on each wash done with it. The Cards sheet counts the washes between its start and end dates; remaining = the card's washes − used, and the status reads valid, ending soon, used up or expired.

### How is shampoo and wax use worked out per wash?

Type in Packages the millilitres of each material for a sedan wash and in Settings a size factor. Use = amount × factor ÷ 1000 litres, deducted from the material balance in Materials.

### How do I pay one worker commission and another a daily wage?

Pick the pay type per worker in Workers. A commission worker earns his percentage of (price − discount) on each wash logged under his name; a daily-wage worker earns the wage × the days you type for him.

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

[All writing](https://softwiro.com/blog.html)
