Qoyod
Pricing

VAT Return Template: Saudi Tax Filing Guide with Free Excel

نموذج جاهز قابل للتعديل — حمّله مجانًا واستخدمه في عملك مباشرة.

A free, editable template — download and use it directly in your business.

A tax return is not an administrative document you file and forget. It is a formal declaration in which your business pledges to the Zakat, Tax and Customs Authority (ZATCA) that your numbers are accurate, that your due tax has been calculated correctly, and that you are ready to be audited at any time. Errors in a return are not resolved with an apology. They trigger penalties starting at 5% and climbing to 50% of the undeclared tax, and in some cases, criminal liability.

This practical guide walks you through what a tax return is and the four types used in Saudi Arabia, every box on the VAT return form, the calculation formula, filing deadlines, the full penalty matrix, a complete numeric example with realistic SAR figures, the details of the Fatoora platform and e-invoicing Phase 2, the mistakes that owners make most often, and finally how Qoyod turns this complex cycle into a fully automated monthly or quarterly process.

Free Download

Get a ready-to-use VAT Return template in Excel

A template pre-built with fields for 15% taxable sales, zero-rated sales, exports, and exempt supplies, input VAT boxes, automatic calculation of net VAT due or refundable, and layouts ready to upload directly to the Fatoora platform run by the Zakat, Tax and Customs Authority.

Run it directly inside Qoyod

What is a tax return, and why is it mandatory?

A tax return is a legal document in which the taxpayer (a company, sole proprietorship, or individual carrying out commercial activity) declares the total taxable transactions during a specific period. Based on that declaration, the amount of tax due for payment or refund from the authority is calculated. In Saudi Arabia, the Zakat, Tax and Customs Authority oversees every type of return and receives them exclusively through its online portal.

The core principle: tax in Saudi Arabia is based on self-assessment. The authority does not calculate the tax on the business’s behalf. It requires the business to compute its own tax and submit the return, while reserving the right to inspect and audit later. This model places full responsibility on the taxpayer and makes accurate daily transaction recording non-negotiable.

A return filed on time, with full payment of the amount due, closes the tax period in the business’s record. A late return, or one amended later because of errors, opens a file that remains reviewable for five years. This is where the value of an accounting system that generates the return automatically from daily transactions becomes obvious, instead of compiling data manually at the end of every period.

Types of tax returns in Saudi Arabia

A Saudi business may be subject to one or several types of returns, depending on the nature of its activity, size, and ownership (fully Saudi, GCC, or foreign). The four main types are:

1. Value Added Tax Return (VAT Return)

The most common return. Any business whose annual taxable sales exceed 375,000 SAR (mandatory registration) or 187,500 SAR (voluntary registration) must file it. The standard rate is 15%, applied to most domestic goods and services, with a zero rate for exports and qualifying GCC inter-state supplies, plus a defined list of exemptions (residential rent, core financial services). For deeper coverage of VAT rates and scenarios, see the guide on how to calculate VAT.

2. Withholding Tax Return (WHT)

Withheld from payments a Saudi business sends to a non-resident party (a foreign company, or a foreign individual outside the Kingdom). Rates range from 5% to 20% depending on the type of payment: 5% on management service fees and rent, 15% on royalties and intellectual property rights, 20% on certain technical consulting and management cases. The return is filed monthly within 10 days of the end of the month in which the payment occurred, and any delay triggers steep penalties.

3. Income Tax on Foreign Entities

Levied on companies wholly or partially owned by non-Saudi and non-GCC investors, at a rate of 20% on annual net income. Fully Saudi and GCC companies are not subject to income tax, but to Zakat. Mixed companies (Saudi-foreign partnership) are subject to Zakat on the Saudi/GCC partner’s share and income tax on the foreign partner’s share. The return is annual, filed within 120 days from the end of the fiscal year.

4. Zakat

Calculated at 2.5% on the business’s Zakat base (roughly equity distributed across its components after statutory adjustments). It covers fully Saudi and GCC companies, and the Saudi/GCC shares in mixed companies. The return is annual, filed within 120 days from the end of the fiscal year. For deeper coverage, see the Zakat calculation guide.

A single commercial business may find itself required to file three returns in one year: a quarterly VAT return, a monthly WHT return for any payment to a foreign supplier, and an annual Zakat return. That is before counting customs returns and excise tax returns if the activity covers those areas.

Tax rates on the return

The four rates that appear on every Saudi VAT return

15%
Standard rate on taxable domestic sales
0%
For exports and qualifying GCC inter-state supplies
Exempt
Residential rent and core financial services
Out of scope
Transactions never subject to VAT (salaries, dividends)
Each rate is recorded in its own box on the return form. Rates may not be combined into a single box.

Periodic returns: monthly or quarterly?

When a business registers for VAT, the authority sets the filing frequency based on annual sales volume:

  • Annual taxable sales above 40 million SAR: the return is monthly. It is filed by the last day of the month following the return period. Example: the January return is due by the end of February at the latest.
  • Annual taxable sales of 40 million SAR or less: the return is quarterly. The calendar year is split into four periods: January to March, April to June, July to September, and October to December. The return is filed by the last day of the month following the end of the quarter.

A business may request a change in filing frequency if eligible, but the change is not granted automatically. A monthly cycle is often better for businesses that record high input VAT (they buy more than they sell each month), because they recover their cash faster instead of waiting for quarter end.

A return filed after the deadline is considered late even if submitted just one hour after the final day. The system does not accept apologies. Therefore, businesses are advised to close their books five days before the deadline, review the return three days before, and submit two days before, leaving room for any emergency.

Components of the VAT return form

The VAT return form approved by ZATCA contains boxes that must be filled in accurately. Each box has a specific accounting meaning, and mixing them produces an incorrect return. The main boxes are:

Output section (Sales / Output)

  • Domestic sales taxable at 15%: the total value of sales inside the Kingdom before tax, along with the tax calculated on them.
  • Zero-rated sales: exports outside the Kingdom, supplies to qualifying GCC states, and supplies in specific sectors (designated medicines and medical products, investment gold services). The value is recorded, the tax is zero, but they are not omitted from the return.
  • Exempt sales: residential property rent, core financial services as defined by the regulations. No tax applies, but they are recorded in a separate box.
  • Exports: goods actually exported through Saudi customs to outside the Kingdom. Calculated at zero rate, but official customs export documents must be on file to prove the goods left the country.

Input section (Purchases / Input)

  • Domestic purchases taxable at 15%: total value of domestic purchases and the tax paid on them.
  • Imports: goods imported from outside the Kingdom, recorded at customs value with the tax paid at customs upon release.
  • Inputs subject to correction: adjustments to prior returns, or invoices not recorded in the correct period.

Tax due section

Here the system calculates automatically: output tax minus input tax equals net tax due. A positive result means an amount payable to the authority. A negative result means a credit balance the business may claim as a refund or carry forward to the next return period.

To understand the accounting entry behind these numbers, it helps to review the golden rule of debit and credit and the accounting period closing guide, so it becomes clear how the period ledger is closed before generating the return.

Final return formula

From output VAT to net VAT due

Output VAT
Output VAT
15% x taxable sales
Input VAT
Input VAT
VAT on eligible purchases
=
Net VAT
Net VAT
Due for payment or refundable
If the result is positive, it is paid to the authority. If negative, a refund is requested or carried forward to the next period.

The final return formula in detail

The central formula is simple to state and complex to apply:

Net VAT = total output VAT minus total deductible input VAT

Output VAT is the tax the business collected from its customers on sales invoices. Input VAT is the tax the business paid to its suppliers on purchase invoices. The difference represents the net amount due to the authority (or owed by the authority, if negative).

Not every input VAT is deductible, however. Conditions for legal deduction:

  • Valid tax invoice: the invoice meets the mandatory elements (invoice number, date, tax registration number of both parties, description of the good or service, tax amount shown separately).
  • Used in taxable activity: purchases tied to personal use by the owner or employees are not deductible.
  • Not on the blocked list: passenger vehicles for personal use, entertainment services, and hospitality are excluded by law.
  • Within the eligible period: the invoice must be issued during the relevant tax period, or within the late-deduction window allowed.

Breaching any condition converts input VAT into an unrecoverable expense, effectively costing the business an extra 15% on the purchase with no refund.

Filing and payment deadlines

The general standard: the return is filed and the amount due paid within one full month of the end of the tax period. The specifics by frequency:

  • Monthly return: the last date for filing and payment is the last day of the following month. Example: the January return is filed and paid by 28 or 29 February (depending on whether it is a leap year).
  • Quarterly return: the last date is the last day of the month following the quarter. Example: the January to March quarter is filed and paid by 30 April.
  • Zakat and income tax return (annual): within 120 days of the fiscal year-end. For a business whose year ends on 31 December, the last date is 30 April of the following year.
  • Withholding tax return: within 10 days of the end of the month in which the payment to the non-resident occurred.

Treat the deadline as sacred. The electronic system closes at midnight sharp, and any attempt to file in the first minute of the following day counts as a full delay.

Penalties and sanctions

The penalty system at ZATCA is tiered, starting mild and escalating quickly based on the type and frequency of the violation:

Late filing and late payment penalties

  • Late return filing: 5% to 25% of the tax due, graduated by length of delay.
  • Late tax payment: 5% of unpaid tax for each month of delay or part thereof.

Substantive error penalties

  • Filing an incorrect return: 50% of the gap between the tax declared in the wrong return and the true tax.
  • Exceeding the mandatory registration threshold without registering: a baseline 10,000 SAR penalty plus tax assessment over the entire unregistered period.
  • Issuing a tax invoice that fails e-invoicing rules: starts at 5,000 SAR per violation, escalating on repeat.

Voluntary disclosure

The authority encourages voluntary disclosure of errors before they are discovered in an audit. If the business finds a mistake in a prior return, notifies the authority, and amends voluntarily, the incorrect-return penalty is reduced to a much lower rate, or waived entirely in some cases. This makes periodic review of filed returns a smart prevention policy.

Practical example: a trading company in Riyadh

A trading company in Riyadh, with annual sales of 6 million SAR, distributes consumer electronics to the local commercial sector and exports to GCC countries. It is registered for VAT under quarterly filing. Let us calculate the Q2 return (April to June):

Sales data (output)

  • Domestic sales taxable at 15%: 1,200,000 SAR, output VAT: 180,000 SAR
  • Exports to the UAE and Kuwait (zero rate): 300,000 SAR, output VAT: 0 SAR
  • Total sales for the period: 1,500,000 SAR
  • Total output VAT: 180,000 SAR

Purchase data (input)

  • Domestic purchases of goods for resale: 800,000 SAR, input VAT: 120,000 SAR
  • Imports from China (cleared through customs): 200,000 SAR, input VAT paid at customs: 30,000 SAR
  • Taxable operating expenses (rent, services, telecom): 120,000 SAR, input VAT: 18,000 SAR
  • Purchase of a personal passenger vehicle for the manager: 180,000 SAR, input VAT: 27,000 SAR, not deductible (blocked)
  • Total deductible input VAT: 120,000 + 30,000 + 18,000 = 168,000 SAR

Net return calculation

Net VAT due = 180,000 minus 168,000 = 12,000 SAR, paid to the authority by end of July.

Notice how, if the business had wrongly included the manager’s vehicle VAT (27,000 SAR) among inputs, the return would show net tax of 180,000 minus 195,000 = -15,000 SAR, a fictitious credit balance. When the error is found in an audit, the correct tax is reassessed, a 50% penalty is added on the gap (27,000 x 50% = 13,500 SAR), then a late-payment penalty for each month from the original filing date. One mistake cost the business roughly 20,000 SAR in extra liability.

The Fatoora platform and e-invoicing (Phase 2)

Since December 2021, e-invoicing has been mandatory for every business registered for VAT. Phase 1 (Generation) required issuing invoices in electronic format with a QR code. Phase 2 (Integration), rolled out in waves since January 2023, requires direct integration between the business’s system and the Fatoora platform operated by the authority.

How does Phase 2 work in practice?

When a tax invoice is issued in a certified accounting system, the following steps run in the background within seconds:

  1. The accounting system creates the invoice in standard XML format per ZATCA specifications.
  2. It generates a digital signature with a certified certificate.
  3. It sends the invoice to the Fatoora platform for validation and stamping.
  4. The invoice returns from ZATCA with a cryptographic stamp and an updated QR code.
  5. The validated invoice is delivered to the customer, and a signed copy is stored in the system.

Any invoice that did not go through this cycle is not considered valid, and the customer cannot deduct its VAT as input on their return. This makes choosing a ZATCA-certified accounting system a basic requirement, not an option. For deeper coverage of invoice requirements, see the e-invoicing guide for Saudi Arabia.

Rollout waves

The Zakat, Tax and Customs Authority has announced Phase 2 rollouts in waves based on annual sales volume. Each wave is given six months from the announcement date before integration becomes mandatory. A business entering Phase 2 must connect its system to Fatoora before the deadline. Otherwise, its invoices become invalid and the paper-invoice gateway is closed.

Common mistakes in preparing the return

The mistakes that businesses, even large ones, keep making:

  • Forgetting VAT on exports: exports are zero-rated, but they must be recorded in the zero-rated sales box on the return. Leaving them out understates the declared total sales and may be treated as concealment.
  • Deducting ineligible input VAT: personal invoices, passenger vehicles, hospitality, entertainment. All of these are tax actually paid by the business, but legally not deductible.
  • Relying on invoices that lack the mandatory format: an invoice missing the supplier’s tax number, or with the tax not shown separately, or without a QR code, does not grant a deduction right.
  • Mixing pre and post VAT revenue: entering the gross invoice total (VAT inclusive) instead of the net value inflates the taxable sales box and doubles the declared tax.
  • Postponing book reconciliation to the last day: a race against the deadline produces human errors. Periodic ledger closing inside the accounting program a week ahead prevents panic.
  • Failing to settle return invoices: when goods are returned, a credit note must be issued in e-invoice format, and the value deducted from sales on the return. Ignoring this inflates output VAT.
  • Neglecting the withholding tax return: any monthly payment to a foreign supplier requires a separate WHT return. Many businesses discover this obligation late, with penalties accumulated over months.

These errors overlap with general accounting errors, and are addressed by an integrated stack of practices from bookkeeping for small businesses to regular monthly reconciliation.

How Qoyod automates tax return preparation

Preparing the return manually in Excel from monthly ledgers is a traditional approach no longer viable under Phase 2 and mandatory ZATCA integration. The Qoyod accounting platform is built to turn the return cycle from a heavy monthly process into a task that takes minutes:

  • Official ZATCA integration: Qoyod is certified by the Zakat, Tax and Customs Authority for Phase 2. Every invoice issued inside Qoyod is sent instantly to the Fatoora platform, cryptographically stamped, and returned in its validated form ready for the customer.
  • Automatic classification of every transaction: when an invoice or journal entry is created, the rate is set automatically (15%, zero, exempt, out of scope) based on account, customer, or item settings. No need to specify the rate manually each time.
  • VAT report ready for the return: at any moment, the system generates a detailed report with total output and input VAT for each period, broken down into the exact boxes required by the filing portal. Numbers transfer directly with no manual computation.
  • Deadline alerts: the system notifies five days before the end of the deadline that the return is ready to submit, and shows open accounting gaps (unapproved invoices, unposted entries) before the books close.
  • Five-year retention of signed invoices: the ZATCA-stamped e-invoice is retained in full (XML plus digital signature) for at least five years, the statutory audit limitation period.

When tax is paid, the system generates an automatic accounting entry: VAT payable debited, bank credited. On refund, the entry is reversed. This eliminates the need to rewrite return entries manually, and closes the cycle in one step.

In addition, Qoyod integrates with other compliance cycles: budget preparation, payroll and social insurance calculations, and accounts receivable and payable tracking.

Pre-submission checklist

Before you hit “submit” on the ZATCA portal, run this checklist. Any incomplete item, reopen the return:

  • All sales invoices for the period are recorded and validated by the Fatoora platform (no pending invoices).
  • All return invoices and debit/credit notes are signed and recorded.
  • All purchase invoices have a supplier tax number, VAT shown separately, and a date within the period.
  • Customs imports are recorded at correct customs value (CIF) with the release certificate.
  • Exports have official customs export documents on file.
  • Blocked purchases (passenger vehicles, hospitality) are excluded from input VAT.
  • Bank reconciliations for operating accounts are completed and match revenue in the books.
  • Numbers generated from the VAT report match the trial balance prior to closing.
  • The payable amount is ready in the bank account, or the refund request is attached with documentation if the return is negative.

Frequently asked questions about tax returns

Can I file a nil return if I had no sales during the period?

Yes, and it is required. Even if no sales or purchases were recorded during the period, the business must file a nil return within the deadline. Skipping the return, even a nil one, triggers a late-filing penalty.

What is the difference between amending the return and a corrective return?

Immediate amendment is possible within 30 days of the original filing date, free of charge. After that, it becomes a “corrective disclosure” subject to authority review, and may result in the incorrect-return penalty at a reduced rate (voluntary disclosure) or in full (discovered in audit).

How do I change my filing frequency from quarterly to monthly?

Through the ZATCA online portal, submit a request to change filing frequency with a stated reason. The request is reviewed by the authority and approved based on defined criteria. It is commonly accepted for businesses requesting the change to accelerate recovery of excess inputs.

Do I need a chartered accountant to file the return?

There is no legal requirement for an external chartered accountant to file a VAT return, but one is required for the annual Zakat and income tax returns for businesses exceeding certain revenue thresholds. For VAT returns, an in-house accountant or a certified accounting system is sufficient.

When am I entitled to request a tax refund instead of carrying it forward?

If the credit balance (refundable tax) exceeds 5,000 SAR, the business may request a cash refund instead of carrying it forward. The request is filed with the return, supporting documents proving input eligibility are attached, and the authority reviews the request within 60 days.

What do I do if I am one day late filing the return?

File the return and pay the tax immediately. The penalty is calculated automatically on late filing and added to the amount due. The faster you file, the lower the cumulative monthly penalty. Do not wait another month.

Start preparing your next return today

A tax return does not start on the last day of the month. It starts with the first invoice you issue in the period. Download the attached template, apply it to your current month or quarter, then connect your accounting system to Qoyod so every future return becomes a single button click. The difference between a business that spends a week each month on the return, and one that wraps it up in ten minutes, is the difference of an integrated, ZATCA-certified system.

Fill in your information to download the template.

من النموذج إلى الدفاتر بدون عناء

قيود يسجّل ويصنّف ويُطابق العمليات في دفاترك تلقائيًا

جرّب قيود مجانًا لمدة 14 يومًا — بدون بطاقة ائتمان.

From template to ledger — effortless

Qoyod automatically records, classifies, and reconciles your transactions.

Try Qoyod free for 14 days — no credit card required.