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

1 answer

Peter Connor Staff May 7, 2016
Public

Hi Sonya,
We don’t do the VAT RTD return, or create a report for. 
The simplest way to do it is export all your invoices and then filter down to the international companies and just click on those invoices.
Pete 

#answer-3202
  1. Peter Connor May 7, 2016
    Hi 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.
  2. sales16 May 7, 2016
    Hi 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​
  3. Peter Connor May 7, 2016
    Hi Sonya,
    The formatting is a bit hard to understand - perhaps you can attach a file that shows the detail?

    John.
  4. sales16 May 7, 2016
    Stupid Gmail.... here you go.
  5. Peter Connor May 7, 2016
    Thanks Sonya. We'll investigate and see what useful report we could provide. Either way, you should have your data by tomorrow at the latest
  6. sales16 May 7, 2016
    Great thanks John, really appreciate your prompt response on this one. It's a killer when revenue own you money and can hold you to ransom like this. If it was the other way round and we owed them, I'm sure they'd be quite happy to accept it!!!
  7. Peter Connor May 7, 2016
    Hi Sonya,
    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.
  8. sales16 May 7, 2016
    Hi 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
  9. Peter Connor May 7, 2016
    Hi 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.
  10. sales16 May 7, 2016
    Ok thanks for that John, I'm just out of a meeting now so I'll go over it this afternoon and get it off to the Accountants.
    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
  11. Peter Connor May 7, 2016
    Hi 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.
  12. sales16 May 7, 2016
    Good to know, thanks John.

Please login or Register to Submit Answer