Importing data

Your MYOB software allows you to take data entered in other software and incorporate it into your company file. You can also incorporate information from one MYOB company file into another MYOB company file. This process is called importing data.

Some of the types of information you can import are: accounts, items, nominal journal entries, Receive Payments transactions, Receive Money transactions, Spend Money transactions, Pay Suppliers transactions, sales, purchases, cards, jobs, activities and activity slips.

note : Importing timesheets

When you import timesheets, only the entries that don’t have activity slips associated with them are included. You must import activity slips to complete the process.

The data can be imported from a tab-delimited or comma‑separated text file.

note : [MYOB Accounting Plus only] Single-user access required for data import

You must not import data when more than one user is logged in. For more information, see Single-user file locking for special tasks.

If you are importing journals from your accountant

If you send information to your accountant using the AccountantLink feature (see To export information to accountants), you can import the adjusting journals your accountant sends you. For more information, see To import nominal journals from your accountant.

To import data

Before you start the import process, you will need to export the data you want from the program you’ve used to create the data. The data you want to import must be stored in a tab-delimited or comma-separated file format.

note :  

Before you import data you should make a backup of your company file. See Backing up and restoring company files.

1	Go to the File menu, choose Import Data and then choose the type of data to import. The Import File window appears.

2	Select the import file format, the type of the first record, and, if required, method of handling duplicate records. For more information, see Import File window.

3	Click Continue. The Open window appears.

4	Locate and select the file you want to import and click Open. The Import Data window appears.

5	Match the import fields with the MYOB Plus Fields column (if you’re using MYOB Accounting, the column is labelled MYOB Fields).

a	Click the name of a field in the Import Fields column.

b	Click the matching field in the MYOB Plus Fields column.

The import field you selected appears in the Matching Import Field column.

note : Some fields must be imported

Fields that have an asterisk (*) next to them must have matching import fields assigned to them.

c	Click a field in the Matching Import Field column to remove it.

d	If all the fields in the import file match those in the MYOB Plus Fields column, click Match All to match all fields simultaneously.

6

Click Import to import the data. If you get a warning or an error message indicating that the import was not successful, refer to the import log file in your MYOB software installation folder for a list of errors or warnings. This is a text file—readable by most word processors—that lists the problems encountered during the import.

Related Topics

■	Import and export fields

■	Exporting data

■	Importing data from MYOB RetailBasics