Friday 22 May 2009

Flat Rate VAT Calculator

If you are registered with the Government's Flat Rate VAT Scheme, you'll find that though they make it very easy to calculate how much VAT you owe (a percentage of your gross turnover), actually filling in your VAT return is a pain.

You have to calculate an "imaginary purchase amount", which is how much you would have had to have spent on VAT-able purchases to be able to reclaim an equivalent amount of VAT to reduce your VAT bill to the figure you worked out in the first place (phew!)

So what they give with one hand they take away with another.

However, I have made a spreadsheet to make the process simple. I hope you "find it useful".

Flat Rate VAT Calculator.xls

6 comments:

  1. thanks. I'm doing my first flat rate return and this is very useful. thanks for sharing!

    ReplyDelete
  2. Confused as to this "imaginary purchase amount". What is this for?

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. This is completely redundant as HMRC have given new advice on how to fill the form in for Flat Rate:

    http://www.hmrc.gov.uk/vat/managing/returns-accounts/fat-rate-returns.htm#4

    ReplyDelete