# Stationery shop and photocopy Excel sheet (free)

> Free Excel sheet for a stationery shop: stock and reorder, photocopy and print log by page, school-list orders with deposit and balance, and a season chart.

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

---

Free Excel template

# Stationery shop and photocopy management in Excel (free)

Track items, copying and school lists in one file, and see before the season what will run out.

15 November 2026 5 min read

## In short

- Write items with buying and selling price and a minimum level, then log deliveries and daily sales.
- Copying is priced by page and copies, with black-and-white and colour kept apart.
- A school list reserves its items from stock until hand-over, so shortfalls show before you promise.
- Net = lines − discount; balance due = net − (deposit + hand-over payment); late lists are flagged.
- The season sheet shows income by month and stream, so you can buy before the peak.

You run a stationery shop with external school books and a photocopy counter, and before and after the school season you want three answers: what will run out, how much you really earn from copying and printing, and what is still owed on each school list in deposit and balance. The free [stationery shop and photocopy management sheet](https://softwiro.com/templates/stationery-bookshop) (the page is in Arabic) answers from things you type: your items and prices, deliveries and sales, the photocopy log and the school lists.

## The problem: three income streams in one notebook

The shop sells items by the piece, sells photocopied pages by the pound and a half, and prepares whole lists for schools with a deposit and a later hand-over. They all crowd into September. A parent asks for a list and the seller promises external books that have not arrived; copying is priced in the head so nobody knows its profit; a ready list sits on a shelf with a balance nobody collected. The sheet puts the three streams in one file and reserves a list's items from the stock before hand-over.

## How it works, step by step

1. In الإعدادات (Settings) type today's date and any date inside the month to summarise, and review the categories and the list of suppliers and publishers.
2. In الأصناف (Items) write each item's code, name, category, unit, buying price, selling price, minimum level, opening balance and supplier.
3. In الخدمات (Services) write the copy and print prices, the cost of a page and each service's type (black-and-white or colour).
4. In المشتريات (Purchases) log deliveries, in المبيعات (Sales) log sales as a daily total per item, and in سجل التصوير (Photocopy log) the service, the pages and the copies.
5. For each school list write a row in قوائم المدارس (School lists) and its items in بنود القوائم (List lines) under the same number. On hand-over change the status to «تم التسليم» (delivered) and log what was paid.
6. Open إعادة الطلب (Reorder) to see what to buy, and الموسم (Season) and الملخص (Summary) to compare months and income streams.

## What each sheet does

- Items: balance = opening + purchases − sales − delivered list lines. Available = balance − reserved for undelivered lists, and the status is worked out on the available figure.
- Services and photocopy log: a service total = pages × copies × page price − discount, and its profit = total − pages × page cost.
- School lists and their lines: net = sum of lines − discount, balance due = net − (deposit + hand-over payment), with a «late» flag.
- Reorder: short items ranked by suggested quantity and its cost.
- Season and summary: income for each month of the year by stream, the chosen month's figures, and profit by category.

## A walk-through with the sample numbers

These numbers are sample data inside the sheet, not a real shop: 16 items, 7 services and 48 school lists, today is 2 November 2026 and the month is October 2026.

- October item sales: 20,884 with a profit of 5,534.50, or 26.5%.
- External books: direct sales in October were 9,725 with a profit of 2,400, or 24.7%, with more going out through the lists. That is why the sheet reserves a list's books from stock, so you do not promise them to a second parent when you do not have them.
- Copying and printing: income 10,952.50 and profit 7,137.15. Black-and-white pages were 4,573 and colour pages 626, yet colour brought about 30.6% of service income because a colour page costs more.
- School lists: 9 lists dated October, with 2,831 income from the delivered ones. Four lists are not yet delivered, one of them «late» past its date, and the balance still due on all lists is 2,665.
- Stock: worth 28,184.50 at cost. Three items are «اطلب» (reorder) and two are «عجز» (shortfall): the grade-six science book has a balance of 5 but 11 reserved, so 6 are missing and the suggestion is 15 × 2 + 6 = 36 copies costing 2,160. Ordering all shortages costs 6,615.
- Season: July income 5,312, August 53,958, September 90,385.50 (the peak) and October 34,667.50. In September alone lists brought 13,006 and copying 23,676.50.

## Common mistakes

- Forgetting to change a list to «delivered», so its items stay reserved and its income is not counted.
- Typing a list number in the lines sheet differently from the number in the lists sheet.
- Leaving the page cost empty, so copying profit looks equal to its income.
- Leaving an old buying price after a publisher raises a book's price. The purchases sheet flags it as «السعر يختلف عن القائمة» (price differs from the list).
- Buying after the season starts rather than before, so shortfalls show while lists wait.

## When to move to a system

The sheet suits a shop where one person records sales and copying. When several staff work at once, or you want a copier counter that logs pages by itself, or parents to write their own lists and pay the deposit from their phones, that is the job of a [custom Softwiro build](https://softwiro.com/contact) or a till system.

## Your next step

Download the sheet, type your first twenty items, log one school list with its items, and open the reorder sheet a month before the season. For general stock see the [general shop inventory sheet](https://softwiro.com/templates/general-inventory).

## FAQ

**What if I cancel a list whose owner paid a deposit?** Set its status to «ملغاة» (cancelled): it reserves nothing and counts no income. Record the refund outside the sheet.

**Do I log every customer who buys a pen?** No. Add up the day's sales of each item into one row.

**Does it work on a phone?** Yes, in Excel, Google Sheets and LibreOffice.

## 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: stationery shop and copying (1/3)](https://softwiro.com/uploads/cheatsheets/stationery-bookshop/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/stationery-bookshop/en-1.jpg)[![Cheat sheet: stationery shop and copying (2/3)](https://softwiro.com/uploads/cheatsheets/stationery-bookshop/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/stationery-bookshop/en-2.jpg)[![Cheat sheet: stationery shop and copying (3/3)](https://softwiro.com/uploads/cheatsheets/stationery-bookshop/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/stationery-bookshop/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 price copying by pages and copies?

In the photocopy log type the service, the pages of the original and the copies; total = pages × copies × page price − discount.

### How are a school list's items reserved?

While the list is «قيد التجهيز» (in preparation) or «جاهزة» (ready) its lines are reserved and reduce the available figure; once «تم التسليم» (delivered) they reduce the balance. A «ملغاة» (cancelled) list reserves nothing.

### What is the difference between balance and available?

Balance = opening + purchases − sales − delivered lines; available = balance − reserved for undelivered lists. The «reorder» and «shortfall» statuses use the available figure.

### How is a school list's balance due worked out?

Balance due = (sum of lines − discount) − (deposit + hand-over payment). An undelivered list past its date shows «late».

### How much does it hold?

300 items, 3,000 sales rows, 1,500 deliveries, 2,000 photocopy rows, 300 lists, 1,500 list lines and 20 services.

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