# Electronics shop sheet: serials, warranty and repairs

> Electronics shop sheet: serial/IMEI register, warranty end date and status per sale, repair tickets with cost and charge, stock by model and profit.

Source: https://softwiro.com/templates/electronics-store
Language: English
Softwiro, softwiro.com

---

Free Excel template

A free Excel sheet for a mobile phone and electronics shop. You record each device by serial number or IMEI when you buy it from the supplier and it shows as "في المخزن" (in stock); when you sell it to a customer it changes to "مباع" (sold), and its warranty end date, warranty status (valid, ending soon or expired) and profit appear. You also track repair and warranty tickets: the fault, sending the device to the agent and its return, the cost and the amount charged to the customer, with the stock balance of each model and a summary with charts.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-electronics-store.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-electronics-store-blank.xlsx)

Excel file (.xlsx) · 181 KB · 8 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

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

| التاريخ | الجهاز | صافي السعر | الربح | نهاية الضمان | حالة الضمان |
| --- | --- | --- | --- | --- | --- |
| 46300 | أنكر شاحن 20 وات | 450.00 | 130.00 | 46331 | منتهي |
| 46300 | أنكر Power Bank 10000 | 1,050.00 | 270.00 | 46482 | ساري |
| 46302 | سامسونج Galaxy A15 128GB | 7,200.00 | 800.00 | 46667 | ساري |
| 46304 | شاومي Redmi Note 13 | 9,000.00 | 800.00 | 46669 | ساري |
| 46307 | سامسونج Galaxy A15 128GB | 7,000.00 | 600.00 | 46672 | ساري |
| 46309 | أنكر شاحن 20 وات | 450.00 | 130.00 | 46340 | منتهي |
| 46311 | آبل iPhone 15 128GB | 41,000.00 | 2,500.00 | 46676 | ساري |
| 46313 | شاومي Redmi Note 13 | 9,100.00 | 900.00 | 46678 | ساري |
| 46315 | أنكر شاحن 20 وات | 450.00 | 130.00 | 46346 | ينتهي قريبًا |
| 46317 | أوبو A58 128GB | 8,000.00 | 700.00 | 46682 | ساري |
| 46320 | أنكر Power Bank 10000 | 1,050.00 | 270.00 | 46502 | ساري |
| 46323 | سامسونج Galaxy A55 256GB | 16,000.00 | 1,500.00 | 46688 | ساري |

Example from the “المبيعات” tab (Arabic), with the numbers and formulas that are in the file.

## What is inside

- الإعدادات: Today's date, how many days before warranty expiry to warn, how many days a repair can be late, the first month of the summary, and the brand and category lists that feed the drop-down lists.
- الموديلات: Purchase price, selling price, warranty period in months and minimum level for each model, with received, sold, stock, stock value, profit per unit, margin, net sales, profit and status (in stock, order or out). Holds 100 models.
- السيريال: Record each device with its serial number or IMEI, model code, supplier, purchase date and cost. It shows its status (in stock or sold), sale date, customer and days in stock, and warns if a serial is repeated. Holds 500 devices.
- المبيعات: One row per sale: date, serial, customer, phone, selling price and discount. It shows the device, its cost, profit, warranty end date, days remaining and warranty status, and warns if the serial is not recorded or the device was sold twice. Holds 500 sales.
- الصيانة: A ticket for each returning device: fault, status, date sent to the agent, return and handover dates, repair cost and amount charged to the customer. The sheet decides whether the device was under warranty when received, calculates the days and the profit or loss, and warns when a ticket is late. Holds 200 tickets.
- الملخص: Stock and its value, sales, profit, valid and expired warranties and repair tickets, a monthly table, a table by brand and one by repair status, with three charts.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

## What makes it different

The serial number is the key to everything: a device appears in stock, then in a sale, then in warranty, then in a repair ticket, so you know who bought it, when its warranty ends and whether repairing it costs you money, without typing its details twice.

## How to use it

1. In the "الإعدادات" (Settings) sheet, enter today's date (or =TODAY()), how many days before warranty expiry to warn, how many days a repair can be late, the first month of the summary, and the brand, category and fault-type lists if needed.
2. In the "الموديلات" (Models) sheet, enter for each model: code, brand, model, category, purchase price, selling price, warranty period in months and minimum stock.
3. When you receive devices from a supplier, record each device in a row of the "السيريال" (Serials) sheet: serial or IMEI, model code, supplier, purchase date and cost. Its status shows "في المخزن" (in stock).
4. When you sell, record in "المبيعات" (Sales) the date, serial, customer, phone, selling price and discount. The device's status changes to "مباع" (sold), and the warranty end date, warranty status and profit appear.
5. When a customer comes back with a fault, record a ticket in "الصيانة" (Repairs): its number, the date received, serial, fault and status. The sheet tells you whether the device was under warranty when received, and calculates the ticket's days and the profit or loss.
6. As the ticket progresses, enter the date sent to the agent, the date it came back, the handover date, the repair cost and the amount charged to the customer.
7. Open "الملخص" (Summary) to see stock, sales, profit, valid and expired warranties and repair tickets, with three charts.

**Before you start:**

- The serial or IMEI is entered as text (the cells are set up for it). The sheet prevents duplicates with a red warning if a serial is repeated or a device is sold twice.
- Warranty end = sale date + the model's warranty period in months. The status is "ساري" (valid), "ينتهي قريبًا" (ending soon, within the number of days in Settings) or "منتهي" (expired).
- A repair ticket's warranty is measured by the date the device was received, not today's date. A device sold by another shop shows "من خارج المحل" (not from this shop).
- Model stock = devices recorded in "السيريال" (Serials) that have not been sold. Stock value uses the actual purchase cost of each device.
- Device profit = net selling price (after discount) - the purchase cost of that device. Repair profit = amount charged to the customer - agent cost (it may be negative on a warranty repair).
- For accessories without a serial, record each piece with a sequential code of your own (such as CH-001). Instalment sales are outside the scope of this sheet.
- The sheet holds 100 models, 500 devices in the serial register, 500 sales and 200 repair tickets, and the summary shows 6 months and 8 brands.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-electronics-store.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-electronics-store-blank.xlsx)

Excel file (.xlsx) · 181 KB · 8 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

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

0 downloads · 3 pages

## Still running this on Excel?

This sheet needs someone to type in every transaction. Accsys deducts the quantity at every sale and works across all the shop's devices at once, even without internet.

| In this sheet | In Accsys |
| --- | --- |
| You type in every sale and every purchase by hand. | Each color and size combination has its own barcode, which is deducted from stock at the sale and returned to stock on a return. |
| The e-invoice for the tax authority lives in a different system. | It issues e-invoices compatible with the Egyptian Tax Authority's ETA system, and sends the invoice on WhatsApp with a payment link. |
| The sheet sits on one device, and whoever edits it last wins. | It works offline, then syncs data across all the shop's devices when the connection returns. |
| Total sales doesn't tell you how much you earned. | A tiered income statement from revenue down to net profit, plus profit and margin for each item. |

[See Accsys](https://softwiro.com/systems/accsys.html) · [Ask for a demo](https://softwiro.com/contact)

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

## Frequently asked questions

### How do I know whether a device's warranty is still valid?

Record the sale by serial in the "المبيعات" (Sales) sheet. The sheet adds the model's warranty period in months to the sale date, so the end date, the days remaining and the status appear: valid, ending soon or expired.

### How is the warranty of a repair ticket decided?

The sheet compares the date the device was received with the end of its warranty, not today's date. So a device received one day before its warranty ended shows as "داخل الضمان" (under warranty) even if the ticket was opened after that.

### Does it work for items that have no serial number?

Yes. Give each item a sequential code of your own (such as CH-001) in the serial column and it is treated like any other device.

### Does it calculate instalment sales?

No, instalments are outside this sheet. It records the selling price, discount, profit, and the device's warranty and repairs.

### 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](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](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

More free templates for: Shops and stores

## More free templates

- Cash Book Template for Excel
- Invoice Template with Invoice Log (Excel)
- Clothing shop inventory sheet by colour and size
- Customer accounts, credit sales and customer statement sheet
- Cash book and customer accounts sheet
- Installments and collection tracker
- General shop inventory tracker (stock in/out, reorder, slow movers)
- Supplier purchase orders and payables tracker
- Multi-warehouse and branch inventory sheet with transfers
- Periodic stock count and count-difference reconciliation sheet
- Barcode, batch and expiry inventory sheet
- Grocery store management sheet
- Stationery shop and photocopy management sheet
- Wholesale clothing trade sheet: traders, stock and collection
- Food wholesale and distribution sheet in Excel: routes, expiry and collection
- Electronics factory sheet: BOM, production and quality
- Periodic table in Excel (Arabic names): lookup, molar mass calculator and quiz
- Science formulas cheat sheet: physics, chemistry and biology with examples
- Complete nursery management sheet
- Private school management sheet
- Complete clinic management sheet
- Medical lab management sheet
- Pharmacy management sheet: sales, purchases, shortages and suppliers

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
