Download Bilingual Saudi VAT Invoice Excel Template

Contents

Popular Categories in Excel Template
Trednding in Excel Template

Employee Productivity Calculator

Employee Productivity Calculator is an excel template which helps you calculate employee productivity for manufacturing, …

Read More

Traditional VS Roth IRA

If you are considering contributing to a Traditional Vs Roth IRA , you may have …

Read More

School Report Card And Marksheet

School Report Card and Marksheet template in Excel simplifies the tedious task of preparing the …

Read More

Fuel Consumption Calculator

The fuel consumption calculator is an excel template to calculate average cost and mileage per …

Read More
Search
Generic filters

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

To use this free Excel Template, you should have Microsoft Office/ Microsoft Excel. You can only use this template if you have these applications in your system. or Use, Google Sheets. 

After installing Excel or Spreadsheet, download the xlsx file of this template to use it

Once extracted, you can open the file using Excel and start entering data or customizing the template.

Click The Button Below To Download Bilingual Saudi VAT Invoice Excel Template

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

Popular Excel Templates: