MYOB to QuickBooks Conversions Presented by Alex Wild

1. MYOB to QuickBooks ConversionsPresented byAlex Wild

2. Overview • What can you convert? • How do you do it? • Where can I get this?

3. What can you convert? • Card Files – Lists • Transaction data (not using this converter) MYOB converter will be loaded on the PSG page of the quicken.co.nz website next week.

4. Why should we convert an MYOB client to QuickBooks? • For improved reporting & management • Inventory & UOM flexible in QuickBooks • More detailed price levels • Reckon Online

5. So… what do we do?

6. Step 1 – Create a new QB Data file

7. Step 1 Cont’d – Skip Interview

8. Step 1 Cont’d – Enter details

9. Step 1 Cont’d – Chose Business type

10. Step 1 Cont’d – Chose first month of the financial year

11. Step 1 Cont’d – Select your Industry Select ‘Other/None

12. Step 1 Cont’d – Dave your company file Once you have saved and created your QuickBooks file, Close out of QuickBooks Save your database, you can save this anywhere you like.

13. Step 2 – Export your lists from MYOB • From the File menu choose each list one by one that you want to export and save the exported items. • You must export the Account List and the Non-Consolidated Tax Code List. • Don’t change the default names.

14. Step 2 Cont’d – Export Settings • Select the month that you want the balances to come across from • Use the default file name when saving the export file

15. Step 2 Cont’d – Match All • Select Match All and export • Save the export file somewhere easy to find.

16. Step 3 – Export your Balances • Open Receivables Reconciliation Summary report • Customise to the closing date of the old file • Select Send to Tab Delimited Text File • Repeat for the Payables Reconciliation Summary report • Repeat for the Analysis Inventory Summary report Customer Balance: custbal.txt Supplier Balance: suppbal.txt Inventory Balance: Inventory.txt

17. Step 4 – Clean up the MYOB Lists in Excel • Open the Lists in excel and tidy up the information. • Remove the MYOB tax codes and replace with QB Tax codes • Delete any inactive or old items. • Use this as a good excuse to have a full clean out of your lists.

18. Step 5 – Install the MYOB Converter • The MYOB converter will be on the PSG page on the Quicken website next week!

19. Step 6 – Setup the conversion process • Select the Wizard Mode Preference • Select Apply

20. Step 6 Cont’d – Select the QuickBooks data file • Select the blank data file you created, Select Open. • Select the location for the IIF file to be saved to.

21. Step 6 Cont’d – Account Preferences Enter the name of the GST account used in MYOB to ensure the balance is mapped correctly.

22. Step 6 – Date Preferences

23. Step 7 – Convert Lists into .IIF formats

24. Step 7 Cont’d – Convert Lists to .IIF Format Ensure you have met all the conversion requirements

25. Step 7 Cont’d – Convert Lists to .IIF Format Accept Account List and choose next

26. Step 7 Cont’d – Convert Lists to .IIF Format Select the Account List you have previously exported from MYOB and select Open

27. Step 7 Cont’d – Convert Lists to .IIF Format The MYOB data converter will go through and convert all lists automatically and will create an IIF file called datastore.iif. The path to this file will be displayed in the message.

28. Step 8 – Import the data into QuickBooks Don’t use step 4 of the data converter, you need to import the IIF file manually

29. Step 8 – Import the data into QuickBooks Open your blank QuickBooks database and import the IIF File: File  Utilities  Import  IIF Files

30. Step 9 – Check your lists Check your imported data

31. Step 10 – Final Notes • Set up your QuickBooks preferences • Set up your users and passwords • Set up templates DONE!

32. Questions