VAT on Amazon sales

[Raw Rob]

I sell food, some of which is standard 20% VAT and some of which is 0%. I started selling on Amazon a few months ago, and so far I've only listed 0% items. I can't see a simple way of selling a mixture of items - there is no way to specify on Amazon whether an item has VAT as far as I can see?

At the moment I just get the monthly reports from Amazon and put the totals into my accounts, knowing that all sales are 0% VAT. I can't see a simple way of selling a mixture - the only way I could do the accounts would be to get a more detailed report from Amazon with each product sold and do lots of messing around in Excel to work out which products have VAT and which don't. Am I missing something? Anyone got a simple solution to this?

thanks, Rob

 

[Tradebox]

Hi Rob

Tradebox provide a desktop program that integrates Amazon marketplaces with the UK version of Sage 50 Accounts. Tradebox is designed as an automated bookkeeper, downloading your Amazon orders and creating individual invoices in Sage. If you set up products in Sage and allocate a tax code against each product, then Tradebox can download your orders, match the Amazon SKU to the Sage stock code and discriminate on your Sage invoice between VAT and non VAT goods.

Happy to answer any questions you may have if you wish to get in touch with us.

 

[Raw Rob]

Thanks Tradebox, but I already use KashFlow, which is integrated with my website, and probably don't want to change that at the moment.

 

[GraemeL]

Anyone got a simple solution to this?

You will need to split your Amazon sales into 0% VAt and 20% Vat. Suggest you include a letter or series of letters at the beginning of each product code (such as ZO for zero VAT and TY for 20% Vat) so you can download all transactions done on Amazon as CSV, convert to Excel and then do a simple sort of the data based on product code. Easy then to split the two types.

 

[Raw Rob]

Thanks Graeme, that would work.