The Book-keepers Forum (BKF)

Post Info TOPIC: MTD excel spreadsheet convert to csv file.


Veteran Member

Status: Offline
Posts: 50
Date:
MTD excel spreadsheet convert to csv file.


Hi all,

I have been using  software to calculate  vat for those clients operating retail vat schemes.   Let down by the lack of forthcoming updates to comply with MTD,   I have madly been looking into alternatives.   

 

I have been working on producing returns via excel  for these clients,  all seems well and they are producing accurate returns.   If I convert my VAT 100 form to a csv file  will I be able to submit this to HMRC? 

 

Thank you in advance for any input.

 

Julie



__________________

Domino VAT Accounting Ltd



Master Book-keeper

Status: Offline
Posts: 7564
Date:

Hi Julie
The numbers from the excel sheets will need to be linked digitally - this can be done via bridging software (some free, some with fees - none really recommended as yet given the circumstances)

__________________

Joanne  

Fallows Hall Ltd 

Winner - Bookkeeper of the Year 2015, 2016 and 2017

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

 



Veteran Member

Status: Offline
Posts: 50
Date:

Thanks Joanne, Will have to have a look around for bridging software !! What a phaff.

__________________

Domino VAT Accounting Ltd



Master Book-keeper

Status: Offline
Posts: 2939
Date:

Hi Julie

These are the ones I know about that are free or low cost.  

Vitaltax  FREE  https://vitaltax.co.uk/

VAT Direct  FREE  https://www.vat.direct/

Avalara  FREE  https://www.avalara.com/simplify/en/eu/avalara-mtd-filer.html

NJ Technology  £40 + VAT https://www.neilsonjamestech.co.uk/

 

However, if you already use Taxfiler, they now have bridging software.  Add the VAT number to the clients list and you can import an excel sheet or paste from clipboard 

Just out of interest what software are you using?



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Master Book-keeper

Status: Offline
Posts: 7564
Date:

I keep forgetting that taxfiler now have bridging software.



__________________

Joanne  

Fallows Hall Ltd 

Winner - Bookkeeper of the Year 2015, 2016 and 2017

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

 



Veteran Member

Status: Offline
Posts: 50
Date:

Thanks John, Will check them out. Depending on the clients preference I use a combination of Xero, Sage, VT, Moneysoft, these are for straightforward VAT clients. No problems with these, moved my first client over to MTD this week as they require monthly returns. My main problem has been with my retail VAT scheme clients as the software is bespoke. I have sussed how to produce accurate returns via excel hence my enquiry about csv files. Will certainly check out list, many thanks. Julie

__________________

Domino VAT Accounting Ltd



Expert

Status: Offline
Posts: 1676
Date:

The free ones suggested above seem (at a very quick skim read of their pages) to *require* Excel, because they provide an add-in.

In the discussion on the El Reg news item I posted t'other day about MTD submissions going pear shaped, someone mentioned their own low-cost solution and I asked for the link: www.xlvat.com

The advantage of this one (as well as being low-cost) is that although it's based around submitting via an Excel spreadsheet, it doesn't need users to install an add-in; you upload the spreadsheet to their server. This means you can use alternative spreadsheets, such as LibreOffice Calc, saving the file in XL format - or even save the VAT return from your accounts software as an Excel sheet if it allows you to (Sage does, for example).



__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Veteran Member

Status: Offline
Posts: 50
Date:

Thanks Vince,

I have had a quick look at Johns suggestions this morning and will add yours to the mix. Will advise once I have found something I feel comfortable with !!

__________________

Domino VAT Accounting Ltd



Master Book-keeper

Status: Offline
Posts: 7564
Date:

Good point about add ins Vince.

I have some Open Office files, although I went back to excel when I started to use the VT addins.



__________________

Joanne  

Fallows Hall Ltd 

Winner - Bookkeeper of the Year 2015, 2016 and 2017

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

 



Newbie

Status: Offline
Posts: 1
Date:

POSTER REMOVED THEIR OWN POSTS.

This post will be allowed to remain as a marker to the responses that followed. other posts will be removed.

Posters account has been cleared of all VEIS.



-- Edited by Shamus on Tuesday 25th of June 2019 05:58:10 PM

__________________


Master Book-keeper

Status: Offline
Posts: 7564
Date:

VEIS disguised as being helpful, whilst its a topic that is on trend this is clearly just link building!

Clearly not read the rules of the site, thin edge if we start allowing software companies to dump stuff.

Of course, we all know buyer beware and self recommendation is to be ignored.


Cannot see you on the HMRC list
https://www.gov.uk/government/publications/vat-returns-and-ec-sales-list-commercial-software-suppliers/vat-commercial-software-suppliers

Of course many companies providing software are cloud based so you dont necessary need an app.

Plus you dont need excel or csv to use many of the offerings out there. You can use google sheets, open office etc with many.



__________________

Joanne  

Fallows Hall Ltd 

Winner - Bookkeeper of the Year 2015, 2016 and 2017

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

 



Master Book-keeper

Status: Offline
Posts: 2939
Date:

Cheshire wrote:

VEIS disguised as being helpful, whilst its a topic that is on trend this is clearly just link building!

Clearly not read the rules of the site, thin edge if we start allowing software companies to dump stuff.

Of course, we all know buyer beware and self recommendation is to be ignored.


Cannot see you on the HMRC list
https://www.gov.uk/government/publications/vat-returns-and-ec-sales-list-commercial-software-suppliers/vat-commercial-software-suppliers


Strange, it's not on your link Joanne, but is on this one https://www.tax.service.gov.uk/making-tax-digital-software, under VAT MTD for IOS and VAT MTD for Mac OS. I'm wondering if your list is out of date, as Taxfiler isn't on there either.  

ALthough we've not conversed, Darren posts on ukbusiness forum.  I wouldn't say the post is VEIS but it's certainly link building. The XLVAT that Vince posted upthread is a fraction of the cost and does the same thing.

 



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Master Book-keeper

Status: Offline
Posts: 7564
Date:

Leger wrote:
Cheshire wrote:

VEIS disguised as being helpful, whilst its a topic that is on trend this is clearly just link building!

Clearly not read the rules of the site, thin edge if we start allowing software companies to dump stuff.

Of course, we all know buyer beware and self recommendation is to be ignored.


Cannot see you on the HMRC list
https://www.gov.uk/government/publications/vat-returns-and-ec-sales-list-commercial-software-suppliers/vat-commercial-software-suppliers


Strange, it's not on your link Joanne, but is on this one https://www.tax.service.gov.uk/making-tax-digital-software, under VAT MTD for IOS and VAT MTD for Mac OS. I'm wondering if your list is out of date, as Taxfiler isn't on there either.  

ALthough we've not conversed, Darren posts on ukbusiness forum.  I wouldn't say the post is VEIS but it's certainly link building. The XLVAT that Vince posted upthread is a fraction of the cost and does the same thing.

 


 Oops, I just did a google search!  I have the darned thing in my faves somewhere amongst a million and one other things.  Thanks for the latest link though.

Personally have to disagree about the VEIS. They would all be at it!   Its not so bad if someone on here recommends them or mentions their product but they have not had the site's permission to post.   



__________________

Joanne  

Fallows Hall Ltd 

Winner - Bookkeeper of the Year 2015, 2016 and 2017

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

 



Master Book-keeper

Status: Offline
Posts: 2939
Date:

Hi Darren

VEIS is very easily identifiable spam (I think)  It's an acronym invented by us a long while ago to warn about spam or potential spam..  Like I said, I don't think your post is spam, but including your website in the footer of your post is link building. From my understanding links to a posters website are only allowed once the poster is an established contributor. You're more than welcome to stick around and contribute, as I think the brown stuff is about to hit the fan as 7th August looms nearer and nearer, so as a software vendor you could well have something unique to contribute.

I disagree that your software is the only one compatible with MAC OS numbers.  If you read the thread through Vince (VinceH) provided a link to very similar software to yours, called XLVAT.  



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Master Book-keeper

Status: Offline
Posts: 7564
Date:

VATMTD wrote:

I created this app because there wasn't an MTD solution suitable for myself, an Apple MAC user with simple accounts.

I didn't want a cloud solution and didn't like the idea of uploading my accounts to a random website.

I buried my head in the sand when the MTD emails and letters started doing the rounds as i'm sure many others have too.

So i've created a solution that will answer the question Mac users will likely be asking their accountants, yet i'm not allowed to tell anyone about it.

 

It is what it is I guess.


 You can tell people about it on as many other sites as you like, but you have to get permission before dumping your spam on this site. Don't know why you do not get that after me saying it several times.

Just to make this VERY clear:- You need permission BEFORE you post something advertising something!  In fact it is also ONLY long term users and contributors who have the right to advertise their business on here. Those are  the rules of this site.

Despite saying you had removed your link from your profile, you have not. Not a great start when you are trying to build confidence in a brand to go back on what you say, I wouldn't have thought.

Besides the above do you really consider that your target market on this site is correct?  Just how many bookkeepers and Accountants do you think use their iPhone etc to lodge clients vat returns?

 

 

 

 

 



__________________

Joanne  

Fallows Hall Ltd 

Winner - Bookkeeper of the Year 2015, 2016 and 2017

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

 



Master Book-keeper

Status: Offline
Posts: 7564
Date:

VATMTD wrote:

 

Nowhere in these pages does it show my website's URL, so no links are going to be picked up by Google which is what I assume you are accusing me of.


There is a link in your profile.

The 'accusation'   (once again, getting boring now) is not getting the permission of the site to include such advertising link BEFORE the links were posted.

 



__________________

Joanne  

Fallows Hall Ltd 

Winner - Bookkeeper of the Year 2015, 2016 and 2017

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

 



Master Book-keeper

Status: Offline
Posts: 7564
Date:

For the record - for anyone with a MAC, MTD can be submitted via the following (these are just SOME of the products that can be used and took all of two minutes to locate):-

Vital tax
BTC
TaxCalc
Taxoptimers
Liquid Accounts
123e filing
MTDfVAT
VAT Direct

There are more - I cannot read my own scribble on the long list!

I am not endorsing any, apart from perhaps the last one,VAT Direct, from Cirrostratus, but only because Ive run a successful test on it (not for MAC!!) and in all truth because the guy behind it has singlehandedly given answers and fed back issues to/from HMRC on a daily basis for months on end via Accountingweb, without the need to self advertise until way after the pilot when he pops in the odd mention about his software. Its not on every bothering post. Plus his software is currently free and at most 50p next year. He has helped people both online via Aweb and indeed offline and deserves a bloody medal in my book. As opposed to the now daily dumping of ads, like the one above, from the other companies now popping out of the woodwork.

__________________

Joanne  

Fallows Hall Ltd 

Winner - Bookkeeper of the Year 2015, 2016 and 2017

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

 



Forum Moderator & Expert

Status: Offline
Posts: 11634
Date:

VATMTD wrote:
I guess no-one uses a Mac either do they 

Not that I've encountered. biggrin

 

Anyway, I stayed clear as sometimes these things work themselves out and other times they need intervention.

In removing the posts you have broken the thread. Which I now need to fix... Now, I could in this instance put your posts back but I'm not going to as such serves no useful purpose. I will however tidy up the thread so that Julies original questions and the sites responses are not sidetracked.

 

 



-- Edited by Shamus on Tuesday 25th of June 2019 06:36:06 PM

__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Master Book-keeper

Status: Offline
Posts: 7564
Date:

Shamus wrote:
VATMTD wrote:
I guess no-one uses a Mac either do they 

 

 

In removing the posts you have broken the thread. Which I now need to fix... Now, I could in this instance put your posts back but I'm not going to as such serves no useful purpose.

 


 I am looking at them all.....tab back far enough and they are still all there.   Sitting on my PC if you really wanted to add them, but as you say dont really add anything to the OP.



__________________

Joanne  

Fallows Hall Ltd 

Winner - Bookkeeper of the Year 2015, 2016 and 2017

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

 



Forum Moderator & Expert

Status: Offline
Posts: 11634
Date:

Cheshire wrote:
Shamus wrote:
VATMTD wrote:
I guess no-one uses a Mac either do they 

 

 

In removing the posts you have broken the thread. Which I now need to fix... Now, I could in this instance put your posts back but I'm not going to as such serves no useful purpose.

 


 I am looking at them all.....tab back far enough and they are still all there.   Sitting on my PC if you really wanted to add them, but as you say dont really add anything to the OP.


Hi hun, got them all in a word document  thanks biggrin

just deleting / tidying posts and the wee miscreant in me thinks, do I leave Julies "Are you taking the piss?" directly after your post but then thinks, no, I'm rather attached to my wedding tackle and wouldn't like to see anything untoward happen to it!!!

Sorry, tidied away a couple of yours as well that lost meaning once the original messages had been removed



__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Forum Moderator & Expert

Status: Offline
Posts: 11634
Date:

Casu wrote:

Are you taking the piss?


had to remove it from the thread due to where it fell with the posters deletions tidied away but have to say, I love this short response that encapsulates perfectly in five words what others were attempting to convey.

Nice one Casu



__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Master Book-keeper

Status: Offline
Posts: 7564
Date:

Shamus wrote:
Casu wrote:

Are you taking the piss?


had to remove it from the thread due to where it fell with the posters deletions tidied away but have to say, I love this short response that encapsulates perfectly in five words what others were attempting to convey.

Nice one Casu


 I spotted where Caron's comment landed as you were clearing up the mess left by the poster!    Thought it was hilarious.  Nearly answered it with a 'yes, always'.  wink    So your manhood is safe, at least for today!  rofl.gif



__________________

Joanne  

Fallows Hall Ltd 

Winner - Bookkeeper of the Year 2015, 2016 and 2017

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

 



Master Book-keeper

Status: Offline
Posts: 2939
Date:

Cheshire wrote:
I spotted where Caron's comment landed as you were clearing up the mess left by the poster!    Thought it was hilarious.  Nearly answered it with a 'yes, always'.  wink    So your manhood is safe, at least for today!  rofl.gif

 biggrinbiggrinbiggrinbiggrinbiggrin  I won't put the link up but Darren's logo looks very much like a phallic object.  I nearly mentioned it yesterday in a reply but thought it might be a bit below the belt!!



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.

Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  

©2007-2019 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: info@bookcert.co.uk.

Privacy & Cookie Policy  About