Hello,

During a meeting between Janusz (@itronics) and I this last weekend we decided that Janusz should look into this. He already has done a test module. More to come in a while.

/Joe

Just wondered how this was going and if the test module was available for evaluation?
Thanks

I was just looking at the post from @apmuthu about the number of downloads (link below) and it seems UK has one of the high numbers of downloads(and I believe users) who all eventually might need VAT MTD module.

https://sourceforge.net/projects/frontaccounting/files/stats/map?dates=2020-02-04+to+2020-02-06

I see that a number of us started the discussion but, not sure how far we got. I am not tech minded but more than happy to help develop a module which could benefit all. I can definitely help in terms of VAT related calculations etc and little bit of coding.

Hope to hear soon.

Regards,
GJ

My reporting may be slightly different than many others as I use the Cash Accounting Plugin module - Works ok for input and output tax with the exception of tracking Credit notes, which I have to manually adjust at the moment prior to submitting to relevant box. I also have to manually work out Sales and manually work my way through the individual expenses and total for the relevant box. Best solution would really need to encompassed both accrual and cash accounting methods.

I did start to look into an implementation, but ran short of time.... Please keep us informed of progress and method, very happy to help in any way I can.

Many thanks
dls

During a meeting between Janusz (@itronics) and I this last weekend we decided that Janusz should look into this. He already has done a test module. More to come in a while.

/Joe

I have subscribed to HMRC as a developer and read through some of the information, this is an update of my findings so far.
As vernonr suggests they are using OAuth2 in the authorisation/flow process.

The identification of EC VAT Transactions is something I feel we should be able to cope with , maybe with report change and flagging a supplier record as an EC supplier.

Background...

I also have a client that uses a high profile package, and as a result of MTD has had to spend £1500 pa on upgrading the system to a 10 user support contract to get their MTD module, being involved in a couple of the meetings it was frustrating to me and obvious as to why they had implemented in the way they had, and I concluded it was to maximise this opportunity for their financial gain etc. (It may also be they were involved in helping to develop the spec in this direction as part of a software focus group or something.)

Now the above may be true, the reality is that there is a reason why all of the software offerings appear to be based on cloud solutions and monthly fees. The system is designed around a MAN IN THE MIDDLE approach, meaning you communicate your data to an authorised provider/application and that application interacts with the HMRC API on your behalf.

Even the bridging software solutions are the same, and that is why they ask you to create an account with them, I am looking at the suggestion made by dls and this looks to be the best short term quick fix.

https://www.taxoptimiser.co.uk/Features/MTDVAT

Go to the site and watch the video, listen very carefully to the commentary and you will see that the process is,

1) Create an account with them
2) Authorise them to send data to HMRC on your behalf
3) Create a spreadsheet using their template
4) CUT and PASTE your figures into the spread sheet so you have box's 1-9 ready
5) drop the spreadsheet onto their portal, you are logged into, and they will submit it.
6) They will return a confirmation you can save/print.

or www.xlvat.com - another bridging package.

Currently the version of FA I use is 2.3.13. My current process is as follows (already raised by others), when I did my VAT returns I created a spread sheet, filled it with the data from a few FA reports along with any adjustments and then created a subsection for box's 1-9, which I then used when I logged onto HMRC for my VAT account and file the VT100.

So the tax optimiser is the closest solution, reasonably priced and a simple way to comply IN THE SHORT TERM.

WARNING !!!! This is not a long plan, it uses HMRC's 12 month soft landing plan where they allow for a CUT & PASTE operation as a valid digital transfer method. As I read it they are committed to removing this option making it only possible for complete electronic generation of the VAT return in the future.

So we still need a better solution in the next 12 months...… but using bridging software gives us some time.

I would also be interested to know how other people are hosting FA, I am using a wamp installation on a local computer resource, and then logging into it over my local network.  My local server does not have externally facing public domain name (MORE ON THIS IN PART2)

In PART2 I will discuss my progress so far …

ps.. before I get any negative responses I am not affiliated in any way with the taxoptimiser people, it's just the simplest I have seen so far, it's free to start with (just my opinion, please do your own research before making any decisions.)

The reason for this post is to start a more detailed discussion on MTD integration into Front Accounting this is my goal.

I'm also exploring some bridging software via my auditors Deloitte, but would prefer a more seamless integrated solution. Willing to help, but not enough time to fully develop solution.

I'm sure an integrated solution to this would further promote the use of FA in UK... I'm not sure how many UK users there are? It's a great flexible system that continues to evolve, with a fantastic community of support. The more people using it the better for everyone.

If you would like this functionality to be developed, and are willing to contribute to the project (even if in a very small way) please respond here so I can gauge interest!

Dx

Found https://developer.service.hmrc.gov.uk/api-documentation/docs/api/service/vat-api/

The API is fairly simple. There would appear to be 2 issues. One that front accounting needs to have OAuth2 embedded in order to authenticate the HMRC - and the chart of accounts will need to specifically identify those transactions and VAT that relate to other EU countries. So the current Tax Report isn't quite comprehensive enough.

Cheers

I'm happily using front accounting in the UK for 4 small companies. I'd love to stick with it if possible.

Is anyone actively developing an extension to give us the functionality required by HMRC after April? If not, is there a plan to support it in the future?

If nobody has the time to develop it, perhaps we can crowd-fund the development? I for one would be up for contributing financially to such an effort.