I am aware that QF will calculate the EC sales list with the VAT report, however this won’t work for me since I would have to change the VAT reporting date (which we don’t want to) and also we supply services, not goods, so there are lots of manual adjustments on my VAT return.
My old (very, very old) accounting software showed a different code for EC sales and so I could simply scroll down the list and pick out the sales to include. QF doesn’t seem to have anything similar, however I thought that it might be possible for me to create a report showing all sales between a period where the customer is marked as VAT Registered in another EC Member State. I can’t work out how to create custom reports as the only option seems to be for different nominal account numbers (no date option or other criteria). Am I missing something?
Apart from the “Generate EC Sales List” option in the VAT return, there isn’t a way to filter specifically for invoices for clients marked “VAT Registered in another EC Member State”.
I think the best way to tackle this would be to use project tags, and tag the invoices with a specific tag, e.g. “ec-invoice” or similar. This would allow you to view invoices with that tag specifically.
It may be worth using the ECSL report from the VAT reports initially to identify these invoices however.
If you have any issues, please let us know and we’ll try our best to help.
OK, I can use project tags but presumably I can only do this going forward, not for the current return, as most of the invoices are already paid and so I can’t modify them.
I don’t see any option on the last VAT return (30 April) to show EC sales, but the EC sales box is ticked in settings. Do you mean that I would need to create a new VAT return for the next quarter to identify the invoices (from 1 May) and then just not submit?
I can just do it manually but was trying to avoid this as it will obviously take longer than having a list produced automatically.
When you look at your VAT return there should be a little box at the bottom to download the VAT return and also another one to download the EC sales list
The “download calculations” should include a section listing the EC sales that make up box 8 (everything where you ticked the so-called “apply reverse charge” option, though I guess you may not have done this if you’re selling services rather than goods).
Is it zero because you don’t tick the “reverse charge” box at all, or is it zero because you do tick that but then manually adjust it back down again? If the latter then the calculations report will still give you what you need.
The reverse charge marker has been removed from all of the invoices after a discussion with Glenn from QF. This is due to QF incorrectly reporting unpaid invoices in box 6 as it treats everything as goods (in addition to the box 8 problem).