• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Download UAE VAT Sales Register Excel Template

Download UAE VAT Sales Register Excel Template

UAE VAT Sales Register is a document that maintains the records of your sales during a specific period along with details of Output VAT collected on those sales.

Earlier, we maintained records of sales, but those records were without VAT calculations.

UAE is all set to implement VAT from Jan 2018 and businesses have been instructed to get VAT ready.

The VAT collected by you n sales of goods or services is called Output Tax.

According to Article 4 of Federal Decree-Law No. (8) of 2017 on Value Added Tax, It is the responsibility of the taxable person to collect VAT whenever a taxable supply takes place.

See imager below:

UAE VAT Sales Register

You can download the pdf copy of Federal Decree-Law No. (8) of 2017 on Value Added Tax from the link below:

Federal Decree-Law No. (8) of 2017 on Value Added Tax

The VAT paid on purchases of raw material intended to be used in the making of the taxable supply is called UAE VAT Recoverable Input Tax.

When you purchase goods you can maintain your purchase records in our UAE VAT Purchase Register.

Whenever you make any sales, you are entitled to collect the VAT on the goods or services you supply.

At the end of the tax period, you pay the difference between the output VAT collected and recoverable Input VAT paid.

We have created the UAE VAT Sales Register Excel Template to maintain your sales records and help you to easily calculate your output tax.

UAE VAT Sales Register

This template is helpful to all traders, wholesalers, retailers, industrial units, etc.

Click here to Download UAE VAT Sales Register Excel Template.

You can also download other UAE centric Accounting Templates like UAE Invoice Template, UAE Invoice Template in Arabic, UAE VAT Debit Note, and UAE VAT Credit Note, etc.

Let us discuss the creation of this template in detail.

Contents of UAE VAT Sales Register

The UAE VAT Sales Register template consists of 2 sections:

  • Header Section
  • Sales Details Section

Header Section

Usually, the header section consists of your company name, template heading.

Apart from that, it consists of Month, Year, and your VAT registration number.

UAE VAT Sales Register

Sales Details Section

This section consists of multiple subheadings:

Sr.No.: A serial number is a sequence to know the number of sales made during a particular period.

Invoice No: You need to enter the Invoice number of the issued against the supply made to your customer.

With the help of a unified numbering of the invoice, it becomes easier for you to identify missing invoices, etc.

Invoice Date: Date on which the sale was made and invoice was issued.

Customer Name: You need to enter the name of the company to which the supply has been made.

Customer’s VAT No.: If your customer is a registered person, enter their VAT registration number. If the customer is an unregistered user, leave it blank.

UAE VAT Sales Register

Taxable Amount: Amount on which the applicable 5% VAT will be calculated. In other words, the sales price on which the 5% VAT is calculated.

VAT % and Amount: Just enter the applicable tax percentage tax of VAT and it will automatically calculate the amount.

VAT percentage in UAE is a flat rate of 5%. Thus, enter 5% in each cell.

Invoice Amount: Invoice amount =  Taxable Amount + VAT Amount.

Lastly, the total of each column is made at the end of the column.

There is a provision to enter up to 100 invoices in this template.

If you have more than 100 invoices, you can insert additional rows as per your requirement.

To maintain records for a longer time, either make a copy of this sheet and you can use it for other tax periods.

We thank our readers for liking, sharing, and following us on different social media platforms.

If you have any queries please share in the comment section below. I will be more than happy to assist you.

« Download UAE VAT Purchase Register Excel Template
Download UAE VAT Payable Calculator Excel Template »

Filed Under: UAE VAT Templates

You are Here: Home / Excel Templates / Accounting Templates / Download UAE VAT Sales Register Excel Template

About Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.

Comments

  1. Shahim says

    December 28, 2017 at 12:50 pm

    How to give discount for full invoice

    Reply
    • Fahim Lashkaria says

      December 28, 2017 at 4:04 pm

      If it is the discount on the complete amount of invoice, it should be deducted after adding the VAT tax to final invoice amount according to Article 59 of Executive Regulation.
      Taxable value + 5% Vat of Taxable Value = Invoice Amount – Discounts = Final Invoice Amount.
      The 5 % tax will be calculated on the taxable value before discount.
      The invoice template with discount is under construction and will soon be published on the website.

      Reply
  2. Amal says

    February 6, 2018 at 2:06 am

    Need help in new vat receipt

    Reply
    • Fahim Lashkaria says

      February 6, 2018 at 6:12 am

      What kind of help do you need? Can you please describe your query in detail?

      Reply
  3. muslam uddin says

    February 10, 2018 at 2:20 pm

    dear sir good day uae vat sale register s r no only 100 sir its possible more sr no

    Reply
    • Fahim Lashkaria says

      February 13, 2018 at 5:50 am

      Yes, you can add as much you want. But make sure you configure the end total formula properly.

      Reply
  4. Salar says

    March 2, 2018 at 12:17 pm

    hello..

    Company A Ltd purchasing item form another Z Ltd without VAT at cost of 100. On invoice it will be written 100. However while payment he pays 90 as discount is allowed to him.

    Comapny A selling same item to its customer C Ltd at price of 100. Now A ltd allowing discount to its customer and will recive 94.

    4 is the profit for A Ltd. please share input and output in this scenerio

    Reply
    • Fahim Lashkaria says

      March 4, 2018 at 2:09 pm

      There are two things to look here. Whether A is registered or not?

      Company A is not eligible for input tax credit.

      Reason: Company A has made the purchase without VAT. Thus, Company A cannot claim any input on his purchase. Anything on which VAT is paid can be claimed as input.

      While selling to Company C, Company A charges VAT at 5%.

      Formula Applied here will be Sales Price – Discount = Invoice Amount + (Invoice Amount X 5% VAT) = Final Invoice Amount.

      = 100 – 4 = 96 + (96 x 5%) = (96 + 4.8) = 100.80

      In the scenario above, Output Tax is 4.8 and Input Tax is 0. Hence 4.8 is payable by company A to the government.

      If the purchase from Company Z by Company A is VAT payable then company A has the input tax of 4.5. In this scenario, Company A will only pay government 0.30 as the VAT. (4.8 – 4.5 = 0.30)

      Hope everything clear.

      Reply
  5. Omar says

    April 9, 2021 at 4:19 am

    Dear,

    Thanks for the information.
    I have one question; why the button “vat201 – new vat return” is not there on my page?
    will it be only shown after the tax cycle starts?
    please clarify ..

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

UAE VAT Templates

  • UAE VAT Tax Invoice Excel Template As Per The Federal Law 8 of 2017 on VAT
  • UAE Invoice Template With VAT in Excel – Arabic
  • UAE VAT Credit Note Excel Template
  • UAE VAT Debit Note Excel Template
  • UAE VAT Inventory Management Excel Template
  • UAE VAT Purchase Register Excel Template
  • UAE VAT Sales Register Excel Template
  • UAE VAT Payable Calculator Excel Template
  • VAT Invoice Template for Bahrain, Kuwait, Oman, Qatar, Saudi Arabia and UAE
  • VAT Credit Note Template for Bahrain, Kuwait, Oman, Qatar, Saudi Arabia and UAE
  • GCC VAT Payable Calculator For All 6 GCC Countries
  • Arabic VAT Invoice Template for Bahrain, Kuwait, Oman, Qatar, Saudi Arabia and UAE
  • GCC VAT Invoice Template With Discount
  • UAE VAT Progress Billing Invoice Excel Template
  • UAE VAT Multiple Tax Invoice Excel Template
  • UAE VAT Dual Currency Invoice Excel Template
  • Bilingual UAE VAT Invoice Excel Template
  • Bilingual Saudi VAT Invoice Excel Template
  • Saudi VAT Payable Calculator Excel Template
  • UAE VAT Invoice Format for Rent A Car Business In Excel

ExcelDataPro

Free Excel Pro Templates

  • Glossary
    • Accounting Glossary
    • HR & Payroll Glossary
    • Tax Glossary
  • Templates
    • Accounting
      • Financial Analysis
      • Financial Statement
    • Educational
    • Taxation
      • Federal Income Tax
      • GST
      • UAE VAT
      • UK VAT
    • Human Resources
      • HR & Payroll
      • HR Metrics
    • School Management
    • Social Media
    • Sales-Marketing
    • Personal Finance
    • Other
      • Health & Fitness
  • Functions
  • FAQ’s
  • Blog
  • Home
  • Contact
  • Privacy
  • Terms

© ExcelDataPro 2023. Content Licensed Under Creative Commons with Attribution Required

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT