# Car showroom accounts Excel (free) + online

> Free Excel sheet for a car showroom: stock, sales, purchases, receipt and payment vouchers, customer and cash/bank statements, payroll and profit per car.

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

---

Free Excel template

# Car showroom accounts in Excel (free): stock, sales, vouchers and profit per car

One workbook for car stock, sales, receipt and payment vouchers, customer and cash/bank statements, payroll and monthly profit.

12 November 2026 6 min read Updated 17 November 2026

## In short

- Each car is typed once; it shows available until sold, then its profit = sale price − (purchase price + preparation).
- A customer payment is typed once as a receipt voucher, so it raises the cash box or bank and lowers what the customer owes.
- Printable receipt and payment vouchers, a customer statement and a cash/bank statement for any period.
- A monthly summary with car profit, operating expenses and net profit.

You run a car showroom and want to know without flipping through notebooks: which cars are still in stock, how much you made on each car you sold, who owes you money, how much is in the cash box and the bank, and what the month's net profit is after expenses. The free [car showroom accounts sheet](https://softwiro.com/templates/car-showroom-accounts) keeps all of it together: stock, purchases, sales, receipt and payment vouchers, a customer statement, a cash and bank statement and payroll.

## The problem it solves

Many showrooms keep the stock in one file, sales in a notebook, vouchers on paper and customer balances on another sheet. When a customer asks what is left on their account, or you want the month's profit, you add numbers by hand and the totals disagree. Here each fact is typed once: the car in "السيارات" (Cars), the sale in "المبيعات" (Sales), the payment as a voucher in "السندات" (Vouchers), and everything else is calculated.

## Steps, from opening the file to the report

1. Settings: enter the year and the opening balance of the cash box and of the bank.
2. Categories: review the receipt and payment categories. Each has a type: collection, car purchase or expense.
3. Cars: one row per car you bought: chassis, make, model, purchase date, supplier, purchase price, preparation costs and asking price. It shows as "available".
4. Customers: each customer's name and phone.
5. Sales: on a sale enter the date, the chassis (from a list), the customer and the sale price. The car becomes "sold" and its profit appears.
6. Vouchers: every receipt and payment with a number, date, account (cash or bank), category and amount. If a receipt is a customer's payment, pick the customer.
7. Open the voucher print sheet, the customer statement, the cash and bank statement, payroll and the monthly summary; all are calculated for you.

## Worked example from the numbers in the sheet

The names and numbers below are sample data inside the sheet, not real people. The example has six cars, three sales and twelve vouchers:

- Stock: three cars remain available (Corolla, Chevrolet Optra and MG 5) with a total cost of 1,302,000.
- Profit per car: the Hyundai Elantra sold for 440,000 against a cost of 418,000, a profit of 22,000; the Kia Sportage sold for 845,000 against 800,000, a profit of 45,000; the Nissan Sunny sold for 298,000 against 275,000, a profit of 23,000. Total 90,000.
- Customers: Adel Mansour bought for 440,000 and paid 440,000, so he is settled; the sample company bought for 845,000 and paid 845,000, so it is settled; Salma Hassan bought for 298,000 and paid 100,000, so she owes 198,000.
- Cash and bank statement for October: the cash box started at 500,000, received 300,000 and paid 521,000, so it ends at 279,000. The bank started at 2,000,000, received 1,085,000 and paid 1,370,000, so it ends at 1,715,000.
- Monthly summary for October: sales 1,583,000, cost of the cars sold 1,493,000, car profit 90,000. Operating expenses (salaries, rent, advertising) are 49,000, so net profit is 41,000. The month's car purchases (1,842,000) are not an expense because each car's cost counts when it is sold.

## How the numbers are worked out

- Car cost = purchase price + preparation costs.
- Car profit = sale price − cost.
- Customer balance due = total purchases − (receipts from the customer − payments to the customer).
- Cash balance after a voucher = opening balance + receipts − payments on the cash box up to that voucher. The bank works the same way.
- Net profit = car profit − operating expenses.

## Tips

- Pick the chassis and the customer from the lists instead of typing them; one different letter separates a car from its sale.
- Enter vouchers in date order so the balance after each voucher is right.
- Give car purchases the category "شراء سيارة" (type: car purchase) so they are not deducted from profit twice.
- If a sale shows "sold more than once" or "car not registered", correct the chassis.

## If you sell on instalments

This sheet records the sale price and the customer's payments and shows what the customer still owes, but it does not follow instalment due dates. To track each instalment, its date and who is late, use the free [instalment tracker sheet](https://softwiro.com/templates/installments-tracker) next to it: enter the contract (customer, car, price, down payment, number of instalments, first due date) and then each payment, and it shows what each customer still owes, the days late and today's list of late payers. Enter the payment here too, as a receipt voucher, so it reaches the cash box or the bank and the net profit.

## Try it now

[Open the sheet, try it online or download the Excel file](https://softwiro.com/templates/car-showroom-accounts). It holds 500 cars, 200 customers and 2,000 vouchers. If you want something made for your showroom, [request it here](https://softwiro.com/request-sheet).

## 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 showroom accounts (1/3)](https://softwiro.com/uploads/cheatsheets/car-showroom-accounts/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/car-showroom-accounts/en-1.jpg)[![Cheat sheet: car showroom accounts (2/3)](https://softwiro.com/uploads/cheatsheets/car-showroom-accounts/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/car-showroom-accounts/en-2.jpg)[![Cheat sheet: car showroom accounts (3/3)](https://softwiro.com/uploads/cheatsheets/car-showroom-accounts/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/car-showroom-accounts/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 do I work out the profit on each car in Excel?

Enter the purchase price and preparation costs in the Cars sheet and the sale price in Sales. The sheet gives car profit = sale price − (purchase price + preparation costs).

### Do I enter a customer payment twice?

No. Enter it once as a receipt voucher with the customer name; it enters the cash box or bank and reduces what the customer owes.

### How do I print a receipt or payment voucher?

Type the voucher number in the print sheet and print it: date, amount, description and signature boxes are ready.

### How do I see the showroom's net profit for a month?

Open the Monthly summary sheet. For each month it shows the profit on the cars sold that month, takes away the operating expenses (salaries, rent, ads and others) and shows the net profit. In the sheet's example: October car profit 90,000, expenses 49,000, net profit 41,000.

### Where do I enter the showroom's expenses?

In the Vouchers sheet, as a payment voucher with a category of type expense, such as rent, salaries or ads. Buying a new car uses the category «شراء سيارة» and is not taken off the profit, because its cost counts when the car is sold.

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