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|
|Activities ||Activities||Plus, Premier only|
|Activity slips||Plus, Premier only|
|Custom lists||Custom lists|
|General journal entries||General journals||Including Tax/GST information and BAS/GST reporting|
|Inventory adjustments||Inventory adjustments||Not Basics|
|Pay bills||Pay bills|
Can only be imported
|Purchases||Service purchases||Not Basics|
|Receive payments||Receive payments||Can only be imported|
|Receive money||Receive money|
|Time billing 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.
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.
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.