You can use the Accountants Export report to export ledger entries from MYOB Essentials Cashbook. The exported file can be imported into other accounting software.
Export formats
You can export data to any of the following formats:
- Text format (AO): Use this for exporting data to Accountants Office, or if you need a simple text-based export file.
- MYE format (MAS): Use this for exporting data to Solution 6 MAS.
- Accounts format (CEEDATA): Use this for exporting data to MYOB AE Accounts.
- Handiledger format (HANDILEDGER): Use this for exporting data to Sage HandiSoft. See
Exporting to Sage HandiSoft
Once you've exported the file to the Handliledger format, you'll need to import it into Sage HandiSoft–you'll need to choose the option to import ASCII data. Then, you'll need map the fields in the two files. Use the mapping table below to help.
| MYOB Essentials Cashbook exported file | Matching field in Handiledger |
|---|---|
| Column 1 | Transaction number |
| Column 2 | Account number |
| Column 3 | Date |
| Column 4 | Description |
| Column 5 | Transaction type |
| Column 6 | Amount |
| Column 7 | Dr Cr Indication |
To create an export file
- Open the cashbook for the relevant business.
- Go to Reports> Accountants Export.
- In the From and To fields, select the appropriate reporting period.
- Click the Download button. If you are asked whether you want to open the file or save it, choose to save the file.