# Wholesale clothing trade sheet

> Wholesale clothing sheet: models by series, factory purchases, trader invoices, returns, consignment, trader accounts with aging, stock and profit.

Source: https://softwiro.com/templates/clothing-wholesale-trade
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Wholesale clothing trade sheet: traders, stock and collection

A free Excel sheet for a wholesale clothing dealer who sells to traders by the series (a fixed pack of sizes). You record your models with cost per piece, wholesale price and pieces per series, what you bought from factories, sales invoices to traders by number of series or by single piece, returns, and goods handed over on consignment, with what sold and what came back. The sheet works out stock for each model, each trader's account with payments, balance due, debt aging and credit limit, and the profit of each model and each trader, and it gathers everything in a summary with charts. It differs from the clothing shop stock sheet (by piece, colour and size) because it is built on wholesale selling and credit accounts with traders.

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

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

| الإجمالي |  |  |  |  | 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

1. 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.
2. 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.
3. In the "التجار" (Traders) sheet, enter each trader with their phone, city, credit limit and any opening balance they owe.
4. When goods arrive from the factory, enter in "المشتريات" (Purchases) the date, factory, code, number of pieces and cost per piece.
5. 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.
6. 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).
7. 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.

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

Excel file (.xlsx) · 383 KB · 11 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: wholesale clothing trade (1/3)](https://softwiro.com/uploads/cheatsheets/clothing-wholesale-trade/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/clothing-wholesale-trade/en-1.jpg)[![Cheat sheet: wholesale clothing trade (2/3)](https://softwiro.com/uploads/cheatsheets/clothing-wholesale-trade/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/clothing-wholesale-trade/en-2.jpg)[![Cheat sheet: wholesale clothing trade (3/3)](https://softwiro.com/uploads/cheatsheets/clothing-wholesale-trade/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/clothing-wholesale-trade/en-3.jpg)

0 downloads · 3 pages

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

[See Accountwiro](https://softwiro.com/systems/budoor.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

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

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