# Stationery shop and photocopy management sheet

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

Source: https://softwiro.com/templates/stationery-bookshop
Language: English
Softwiro, softwiro.com

---

Free Excel template

A free Excel sheet for a shop selling school supplies, outside books and photocopy services. List your items with purchase price, selling price and minimum stock, then log deliveries and sales, and the sheet works out each item's balance and profit. Log photocopying and printing by page and by number of copies (black-and-white or colour) and it calculates revenue, cost and profit. Enter school lists with their deposit and items: the items are reserved from stock until delivery, and the amount still owed shows on each list. At the end you get a reorder list with quantities and cost, and a season sheet that charts revenue for each month of the year.

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

Excel file (.xlsx) · 778 KB · 13 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

| الكود | اسم الصنف | الفئة | سعر الشراء | سعر البيع | الرصيد | المتاح | الحالة |
| --- | --- | --- | --- | --- | --- | --- | --- |
| D01 | كراسة سلك 60 ورقة | دفاتر وكراسات | 12.00 | 16.00 | 211 | 207 | متوفر |
| D02 | كراسة 80 ورقة | دفاتر وكراسات | 15.00 | 20.00 | 170 | 146 | متوفر |
| D03 | دفتر رسم A4 | دفاتر وكراسات | 18.00 | 25.00 | 22 | 8 | اطلب |
| A01 | قلم جاف أزرق | أدوات كتابة | 2.50 | 4.00 | 460 | 450 | متوفر |
| A02 | قلم رصاص HB | أدوات كتابة | 1.50 | 3.00 | 351 | 343 | متوفر |
| A03 | قلم تحديد فسفوري | أدوات كتابة | 8.00 | 12.00 | 0 | -3 | عجز |
| A04 | مسطرة 30 سم | أدوات مدرسية | 5.00 | 8.00 | 94 | 91 | متوفر |
| A05 | علبة أدوات هندسية | أدوات مدرسية | 35.00 | 50.00 | 12 | 7 | اطلب |
| A06 | مقلمة | أدوات مدرسية | 25.00 | 38.00 | 55 | 51 | متوفر |
| A07 | ألوان خشبية 24 لون | أدوات مدرسية | 45.00 | 65.00 | 59 | 54 | متوفر |

Example from the “الأصناف” tab (Arabic), with the numbers and formulas that are in the file.

## What is inside

- "الإعدادات" (Settings): Today's date, any date inside the month you want summarised (the season year is taken from it), the multiplier for the minimum order quantity, the list of item categories, and the list of suppliers and publishers.
- "الأصناف" (Items): Code, name, category, unit, purchase price, selling price, minimum stock, opening balance and supplier. The sheet calculates purchases, sales, delivered list items, balance, quantity reserved for lists, available quantity, stock value, profit margin, status (in stock, reorder, out of stock, shortfall or negative balance) and the suggested order quantity. Room for 300 items.
- "المشتريات" (Purchases): One row per delivery from a supplier: date, code, quantity, purchase price and supplier. The item name and total appear automatically, with a warning if the price differs from the price list. Room for 1,500 deliveries.
- "المبيعات" (Sales): One row per sale (combine an item's sales for the day): date, code, quantity and an optional custom price. The name, total, profit and category appear automatically. Room for 3,000 rows.
- "الخدمات" (Services): Price list for photocopying and printing: the service, its type (black-and-white, colour, or lamination and binding), price per page and cost per page, with the month's units, revenue and profit beside each. Room for 20 services.
- "سجل التصوير" (Copy log): One row per job: date, service, number of pages, number of copies and discount. The sheet calculates total units, revenue, cost and profit. Room for 2,000 rows.
- "قوائم المدارس" (School lists): One row per list: number, date, parent, school, grade, delivery date, discount, deposit, payment on delivery and status. It shows the items total, net amount, amount paid, balance due, profit and a "late" warning. Room for 300 lists.
- "بنود القوائم" (List items): The items of each list, entered under the list number: code and quantity. Price, total, cost and the list's status appear automatically. Items are reserved from stock until delivery. Room for 1,500 items.
- "إعادة الطلب" (Reorder): Items that have run out or fallen below their minimum, sorted by suggested quantity, with the order cost and the supplier. It shows the first 50 items.
- "الموسم" (Season): The twelve months of the summary year: revenue from shop sales, photocopying and delivered lists, the total, purchases, profit on sales, and the peak month.
- "الملخص" (Summary): The month's sales and profit, photocopy revenue and pages (black-and-white and colour), school lists with the overdue amount and balance owed, stock and shortages, a category table, and three charts including the season curve.

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

## What makes it different

School lists reserve their items from stock before delivery, so a "shortfall" shows up before you promise a parent something you do not have. Photocopying is priced by the page, with black-and-white kept apart from colour. The season curve shows when your peak is, so you can buy ahead of it.

## How to use it

1. In "الإعدادات" (Settings) enter today's date and any date inside the month you want summarised (the season year is taken from it), and review the item categories and the list of suppliers and publishers.
2. In "الأصناف" (Items) enter, for each item: code, name, category, unit, purchase price, selling price, minimum stock, opening balance and supplier.
3. In "الخدمات" (Services) enter each photocopy or print service with its price per page, cost per page and type (black-and-white, colour, or lamination and binding).
4. Log deliveries in "المشتريات" (Purchases) and sales in "المبيعات" (Sales), combining an item's sales for the day in one row. Log photocopying and printing in "سجل التصوير" (Copy log).
5. For each school list, add a row in "قوائم المدارس" (School lists) with the parent, school, grade, delivery date and deposit, then its items in "بنود القوائم" (List items) under the list number. Items are reserved from stock until delivery.
6. When a list is delivered, change its status to "تم التسليم" (delivered) and record what was paid. Check "إعادة الطلب" (Reorder) for what to buy before the season, and "الموسم" (Season) and "الملخص" (Summary) to compare months.

**Before you start:**

- Item balance = opening balance + purchases − sales − delivered list items. Available = balance − what is reserved for lists not yet delivered (in preparation or ready).
- Status is calculated on the available quantity: "shortfall" if more is reserved than you have, "out of stock" if none is left, "reorder" if it has fallen below the minimum, and "negative balance" if you have sold more than you recorded.
- Photocopy service total = pages × copies × price per page − discount. Leave "copies" empty for a single copy. Service profit = total − pages × cost per page.
- School list: net = items total − discount, and balance due = net − (deposit + payment on delivery). A "cancelled" list is left out of revenue and reserves no items. A refunded deposit is recorded outside the sheet.
- List revenue in "الموسم" (Season) and "الملخص" (Summary) is counted for lists marked "delivered", by the list date. "Late" appears on a list that has not been delivered and whose delivery date has passed today's date.
- Profit on a sale = total − quantity × purchase price in "الأصناف" (Items). The sheet has room for 300 items, 1,500 deliveries, 3,000 sales rows, 2,000 photocopy rows, 300 lists and 1,500 list items, and "إعادة الطلب" (Reorder) shows the first 50 items.

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

Excel file (.xlsx) · 778 KB · 13 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: 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

## Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

| In this sheet | In Custom Software from Softwiro |
| --- | --- |
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |

[See Custom Software from Softwiro](https://softwiro.com/contact) · [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 calculate the photocopy price by pages and copies?

In "سجل التصوير" (Copy log) enter the service, the number of pages in the original and the number of copies (leave it empty for one copy). Total = pages × copies × price per page − discount, and profit = total − pages × cost per page.

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

Enter the list's items in "بنود القوائم" (List items) under its number. While the list's status is "قيد التجهيز" (in preparation) or "جاهزة" (ready), its items are "reserved" and come off the available quantity, not the balance. Once it becomes "تم التسليم" (delivered), they come off the balance. A list marked "ملغاة" (cancelled) reserves nothing.

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

Balance = opening balance + purchases − sales − delivered list items. Available = balance − quantity reserved for lists not yet delivered. The "reorder" and "shortfall" statuses are calculated on the available quantity.

### How does the sheet calculate what is still owed on a school list?

Net = items total − discount, paid = deposit + payment on delivery, and balance due = net − paid. "Late" appears on a list that has not been delivered and whose delivery date has passed today's date.

### 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
- Electronics shop sheet: serials, warranty and repairs
- 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)
