Zero VAT report...

[Chris74]

Hi folks, I would like to create a report that includes the total from paid invoices where VAT has not been charged. It should work on the date paid field.

As we are in the UK, we charge VAT at 20% to our resident customers, which makes up almost our entire customer base. We don't charge VAT to customers outside Europe.

The way our accountant calculates VAT payable is on the gross income from transactions, with the VAT MOSS data taken into consideration. Until now, I haven't tried to identify the non VAT transactions, so we've been paying a bit more VAT that necessary.

I need to identify for any given month, the total income from paid invoices that is not VAT-able, so we do not have to pay VAT at 20% on these invoices to the government. It won't be much, but I want to make sure it is correct - and we can also claim for the last four years.

I'm not a developer so this is beyond my expertise so will gladly pay a fee.

Many thanks.

Edited November 23, 2018 by Chris74

[brian!]

2 hours ago, Chris74 said:

Until now, I haven't tried to identify the non VAT transactions, so we've been paying a bit more VAT that necessary.

I need to identify for any given month, the total income from paid invoices that is not VAT-able, so we do not have to pay VAT at 20% on these invoices to the government. It won't be much, but I want to make sure it is correct - and we can also claim for the last four years.

you would almost be able to use the existing Invoices Report for this - assuming that you're not selling services/products that have 0% VAT, wouldn't it be a case of searching for paid invoices, with a tax rate of 0%, for any given month... ?

the above should give you a list of paid invoices for this month, where no tax was charged.... then you'd either have to sum them yourself, or modify the report to sum them for you.

2 hours ago, Chris74 said:

I'm not a developer so this is beyond my expertise so will gladly pay a fee.

then you should have posted this in Service Offers & Requests. 🙂

[Chris74]

Yeah you're right, it does exactly what I want it to. I didn't know there was such a comprehensive reporting function in there. Never spotted it before.

Thanks.