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
| الإجمالي | 1,113 | 191,370.00 | 265,096.00 | 67,696.00 | |||||
|---|---|---|---|---|---|---|---|---|---|
| الكود | اسم الموديل | الموسم | سعر الجملة للقطعة | قطع السيري | رصيد المخزن (قطع) | قيمة المخزن (تكلفة) | الإيراد | الربح | الحالة |
| SH-101 | قميص رجالي كلاسيك | صيفي | 235.00 | 6 | 278 | 50,040.00 | 44,970.00 | 10,410.00 | متوفر |
| JN-202 | بنطلون جينز رجالي | عام | 340.00 | 6 | 282 | 73,320.00 | 46,920.00 | 11,040.00 | متوفر |
| KD-303 | طقم أطفال قطن | صيفي | 165.00 | 8 | 284 | 34,080.00 | 25,740.00 | 6,540.00 | متوفر |
| DR-404 | فستان حريمي كاجوال | صيفي | 290.00 | 5 | 0 | 0.00 | 21,576.00 | 5,826.00 | نفد |
| JK-505 | جاكيت شتوي رجالي | شتوي | 560.00 | 4 | 12 | 5,040.00 | 31,360.00 | 7,840.00 | اطلب |
| PL-606 | بلوفر صوف حريمي | شتوي | 310.00 | 6 | 14 | 3,220.00 | 20,460.00 | 5,280.00 | اطلب |
| AB-707 | عباية خروج | عام | 450.00 | 5 | 11 | 3,630.00 | 40,050.00 | 10,680.00 | اطلب |
| TS-808 | تيشيرت بولو | صيفي | 135.00 | 12 | 232 | 22,040.00 | 34,020.00 | 10,080.00 | متوفر |
Example from the “الموديلات” tab (Arabic), with the numbers and formulas that are in the file.
What is inside
- الملخص: Purchases, sales, returns, consignment settlements, net sales, profit and margin, amounts due from traders and their aging, stock value, and a six-month table, with five charts.
- الإعدادات: Today's date, how many consignment days before a warning, the first month of the summary, and the list of seasons.
- الموديلات: Code, name, season, cost per piece, wholesale price, pieces per series and minimum level. It calculates the series price, purchases, sales, returns, consignment and stock in pieces and series and its value, what is with traders, revenue, cost, profit, margin and status. Holds 200 models.
- المشتريات: Date, factory, code, number of pieces and cost per piece. It calculates the purchase value and warns about an unregistered model. Holds 600 rows.
- المبيعات: One row per model on the invoice: trader, number of series, single pieces, discount and an optional price. It calculates the pieces, price, value, cost, profit and error warnings. Holds 1200 rows.
- المرتجعات: What came back from each trader in pieces, with the reason; its value and cost are calculated. Holds 300 rows.
- الأمانة: Goods handed to traders on consignment, with their date, what sold, what came back and the settlement date. It shows what remains with the trader, the days outstanding, the value sold and the status "مع التاجر" (with trader), "متأخرة" (late) or "تمت التسوية" (settled). Holds 300 rows.
- التحصيل: Every payment from a trader with receipt number, amount and payment method (cash, transfer, cheque or wallet), with a warning for an unregistered trader or a duplicate receipt. Holds 800 payments.
- التجار: Name, phone, city, credit limit and opening balance. It calculates sales invoices, consignment settlements, returns, net sales, amount paid, balance due, profit, debt aging (0-30, 31-60 and over 60 days), consignment held and status. Holds 200 traders.
The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.
What makes it different
The sheet ties stock and accounts together in one place: each sales invoice reduces stock and raises the trader's account at the same time, each payment reduces what they owe, and each return puts the pieces back in stock and lowers the debt. Consignment goods are kept separate from sales so they are not lost, and only what sold enters the account. In minutes you know who owes how much and since when, which model earns the most, and what to reorder from the factory.
How to use it
- In the "الإعدادات" (Settings) sheet, enter today's date, the number of consignment days before a warning, the first month of the summary and the season names.
- In the "الموديلات" (Models) sheet, record each model: code, name, season, cost per piece, wholesale price, pieces per series and minimum level. The series price and profit margin appear.
- In the "التجار" (Traders) sheet, enter each trader with their phone, city, credit limit and any opening balance they owe.
- When goods arrive from the factory, enter in "المشتريات" (Purchases) the date, factory, code, number of pieces and cost per piece.
- When you sell, enter in "المبيعات" (Sales) a row for each model on the invoice: trader, code, number of series, any single pieces and an optional discount. Pieces, price, value and profit are calculated.
- Record what a trader returns in "المرتجعات" (Returns), goods handed over on consignment in "الأمانة" (Consignment) with what sold and what came back, and every payment in "التحصيل" (Collection).
- Open "التجار" (Traders) to see each trader's balance, debt aging and status, "الموديلات" (Models) to see stock and profit, and "الملخص" (Summary) for the numbers and charts.
Before you start:
- A series is a fixed number of pieces in different sizes (for example 6 pieces). You enter the number of series and any single pieces, and the sheet converts them to pieces.
- Stock = purchases - invoice sales + returns - consignment handed out + consignment returned. What sold from consignment enters the trader's account when you record the settlement.
- Consignment does not enter the trader's account or the profit except what is recorded in the "المباع" (Sold) column with a settlement date, at the model's current wholesale price.
- Profit = sales value - (pieces × cost per piece in the Models sheet). Update the cost when the factory price changes, because the change applies to all sales.
- A return is valued at the model's current wholesale price unless you enter a price in the price column. Debt aging assumes payments settle the oldest debt first.
- Write the code and the trader's name in exactly the same way in every sheet. The drop-down lists prevent spelling differences, and the red cells in the warning column alert you.
- The sheet holds 200 models, 600 purchase rows, 1200 sales rows, 300 returns, 300 consignment rows, 800 payments and 200 traders.
- The numbers and names in the sheet are made-up examples. Anything to do with official invoices and taxes follows local law.
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.
Still running this on Excel?
This sheet needs someone to copy every invoice and payment into it. In Accountwiro an invoice and a payment are recorded the moment they happen, and the customer's balance shows in a single statement of account.
| In this sheet | In Accountwiro |
|---|---|
| You copy every invoice and payment into the sheet by hand. | It shows the customer's invoices, payments and outstanding balance in a single statement of account. |
| Invoices are typed or copied by hand. | It creates an invoice by scanning a barcode or searching by product name, calculates discounts and taxes, and sends it to the customer over WhatsApp. |
| Stock shortages are discovered late. | It updates quantities after every sale and alerts you when a product drops below the required level. |
| Anyone who opens the sheet sees every number. | Permissions per user: the sales employee issues invoices, and the warehouse employee manages stock without access to financial data. |
Frequently asked questions
What is the difference between this sheet and the clothing shop stock sheet?
The clothing shop stock sheet is for retail selling to customers by piece, colour and size. This sheet is for wholesale: series, trader invoices, consignment, each trader's account and debt aging. If you sell to the public, the first is a better fit; if you sell to retail traders, this one is.
How do I record a sale by the series?
In the "الموديلات" (Models) sheet, enter the pieces per series for each model, then in "المبيعات" (Sales) enter the number of series and any single pieces. The sheet calculates pieces = series × pieces per series + single pieces, then value = pieces × price per piece after discount.
How does consignment goods work?
Record in "الأمانة" (Consignment) what you handed to the trader. The pieces leave your stock and show as "عند التجار" (with traders). When the trader sells and settles with you, enter the quantity sold and the settlement date, and its price enters their account. Enter what came back in the returned column and it goes back into stock.
How is debt aging calculated?
The sheet assumes payments settle the oldest debt first, so it spreads the balance due over the newer periods first and then the older ones, and counts the opening balance written in "التجار" (Traders) under "over 60 days". Enter today's date in "الإعدادات" (Settings) so the ages are right.
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, 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
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
- Electronics shop sheet: serials, warranty and repairs
- Food wholesale and distribution sheet in Excel: routes, expiry and collection
- 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
- Small hospital management sheet: departments, beds, admissions and revenue





