MYOB Logo

Importing and exporting data > Managing import and export records
Importing and Exporting—procedures
Importing Accounts Lists from an accountant
If your accountant uses MYOB Accountants Office, an accounting solution widely used by public accountants in practice, you can easily import the Accountants Office Accounts List used by your accountant into your company file.
After you import your accountant’s Accounts List, the accounting information you export will match the accounts list used by your accountant; this enables an easy exchange of information from your company file to Accountants Office.
Before you begin the import process, you must obtain from your accountant a text file (files with an extension of .txt) containing an accounts list from Accountants Office. To learn how to create the file, check the Accountants Office documentation.
To import an Accountants Office List of Accounts
1
Choose AccountantLink from the File menu, then choose Receive from Accountants > Lists of Accounts from the submenu. An alert message appears.
2
Click Yes if you want to continue with the importing process. The Open window appears.
3
Select the text (.txt) file that contains the Accountants Office accounts list and click Open.
When the import is complete a message will show the number of records imported. If some records were skipped during the import process, or some other event occurred, a message will appear in this window, indicating that the Import Log report was created.
Exporting information for use with MYOB Accountants Office
You can export your accounting information to a compressed tab‑delimited text file that can be read by MYOB Accountants Office. You can export your accounts list (account number, account name, account opening balance and Accountant Code), journal entries, sales and purchases.
You can also export reports in PDF format that will provide your accountant with additional information and to alert them to any irregularities in the data.
These reports are always included in the export:
▪
Receivables Reconciliation Exceptions
▪
Payables Reconciliation Exceptions
▪
Bank Reconciliation.
These reports are included only if exceptions occur:
▪
Inventory Value Reconciliation Exceptions
▪
GST Amount Variance Sales
▪
GST Amount Variance Purchases
▪
GST Code Exceptions Invoices
▪
GST Code Exceptions Cash.
To export data for use with MYOB Accountants Office
Please note that this task requires single-user access.
1
Click Send to Accountant in the Accounts command centre. The Reporting Period window appears.
2
Select the period of the transactions and reports you want to be exported. (To select a range of months, hold down the mouse button while you move the cursor over the range of months.)
It’s important not to include dates you’ve included in a previous export, since this would result in double-counting your transactions. As a precaution, we recommend that you tell your accountant the period you’ve selected.
3
Choose the method you want to use to send the information.
▪
If you want to send the file as an attachment to an email message, you can enter a linked card in the Linked Card for Accountant field and then click the Email button. (If you’ve entered an email address on the card, the email address will appear automatically when the email is created by your email application.)
▪
If you want to save the file to disk, click the Disk button. A “save” dialogue box appears, allowing you to enter a name and location for the export file. The name that appears automatically is XXX.mye (Company.myo). You can change the file name if you want, but you must use the .mye extension.
4
When you’re satisfied with your entries, click the Save button (Disk) or the Send button (Email).
Related Topics
▪
Records that can be imported and exported
▪
File formats for importing and exporting
▪
Dealing with duplicate records when importing
▪
Import and Export—general topics
▪
Import log
▪
Export options
 
Top of page