For those who like figures...

Yazi Registered Posts: 225 🎆 🐘 🎆
How to check a valid vat number

a) list vat number digits in a column
b) in the next column multiply by 8, then 7 etc, 6, 5, 4, 3, 2..
c) add the totals second column
d) take off 97 as many times as necessary to achieve a "negative" number
e) this total should be the last two digits.



  • Monsoon
    Monsoon FMAAT, AAT Licensed Accountant Posts: 4,071 🎆 🐘 🎆
    I'm geeky enough to have tried it :)

    It doesn't work for me (and I used my own VAT number so I know it's right) :(
  • blobbyh
    blobbyh Registered Posts: 2,415
    Or just validate it using the VIES website, essential for intra-EU supplies and services:

    You should certainly be on that, Miss Pole?!
  • Yazi
    Yazi Registered Posts: 225 🎆 🐘 🎆
    It should work for you Monsoon..

    Vat number of a very well known phone provider. 245719348.

    2 x 8 16
    4 x 7 28
    5 x 6 30
    7 x 5 35
    1 x 4 4
    9 x 3 27
    3 x 2 6

    Total 146 less 97 twice = -48

  • MarkT
    MarkT Registered Posts: 302
    It should work Monsoon. I made a very basic excel file for this exact purpose last year as I was in a team of people searching out duplicate companies for a ftse 100 company last year. Checking their VAT numbers had not been done in over 7 years, so this was one trick I used :thumbup:
  • Monsoon
    Monsoon FMAAT, AAT Licensed Accountant Posts: 4,071 🎆 🐘 🎆
    Ah Yazi, thanks, I didn't understand the instructions right and didn't do it like your example. It will probably work now.

    And yes blobby, I've got that link too.

    Geek that I am I like to know there is a pattern behind these and whether they are simple or hellishly complicated :)
  • Rozzi Rainbow
    Rozzi Rainbow Registered Posts: 465
    Haha this is brilliant I love it :) Our VAT number is certainly valid!
Privacy Policy