Importing and Exporting—procedures

Importing Quicken (QIF) transactions

Transactions from Quicken can be imported into your company file. To import Quicken transactions, you must create a Quicken (QIF) file that contains the transactions. (In Quicken, you’ll choose File > Export Custom > Transactions. You’ll then choose the accounts that are associated with the transactions you want to export. For example, you may wish to export your banking and credit card transactions, but not transactions associated with your investment or brokerage accounts. Refer to your Quicken documentation for information about export options and QIF files.)

Associating accounts with your transactions

Your MYOB software checks each account associated with transactions in the Quicken (QIF) file when you import the file. If the Quicken account doesn’t match any account in your company file, the Choose an Account window will appear.

Using the window, you’ll match the Quicken account with an account in your software. If you don’t match an account, one will be created for you using the name of the Quicken account or a default account name.

To import Quicken (QIF) transactions

note : Turn off category tracking

If you selected Category Tracking in the System view of the Preferences window and you’ve selected the Required option, deselect it or turn off the option before importing your QIF information. Otherwise, the import will not be successful.

1	Choose Import Data from the File menu, then choose Quicken (QIF) File from the Import Data sub-menu. A selection window appears.

2	Select the QIF file you want to import. click OK. The import process begins.

Import and export with CaseWare

To export to CaseWare

1	Make a backup of your company file.

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

3	If you want to export journal entries in addition to company and account information, be sure the Include Journal Entries in Export File box is marked. (Keep in mind, however, that exporting journal entries may take some time, and probably will create a very large export file.)

4	From the Dated to End Of list, choose the most recent month you want to include in the file. All journal entries from the first day of the fiscal year through the last day of the month you selected will be included in the text file.

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

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

7	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. (See Preferences in a network environment)

1	Make a backup of your company file.

2	Choose AccountantLink from the File menu, then choose Import from CaseWare from the sub-menu. A standard “Open” dialog box appears.

3	Use the Open dialog box to find the file your accountant has given you.

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

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