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.