VAT in the UK Version of Microsoft Dynamics GP
Her Majesty's Revenue and Customs (HMRC) is implementing the first step of Making Tax Digital, which imposes new requirements on VAT registered businesses above the VAT threshold. Requirements will be implemented in phases. In the first phase, with a deadline in April, 2019, the following requirements will take effect:
- Keeping records digitally - Businesses must now keep all their records digitally. For users of ERP systems this will not have any impact since they already keep their records digitally in these systems.
- Submit VAT return electronically using software recognized by HMRC.
- If you are new to VAT 100 setup, review How to set up VAT 100 Return
- If you are having issues using the Making Tax Digital, see Troubleshooting Making Tax Digital
- Group VAT functionality added to Microsoft Dynamics GP. For more information, see Group VAT filing for multiple companies with VAT 100 Return
Set up Making Tax Digital for VAT
The Making Tax Digital feature uses a service connection to communicate with HMRC.
In the Company Setup window, you must specify your company's tax registration number.
In the UK Digital VAT Setup window (Cards -> Company-UK Electronic VAT Setup), you must specify that you want to use the Making Tax Digital service.
Set up VAT returns
HMRC maintains a list of VAT obligations for companies, which are the periods for which they must report VAT and the due date for the report. HMRC exposes this information through their API so that Dynamics GP can retrieve the obligations. Dynamics GP stores VAT obligations as VAT Return Periods, and uses them to:
- Remind you about VAT returns that are due or overdue.
- Automatically enter start and end dates when you create VAT returns.
In order to use the Making Tax Digital service, you must connect to the service from the VAT Return window. (Tools -> Routines -> Company -> Vat Return) The window information and verbiage will changed based on if you mark Use UK VAT Making Tax Digital in the above step.
To enable the connection, you must create a new VAT return.
To connect to the Making Tax Digital service
In the VAT Return window, enter a VAT Report ID, and then enter a year (this is the year that your VAT tax obligation is due).
Once you tab off the Year field, the HMRC Log in window appears where you can login to the HMRC site.
Grant authority to the software application to access your VAT information.
After you have successfully logged in, then the VAT Obligations window opens, and you can choose your obligation period. This comes from the HMRC site and will return your company’s VAT periods.
The screenshot above is based on a test environment with quarterly VAT tax and only 2 obligation periods open. Your view will be different.
When you return to the VAT Return window, click Calculate to have the system calculate VAT for you as shown in the following picture.
If the calculations are not correct, you can clear the window at this time. Then repeat steps above when ready. Click Save to save the information.
When you save the VAT return, VAT box fields are now editable so any further corrections can be made.
The Final Return checkbox is also editable and it must be marked before you can submit.
Click Submit to start the submission. You must supply your HMRC credentials again.
You will get a mandatory message required by HMRC, where you just choose the OK button, so that you will see a progress bar for the VAT information being submitted to HMRC.
When the submission is complete you will see the VAT Response window.
To submit VAT Daybook returns
Create the column codes for GB country code for all the boxes in VAT Daybook report (Cards >> Company >> VAT Daybook report)
Create and Post Purchase and Sales transaction with Tax for GB customer and vendor.
If you want to view the report before submission then select the draft option in VAT Daybook report(Routines >> Company >> VAT day book report)
If not then you can print the audit trial code report for that posted period. As soon as you tab off from the period field HMRC login page will open up and you enter the credential.
a. If in case, VAT calendar setup is not as per the HMRC calendar setup then you get the message for incorrect calendar setup and obligation window will open to view(only to view but you can’t select any period) the calendar setup for that year. You need to do the calendar setup as per the HMRC site in order to proceed further.
b. If calendar setup is as per the HMRC then you can print the audit trial report.
After generating the audit trial report, you can now perform the electronic submission for the same period.
When you choose Electronic Submission and then enter Year and Period Key, VAT HMRC login page pops up and you must enter the credentials.
After entering the credentials, you can click on submit button which again takes you to the HMRC login page. Post submission, VAT response window will open up for the submitted record.
Note
After submitting the return, if the progress window does not start and there is no response window, it could be a proxy server issue. For more information, see https://developer.service.hmrc.gov.uk/api-documentation/docs/reference-guide#network-access
Note
The above Making Tax Digital process of submitting to the HMRC also works for the VAT Daybook module in Dynamics GP. VAT Daybook does not allow you to edit the amounts prior to submission like you can in the VAT 100 (return) window.
Note
The VAT Return is mainly pulling from the TX30000 table. The VAT Return also uses the DOCDATE, not the Tax_Date. We typically do not see users changing the Tax_Date to be something different than the document date. If yours appear different, this may cause your summary and detail reports to be off/different.