Get started

HTML Wrap

class	section group

HTML
<span data-swiftype-index="true">

HTML Wrap

class	col span_3_of_5

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
Accounts	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.

HTML
<h2><i class="fa fa-comments"></i>  Import/export FAQs</h2><br>

UI Expand

title	How do I import or export data?

How do I import or export data?

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

UI Expand

title	How do I import from RetailManager?

How do I import from RetailManager?

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.

UI Expand

title	What is the required import file format?

What is the required import file format?

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.

UI Expand

title	How do I troubleshoot an import issue?

How do I troubleshoot an import issue?

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

HTML
</span>

HTML Wrap

width	15%
class	col span_1_of_5

HTML Wrap

float	left
class	col span_1_of_5

Panelbox

name	green
title	Related topics

HTML Wrap

class	sidebarlinks

Exporting data

Importing data

Import and export fields

Using an import template

Importing and exporting tips

Opening an export file in Excel

Panelbox

name	yellow
title	From the community

RSS Feed

titleBar	false
max	5
showTitlesOnly	true
url	http://community.myob.com/myob/rss/search?q=import+export&filter=labels%2Clocation%2CsolvedThreads&location=category%3AAccountRight&search_type=thread&solved=true

HTML Wrap

class	morelinks

More »

...

Page tree

Versions Compared

Old Version 52

New Version 53

Key

What can be imported and exported?

How do I import or export data?

How do I import from RetailManager?

What is the required import file format?

How do I troubleshoot an import issue?

Was this information helpful?

Why not?

How would you improve this topic?

Thanks! Anything you'd like to add?

Get started

Company file

Work with others

Banking

Emails & printing

Items

Employees (AU)

Suppliers

Customers

Reporting

EOFY

Tips & tricks