HandiLedger can import transaction information from MYOB AccountRight.
The import process uses ASCII-formatted files to get the MYOB data files into a format that can be read by HandiLedger, and this requires both a transactions and a chart of accounts data files.
The transaction file is used to bring in the transactions, and the chart of accounts file is used to allocate valid HandiSoft account numbers to MYOB account numbers, to ensure that the importation posts the entries to the correct accounts.
Create the export files in MYOB
The import process requires the export of a transaction (Journal.txt) file and a chart of accounts (Accounts.txt) file.
Note: The export process out of MYOB is current at the time of writing. However, you may need to consult your MYOB user manual or contact their support department for revised or more detailed instructions.
Export transactions from MYOB
From the MYOB File menu, click Export Data and then Transaction Journals.
On the MYOB Export file window, enter the following information:
Export File Format: Comma-Separated
First Record is: Header Record
Source Journal: All Dated From/To: The period you want to export.
Click Continue to proceed to the Export Data window, on the MYOB Export Data window, click Match All so that all fields are exported.
Click Export to create the export file.
In the Save as window select the directory to which the export file is to be saved, and give the file a meaningful name like JOURNAL.TXT.
Click Save.
Export Chart of Accounts from MYOB
From the MYOB File menu, click Export Data and then Accounts.
On the MYOB Export File (Export Accounts) window, enter the following information:
Export File Format:Comma-separated
First Record is: Header Record
Balance from: This Year
Click Continue to proceed to the Export Data window.
On the Export Data window, click Match All to select all the fields for exporting.
Click Export to create the export file.
In the Save as window, select the directory to which the export file is to be saved, and give the file a meaningful name like Accounts.TXT.
Click Save.
Import into HandiLedger
To import the two ASCII files into HandiLedger, both files need to be verified, in particular, the accounts file, to make sure that all postings go to a valid HandiLedger account number.
Verify the account mapping
To map the MYOB accounts to their corresponding HandiSoft accounts.
Log in to HandiLedger and Select or create the entity.
From the Tools menu, point to Import Data from an ASCII File, and then click MYOB Accounting Right/ Accounting Plus.
On the Import Entries window that opens, click Import. (If this is the first time you are importing data for the selected entity, you will be required to select a master map chart type for the entity from which the data is being imported.)
Click OK. The Master Map Chart window will display the list of entity charts for MYOB.
Highlight the required master chart and click Select. The Account Mapping Scheme window will open, listing the accounts in the selected master chart and their corresponding HandiSoft accounts. You can edit these if necessary.
Click Verify. Then enter the location and names of the ASCII import files.
In the Chart File and Transaction File fields, type or select the locations and names of the import files from MYOB.
Click Verify. Accounts that are used in the imported transactions will be displayed in red or blue. Those displayed in red will need to be mapped manually.
In the HS Acct column, click to select a HandiSoft account number for the unmapped (red) entries. These will change to blue once mapped.
Continue mapping accounts until there are no red entries.
The data can now be imported.
Storing the amended account mappings for future use
The account mappings made on the Account Mapping Scheme window can be saved for later use when importing other entities.
On the Account Mapping Scheme window from step eight above, click Store.
On the Store Profile window, enter a suitable name to save the mapping, and click OK.
When you next open the Master Map Chart window, your saved mapping will be listed without - Master, indicating that it is user-defined.
Importing the data
The Account Mapping Scheme window should be open, and have no red entries.
Following on from above, click Run to start the import. The Import Entries window will open, listing the transactions in the import file.
Click Errors to check whether any areas need attention.
Click Close.
Click Yes to the Post imported entries to ledger prompt.
The data should now have been imported into the entity.
Notes:
HandiLedger allocates the transaction numbers from the next available transaction numbers.
If you repeat the process, it will add the transactions again, with the next set of transaction numbers available.