Hi folks, we have to return our RTD to revenue and must give a breakdown of purchases and sales broken into 23% and 13.5%. The export report doesn’t give this breakdown. Please advise how I get it without having to manually open every entry? Sonya
Hi folks, we have to return our RTD to revenue and must give a breakdown of purchases and sales broken into 23% and 13.5%. The export report doesn’t give this breakdown. Please advise how I get it without having to manually open every entry? Sonya
Do you have the country filled in for your clients and suppliers? We can add a VAT by Country report that would have the following information:
Sales
--------
Country - VAT Rate - Amount
...
Purchases
------------
Country - VAT Rate - Amount
...
For Example:
Sales
--------
Ireland - 13.5% - €1,000
Ireland - 23% - €2,000
UK - 23% - €500
...
Purchases
------------
UK - 13.5% - €500
Ireland - 13.5% - €2,000
Ireland - 23% - €4,000
UK - 23% - €500
...
Would that report suffice for your needs?
Regards,
John.
Yes I put the country in for everybody. I think that would work but we would need to be able to sort month by month as they require monthly totals. I've included below an example of how we had to send the information to our Accountant for last years' return for both purchases and sales. What we need is the information in the box.
Kind regards
Sonya
The formatting is a bit hard to understand - perhaps you can attach a file that shows the detail?
John.
It will take a little longer than I initially thought to create the VAT report. Let me know the dates you need the information for and I'll get it from the backend data and send it to you in a spreadsheet.
John.
I'm actually up in the Accountants now. We need from 01 May 2015 to 31 March 2016 for Fitzpatrick Plant Sales Ltd only. We don't need the other 2 companies.
Thanks a million
Sonya
I've attached a file which is the VAT details of your sales and purchases between the dates requested. Note that there are 2 tabs for sales and 2 for sales credit notes (this was easier for us because some of your sales/credit notes were tax inclusive pricing, most were tax exclusive).
The sheets are ordered by date, and then y VAT rate. You should be able to use excel filtering to extract the data you need. I left the data more granular incase you have different requirement for filtering to complete the RTD.
By the way, while I was with the Accountants they mentioned about processing the VAT on a cash receipt basis (i.e. vat calculated on paid rather than entered bills and invoices) and that there's a threshold applied to this. It doesn't effect any of our companies this year but might be something for you to consider for the future.
Thanks for your help.
Kind regards
Sonya
Yes, we support both cash basis and invoice bases for VAT. We can switch people out backend. We don't have an option to change this in the front-end, as if someone changes it by accident it could cause problems for them.
John.