# Electronics shop Excel (free): serials & warranty

> Free Excel sheet for a mobile or electronics shop: serial/IMEI register, warranty end and status, repair tickets, stock by model and profit. No sign-up.

Source: https://softwiro.com/blog/electronics-store-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Electronics shop in Excel (free): serials, warranty and repairs

Follow each device by serial from supplier to customer, see its warranty end and status, and track repair tickets and their cost.

15 November 2026 6 min read

## In short

- Each device is logged once by serial or IMEI: in stock, then sold, with its profit from its own purchase cost.
- Warranty end = sale date + the model's warranty months, shown as active, expiring soon or expired.
- A repair ticket says whether the device was under warranty when it arrived, and works out days open and profit or loss.
- A summary with stock value, profit, warranties and repair tickets, and three charts.

You run a mobile or electronics shop and want to know, without a notebook or your memory, which device you sold to whom, whether its warranty is still running, how much its faults cost you, and how many of each model are left in stock. The free [electronics shop sheet](https://softwiro.com/templates/electronics-store) answers this from one key: the serial number (or IMEI) that follows each device from the supplier to the repair ticket.

## The problem it solves

In an electronics shop a customer comes back two months later saying "the device is dead". The questions start: did they buy it from us? When? How long is the warranty? Is the charger, say, on a one-month warranty that ended yesterday? When a device goes to the agent nobody remembers when it left, and you pay a repair bill nobody is charged for. The sheet ties all of it to the serial, so the answer is one row away.

## How the sheet works, step by step

1. In الموديلات (Models) write each model's code, brand, name, category, buy price, sell price, warranty months and minimum stock.
2. When devices arrive from the supplier, log each one in السيريال (Serials): serial, model code, supplier, purchase date and cost. Its status is "in stock".
3. When you sell, write the date, serial, customer, phone, price and discount in المبيعات (Sales). The device becomes "sold", and its profit, warranty end and warranty status appear.
4. When a faulty device returns, open a ticket in الصيانة (Repairs): number, received date, serial, fault and status. The sheet tells you whether the device was under warranty when it arrived.
5. As the ticket moves, write the date it was sent to the agent, the return date, the delivery date, the repair cost and the amount charged to the customer.
6. الملخص (Summary) shows stock, sales, profit, warranties and repair tickets.

## What is in each sheet

- الإعدادات (Settings): today's date, the warning and late-ticket day limits, and the brand and category lists.
- الموديلات (Models): the basics, then received, sold, balance, value, margin and status.
- السيريال (Serials): the device register, with a red alert for a repeated serial.
- المبيعات (Sales): the sale, then the warranty end and days left, with an alert for an unregistered serial or a sale before the purchase.
- الصيانة (Repairs): tickets with status, cost, amount charged and result, and an alert when late.
- الملخص (Summary): the headline numbers and three charts: sales and profit by month, stock value by brand, and repair tickets by status.

## Walk-through on the sample numbers

The numbers below are sample data inside the sheet, not a real shop. The example has 8 models, 30 registered devices, 17 sales and 5 tickets, and today's date is 15 November 2026:

- Galaxy A15: 5 devices received and 3 sold at net 7,200, 7,000 (after a 200 discount) and 7,200, so profit is 2,200. Two remain, worth 12,900 because the last two were bought at 6,450, not 6,400.
- Redmi Note 13: the first unit sold at 9,100 less a 100 discount, so net 9,000, cost 8,200 and profit 800. Its 12-month warranty ends 9 October 2027, 328 days away, status "active".
- Chargers (one-month warranty): the first sold on 5 October and its warranty ended on 5 November; the second sold on 14 October and ended yesterday, 14 November; the third sold on 20 October has 5 days left, so it shows "expiring soon".
- Tickets: the first charger came back on 3 November, two days before its warranty ended, so it is "in warranty"; replacing it cost 320 with nothing charged, a loss of 320. A screen for a device bought elsewhere cost 1,100 and you charged 1,500, a profit of 400. The ticket open since 30 October is 16 days old and shows "late" because the limit in Settings is 14.

**Summary:** 13 devices in stock worth 94,100, and three models below their minimum (Redmi Note 13, the power bank and the charger). Net sales are 120,950 against a cost of 109,630, a profit of 11,320, about a 9.4% margin. Warranties: 14 active, 1 expiring soon and 2 expired. Repairs net +80, so profit after repairs is 11,400. The monthly table shows October with 12 devices and a profit of 8,730, and November with 5 devices and a profit of 2,590.

## Why it helps

- One serial links sale, warranty and repair: in seconds you know whether to accept a fault for free.
- Warranty measured at the received date: you do not judge by today's date a device that arrived before its warranty ended.
- Real purchase cost per device: profit comes from that device's cost, even when the supplier's price moved.
- Alerts: a repeated serial, a device sold twice, a late ticket.
- Works in Excel 2016 and later, Google Sheets and LibreOffice, with room for 100 models, 500 devices, 500 sales and 200 tickets.

## Common mistakes

- Typing the serial in different ways: an extra space or a lowercase letter makes the device "not registered". Pick it from the list.
- Forgetting to log a device when you buy it: it will have no serial to sell. Log each delivery the same day.
- One warranty length for everything: a phone and a charger differ; set it per model.
- Leaving today's date old: warranty status and open days depend on it. Type =TODAY() so it updates itself.
- Leaving a ticket without a delivery date: it stays open and shows as late.

You can start from the [general shop inventory sheet](https://softwiro.com/templates/general-inventory) if your shop has no warranty or serials, and look at the [spare parts inventory sheet](https://softwiro.com/templates/spare-parts-inventory) if you run a repair bench with its own parts.

## Who it suits and when it is not enough

It suits a shop owner who sells dozens of devices a month and types them in; the sheet always needs someone to type every device and sale. If daily sales outgrow typing, or you need several cashiers on the same stock, or electronic invoices for the tax authority, [Accsys](https://softwiro.com/systems/accsys.html) deducts quantity at every sale, works on all the shop's devices and issues ETA invoices.

## Next step

Open the [sheet page](https://softwiro.com/templates/electronics-store), try the example or download it. Replace the models with yours, then log your first delivery in "السيريال", your first sale in "المبيعات", and type `=TODAY()` in Settings.

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

## 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 know if a device is still under warranty?

Log the sale by serial in the Sales sheet. The sheet adds the model's warranty months to the sale date and shows the end date, days left and status: active, expiring soon or expired.

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

The sheet compares the date the device was received with its warranty end, not today's date. A device received the day before its warranty ended shows "in warranty".

### What about items without a serial number?

Type your own running code for each piece (such as CH-001) in the serial column and it works like any device.

### Does it handle instalment sales?

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

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