Importing and Exporting

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

▪	Tax Amount Variance Sales

▪	Tax Amount Variance Purchases

▪	Tax Code Exceptions Invoices

▪	Tax 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 program.)

▪	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).

Using AccountantLink to export your accounting information for use with CaseWare, Ceedata, HandiLedger and Solution 6 MAS

If your accountant uses CaseWare and requests an electronic copy of your accounting records, you can proivide a comma-separated text file of your data that can be read by CaseWare.

Then, if your accountant makes adjusting journal entries that you need to enter in your company file, you can import the journal entries in the comma-separated format.

The AccountantLink function also enables you to export your accounting information for use with Ceedata, HandiLedger and Solution 6 MAS.

If your accountant uses any of these software packages, export your accounting information in the appropriate format and save the file to a disk. Your accountant will then be able to import the information on the disk for use with their accountant software.

To export to CaseWare

1	Make a backup of your company file.

2	Choose AccountantLink from the File menu; then choose Send To CaseWare from the sub-menu. The Export File/Export to CaseWare window appears.

3	When you're ready to create the CaseWare export file, click the Export button.

4	A dialogue box appears, allowing you to enter a name and location for the export file. Make entries in the dialogue box, then click Save to begin creating the CaseWare export file.

5	When the file has been created, you're ready to send the file to your accountant, who can then import it into CaseWare.

6	When you're ready to create the CaseWare export file, click the Export button.

7	A dialogue box appears, allowing you to enter a name and location for the export file. Make entries in the dialogue box, then click Save to begin creating the CaseWare export file.

8	When the file has been created, you're ready to send the file to your accountant, who can then import it into CaseWare.

To import from CaseWare

Please note that this task requires single-user access.

9	Make a backup of your company file.

10	Choose AccountantLink from the File menu, then choose Receive from CaseWare from the sub-menu. A standard “Open” dialogue box appears.

11	Use the Open dialogue box to find the file your accountant has given you.

12	When you locate the file, highlight it and then click Open. The importing process begins immediately.

To export data for use with Ceedata

Please note that this task requires single-user access.

13	Make a backup of your company file.

14	Choose AccountantLink from the File menu and then choose Others. Choose Ceedata from the submenu that appears. The Export File window opens with Ceedata Format as the Export File Format.

15	Select the journal you want to export from the Source Journal menu. You can choose these individually to export each journal as a separate file or you can select All to export all journals as one file.

16	Enter the date range of the transactions you want to be exported.

17	Click the Export button.

A “save” window appears and the file name ceedata.tfr will automatically be entered. You can change the name, if you want, but be sure the extension remains .tfr. When you’re satisfied with the name and location of the file, click OK.

To export data for use with HandiLedger

Please note that this task requires single-user access.

18	Make a backup of your company file.

19	Choose AccountantLink from the File menu and then choose Others. Choose HandiLedger from the submenu that appears. The Export File window opens with HandiLedger Format as the Export File Format.

20	Select the journal you want to export from the Source Journal menu. You can choose these individually to export each journal as a separate file or you can select All to export all journals as one file.

21	Enter the date range of the transactions you want to be exported.

22	Click the Export button.

A “save” window appears and the file name handiled.txt will automatically be entered. You can change the name, if you want, but be sure the extension remains .txt.

To export data for use with Solution 6 MAS

Please note that this task requires single-user access.

23	Make a backup of your company file.

24	Choose AccountantLink from the File menu and then choose Others. Choose Solution 6 MAS from the submenu that appears. The Export File window opens with Solution 6 MAS Format as the Export File Format.

25	Select the journal you want to export from the Source Journal menu. You can choose these individually to export each journal as a separate file or you can select All to export all journals as one file.

26	Enter the date range of the transactions you want to be exported.

27	Click the Export button.

A “save” window appears and the file name solution.txt will automatically be entered. You can change the name, if you want, but be sure the extension remains .txt.