Share this content

MTD Advice using Proprietary MySQL system.

Looking to find out if I can use CSV files with Sage to submit VAT and Tax

We run a small business and I have built bespoke in house system that uses MySQL as the database, we have records of all our jobs, customers and invoices etc on this.  Recently I decided that we should set up our accountancy using this system (we currently use Excel and do it all manually) then MTD comes along. 


My question is: MySQL can export to CSV, XML etc, am I right in thinking that the way to go is to import this file into a program like Sage and submit from there? Is that overkill? If it is the right route then I need to figure out all the necessary fields names etc.

I might be completely out of my depth here but our plan is to subscribe to Sage and, for the first year, double up i.e. do all the entries in both systems and see if there is a way of going from there.

Any advice would be greatly appreciated.



Please login or register to join the discussion.

17th Apr 2019 11:23

If you've built the system yourself and are confident in the technologies involved, you could always look into implementing the HMRC API in your own system and have it interface directly.

I have no idea how much is involved in doing this but there's a poster on here who's designed and built MTD software who might be better placed to advise.

Failing that, your best option for now is to export to CSV and get bridging software, rather than Sage. It's much simpler and cheaper and should give you at least a couple of years of compliance.

Thanks (0)
17th Apr 2019 13:03

This is the sort of thing that bridging software is designed for.

Thanks (0)
17th Apr 2019 14:46

Bridging Software. £50. Job done

Thanks (0)
18th Apr 2019 12:11

Thank you for the replies, we will probably run Sage for the first year to give us confidence in compliance but I'd like to know a lot more about bridging software.

Does bridging software essentially convert the csv format to the appropriate naming conventions?

Any reccomendations on Bridging software?

Thanks (0)
to AcornCreative
01st May 2019 15:30

As others have suggested, bridging software is what you require. Introducing a full blown accounting package like Sage is overkill and money wasted if you use spreadsheets and MySQL to keep your business records. Our bridging software (Easy MTD VAT - costs as little as £0.99 to submit a return to HMRC (you can view obligations, liabilities and payments without cost) and it can take VAT figures stored in Excel and a CSV.

As for your comment about compliance, any software that is listed on the HMRC software list is compliant. If it wasn't and if it hadn't been used to submit a return successfully it wouldn't be there.

If you're wondering why Easy MTD VAT isn't on the list (as of today), we're waiting for HMRC to put us there. As you know, HMRC don't tend to accomplish things quickly but we're hoping to be up there any day now :)

Thanks (0)
Share this content