The Bookkeepers.Network (BKN)

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


Veteran Member

Status: Offline
Posts: 36
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: 7457
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: 36
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: 2852
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: 7457
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: 36
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: 1667
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: 36
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: 7457
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.

 

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  

©2018 The Bookkeepers Network (BKN). All Rights Reserved. The Bookkeepers Network (BKN) 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 Bookkeepers Network and BKN 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 Bookkeepers Network. 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 Bookkeepers Network. 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@bookkeepers.network or info@bookcert.co.uk.

Privacy & Cookie Policy