If you are an MYOB or AccountEdge user, you may have noticed that it is next to impossible to export your vital accounting information out of your system. For example, export your items list and there is no stock on hand. Export your customer list and there are no balances. This makes it hard for people to migrate from MYOB into a more modern system.
The converter is a free utility that we provide that will (probably) convert your MYOB or AccountEdge data into a MoneyWorks file! Simply run the converter, choose your MYOB file, set a couple of parameters, and a new MoneyWorks data file will be created with most of your vital accounting information in it (at least that is the theory).
First off, you will need a copy of MoneyWorks Gold (or the MoneyWorks Gold demo) installed on your computer. Then simply download (and, on the Mac, decompress) the MoneyWorks Converter application:
Note that you can put this anywhere on your computer (it doesn't need to be in the Applications or Program Files folder).
Now download and read the MoneyWorks Converter Notes.pdf (about 700kb).
And that in theory is all you need to do. You might at some point want to tidy up your chart of accounts to take advantage of the more powerful concepts available in MoneyWorks.
For more detailed instructions, please download the MoneyWorks Converter Notes.pdf (about 700kb).
If you have used the Converter we would like to hear from you, whether it worked or not. Please let us know how you got on by emailing info at cognito.co.nz.
Is it Guaranteed?
Absolutely not. It is provided on a "best endeavours" basis -- it works for us but may not work for you. In particular there can be so many odd things in an MYOB data file that MoneyWorks just will not let happen, and this may thwart you.
What versions of MYOB or AccountEdge does it work on?
Any version from about 2004 up to and including v19.x. There are a plethora of versions (different for every year and country), and we have tried it with Canadian, US, UK, Australian and New Zealand. In principle it should work for any jurisdiction. Note that it has not been tried on FirstEdge or BusinessBasics files.
It will not work on any versions of AccountRight that use the new database format. This appears to be AccountRight 2012 and later.
My MYOB file has heaps of rubbish in the cards and items file. Should I tidy this up first?
Try just sending it through to MoneyWorks. Maintaining your products and names information in MoneyWorks is much, much easier than in MYOB (for example, you can batch delete).
Where does the MoneyWorks file get created?
It will get created in the same directory as your MYOB file, and will have the same name (but a file extension of .mwd6).
What if I need to do it again?
No trouble -- just run it again (but remember that the previous MoneyWorks file will be over-written, so move it or change its name if you want to keep it for some reason).
Why are some of the products in MoneyWorks showing in Red?
The Converter detected that you had dodgy linked account codes (such as a bank account instead of a cost of sales account), so has replaced the code with something more sensible.
Why are some of the accounts and transactions in MoneyWorks showing in Green?
The Converter detected that these involved a foreign currency. The currency handling under MYOB and MoneyWorks is done differently. You will need to add the appropriate currencies into MoneyWorks (at the last exchange rate used in MYOB), and modify the transactions (they are in the dollar value of the foreign currency, not your local currency). For information on multiple currencies in MoneyWorks please refer to the MoneyWorks Manual (page G253 - available under the Help menu in MoneyWorks).