• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Anyone know where I can get historical Euro buy rates?

Collapse
X
  •  
  • Filter
  • Time
  • Show
Clear All
new posts

    Anyone know where I can get historical Euro buy rates?

    Seems that HMRC allow you to use the crappy buy rate when you convert your invoices from Euros for the purpose of VAT. Of course, the crapper your invoice converts to sterling the less VAT you pay back on it (if you're on flat rate).

    Its easy to find historical rates for mid rates (i.e. not the crap buy ones) and I'm sure I've read somewhere that commericial buy rates are normally about 4% on top. However, since HMRC expect you to quote your source for exchange rates I dont know if they'd be happy if I just took mid-rate and added 4%. (but then again how are they going to check exact historical tourist rates cos I cant find them!)

    Of course, ideal situation is to check the tourist rate on the day you invoice and stick the converted sterling amount on your invoice for information. You're supposed to do this anyway.

    Unfortunately, despite asking him about three times about Euro invoices in general, my accountant never though to advise me of this simple task. Admitedly, I could have read it myself on the HMRC website,

    Anyway, VAT return and accountant has just gone and used a standard historical rate for that day. Didnt discuss with me just did it. I'm aware you could use the HMRCs standard rate for a month but see my opening paragraph. For me, depending on rate it could mean £20-£30 month extra VAT. Not a huge amount but hey.
    Rhyddid i lofnod psychocandy!!!!

    #2
    Try the link below. It has a tracker that emails you over time as well

    Travelex United Kingdom - Travel Rate Tracker
    'CUK forum personality of 2011 - Winner - Yes really!!!!

    Comment


      #3
      Oanda

      I use these guys - an excellent source of historical FX data.

      Look under Currency Tools / Historical Currency Converters

      OANDA - Forex Trading and Exchange Rates Services
      2012 CUK Reader Awards - '...Capital City Accountancy, all of whom were outside the top three yet still won compliments from CUK readers for their services' - well, its not an award, but we'll take it! - Best Accountant (for IT contractors) category
      2011 CUK Reader Awards - Top 3 - Best Accountant (for IT contractors) category
      || Check us out at: http://www.linkedin.com/company/capi...ccountancy-ltd

      Comment


        #4
        But what I need, for example, is what was the sell rate for Euros on 31st May 2011?

        I can used Oanda to get the interbank rate, and I see its got a little add % tool. Like I said, I've heard its generally interbank+4% but HMRC say you can use market rate from, for example, newspaper. Not sure if they'll let me calculate it myself.
        Rhyddid i lofnod psychocandy!!!!

        Comment


          #5
          Originally posted by psychocandy View Post
          But what I need, for example, is what was the sell rate for Euros on 31st May 2011?

          I can used Oanda to get the interbank rate, and I see its got a little add % tool. Like I said, I've heard its generally interbank+4% but HMRC say you can use market rate from, for example, newspaper. Not sure if they'll let me calculate it myself.
          I wouldn't try calculating it yourself as you are asking for trouble.

          The only rate you can use if you can't find a tourist rate is HMRC's published rate.
          "You’re just a bad memory who doesn’t know when to go away" JR

          Comment


            #6
            Originally posted by psychocandy View Post
            But what I need, for example, is what was the sell rate for Euros on 31st May 2011?

            I can used Oanda to get the interbank rate, and I see its got a little add % tool. Like I said, I've heard its generally interbank+4% but HMRC say you can use market rate from, for example, newspaper. Not sure if they'll let me calculate it myself.
            Why dont you ask them then?? Jesus. Your reliance on a load of random people on a public board who don't know your situation when it comes to dealing with important matters of your finance is amazing.

            HMRC Contact us
            'CUK forum personality of 2011 - Winner - Yes really!!!!

            Comment


              #7
              Originally posted by northernladuk View Post
              Why dont you ask them then?? Jesus. Your reliance on a load of random people on a public board who don't know your situation when it comes to dealing with important matters of your finance is amazing.

              HMRC Contact us
              No harm in asking if anyone else has done similar...
              Rhyddid i lofnod psychocandy!!!!

              Comment


                #8
                Originally posted by SueEllen View Post
                I wouldn't try calculating it yourself as you are asking for trouble.

                The only rate you can use if you can't find a tourist rate is HMRC's published rate.
                Yeh. Looks like accountant has cost me a few tenners then.....
                Rhyddid i lofnod psychocandy!!!!

                Comment


                  #9
                  I always use http://uk.finance.yahoo.om

                  Or try googling "historical exchange rates"

                  Comment


                    #10
                    Originally posted by PandyLegend View Post
                    I always use http://uk.finance.yahoo.om

                    Or try googling "historical exchange rates"
                    But these are the interbank rates not the tourist rate which I want to use. The tourist rates are 'worse' so less sterling = less vat.

                    Not from Tonypandy by any chance are you? :-)
                    Rhyddid i lofnod psychocandy!!!!

                    Comment

                    Working...
                    X