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

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
  • Calendars
  • Functions
  • FAQ’s
  • Blog
  • About

Download UAE VAT Invoice Format for Rent A Car Business In Excel

Download UAE VAT Invoice Format for Rent A Car Business In Excel

In this article, we will discuss the UAE VAT Invoice Format for Rent a Car Business. It is a ready-to-use invoice template with predefined formulas and VAT computations for the Car Rental business.

We received many requests from rental car business owners and made some customized templates for them.

The contents of an invoice are always the same, but there are minor changes according to the industry. For example, the rental business. Here things aren’t sold.

In Car Rental business, vehicles with same or different make and model which are rented to different persons or companies for different durations.

Thus a rental car Invoice must have all these fields along with basic calculations. In addition to that after the launch of UAE, the invoice should also be VAT compliant.

UAE VAT Invoice Format for Rent A Car Business

UAE VAT Invoice Format For Rent A Car Business In Excel

Keeping in mind all the above points, we have created UAE VAT invoice Format For Rent A Car Busines in Excel with predefined formulas. The headings in this template are in both English and Arabic so that it is easy for the customer to understand the invoice.

Just enter the required details and it will automatically fetch the names of the car, plate numbers, customer information etc.

Click here to download UAE VAT Invoice Format For Rent A Car Business.

In addition to the above, you can also download other UAE VAT templates like UAE VAT Payable Calculator, UAE VAT Multiple Tax Invoice, UAE VAT Dual Currency Invoice and Bilingual UAE VAT Invoice from our website.

Let us discuss the contents of the template in detail.

Contents of UAE VAT Invoice Format for Rent A Car Business

This template consists of two sheets:

  1. Database sheet
  2. Invoice Template

1. Database Sheet

This sheet consists of data that the invoice template will fetch with the help of Vlookup programming. It consists of following details:

Customer Name
Mobile Number
Car No
Car Name
TRN Number
Contract Number
Contract Out Date
Contract In Date
Per Day Rent

UAE VAT Invoice Format for Rent A Car Business

2. Invoice Template

Invoice template consists of five sections:

  1. Supplier Details
  2. Customer and Car Details
  3. Billing Calculations
  4. Bank Details
  5. Signatures

1. Supplier Details

This section consists of supplier details like company name, address, phone numbers, your TRN number etc in both English and Arabic language.

UAE VAT Invoice Format for Rent A Car Business

2. Customer and Car Details

The second section consists of customer and Car details. It consists of the following details:

Customer Name
Mobile Number
Office Number
Fax Number
Car Number
Car Name
Tax Registration Number of Customer

UAE VAT Invoice Format for Rent A Car Business

In addition to the above, it also consists of contract details like contract number, Contracts Out Date, Contract In Date. per day rent, Address etc. On the right-hand side, it consists of invoice no, date, LPO number, Do number etc.

3. Billing Calculations

Billing calculations consist of Description, Days, Count, Value, Tax, Amount etc. Below the billing calculation, Amount in words and Total calculations are given.

UAE VAT Invoice Format for Rent A Car Business

4. Bank Details

If the payments are to be made through the bank, then your customer must have your bank details. If you wish you can leave it blank or else add your bank details in this section.

UAE VAT Invoice Format for Rent A Car Business

5. Signature Section

Lastly, the signature section is given where the receiver can put his name and signature.

UAE VAT Invoice Format for Rent A Car Business

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 Saudi VAT Payable Calculator Excel Template

Filed Under: UAE VAT Templates

You are Here: Home / Excel Templates / UAE VAT Templates / Download UAE VAT Invoice Format for Rent A Car Business In Excel

About Fahim Lashkaria

I love working in Excel and I share functional excel templates at ExcelDataPro. Read more about me here or interact with me on twitter.

Comments

  1. JAVED says

    July 15, 2019 at 4:09 pm

    Please upload VAT audit file in excel..

    Reply
    • Fahim Lashkaria says

      July 16, 2019 at 11:34 am

      Noted

      Reply
    • JAVED says

      August 5, 2020 at 2:52 pm

      Sir my request still pending from July 15, 2019. Please do the needful.

      Reply
      • Fahim Lashkaria says

        August 6, 2020 at 11:44 am

        There is no audit file format in excel. It is auto-generated. Kindly Contact FTA for the format.

        Reply
  2. rent a car in sharjah says

    March 3, 2020 at 5:13 pm

    Hi Sir! This website is very good website and having a lot of information for all of us.

    Reply
    • Fahim Lashkaria says

      March 3, 2020 at 5:43 pm

      Thanks for the appreciation.

      Reply
  3. Aliya Amir says

    March 26, 2020 at 2:02 pm

    Amazing information you can provide I really appreciated it, sir.
    I am so glad to check how beautifully you can describe each and everything.
    Well, we also offer rent a car offer join us for more details one of the best services of rental we provide in Abu Dhabi

    Reply
    • Fahim Lashkaria says

      March 26, 2020 at 8:52 pm

      Thanks, Aliya Amir. Thank you for your appreciation. Glad to know it was helpful. Whenever in the near future, I will visit Abu Dhabi then will surely get rent a car from your company.

      Reply
  4. RENT A CAR IN LAHORE: says

    July 18, 2020 at 10:21 pm

    Thanks For Sharing Its Very Informative For Me

    Reply
    • Fahim Lashkaria says

      July 20, 2020 at 12:13 pm

      Thanks or appreciation.

      Reply
  5. Rent Car In Lahore says

    August 4, 2020 at 6:45 pm

    Thanks for Sharing Its Very Informative For Me

    Reply
    • Fahim Lashkaria says

      August 5, 2020 at 11:41 am

      Thanks, dear. Glad to know it was helpful to you.

      Reply
  6. Rent Car In Lahore says

    August 18, 2020 at 4:43 pm

    Thanks For Sharing Its Very Informative For Me

    Reply
    • Fahim Lashkaria says

      August 18, 2020 at 5:38 pm

      Thanks for the appreciation.

      Reply
  7. Rent Car In Lahore says

    October 28, 2020 at 8:46 pm

    Nice Article Thanks for Sharing

    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
  • Home
  • Contact
  • Privacy
  • Terms

© ExcelDataPro 2021. 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.