You run a small delivery company and at the end of the week every merchant asks "how much do you owe me?" while every courier asks "how much do I hand in and how much is my commission?" Answering from notebooks and WhatsApp means hours of adding. This free Excel sheet turns one shipment log into both answers, for whatever period you choose. (The template and its page are in Arabic.)
What the template gives you
- Start here. A short guide.
- Settings (الإعدادات). The start and end dates of the period. Shipments dated between them, inclusive, are counted.
- Zones (المناطق). For each zone: the delivery fee and the return fee charged to the merchant, and the courier's commission for a delivery and for a return.
- Merchants (التجار) and Couriers (المناديب). A code and a name for each.
- Shipments (الشحنات). Each shipment: date, number, merchant, courier, zone, cash to collect and status. The sheet works out its fee, the cash collected, what is due to the merchant and the courier's commission.
- Merchant settlement (تسوية التجار). Per merchant for the period: shipments, delivered, returned, collection, fees and net due.
- Courier account (حساب المناديب). Per courier: delivered, returned, the cash collected that he hands to the company, and his commission.
A walkthrough with the sample numbers
All figures are sample data. The period is 1 to 31 October 2026, and the zones are Cairo (delivery fee 40, return fee 20), Giza (45, 25), Alexandria (60, 30) and Delta (70, 35).
The rules are simple. A delivered shipment is charged the delivery fee and the merchant is owed the collection minus that fee. A returned shipment is charged the return fee and the merchant is owed minus that fee. Postponed and on-the-way shipments carry no fee and no commission.
| Merchant | Shipments | Collection | Fees | Net due to merchant |
|---|---|---|---|---|
| Al-Nil Fashion (T01) | 8 | 2,860 | 265 | 2,595 |
| Bayt Al-Anaqa (T02) | 6 | 1,450 | 180 | 1,270 |
| Al-Amal Store (T03) | 6 | 4,680 | 295 | 4,385 |
| Total | 20 | 8,990 | 740 | 8,250 |
Take Al-Amal Store. It has a delivered Alexandria shipment collecting 1,200 with a fee of 60, which leaves 1,140 for the merchant. Its returned Delta shipment collected nothing and costs a return fee of 35, so it contributes -35. Add the rest and the net is 4,385.
The sample also contains a shipment dated 28 September. It is not in the October settlement, because it falls outside the period. That is the point of the settings sheet: change the dates and every settlement changes with them.
On the courier side, Ahmed Salem (M01) has 4 delivered and 2 returned shipments in the period, collects 1,520 in cash that he hands to the company and earns 60 in commission.
Features and why they matter
- One log, two reports. Settlement and courier accounts both come from the same shipment list, so they always agree.
- Fees by zone. Change a zone's price once and every shipment in it follows.
- Any period. Weekly, fortnightly or monthly settlement is a change of two dates.
- Negative net shown in red. When return fees exceed the collection you see it immediately.
- Works in Excel 2016 and later, Google Sheets and LibreOffice, free, no sign-up.
Using the online version
The template page opens directly on a worked example with numbers. Edit the white (input) cells right in the page and the grey calculated cells update immediately. You can import your own .xlsx made from this template, export your work to .xlsx, or download the original Excel file. Your data stays in your browser and is not sent to the server, so export before you close the page.
Open the delivery company template page, or see the free templates list.
Common mistakes, and when a sheet stops being enough
- Writing a merchant, courier or zone name in the shipments sheet differently from how it is written in its own sheet. Write them exactly alike.
- Forgetting to update the status. Only the status moves a shipment from "no fee" to "fee".
- Changing the period and forgetting the settlement was already sent to a merchant for the earlier one.
The sheet takes 1,000 shipments. Its weak point is that someone must type every shipment and every collection. If merchants keep phoning to ask about their shipments, Wassalni is the Softwiro system for this: each merchant gets an app to create shipments and follow collections, and each courier updates the status from his own app. For the wider picture of running couriers and cash on delivery, read delivery management with your own couriers.
FAQ
Can I set a different fee per zone? Yes. Write each zone's delivery fee, return fee and courier commissions in the zones sheet; each shipment takes its zone's values.
Why does a shipment have no fee? Its status is postponed or on the way. Only delivered and returned shipments carry fees.
Can the merchant's net be negative? Yes, when the return fee is larger than the collection. It shows in red in the settlement.
Next step
Open the template page, write your zones and fees, and enter this week's shipments.