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 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, and selling whole cars has the car showroom accounts sheet.
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
- Settings (الإعدادات): type today's date, the dead-stock days, the reorder multiplier and the workshop discount, and check the category and car make lists.
- 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.
- Parts (القطع): a card for each part with its code, type (original, commercial or used), cost, retail and wholesale prices, opening stock, minimum and shelf.
- Compatibility (التوافق): for each part the cars it fits: make, model, first and last year.
- Purchases and sales (المشتريات, المبيعات): one line per part; on a sale pick the price tier and type the discount and the amount paid.
- 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.
- 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, or ask for software built your way.
Your next step
Open the sheet, 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.





