You can take data entered in your company file and use it in other software (like Excel) or in other company files. This process is called exporting data. The following video explains how it works. Take a look at this quick overview: HTML |
---|
<p> </p><iframe width="560" height="315"
src="https://www.youtube.com/embed/IEvkNuInhQ0?rel=0" frameborder="0"
allowfullscreen></iframe> |
Export file typeYour company file data can be exported to as either a tab-separated text file or a comma-separated text file:. You can open files in both formats in most common spreadsheet programs, including Excel. contain | These files contain fields that are separated by tab characters. For example, if a tab character appears between Brewster and 300 Roundhill Drive in a file of customer information, the file counts Brewster and 300 Roundhill Drive as two separate fields in a record. Tab-separated files are a common export format in spreadsheet programs. | Comma-separated files |
contain | These files contain records that are separated by commas. For example, if a comma appears between Brewster and 300 Roundhill Drive in a file of customer information, the file counts Brewster and 300 Roundhill Drive as two separate fields in a record. Comma-separated files are often used by popular database programs. |
Who can export data?You need to have been assigned a role that enables you to import or export data. The default roles that give access to the Import/Export Assistant are Administrator and Accountant/Bookkeeper. Learn more about the default user roles. Exporting to another company fileYou can export data such as an accounts list or customer list to import into another AccountRight company file. The procedure below explains how to export data. You'll need to export each type of data separately (for example, your accounts list and then your customer list). Once exported, open the other company file and import the data. Note that there are some fields that must be exported so that your data can be matched to records in your import file. Required fields depend on the type of data you're transferring and are indicated with a caret ^ or asterisks * in the export window. You can choose either comma-separated or tab-separated format. You can export customised forms from one company file to another. For more information, see Exporting and importing personalised formsSharing forms with other company files. Exporting to Accountants OfficeIf your accountant uses MYOB Accountants Office, you can export financial information (including your accounts list, journal entries, BAS information [Australia only], sales and purchases) directly to MYOB Accountants Office as a tab-separated text file. This file can be sent by email or saved to disk. For more information, see Provide information to your accountant. UI Text Box |
---|
|