Close

How satisfied are you with our online help?*

Just these help pages, not phone support or the product itself

0
1
2
3
4
5
Very dissatisfied
Very satisfied

Why did you give this rating?

Anything else you want to tell us about the help?

You can import data such as a list of customers and suppliers (your cards list), items you stock and a list of your accounts. The way you import is the same for all data types, you use the Import/Export Assistant and choose the type of data you want to import.

This information is for importing data into AccountRight 2015 or later. See the relevant topic for importing data into:

 

If you're importing from another MYOB company file or software such as Microsoft Excel, you'll need to export the data you want from the program you’ve used to create the data and save it in a tab-delimited or comma-separated text file.

Need help moving to AccountRight from a different program?

Check out our Product Migration Services (Australia | New Zealand).

For the import to work successfully, the data you import needs to meet the import rules and formats required for each field.

 

What can I import?

To find out what can be imported, open the Import/Export Assistant (go to the File menu > Import/Export Assistant > Import data > Next). Click the dropdown arrow next to the Import field to see the list.

Import and export assistant window with dropdown list showing import options

Other things you can import

There are some things you can import into AccountRight without using the Import/Export Assistant.

To importDo this
customised forms (from another AccountRight 2011 or later company file)

Go to Setup > Import Customised Forms.

For more information, see Sharing forms with other company files.

customised forms (from AccountRight v19 or earlier)

Go to File > Migrate Custom Forms.

For more information, see Upgrade task - migrating personalised forms.

an accounts list (from MYOB Accountants Office)

Go to File > AccountantLink > Receive From Accountant > Accounts List.

For more information, see Importing an accounts list from MYOB Accountants Office.

bank transactions

Use bank feeds to automatically bring your bank transactions into AccountRight. Alternatively (or to bring bank transactions into AccountRight from before your bank feeds are set up), import a bank statement downloaded from your bank.

Go to Banking > Reconcile Accounts > Get Statement. Statements must be in OFX, QFX, QIF or OFC format.

For more information, see Importing a bank statement.

contacts from Microsoft Outlook

Go to Card File > Cards List > Synchronise Cards.

For more information, see Synchronising cards with Microsoft Outlook.

Using an import template

You can create an import template by exporting data from AccountRight's sample company file. For example, to create an import template for sales data, simply export sales data from AccountRight's sample company file. The export file becomes your template. All you need to do is open the export file and replace the contents with your data, ready for importing.

For more details, see Using an import template.

 

To import data

To import data

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

  1. Go to the File menu > Import/Export Assistant.
  2. In the Import and Export Assistant window, select Import data and click Next.
  3. Select the type of data you want to import from the Import list.
    Select the type of records you want to import 

    Importing timesheets (Plus and Premier, Australia only)

    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.

  4. Click Browse to locate and select the file you want to import. This needs to be a text file which ends with ".txt", such as ITEMS.TXT.

  5. Click Next.

  6. Select the import file format, the type of the first record, and the method of handling duplicate records.

  7. Click Next and match the import fields with fields in the Available Fields column. To do this:

    1. Click the name of a field in the Import fields column.

    2. Click the matching field in the Available fields column.

      The import field you selected appears in the Matched Import fields column.

      The Addr 1 - Line 1 field is matched. 

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

    3. If all the fields in the import file match those in the Available fields column, including their order, click Match All. If the fields in your import file are not in the same order, click Auto Match to match the fields that have the same names.

  8. Click Next. If you didn’t make a backup prior to starting the import process, click Back up to make one now.

  9. 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, which you can access from the Conclusion step of the assistant.

  10. When the data has finished importing, click Close.