Making Tax Digital

December Update

We have been working closely with tax industry leaders to provide K3 SYSPRO customers with the best options to comply with HMRC’s upcoming Making Tax Digital Program for VAT. Through our research, we have identified that each business can have unique tax reporting requirements. We are therefore putting together a Making-Tax-Digital Advisory tool that will guide you to what you need to do to be MTD compliant for the 2019 and 2020 deadlines based on the information you provide through a series of questions. We will be in touch mid January with a link to this advisory tool.

October Update

The HMRC have provided guidelines here for electronic submission of tax returns as part of their Making Tax Digital Program which is effective from the first VAT period following 1 April 2019.

Our understanding of this is as follows:

  • From 2019 you must have a digital record keeping system in use for producing tax records. For SYSPRO customers you are already compliant because you run the SYSPRO ERP solution.
  • From 2019, UK Businesses operating within the thresholds outlined above will have to submit their 9 box VAT return to HMRC via API using either a direct push from their core ERP system or a middleware software tool produced by a third party (such as an Excel add-on tool).
    You will not be allowed to transpose data into any portals manually. What you are allowed to do until 2020 is collect the underlying VAT data for posting using any digital mechanism i.e. Excel linked to an ERP Database, which you can then adjust for ‘off ERP’ VAT adjustment transactions – such as initiatives like ‘cycle to work schemes’ etc.
  • From 2020 all links between the source ERP Tax Transaction and the HMRC VAT submission portal must be digitally linked in nature. So you will not be allowed to amend VAT figures in excel prior to posting.

We would like to understand exactly how our SYSPRO customers are currently creating their HMRC VAT returns to understand whether you are submitting figures direct from K3 VAT100 module (for older versions of SYSPRO) or the SYSPRO 7+ built in Tax Return Reporting which produces the 9 box tax return, or whether you are first adjusting figures in excel.

Please could you confirm this for us by filling in the following 1 question survey. The results will be posted here and updated weekly.


What do you need to do?

K3 are committed to providing our customers with help and guidance to ensure that you are compliant for MTD for VAT.

Andy Latham Chief Technology Officer has stated:  “K3 are currently developing a tax portal on our Imagine platform. The system will enable customers to submit data for HMRC VAT returns. Using K3 DataSwitch integration platform we would anticipate connections to most ERP systems along with functionality to load data via spreadsheets. The system is expected to provide data upload facilities, features for amending the data, preview VAT submissions, audit trails and reports.”

Pricing of the solution will be available once the tax portal has been developed.


Your needs will depend on who you are and your current process:

  1. I am single ERP Company with a requirement to submit 1 VAT Return to HMRC:
    • If you currently transpose your 9 box SYSPRO tax return into the HMRC Portal without any adjustments, then for 2019 – you will need to partner with a solution provider that will allow you to instead pull the 9 box return straight from SYSPRO into a portal for you to review and post to HMRC. K3 will be providing a portal that you can push data into from January 2019.
    • If you currently amend the 9 box SYSPRO tax return (in Excel or other tool) prior to submission for ‘off ERP’ VAT Schemes, then for 2019 – you will still be able to do this, but you will need to find a partner or tool that allows you to map the 9 summary boxes in Excel and post them to HMRC or into a review portal. K3 will be providing such a portal to allow you to post from Excel to Portal to HMRC until 2020. Prior to 2020 you need to engage with us and find out how you get your current ‘off ERP’ VAT schemes posting back into SYSPRO as core transactions, so that they can be picked up by the VAT return reports and processed in SYSPRO.
  2. I am a multi ERP / multi SYSPRO Company with a requirement to consolidate several 9 box returns into a portal that will allow me to submit a single VAT return against my single company VAT Number:
    • From January 2019 you will be able to pass these combined returns digitally into an Excel workbook (or other tool) – as long as you have an add-on for the tool that posts direct – you will be able to post from your own ‘excel model’ the tax return to HMRC. K3 will be providing a portal to allow you to post from Excel to Portal to HMRC until 2020.
    • Please note that for 2020 – you will no longer be able to do this and in 2019 you will need to engage a third party that can consolidate multiple ERP tax data or summaries into a single consolidated portal, which will allow you to review VAT by company, by ERP, in Total and include VAT schemes, prior submissions and view HMRC obligations. K3 will have a tax portal ready by 2020 that will allow you to do just that.
  3. I am a multi ERP / multi SYSPRO Company with a requirement to submit VAT or other live tax data to multiple Countries governments that are already running a digital submission programs (Hungary / Spain / Italy / Latin America):
    • Whilst not really included in the scope of MTD for VAT, there is a requirement from our customers for a solution to the problem of posting multiple tax returns to multiple authorities. K3 has no intention of being the Global Tax submission experts outside of Digital Tax submissions within the UK.
      To this end K3 SYSPRO recommend that our customers engage with the global tax submission experts at Avalara to quote for any particular global tax submission requirement:

We will continue to keep you updated via this blog and our customer newsletter.

August Update

The last update statement on the Making Tax Digital for VAT program was made available on 13th July by HMRC. Although the MTD scheme was not deferred as the analysts originally expected, HMRC have deferred full digital submission and backed down slightly on their aspiration by allowing a year of ‘soft landing’ for submissions – this effectively means you can log on to the new HMRC portal and copy and paste the 9 box Tax return from Excel into the HMRC portal without any risk of reprimand from HMRC.

It’s only from the following year (2020) that a direct software submission will be compulsory.

The 13th of July update and subsequent access granted to the development portal has empowered the software world with the knowledge they need to make the necessary software arrangements to assist their customers with understanding & planning for the change.

There are several fundamental points for businesses and ERP vendors to consider, these will be explored in the next update in September 2018.

Most businesses have a single VAT number and are required to perform a submission of a single 9 box VAT return, but:

  • If the business runs multiple companies or ERP systems which then generate multiple VAT Return reports, the VAT reports then need to be consolidated into a single auditable submission.
    1. This may mean the SYSPRO ERP solution cannot carry the burden of submission as it has no awareness of other ERP’s VAT statuses.
    2. It may be that a middleware product is required to pull the information from multiple ERP’s, then provide a summary for posting.

We will be exploring these options, plus the requirement to collect and post VAT returns digitally into other EU Digital VAT solutions, such as Spain, Hungary & Italy who have already moved to more detailed levels of digital tax and record submission.

We hope to have the next update prepared for the September K3 Customer Newsletter and will be making further announcements at the K3 Customer event in Coventry in October.

March Update

We are starting to receive an increasing number of enquiries asking for confirmation of what K3 and SYSPRO are planning to do in order to assist Businesses with the UK Governments ‘Making Tax Digital Program‘. You will find more on the program here.

The aim of the initiative is to provide businesses of a certain size with the ability to submit their VAT returns electronically from the 2019 Tax Year. The solution is planned to provide the future foundation for UK Digital Tax submissions.

Following the announcement by the UK government’s Public Accounts Committee into HMRC’s performance in 2016/17 there is currently speculation around when the solution will actually be available, the report noted that the “HMRC’s transformation program is not deliverable as planned due to unrealistic assumptions,” and “HMRC again told us that it is not credible to continue with its transformation program as it is.”

At present a mechanism for submitting VAT data is not available to test and the assumption now is that the initiative will not be available until 2020.

What we can confirm is that SYSPRO by design has the inbuilt capability to extract electronic data using the IMPQTS business object and once the MTD platform is available we will have solutions available to allow SYSPRO Businesses to submit their VAT data in a controlled and valid way.


0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *

  • Contact Us

    : Head Offices.
    Baltimore House,
    50 Kansas Avenue,
    Manchester. M50 2GL.
    : +44 (0)161 876 4498
  • Connect With Us

  • Brochure Download