Share this content
23

MTD for VAT - bridging software for Excel users

Is anyone aware of any available solution?

Didn't find your answer?

As the date for the implementation of MTD for VAT draws closer and is apparently actually happening, is anyone aware of any bridging software available that works with the HMRC API and allows data to be submitted from Excel records? HMRC have confirmed that Excel is acceptable in terms of record keeping, but I am drawing a blank in terms of how that data can actually be submitted via the new Agent Services Account for MTD.

The software houses are obviously conflicted here because they would rather we all put clients onto bookeeping software than provide a method to transmit out of our agent / bureau software. But presumably one of them will have to break ranks at some point. Failing that, is anyone developing their own?

Replies (23)

Please login or register to join the discussion.

By Tim Vane
21st Mar 2018 12:56

The only software houses that are conflicted are the ones that provide bookkeeping products. There are lots of tax software providers that will no doubt add this functionality to their products. My belief is that that the likes of taxcalc, btc, digita, taxfiler et al will be releasing addons eventually - they are no doubt being a little cautious in their progress with the deadline at least a year away and HMRC having a bit of a track record when it comes to u-turns...

I suggest you ask your current software provider what their plans are...

Thanks (1)
avatar
By JazzySasha
21st Mar 2018 13:01

I was on a CPD course yesterday - Rebecca Benneyworth told us that there would be bridging software (an Excel add-in) that would cost "about £10" to enable VAT filing from a spreadsheet. HMRC accept that this is required because some bookkeeping software will not handle complex VAT issues such as partial exemption and the bookkeeping data will need to be exported to a spreadsheet and 'manipulated' to obtain the figures for filing.
I don't have any further details such as when this is expected to be available.

Thanks (4)
Replying to JazzySasha:
avatar
By justtoconfirm
21st Mar 2018 13:44

That's interesting and good news thank you. Was the £10 per client / per year?

Thanks (0)
avatar
By cbp99
21st Mar 2018 14:01

This has been mentioned https://www.neilsonjamestech.co.uk/

Thanks (2)
Replying to cbp99:
avatar
By carole.businessheads
13th Jun 2018 17:49

That looks really good on the face of it. And, its developed by the people who created VT, a beautifully simple and inexpensive bookkeeping system that does everything a simple small business needs. Thanks very much cbp99.

Thanks (0)
Replying to carole.businessheads:
avatar
By JohnnhoJ
10th Jan 2019 17:26

VT now offering £75/yr for MTD integrated into VT

Thanks (0)
By jon_griffey
21st Mar 2018 16:05

I seem to recall a mention that Absolute are working on an Excel add-in product.

Thanks (1)
Replying to jon_griffey:
avatar
By NewACA
20th Dec 2018 15:43

Yes, I spoke to Giles Mooney about this on Saturday last week. He said it should be going ahead, their developers are confident they can do it, but no promises. Their current thought is to charge £10/year / client apparently.

EDIT 20/12/2018: I've discovered many other providers eg: https://123sheets.co.uk whom offer what appears to be a more user-friendly interface, a client portal, and also MTD registration support.

Thanks (2)
Replying to NewACA:
avatar
By JohnnhoJ
10th Jan 2019 17:25

123 - currently offering 1/2 price one year at £19.75 plus vat ....offer until end Jan 2019

Thanks (0)
avatar
By junereece
11th May 2018 12:04

Tim Good has advised that Absolute Tax will be developing this product at an affordable price

Thanks (1)
avatar
By Wanderer
11th May 2018 12:17

BTC likewise:-
https://www.btcsoftware.co.uk/mtd-for-vat-vt-users/

The output from VT for MTDfV is really simple and you could easily replicate it in your spreadsheet so should be able to use BTC to file.

Thanks (1)
avatar
By Karina.Harley
15th May 2018 08:54

Hi Justtoconfirm,

Clear Books have developed an online spreadsheet for your clients to use. The expense and income data they enter into the spreadsheet is loaded automatically into fully-featured online accounting software where you can make adjustments and submit quarterly MTD VAT returns to HMRC.

We've just published a video explainer at: https://www.accountingweb.co.uk/community/industry-insights/how-to-use-s...

Check it out and email [email protected] if you wish to demo the software!

Thanks (0)
Replying to Karina.Harley:
avatar
By carole.businessheads
13th Jun 2018 17:57

Hi Karina
We are Clear Books accountants and recall you were developing this but don't recall any announcement that it was available. I'll email you later about it.

Thanks (0)
avatar
By markogrady
08th Jun 2018 20:21

Duplicate Comment

Thanks (0)
avatar
By markogrady
08th Jun 2018 20:20

I have created an excel bridging tool
https://www.taxoptimiser.co.uk/Features/MTDVAT

The video also explain a few of my thoughts on how to be as efficient as possible when processing VAT returns

Thanks (2)
avatar
By David160
04th Oct 2018 14:47
Thanks (0)
avatar
By Dave Frost
07th Feb 2019 17:18

Hi.

Just noticed a reference to the pricing of our bridging software Absolute Excel Vat Filer.

The software in fact costs £40 plus VAT per 10 traders for a 13 month licence and following the successful release last year we have had many users file successfully under the HMRC pilot.

For more information or to see our video showing how easy MTD really is go to;

https://www.absoluteexcelvatfiler.co.uk/pages/absolute-excel-vat-filer

Kind Regards

Dave Frost
Absolute Software.

Thanks (0)
Replying to MadeOfStarStuff:
By Tim Vane
18th Mar 2019 08:19

MadeOfStarStuff wrote:

I've checked out a few desktop versions of MTD bridging software and one or two web based ones. The one I'm sticking with on April 01 is Easy MTD VAT (https://easymtdvat.com).
It works with Excel spreadsheets (which is what I use) and it's a simple solution even for a technophobe like me!

Well you don’t get any marks for the blatant unsubtlety of your spamming, but 10 out of 10 for sheer cheekiness. Love the bit about being a technophobe. Nice touch from a software developer!

Thanks (0)
avatar
By comsci
01st Apr 2019 21:09

As a software developer of 30+ years and since I keep my relatively simple company accounts in Excel / OpenOffice, I too looked for a simple solution and ended up writing my own bridging software.

I have tested it with the HMRC test API's and all appears fine. Once, I have a production ready account from HMRC, I plan to make it available as a free Windows installed application. Free to install and free to use. (Although I might add a link to a voluntary donation to my son's forthcoming humanitarian trip to Malawi in 2020)

More details at http://www.comsci.co.uk/100PcVatFreeBridge.html

No bells and whistles, but should just do the job with minimum fuss!

Thanks (1)
Replying to comsci:
avatar
By justtoconfirm
01st Apr 2019 21:19

Hi comsci, what an amazing gesture in the midst of this fiasco. Just over a year since I posted this originally and even now the system isn’t working right at the HMRC end with some registrations failing for unknown reasons. Hope you’re son is as proud of you as you must be of him!

Thanks (2)
Replying to justtoconfirm:
avatar
By johnhemming
03rd Apr 2019 07:02

I can normally find out why registrations fail. The complexity is that there are two steps. One of registration and one of authorisation. (or Authorization to use the spelling in the protocol definition).

Thanks (0)
Replying to johnhemming:
avatar
By justtoconfirm
03rd Apr 2019 07:44

How do you go about finding out Johnhemming? The problem I’ve had is at the registration stage. Go all the way through the process only to be told at the last step that it’s failed, yet it works for the next client I try.

Thanks (0)
Replying to comsci:
avatar
By vbs3012
02nd Apr 2019 22:29

Thank you. greatly appreciated

Thanks (0)
Share this content