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

Download UK VAT Dual Currency Invoice Excel Template

Download UK VAT Dual Currency Invoice Excel Template

UK VAT Dual Currency Invoice is a ready-to-use excel template that helps you to issue a VAT compliant invoice in two different currencies.

A dual currency invoice is prepared when the goods or services supplied are from a foreign location or in foreign currency. It is mandatory by law to mention the tax amount in sterling with the applied exchange rate.

Table of Contents

  • Guidelines for Dual Currency Invoice
  • UK VAT Dual Currency Invoice Excel Template
  • Contents of UK VAT Dual Currency Invoice Template
    • Customer Database Sheet
    • UK VAT Dual Currency Invoice Template
      • Supplier Details (Your Company Details)
      • Customer Details
      • Product Details
      • Other Details

Guidelines for Dual Currency Invoice

According to Point 7.6 of VAT Guide Notice 700, “For VAT purposes, amounts of money must always be expressed in sterling.” See image below:

UK VAT Dual Currency Invoice

Source: www.gov.uk

UK VAT Dual Currency Invoice Excel Template

UK VAT Dual Currency Invoice

We have created the UK VAT Dual Currency Invoice excel template with predefined formulas that will help you to issue the invoice with 2 currencies. One is Sterling Pound and another currency whichever is applicable.

Click here to download UK VAT Dual Currency Invoice Excel Template.

In addition to that, you can also download other UK VAT Templates like UK VAT Sales Register UK VAT Debit Note, UK VAT Credit Note,  UK VAT Invoice Template, UK VAT Multiple Tax Invoice Template, UK VAT Invoice Template With Discount, and many more from our website.

Let us discuss the contents of the template in detail.

Contents of UK VAT Dual Currency Invoice Template

This Invoice template consists of 2 worksheets: UK VAT Dual Currency Invoice Template and Customer Database Sheet.

Customer Database Sheet

UK VAT Dual Currency Invoice

The customer sheet contains customer details of customers like company name, address, contact details, and VAT numbers, etc. The user needs to enter the name only once on the sheet.

The customer sheet has been linked to the customer details section of the invoice template using data validation and VLOOKUP. Customer information can be fetched on the invoice with the help fo the dropdown list.

UK VAT Dual Currency Invoice Template

The template consists of 4 sections: Supplier Details, Customer Details, Product Details, and Other Details

Supplier Details (Your Company Details)

UK VAT Dual Currency Invoice

This section consists of your company name, address, logo, VAT registration number, and Invoice heading.

Customer Details

UK VAT Dual Currency Invoice

The customer detail section consists of the Invoice number, date of issue, payment due date, and the number of days between the issue date and the payment date.

You don’t need to type customer details in this section. It is pre-programmed using data validation and Vlookup function. Just select the customer name from the dropdown list and it will automatically fetch all customer details such as an address, VAT number, and contact details.

UK VAT Dual Currency Invoice

As the invoice is in two different currencies, insert the currency conversion rate in this cell. In this template, we have taken USD as other currency and thus given the conversion rate for the same. If you use any other currency, mention the currency’s alphabetical code and respective conversion rate.

Product Details

UK VAT Dual Currency Invoice

This section consists of the following columns:

Description of Products
Quantity
Unit Price (USD)
Unit Price (GBP)
Taxable Value (USD)
Taxable Value (GBP)
Percentage of VAT
VAT Amount (USD)
VAT Amount (GBP)
Line Total (USD)
Line Total (GBP)
Column Totals

Each of the above columns calculates the GBP amount based on the conversion rate. Select the VAT percentage from the dropdown list.

UK VAT Dual Currency Invoice

Other Details

Invoice Summary contains the totals of each column of the product details section in both USD and GBP. Additionally, it consists of a discount section. Insert the percentage if it is applicable. The template will automatically calculate the discount amount.

Lastly, it consists of the Invoice Amount. The amount is calculated using the below formula:

Invoice Amount (GBP) = Taxable Value (GBP) + Total VAT Amount (GBP) – Discounts (GBP)

Invoice Amount (USD) = Taxable Value (USD) + Total VAT Amount (USD) – Discounts (USD)

UK VAT Dual Currency Invoice

Furthermore, it consists of “Amount in words” for both the currencies(GBP and USD). This cell auto-populates using SpellNumber Function.

In addition to that, it consists of Terms & Conditions along with the space for company seal and authorized signatories. On the extreme left, it consists of the business greeting.

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. We will be more than happy to assist you.

Filed Under: UK VAT Templates

You are Here: Home / Excel Templates / UK VAT Templates / Download UK VAT Dual Currency Invoice Excel Template

About Shabbir Bhimani

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

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

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