You need to hand a customer a proper invoice today, with the shop name, the items, the discount, the VAT and the total, and you do not want to rebuild a Word table or recalculate on a phone every time. This free Excel sheet is an invoice you fill in once per sale: choose the item, type the quantity, and everything else is calculated. (The template and its page are in Arabic.)
What the template gives you
- Start here. A short guide.
- Shop details (بيانات المحل). Name, address, phone, tax number, the tax rate and the currency. They appear in the invoice header.
- Items (الأصناف). Code, name and selling price before tax for each item (room for 300).
- Invoice (الفاتورة). The printable page: invoice number, date, customer, then lines where you pick the code and type the quantity. Each line can have a different price and its own discount percentage, and the whole invoice can have an extra discount. It ends with the subtotal, net before tax, VAT and the amount due.
- Invoice register (سجل الفواتير). One row per invoice with its net, tax and total, and monthly totals for the year.
A walkthrough with the sample numbers
The numbers are sample data from the template, with a 14% tax rate in the shop details.
| Item | Qty | Unit price | Special price | Discount | Line total |
|---|---|---|---|---|---|
| Cotton T-shirt | 3 | 220 | 660 | ||
| Jeans | 2 | 520 | 10% | 936 | |
| Leather belt | 1 | 150 | 130 | 130 | |
| Classic shirt | 2 | 450 | 900 |
- Subtotal: 2,626
- Extra discount on the invoice: 26
- Net before tax: 2,600
- VAT at 14%: 364
- Amount due: 2,964
Notice how the lines behave. The jeans: 2 x 520 = 1,040, less 10% gives 936. The belt: the list price is 150 but the "special price" column holds 130, so that line uses 130. The item list is the single source of prices; the special price is for the exception on that one line.
After printing or saving as PDF, you copy the invoice number, date, customer and net before tax into the register, as values. The register then computes the tax and total for each invoice and adds them by month. In the sample register, September holds three invoices with 5,230.5 net before tax and October holds three with 8,560.
Features and why they matter
- Item lookup. You do not retype names and prices, which removes a common source of mismatches between invoices.
- Line discount and invoice discount. Both are separate, so the sheet shows what each did.
- Print-ready. The invoice sheet is set to print on one A4 page without the banner.
- A register with monthly totals. At month end you know how much you sold and how much tax it carried.
- Works in Excel 2016 and later, Google Sheets and LibreOffice, free, no sign-up.
An important limit, stated plainly by the sheet itself: this is a simple invoice for printing or sending as PDF. It is not an electronic invoice sent to the Egyptian Tax Authority (ETA) or to ZATCA in Saudi Arabia. The VAT rate is a cell you write yourself; the sample uses 14%, the general rate in Egypt, and you can write 15 for Saudi Arabia. Check the current official rate in your own country before use. For what an e-invoicing system actually has to do in Egypt, read E-invoicing in Egypt.
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 closing the page.
Start from the sales invoice template page, or see the free templates list.
Common mistakes, and when a sheet stops being enough
- Typing the VAT rate as 0.14 instead of 14. Percentages are written as numbers: 5 means 5%.
- Typing over the formula cells in the invoice (the grey ones).
- Forgetting to copy the invoice into the register, so the monthly totals miss it.
- Pasting formulas instead of values into the register.
An invoice sheet records a sale but does not reduce stock. If you want every sale to deduct the quantity automatically and the invoice to go out electronically, Accsys does that: it deducts the quantity on every sale, works offline and syncs when the connection returns, and issues e-invoices compatible with the ETA system.
FAQ
Is this an electronic invoice for the tax authority? No. It is for printing or sending as PDF only.
Can I change the tax rate? Yes, in the shop details sheet. Write the rate as a number: 14 means 14%.
How do I give one customer a different price? Type the new price in the "special price" column on that line only. For a percentage, use the discount column.
Next step
Open the template page, replace the shop details and the eight sample items with yours, and issue your first invoice.