ZATCA VAT Tracker
An Excel workbook for a VAT-registered business: issue a simplified tax invoice, log sales and purchases, and it adds them up into the VAT return fields for the period you choose.
- Format
- One .xlsx file, no macros
- Sheets
- 6, each named in Arabic and English
- Ledgers
- 200 rows for sales, 200 for purchases
- Invoice
- Up to 10 lines per invoice
- Checks
- 35 automated tests on the file
Phase 1 QR only; not for Phase 2 e-invoicing. It does not connect to the Fatoora portal or send invoices to ZATCA.
Workbook preview
=G24-G25| الصف | بيانات البائع | القيمة |
|---|---|---|
| 4 | الاسم التجاري (عربي) | شركة المثال للتجارة |
| 5 | الاسم التجاري (إنجليزي) | Example Trading Co. |
| 6 | الرقم الضريبي (15 رقم) | 300000000000003 |
| 8 | العنوان — المدينة | الرياض / Riyadh |
| 10 | الرمز البريدي | 12244 |
| 12 | نسبة الضريبة الافتراضية | 15% |
| الصف | البند | البيان | الوعاء الضريبي | الضريبة |
|---|---|---|---|---|
| 8 | 1 | المبيعات الخاضعة للنسبة الأساسية | 1,000.00 | 150.00 |
| 9 | 2 | المبيعات للمواطنين | غير مدرج في هذا القالب | |
| 10 | 3+4 | المبيعات المحلية الخاضعة للضريبة الصفرية + الصادرات | 0.00 | 0.00 |
| 11 | 5 | المبيعات المعفاة | 0.00 | 0.00 |
| 12 | 6 | إجمالي المبيعات | 1,000.00 | 150.00 |
| 16 | 7 | المشتريات الخاضعة للنسبة الأساسية (القابلة للخصم فقط) | 0.00 | 0.00 |
| 21 | 12 | إجمالي المشتريات | 0.00 | 0.00 |
| 26 | صافي الضريبة المستحقة / (المسترد) | 150.00 | ||
| 27 | PAYABLE TO ZATCA | |||
What it does
-
A simplified tax invoice
Type the invoice number, date, time and lines, and the VAT and total work themselves out. The print area is set for A4 portrait.
Invoice
-
VAT by each row's category
Pick one per row: standard-rated at the Settings rate (15% preset), zero-rated, exempt, or out of scope. The last three carry no VAT, and out-of-scope rows stay out of the return.
Sales, Purchases
-
The return, field by field
Type the period's start and end dates and the fields fill from the ledgers: 1 to 6 for sales, 7 to 12 for purchases, then the net VAT and whether it is payable or a refund.
VAT Return
-
Only deductible input VAT
Mark each purchase invoice deductible or not. Field 7 and the dashboard count only the rows marked Yes.
Purchases
-
Undated rows do not vanish
A row with an amount but no real date stays out of every field, but the count of such rows shows at the top of the return and turns red above zero.
VAT Return
-
A QR with its five fields
Seller name, VAT number, date and time, total, and VAT. A Python script makes it on your own PC and sends nothing; an optional macro does it inside Excel for Windows.
generate_qr.py, ZATCA_QR.bas
Inside the file
- Settings الإعداداتSeller details and the default VAT rate
- Invoice الفاتورةA simplified tax invoice, ready to print
- Sales المبيعاتThe output VAT ledger, 200 rows
- Purchases المشترياتThe input VAT ledger, 200 rows
- VAT Return إقرار الضريبةReturn fields and net VAT for the period
- Dashboard لوحة التحكمFour indicators and two charts
Before you buy
- Phase 2
- No Fatoora connection, no cryptographic stamp, no XML, no UUID. Phase 2 needs a certified e-invoicing solution.
- Filing
- You file the return yourself on the ZATCA portal. The field numbers follow published guides to the return and have not been checked against the portal, so compare them with your form before filing.
- Fields it leaves
- Fill fields 2, 8 and 9 from your own records. Fields 3 and 4 share one line, so split out exports before filing. Corrections from earlier periods and VAT credit carried forward are not tracked.
- Invoice number
- You type it; there is no automatic numbering.
- QR code
- The workbook itself does not draw the code. The script needs Python on your PC; the macro needs the internet and, after asking you, sends the QR data to a free public web service.
- Software
- Microsoft Excel 2016 or later; Excel 365 shows Arabic best. Dates are Gregorian, day/month/year.
- Licence
- One user, for your own business or one client.
- Affiliation
- Not affiliated with or endorsed by ZATCA.