# Auto parts shop Excel sheet (free): sales and credit

> Free Excel sheet for a car parts shop: retail, wholesale and workshop prices, car-fit search, stock deducted on sale, profit per line, credit aging, dead stock.

Source: https://softwiro.com/blog/auto-parts-shop-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Auto parts shop in Excel (free): sales, profit, credit customers and car compatibility

One workbook for part cards, retail, wholesale and workshop prices, a car-fit search, purchases, sales with profit, credit aging and reorder.

20 November 2026 5 min read

## In short

- Each part has a card with its type (original, commercial or used), cost, retail and wholesale prices, opening stock and shelf.
- Type a car make, model and year and the sheet lists the parts that fit it with stock, price and shelf.
- Every sale picks a price tier (retail, wholesale or workshop), takes the stock off the part and shows the profit and what the customer still owes.
- Customer credit is split by age (30, 60, 90 and over 90 days), with a flag for those over their limit.
- Reorder and dead-stock lists, supplier balances, daily and monthly profit and a dashboard with five charts.

You run a car parts shop and want to know, without notebooks or a calculator, how much you sold today and really earned, which part is about to run out, who owes you and since when, how much you owe suppliers, and which parts fit the car in front of you. The free [auto parts shop sheet](https://softwiro.com/ar/templates/auto-parts-shop) keeps all of this in one file.

This sheet is for a shop that **sells** parts. A spare parts store inside a workshop or plant, where parts are issued to machines and work orders, has its own [spare parts inventory sheet](https://softwiro.com/templates/spare-parts-inventory), and selling whole cars has the [car showroom accounts sheet](https://softwiro.com/templates/car-showroom-accounts).

## The problem it solves

A parts shop serves three kinds of buyer at three prices: the car owner at retail, the small shop at wholesale, and the workshop at a little less than retail. It sells a lot on credit to workshops and shops, one part fits many cars, and the same part comes as original, commercial or used at different prices. If the accounts stay in a notebook, the real profit on each sale is lost, you forget whose debt is late, and you look for the right part in your memory or in scattered catalogues. Here each fact is typed once and the rest is calculated.

## Steps, from opening the file to the report

1. Settings (الإعدادات): type today's date, the dead-stock days, the reorder multiplier and the workshop discount, and check the category and car make lists.
2. Suppliers and customers (الموردون, العملاء): name and phone; for a customer the type and credit limit, and an old balance with its date if there is one.
3. Parts (القطع): a card for each part with its code, type (original, commercial or used), cost, retail and wholesale prices, opening stock, minimum and shelf.
4. Compatibility (التوافق): for each part the cars it fits: make, model, first and last year.
5. Purchases and sales (المشتريات, المبيعات): one line per part; on a sale pick the price tier and type the discount and the amount paid.
6. Returns and payments (المرتجعات, الدفعات): what came back from a customer or went back to a supplier, and what you collected or paid after the sale or purchase.
7. Open Customers, Suppliers, Monthly (الشهري), Reorder (إعادة الطلب), Dead stock (الراكد) and Summary (الملخص): all of them calculate by themselves.

## What each sheet does

- Parts: balance = opening + purchases - sales + customer returns - returns to suppliers, its value at cost, the retail margin, the status (out, reorder or available), dead stock and the reorder quantity.
- Compatibility and car search (بحث سيارة): type make, model and year and the first 20 matching parts appear with prices, balance and shelf.
- Sales: the unit price by tier, the total after discount, the cost, the profit, what the customer still owes and a warning if stock is not enough.
- Customers: each customer's balance, debt aging and status. The balance is spread from the newest to the oldest on the basis that what a customer pays settles the oldest debt first.
- Suppliers and Monthly: what each supplier is owed, six months of sales and profit, and a daily table.
- Reorder, dead stock and summary: what to buy, what to clear, stock value and five charts.

## Walk-through on the sample numbers

The names and figures below are sample data in the sheet; replace them with yours.

- Car search: Toyota Corolla 2016 shows 11 parts, including a Toyota oil filter and the original front brake pads. The pads have 3 in stock and the status "اطلب" (reorder) because their minimum is 4.
- Three prices: a commercial brake pad set retails at 420 and sells wholesale at 370; the workshop price is 386.40 (420 minus 8%). Al-Amal workshop bought 4 for 1,545.60 against a cost of 1,120, so the line profit is 425.60.
- Discount: the shop sold Ahmed Samir two front shock absorbers at the retail price of 900 each with a discount of 100: total 1,700, cost 1,300, profit 400.
- Credit and aging: Al-Nour shop's balance is 22,140 = old balance 12,000 + purchases 17,580 - paid at sale 2,250 - collected 5,000 - returned 190. It splits into 2,250 up to 30 days, 13,080 between 31 and 60 days and 6,810 over 90 days. Al-Ikhlas shop owes 14,950 against a limit of 12,000, so its status is "تجاوز الحد" (over the limit). Customers owe 59,518.20 in all, 10,810 of it late by more than 60 days.
- Suppliers: Al-Amana Import is owed 9,960 = old balance 5,000 + purchases 21,800 - paid 14,600 - settled 2,000 - returned 240. In all you owe suppliers 20,840.
- Monthly: October sales were 50,475.20 with a profit of 10,275.20, a margin of 20.4%. November net sales were 51,427.60 after returns of 576.40, with a profit of 10,987.60, a margin of 21.4%. The total is 101,902.80 with a profit of 21,262.80.
- Stock: worth 156,830 at cost...

## Common mistakes

- Forgetting to update the cost: profit is worked out from the cost on the part card. If the buying price rises and you do not update it, the profit shown is higher than the real one. The Purchases sheet warns you when the cost differs.
- Writing a customer's name in several ways: pick it from the list so the debt gathers in one row.
- Entering a later payment as a new sale: what a customer pays after the sale belongs in Payments.
- Leaving a return unrecorded: the part balance and the customer's debt are then wrong.
- Leaving compatibility incomplete: a part with no car written for it will not show in the car search. Check the catalogue before you sell.

## When to move to a system

The sheet is enough for a shop that starts small, with data typed by one person. When you have several sellers and cashiers and want to scan a part's barcode, issue an invoice sent to the customer on WhatsApp and give each user their own permissions, look at [Accountwiro](https://softwiro.com/product/budoor), or ask for [software built your way](https://softwiro.com/contact).

## Your next step

[Open the sheet](https://softwiro.com/ar/templates/auto-parts-shop), clear the sample numbers, then type the cards of your ten best-selling parts with their compatibility and prices and log this week's sales. By the end of the week you will have your profit, your customers' credit and your reorder list ready; then add the remaining parts gradually.

## Car makes

The makes list in Settings comes ready with Toyota, Hyundai, Kia, Nissan, Chevrolet, Renault, Skoda, Mitsubishi, Suzuki, Fiat, Peugeot and Chery, and you can edit it. So you find spare parts for a Toyota, or any other make, by typing the make, model and year in the car search 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: auto parts shop accounts (1/3)](https://softwiro.com/uploads/cheatsheets/auto-parts-shop/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/auto-parts-shop/en-1.jpg)[![Cheat sheet: auto parts shop accounts (2/3)](https://softwiro.com/uploads/cheatsheets/auto-parts-shop/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/auto-parts-shop/en-2.jpg)[![Cheat sheet: auto parts shop accounts (3/3)](https://softwiro.com/uploads/cheatsheets/auto-parts-shop/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/auto-parts-shop/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 find the parts that fit a customer's car in Excel?

In the Compatibility sheet, write for each part the make, model, first year and last year. Then type the make, model and year in the car search sheet and the matching parts appear with prices, stock and shelf.

### How do I sell the same part at retail, wholesale and workshop prices?

Write the retail and wholesale prices on the part card and the workshop discount in Settings. On each sale line pick the price tier and the sheet takes the right price and works out the total after discount. In the sample the workshop price of a 420 part is 386.40.

### How do I follow customer credit and debt aging?

Type what the customer paid at the sale in Sales and later collections in Payments. The Customers sheet shows the balance, splits it into up to 30, 31 to 60, 61 to 90 and over 90 days, and colours customers over their credit limit.

### How is the profit on each sale worked out?

Profit = quantity x price - discount - quantity x the part's unit cost. In the sample, 4 workshop brake pads sold for 1,545.60 against a cost of 1,120 give a profit of 425.60. Update the cost on the card when the buying price changes.

### What is the difference from the spare parts inventory sheet?

This sheet is for a shop that sells parts to customers, so it cares about selling prices, profit, credit and fit with cars. The spare parts inventory sheet is for a store inside a workshop or plant that issues parts to machines and work orders.

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