Call Us: +44 (0)1748 473000

Call Us Facebook Twitter Pinterest Linked in Instagram Youtube GooglePlus

Find out how to get 2 hours free training by referring a friend? 
What's the catch?
Articles Categories Screencasts

Xero Tax Rates / Types

Updated: 05 September 2016 14:46:16 OpenCRM::Invoice OpenCRM::Xero Integration

The list below shows all Xero tax classes. You will need to map OpenCRM VAT rates to appropriate tax classes by editing the VAT Rate picklist (under invoices) and in the "Other" column, putting the Xero tax type value for the corresponding VAT percentage.

Please note that in OpenCRM to cater for both Zero rate and Exampt tax classes, these two tax classes are mapped as follows (using recommended Xero examples for UK). Below we also include our recommended mapping for standard UK systems. If you use custom tax classes in OpenCRM or custom vat rates in Xero, you will need to contact OpenCRM support for help in configuring this correctly. 

Tax Class VAT Rate Other (Xero Tax Type)
Standard 20 OUTPUT2
Reduced Rate 5 RROUTPUT

Xero Tax Codes

United Kingdom

CAPEXINPUT 17.50 17.5% (VAT on Capital Purchases)
CAPEXINPUT2 20 20% (VAT on Capital Purchases)
CAPEXOUTPUT 17.50 17.5% (VAT on Capital Sales)
CAPEXOUTPUT2 20 20% (VAT on Capital Sales)
CAPEXSRINPUT 15 15% (VAT on Capital Purchases)
CAPEXSROUTPUT 15 15% (VAT on Capital Sales)
ECZRINPUT 0.00 Zero Rated EC Expenses
ECZROUTPUT 0.00 Zero Rated EC Goods Income
ECZROUTPUTSERVICES 0.00 Zero Rated EC Services
EXEMPTINPUT 0.00 Exempt Expenses
EXEMPTOUTPUT 0.00 Exempt Income
GSTONIMPORTS 0.00 VAT on Imports
INPUT2 20.00 20% (VAT on Expenses)
NONE 0.00 No VAT
OUTPUT2 20.0 20% (VAT on Income)
RRINPUT 5.00 5% (VAT on Expenses)
RROUTPUT 5.00 5% (VAT on Income)
SRINPUT 15.00 15% (VAT on Expenses)
SROUTPUT 15.00 15% (VAT on Income)
ZERORATEDINPUT 0.00 Zero Rated Expenses
ZERORATEDOUTPUT 0.00 Zero Rated Income


OUTPUT 10.00 GST on Income
INPUT 10.00 GST on Expenses
CAPEXINPUT 10.00 GST on Capital
EXEMPTEXPORT 0.00 GST Free Exports
INPUTTAXED 0.00 Input Taxed
GSTONCAPIMPORTS 0.00 GST on Capital Imports
GSTONIMPORTS 0.00 GST on Imports


INPUT 0.00 Tax on Purchases
NONE 0.00 Tax Exempt
OUTPUT 0.00 Tax on Sales
GSTONIMPORTS 0.00 Sales Tax on Imports

New Zealand

INPUT2 15.00 GST on Expenses
NONE 0.00 No GST
ZERORATED 0.00 Zero Rated
OUTPUT2 15.00 GST on Income
GSTONIMPORTS 0.00 GST on Imports

United States

INPUT 9.2500 Tax on Purchases
NONE 0.00 Tax Exempt
OUTPUT 9.2500 Tax on Sales
GSTONIMPORTS 0.00 Sales Tax on Imports

Rate This Article
  • 1 star
  • 2 star
  • 3 star
  • 4 star
  • 5 star
Feedback and Comments
captcha code  

You may also be interested in:


Twitter Feed


Software Add-ons Ltd
1 Battalion Court
Colburn Business Park
North Yorkshire
United Kingdom
+44 (0)1748 473000
+44 (0)870 125 5962
Reg #:
England & Wales 05387424

marker Find on Google Maps


OpenCRM Campaigns vs …

A little while ago now, we had a customer with a very specific reason for wanting to use MailChimp instead of relying solely the bulk emailing and Campaigns module in OpenCRM. This was all down to the way they managed some, but not all of the elements of their marketing strategy. Long story short, we developed a MailChimp integration as part of this implementation. As it was an integration we could see being useful to other customers, we decided to release it...

Let Your Employees Ru…

Each different industry and the players within that field face their own challenges when it comes to the successful running of their business, but the basic goals will generally be along similar lines - business expansion, growing profits, customer retention and keeping employees happy. A key part of that staff satisfaction is empowerment. Brands all over are doing their best to empower their customers by inviting them to complete customer surveys and take part in competitions. By inviting them to...

The Cloud is Just Bet…

I’m always amazed when I speak to people who would rather keep their data in a onsite server in their office rather than the Cloud. I spoke to someone just this past weekend who was convinced that it was safer because they could see and touch that server in the back room of the office. They knew where it was and what it was doing…or at least knew that it wasn’t physically going anywhere. And I can understand the peace of mind...

Productivity is Drive…

Productivity has always been one of those things that I feel strongly about when it comes to running a business. Now you talk about giving people the right tools and finding the right job role for them all day long, but the one thing that never fails to increase a team’s productivity in my experience comes down to processes. Let me give you an example. Several years ago we had a little problem here at OpenCRM. Our sales team and our projects team...

Protect Yourself agai…

As currencies fluctuate, make sure the Value of your Quotes and Sales Orders don’t. I was listening to a conversation on BBC Breakfast the other morning when something caught my ear: No one is quite sure what the impact of Brexit will be on the strength of the pound. This can create some uncertainty when generating Quotes if you operate using a number of different currencies. Lots of systems, including OpenCRM, have the ability to integrate with an Online Currency Exchange, giving...

Find the Right Approa…

It’s not terribly surprising that a recent study presented to the British Psychological Society by John Hackston found that some people found receiving, replying, and managing their email inbox more stressful than others. The author suggested that different personality types will need to structure the way they approach their emails and to-do lists in different ways. It all makes perfect sense to me (and I’m assuming most of you). I think about the way our “always on” MD likes to work...

Making Your Data Safe…

We are so used to storing data in the cloud, it is simply how things work these days. Large swathes of your personal life are already cloud-based – all your email addresses, social media profiles, photos etc. are likely to be stored digitally. In your home you may also have connected appliances – also known as the internet of things – such as heating that is controlled via an account synced to an app on your mobile phone. But apart...

Happy Burns' Night

Everyone remembers to wish people a Happy New Year or Merry Christmas when the season approaches, but what about the other, more regional or country specific holidays? Let's say, for example, that I would like to wish a Very Happy Burns Night to all of my Scottish clients….how can I do this in the most efficient way? In the words of Mel Gibson in Braveheart..’ FILTERING !!’ The ability to filter the information or data that you have stored within OpenCRM makes...

From Website Visitor …

Your website is your shop front. You spend time, money, and effort into getting it just right and making sure that people are finding it. Once there, you want to turn as many of these people as you can into actual sales, but first you have to find out a little bit about them. Then you need to nurture that relationship, but I’m getting ahead of myself. Asking people for their contact details via a web form is pretty ubiquitous these days...

Making The Best Use O…

The end of the year tends to be something of an expensive exercise. At home you’ve spent money on food, drinks and presents. At work you have had Christmas parties and a period of closure – all in all it’s not the cheapest time of year. So if now is a time when you are looking to spend a little less, it is the perfect occasion to dig into the existing resources you have to try and make the most out...

Post-Holiday Struggle…

The first week back from the Christmas holidays is almost over and there’s a curious mixture of sadness and gladness at being back at work. There is the tiredness we all feel, the result of a slightly altered sleeping schedule and a week of indulgences and lazy days. Plus you’ve got the slight malaise from bad weather and no bank holidays until April. Finally, there’s the enjoyment that comes from accomplishing something during the day and feeling productive. Some will even look...

Forecasting for 2017

As we approach the end of 2016, it is time to start looking forward to 2017. It’s become a bit of a tradition for me to write a post with a bit of a forecast on what I think the big topics in CRM will be for the New Year. So below are the issues that I think will be the three “big ticket” items in 2017, along with some questions you might want to consider asking your CRM and SaaS...

The Office Christmas …

Last week saw the the usual out of office OpenCRM Christmas Party. Last year we got all dressed to the nines and went Private Dining at Rockliffe Hall so this year we thought how on earth are we going to top that….. PAINTBALL AND PUB!!! We headed off to No Limits Paintball for an afternoon of snipering and target practice for some and lots of ooo’s and ahh’s from others, I was the latter! We had a blast (Pardon the pun)...

Interviewing for a CR…

Whenever I’ve been to an interview, my two favourite questions to ask are: “What is a normal day for someone in this role?” and “What will be your expectations of me after the first three months?” The first question is usually answered with a quick outline of basic jobs and then quickly descends into some of the more quirky, unusual, or random tasks that sometimes crop up. Every time I’ve asked this question, I have walked away with a far better...

Is It Safe To Head Ou…

There are so many ways of receiving the news, and this information becomes so much more powerful when it is designed to answer your questions or make you aware of issues specific to you. One great example of this is Transport Scotland. They have recently worked on developing a website and companion app that lets you know in real-time along which routes their trucks have been gritting the roads. The idea behind the live monitoring is to help give motorists confidence...