Thanks. I went for option 2 you suggested and uploaded cost prices including vat and recalculated.
I do still have the issue with the reporting profit totals include VAT? Is there any way to show the profit on reports excluding VAT without doing option 1 you suggested?