Skip to content

Importing and exporting data

You can take data entered in your company file and use it in other software or in other company files. This process is called exporting data. You can also take data entered in other software programs and incorporate it into your company file, or incorporate information from one company file into another company file. This process is called importing data.

What can be imported and exported?

The following table lists the record types that you can import and export, along with the field specifications for the different types of records.

Need to import/export customised forms? See Sharing forms with other company files.

Record types

Field specifications

Notes

Accounts

 

Accounts list

 

Budgets

 

Activities

Activities

Plus, Premier only

Activity slips

Activity slips

Plus, Premier only

Cards

Customer cards

Supplier cards

Employee cards

Personal cards

 

Contact logs

Contact logs

 

Custom lists

Custom lists

 

General journal entries

General journals

Including Tax/GST information and BAS/GST reporting

Inventory adjustments

Inventory adjustments

Not Basics

Items

Items

 

Jobs

Jobs

 

Pay bills

Pay bills

Can only be imported 

Not Basics

Purchases




Service purchases

Not Basics

Item purchases

Professional purchases

Miscellaneous purchases

Receive payments

Receive payments

Can only be imported

Receive money

Receive money

 

Sales

Service sales

 

Item sales

 

Professional sales

 

Time billing sales

 

Miscellaneous sales

 

Spend money

Spend money

 

Tax/GST code list

Tax/GST code list

 

Timesheets

Timesheets

Plus and Premier, AU only

Transaction journal entries

Transaction journals

Excluding Tax/GST information and BAS/GST reporting.

Import/export FAQs

How do I import or export data?

AddAdd

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

How do I import from Retail Manager?

AddAdd

We've put together the Accounting Integration Guide to step you through integrating MYOB RetailManager and MYOB accounting software.

The Guide includes:

  • required setup

  • the integration process

  • troubleshooting integration issues.

What is the required import file format?

AddAdd

AccountRight can import comma separated or tab delimited text files (.txt). The best way to ensure an import file is in the right format, create 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.

How do I troubleshoot an import issue?

AddAdd

If you're getting errors or warnings when importing, check the import log.