web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Showing EU purchase of services correctly on VAT Daybook

(0) ShareShare
ReportReport
Posted on by 214

My client is setup in the UK to purchase services from the EU and are subject to Reverse Charge and EC Sales.

We have been trying to setup GP with Intrastat enabled as they are purely purchasing services and not goods so that it shows up correctly on their VAT return.

They are only raising Payables transactions Invoices and Credits but need it to populate the following 4 boxes on the VAT return:

Box 1 (output VAT)

Box 4 (input VAT)

Box 6 (value of the deemed supply)

Box 7 (purchase value)

The problem is that no matter what we add to the VAT Daybook Report it will not show up on Box 4 and I am struggling with which Tax Detail ID needs to be added to which box then what do they need to enter on the transaction in the Tax so that it picks up correctly??

Can anyone help at all please? They are wanting to go live with this on the 1st October??

A previous post asked for the same advice below but there has been no answer surely someone else in the UK is setup correctly to account for purchasing services in the EU??

Both the supplier and the recipient.  This requires that a single Invoice from a Creditor actually should generate both a Sales and Purchase event, as follows (again from the HRMC literature):
You simply credit your VAT account with an amount of output tax, calculated on the full value of the supply you have received, and at the same time debit your VAT account with the input tax to which you are entitled, in accordance with the normal rules.
You then include in the relevant boxes of your VAT return:
  the amount of output tax in box 1 VAT due on sales;
  the amount of input tax in box 4 VAT reclaimed
on purchases;
  the full value of the supply in box 6 total value of sales; and
  the full value of the supply in box 7 total value of purchases

So it would appear that from this one single purchase we need to generate both a Sales and Purchase VAT amount and net purchase amount, 4 separate entries on the VAT report. 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    Hi. I have a fair bit of knowledge of this. The short answer is that you can handle this, but you won't be able to use the out of the nox autogenerated VAT return. This is generally not a big issue...you can create a SSRS report to generate the VAT return.  The underlying transaction can be recorded correctly etc. PM me and we can organise to have a chat if you want...far yoo many ifs and questions to go through in the forum.

    Ian.

  • Laura Bowie Profile Picture
    214 on at

    Hi Ian

    I tried PMing you to have a chat about this and would really appreciate if we could get a chance to go over this so I can let my client know?

    Laura

  • Community Member Profile Picture
    on at

    Hi Laura, I responded to you in email.

    I will send you a new email now.

    Ian.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans