Skip to content

Import and export fields

When you import data into AccountRight, it's important to know the required import rules and formats to ensure the import works successfully. For example, import files need to be tab-delimited or comma-separated text files. It's also handy to know how many or what type of characters a field can contain, and whether it can have alpha characters (letters from A-Z), numbers or a mix of both.

If you're exporting data, it's good to know the format of the data you're exporting so that you can use it in other software, such as Microsoft Excel.

When using the Import/Export assistant, pay attention to the field that is marked with an asterisk (*). This must be included and have a valid matching import field. If other fields are marked with a caret (^) they're conditional. This means at least one of these fields (not all) must be included and have a valid matching import field.

Select a field type below to learn about each of the records that can be exported or imported. If you've already done an import and have errors, then the import log helps you work out what went wrong. You can use the details below to learn more about the requirements.

This list is for MYOB AccountRight 2015 and later. If you're using MYOB AccountRight v19 or earlier, see the list for your country version: Australia New Zealand.

When you're ready to go, see the Exporting data or Importing data topics.

Simplify importing by creating a template

You can create an import template by exporting the same type of data from AccountRight's sample company file, Clearwater. You then open the exported file and replace the contents with your data, ready for importing.

For more details, see Using an import template.

Accounts

Activities

Activity slips

Budgets

Cards - customers

Cards - suppliers

Cards - employees

Cards - personal

Contact logs

Custom lists

Items

Inventory adjustments

Jobs

General journal entries

Transaction journals

Pay bills

Purchases - Services

Purchases - Items

Purchases - Professional

Purchases - Miscellaneous

Receive money

Receive payments

Sales - Services

Sales - Items

Sales - Professional

Sales - Time billing

Sales - Miscellaneous

Spend money

Timesheets

Tax/GST code list

Ready to go?

When you're ready to go, see the Exporting data or Importing data topics.

Fields don't match your AccountRight version?

This list is for MYOB AccountRight 2011 or later . If you're using MYOB AccountRight v19 or earlier, see the list for your country version: Australia New Zealand.