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
| المتاحة الآن | 3 | 2,730,000.00 | 2,795,000.00 | 1,583,000.00 | 90,000.00 | |||
|---|---|---|---|---|---|---|---|---|
| الشاسيه / الكود | الماركة | الموديل | سنة الصنع | سعر الشراء | التكلفة | الحالة | سعر البيع | الربح |
| JTD-1001 | تويوتا | كورولا | 2021 | 520,000.00 | 535,000.00 | متاحة | ||
| HYU-2002 | هيونداي | إلنترا | 2020 | 410,000.00 | 418,000.00 | مباعة | 440,000.00 | 22,000.00 |
| KIA-3003 | كيا | سبورتاج | 2022 | 780,000.00 | 800,000.00 | مباعة | 845,000.00 | 45,000.00 |
| NIS-4004 | نيسان | صني | 2019 | 270,000.00 | 275,000.00 | مباعة | 298,000.00 | 23,000.00 |
| CHE-5005 | شيفروليه | أوبترا | 2018 | 190,000.00 | 197,000.00 | متاحة | ||
| MG-6006 | إم جي | 5 | 2023 | 560,000.00 | 570,000.00 | متاحة |
Example from the “السيارات” tab (Arabic), with the numbers and formulas that are in the file.
What is inside
- “الإعدادات” (Settings): The year and the opening balance of the cash box and the bank.
- “التصنيفات” (Categories): Receipt and payment categories, each with a type: collection, car purchase or expense.
- “السيارات” (Cars): The purchase and stock register: chassis number, make, model, year, colour, purchase date, supplier, purchase price, preparation costs and asking price. The cost and status (available or sold), sale date, sale price and profit appear automatically. It holds up to 500 cars.
- “العملاء” (Customers): Each customer's name and phone number, with the number of cars, total purchases, amount paid, amount due and status.
- “المبيعات” (Sales): One row per sale: date, chassis number, customer and sale price. The car, its cost and the profit appear, and the sheet warns you if a car is sold twice or has not been recorded.
- “السندات” (Vouchers): Receipt and payment vouchers with a number, date, account (cash box or bank), category and amount, plus the cash box balance and bank balance after each voucher. It holds up to 2,000 vouchers.
- “كشف عميل” (Customer statement): Pick a customer to see the cars they bought, their vouchers and the amount they owe.
- “كشف الخزينة والبنك” (Cash and bank statement): Enter a start and end date to see the opening balance, money received, money paid and the closing balance, with receipts and payments for each category.
- “طباعة سند” (Print voucher): Enter a voucher number and a receipt or payment voucher appears ready to print, with spaces for the recipient's and the accountant's signatures.
- “الرواتب” (Payroll): Each employee's basic salary, commissions, allowances, deductions, advances and net salary.
- “ملخص شهري” (Monthly summary): For each month: cars sold, sales, their cost and the profit on the cars, plus car purchases, money received and paid, operating expenses and net profit.
The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.
What makes it different
Car stock, sales, vouchers and customer accounts in one file. A payment is entered once as a receipt voucher, and it raises the cash box or bank and lowers the customer's amount due at the same time.
How to use it
- In the “الإعدادات” (Settings) tab, enter the year and the opening balance of the cash box and the bank. In “التصنيفات” (Categories), enter the receipt and payment types.
- In the “السيارات” (Cars) tab, record each car you buy: chassis number, make, model, purchase price, preparation costs and asking price. Its status shows “متاحة” (available) until it is sold.
- In the “العملاء” (Customers) tab, enter each customer's name and phone number.
- When you sell a car, record in “المبيعات” (Sales) the date, chassis number, customer and sale price. The car changes to “مباعة” (sold) and its profit appears.
- Record every receipt and payment in “السندات” (Vouchers): number, date, type, account (cash box or bank) and amount. If a receipt is a customer payment, pick their name.
- Open “طباعة سند” (Print voucher) and enter the voucher number to print it, and “كشف عميل” (Customer statement) to pick a customer and see their purchases, payments and amount due.
- Open “كشف الخزينة والبنك” (Cash and bank statement) and enter the start and end dates to see the opening balance, money received, money paid and closing balance.
- “ملخص شهري” (Monthly summary) shows sales, profit on cars, expenses and net profit for each month.
Before you start:
- The “السيارات” (Cars) tab is the purchase register: each row is a car you bought, with its purchase date, supplier and price.
- Car profit = sale price − (purchase price + preparation costs). Net profit = profit on cars − operating expenses.
- Car purchases are not an expense (the cost is counted when the car is sold). So give purchases the category “شراء سيارة” (car purchase), and use “مصروف” (expense) for the costs that are charged against profit.
- A customer's payment is entered once in “السندات” (Vouchers) as a receipt. It raises the cash box or bank and lowers the customer's amount due together.
- Write the chassis number and customer name in the same form in every tab. The drop-down lists prevent spelling differences.
- The balance after each voucher is worked out in row order, so record vouchers in date order.
- The sheet holds 500 cars, 500 sales, 200 customers, 2,000 vouchers and 50 employees.
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.
Still running this on Excel?
This sheet needs someone to copy every invoice and payment into it. In Accountwiro an invoice and a payment are recorded the moment they happen, and the customer's balance shows in a single statement of account.
| In this sheet | In Accountwiro |
|---|---|
| You copy every invoice and payment into the sheet by hand. | It shows the customer's invoices, payments and outstanding balance in a single statement of account. |
| Invoices are typed or copied by hand. | It creates an invoice by scanning a barcode or searching by product name, calculates discounts and taxes, and sends it to the customer over WhatsApp. |
| Stock shortages are discovered late. | It updates quantities after every sale and alerts you when a product drops below the required level. |
| Anyone who opens the sheet sees every number. | Permissions per user: the sales employee issues invoices, and the warehouse employee manages stock without access to financial data. |
Frequently asked questions
How do I calculate the profit on each car in a car dealership?
Enter the purchase price and preparation costs in the “السيارات” (Cars) tab and the sale price in “المبيعات” (Sales). The sheet works out the car's profit = sale price − (purchase price + preparation costs).
Do I enter a customer's payment in the vouchers and in the customer's account?
No. You enter it once as a receipt voucher in “السندات” (Vouchers) and pick the customer's name. It goes into the cash box or bank and is deducted from what the customer owes.
How do I print a receipt or payment voucher?
Enter the voucher number in the “طباعة سند” (Print voucher) tab. The voucher appears ready with the date, amount, description and two signature boxes. Then print it.
What goes into net profit?
Net profit = profit on cars − operating expenses. Car purchases are not counted as an expense, because a car's cost enters when it is sold.
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: Transport and cars
More free templates
- Car rental fleet tracker (Excel)
- Fleet fuel and maintenance tracker (Excel)
- 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)
- Freelancer projects, hours and invoices tracker
- Supplier purchase orders and payables tracker
- Charity donations and disbursements tracker
- Travel agency bookings tracker
- Laundry orders tracker (Excel)
- Dental clinic treatment plans tracker (Excel)
- School class timetable (Excel)
- Exam schedule with committees and invigilators (Excel)





