Search
Generic filters

Bilingual Saudi VAT Invoice Excel Template

It is mandatory in Saudi VAT Law that the Tax invoices issued by business entities in Saudi should issue Bilingual Saudi VAT Invoice. Bilingual express two languages.

According to Article 53, Clause No.5 of Implementing Regulations under Saudi VAT Law:

“A Bilingual Saudi VAT Invoice must include the details in Arabic, in addition to other language also shown in the Tax Invoice as a translation.”

Arabic is national language of Saudi. Thus the bilingual Saudi VAT Invoice must contain Arabic along with any other language.

Article 53 Clause No. 5 describes the contents of Saudi VAT Invoice.

Keeping in mind the guidelines, we have created an excel template for Bilingual Saudi VAT Invoice with predefine formulas.

The user just needs to add his details to supplier’s details section and start using it.

Contents of Bilingual Saudi VAT Invoice Template

Bilingual Saudi VAT Template contains 2 worksheets which are as below:

  1. Bilingual Saudi VAT Invoice
  2. Customer Details Sheet.

All details in given template are in Arabic and English language.

Customer Details sheet consists of details relate to the customer like customer name, customer address, Customer VAT number, and contact details.

The purpose of this sheet is to minimize the manual entry in the invoice. However, this sheet is link to the invoice template using the Data Validation and VLOOKUP Function.

1. Supplier Details

In the header section, supplier detail like supplier’s company name, address, contact details, emails, vat number and type of invoice “Tax Invoice”

However you can see all details provided in this section are mandatory to display by law.

2. Customer Details

This section is pre-program with data validation and VLOOKUP. The user needs to select the customer name from the drop-down list. It will automatically show other respective details the customer from the customer sheet.

3. Product Details

Product detail consists of following:

Description – Details of goods or services or both.

Quantity – Quantity of goods or services.

Unit Price – Price per unit of goods or services.

Taxable Value – Taxable value is value on which the tax is calculated.

Taxable Value = Quantity X Unit Price

VAT % – Percentage of VAT applicable to the goods or services. Usually, it will be either 0% in case of zero-rated supply or 5% in case of taxable supply.

VAT – Also, VAT amount is calculated using the following formula.

VAT Amount = Taxable Value X VAT Percentage

Total – Therefore, Line total of each item.

Total = Taxable Value + VAT Amount

Columnar totals of each line are given below which displays the total of taxable value of complete invoice, Total of VAT Amount collect against invoice and also the Final total of Invoice.

4. Other Miscellaneous Details

Other details include the following details of invoice:

Amount in Words
Terms and conditions
Prepare By
Approve By
Company Seal
Business Greeting

So, Everything in the invoice is bilingual except numbers. The numbers can be changed to the Arabic language by changing the regional settings in the control panel.

However, You can use the cell locking feature in excel to save you from deleting the important formulas.

Download Bilingual Saudi VAT Invoice Excel Template
Share on facebook
Share on linkedin
Share on email
Share on whatsapp

Download Guide

Compatible with : Microsoft Office Excel, Libra Office, WPS Office, Google WorkSheet
  • Download The Template XLSX File Format
  • Use the Template

Download Instruction :

All Excel templates and tools are sole property of xlsxtemplates.com. User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from PPTXTemplates.com  Completely Free. All our templates are designed by Professionals

Recently Uploaded Excel Templates: