The following AppleScript terms can be used to import and export accounting data to and from MYOB software. Terms displayed in brackets are optional.

export accounts
export accounts allows you to export account data from your MYOB software.

Value syntax

• to string

Name of file to which to export data.

• username string

Username of the data file.

• password string

Password for the data file.

• [separated by tabs/commas]

How data will be separated. Default is "tabs."

• [first record is header/data]

Record type of first record in the file. Default is "header."

• [balances from month of january/february/march/april/may/june/july/august/september/october/november/december]

Indicates from which month you want to export data. Default is the current month.

• [in this year/last year]

Indicates from which fiscal year you want to export data. Default is "this year."

export activities
export activities allows you to export activity data from your MYOB software.

Value syntax

• to string

Name of file to which to export data.

• username string

Username of the data file.

• password string

Password for the data file.

• [separated by tabs/commas]

How data will be separated. Default is "tabs."

• [first record is header/data]

Record type of first record in the file. Default is "header."

export activity slips
export activity slips allows you to export activity slips data from your MYOB software.

Value syntax

• to string

Name of file to which to export data.

• username string

Username of the data file.

• password string

Password for the data file.

• [separated by tabs/commas]

How data will be separated. Default is "tabs."

• [first record is header/data]

Record type of first record in the file. Default is "header."

• [identifiers string]

Specify which transactions to export by their identifiers. No default.

• [dated from date]

Beginning date of a range of transactions to export.

• [dated until date]

Ending date of a range of transactions to export.

export cards
export cards allows you to export card data from your MYOB software.

Value syntax

• of type customer/vendor/employee/personal

Type of card to export.

• to string

Name of file to which to export data.

• username string

Username of the data file.

• password string

Password for the data file.

• [separated by tabs/commas]

How data will be separated. Default is "tabs."

• [first record is header/data]

Record type of first record in the file. Default is "header."

• [identifiers string]

Specifies what cards to export by their identifiers. No default.

• [zip code from string]

Specifies what cards to export by their postal codes. Must also use until parameter (below) with this parameter.

• [until string]

Specifies the end range of postal codes. Must be used with zip code from parameter above.

• [custom list 1 string]

Specifies what cards to export by the contents of their "custom list 1" fields. No default.

• [custom list 2 string]

Specifies what cards to export by the contents of their "custom list 2" fields. No default.

• [custom list 3 string]

Specifies what cards to export by the contents of their "custom list 3" fields. No default.

export items
export items allows you to export item data from your MYOB software.

Value syntax

• to string

Name of file to which to export data.

• username string

Username of the data file.

• password string

Password for the data file.

• [separated by tabs/commas]

How data will be separated. Default is "tabs."

• [first record is header/data]

Record type of first record in the file. Default is "header."

export journal entries
export journal entries allows you to export journal entry data from your MYOB software.

Value syntax

• to string

Name of file to which to export data.

• username string

Username of the data file.

• password string

Password for the data file.

• [separated by tabs/commas]

How data will be separated. Default is "tabs."

• [first record is header/data]

Record type of first record in the file. Default is "header."

• [source journal general/sales/purchases/disbursements/receipts/inventory/all]

Specifies the source journal to export. Default is "general."

• [type disbursements all/spend money/employee paychecks/vendor payments/customer refunds]

Indicates the type of disbursements to export. Default is "all."

• [type receipts all/receive money/customer payments/vendor refunds]

Indicates the type of receipts to export. Default is "all."

• [dated from date]

Beginning date of a range of transactions to export.

• [dated until date]

Ending date of a range of transactions to export.

• [thirteenth period false/true]

Indicates whether the date range specified above is in the 13th period.

export purchases
export purchases allows you to export purchase data from your MYOB software.

Value syntax

• of type service/item/professional/miscellaneous

Type of purchases to export.

• to string

Name of file to which to export data.

• username string

Username of the data file.

• password string

Password for the data file.

• [separated by tabs/commas]

How data will be separated. Default is "tabs."

• [first record is header/data]

Record type of first record in the file. Default is "header."

• [status opened/debit/closed/all bills/orders/quotes/all purchases]

Specifies what sales to export by their status. Default is "all invoices."

• [identifiers string]

Specifies what purchases to export by their identifiers. No default.

• [dated from date]

Beginning date of a range of transactions to export.

• [until date]

Ending date of a range of transactions to export.

export receive money
export receive money allows you to export receive money data from your MYOB software.

Value syntax

• to string

Name of file to which to export data.

• username string

Username of the data file.

• password string

Password for the data file.

• [separated by tabs/commas]

How data will be separated. Default is "tabs."

• [first record is header/data]

Record type of first record in the file. Default is "header."

• [dated from date]

Beginning date of a range of transactions to export.

• [dated until date]

Ending date of a range of transactions to export.

• [thirteenth period false/true]

Indicates whether the date range specified above is in the 13th period.

export spend money
export spend money allows you to export spend money data from your MYOB software.

Value syntax

• to string

Name of file to which to export data.

• username string

Username of the data file.

• password string

Password for the data file.

• [separated by tabs/commas]

How data will be separated. Default is "tabs."

• [first record is header/data]

Record type of first record in the file. Default is "header."

• [dated from date]

Beginning date of a range of transactions to export.

• [dated until date]

Ending date of a range of transactions to export.

• [thirteenth period false/true]

Indicates whether the date range specified above is in the 13th period.

export sales
export sales allows you to export sales data from your MYOB software.

Value syntax

• of type service/item/professional/timebilling/miscellaneous

Type of sales to export.

• to string

Name of file to which to export data.

• username string

Username of the data file.

• password string

Password for the data file.

• [separated by tabs/commas]

How data will be separated. Default is "tabs."

• [first record is header/data]

Record type of first record in the file. Default is "header."

• [status opened/credit/closed/all invoices/orders/quotes/all sales]

Specifies what sales to export by their status. Default is "all invoices."

• [identifiers string]

Specifies what sales to export by their identifiers. No default.

• [dated from date]

Beginning date of a range of transactions to export.

• [until date]

Ending date of a range of transactions to export.

import accounts
import accounts allows you to import account data into your MYOB software.

Value syntax

• from alias

File from which to import data.

• username string

Username of the data file.

• password string

Password for the data file.

• [separated by tabs/commas]

How data will be separated. Default is "tabs."

• [first record is header/data]

Record type of first record in the file. Default is "header."

• [duplicates are reject them/update existing record]

Indicates what to do with duplicate records. Default is "reject them."

Result
A list containing records imported without errors, skipped and imported with warnings

import activities
import activities allows you to import activity data into your MYOB software.

Value syntax

• from alias

File from which to import data.

• username string

Username of the data file.

• password string

Password for the data file.

• [separated by tabs/commas]

How data will be separated. Default is "tabs."

• [first record is header/data]

Record type of first record in the file. Default is "header."

• [duplicates are reject them/update existing record]

Indicates what to do with duplicate records. Default is "reject them."

Result
A list containing records imported without errors, skipped and imported with warnings

import activity slips
import activity slips allows you to import activity slip data into your MYOB software.

Value syntax

• from alias

File from which to import data.

• username string

Username of the data file.

• password string

Password for the data file.

• [separated by tabs/commas]

How data will be separated. Default is "tabs."

• [first record is header/data]

Record type of first record in the file. Default is "header."

Result
A list containing records imported without errors, skipped and imported with warnings

import cards
import cards allows you to import card data into your MYOB software.

Value syntax

• of type customer/vendor/employee/personal

Type of cards to import.

• from alias

File from which to import data.

• username string

Username of the data file.

• password string

Password for the data file.

• [separated by tabs/commas]

How data will be separated. Default is "tabs."

• [first record is header/data]

Record type of first record in the file. Default is "header."

• [duplicates are reject them/update existing record]

Indicates what to do with duplicate records. Default is "reject them."

Result
A list containing records imported without errors, skipped and imported with warnings

import items
import items allows you to import item data into your MYOB software.

Value syntax

• from alias

File from which to import data.

• username string

Username of the data file.

• password string

Password for the data file.

• [separated by tabs/commas]

How data will be separated. Default is "tabs."

• [first record is header/data]

Record type of first record in the file. Default is "header."

• [duplicates are reject them/update existing record]

Indicates what to do with duplicate records. Default is "reject them."

Result
A list containing records imported without errors, skipped and imported with warnings

import journal entries
import journal entries allows you to import journal entry data into your MYOB software.

Value syntax

• from alias

File from which to import data.

• username string

Username of the data file.

• password string

Password for the data file.

• [separated by tabs/commas]

How data will be separated. Default is "tabs."

• [first record is header/data]

Record type of first record in the file. Default is "header."

Result
A list containing records imported without errors, skipped and imported with warnings

import pay bills
import pay bills allows you to import pay bills data into your MYOB software.

Value syntax

• from alias

File from which to import data.

• username string

Username of the data file.

• password string

Password for the data file.

• [separated by tabs/commas]

How data will be separated. Default is "tabs."

• [first record is header/data]

Record type of first record in the file. Default is "header."

• [duplicates are reject them/update existing record]

Indicates what to do with duplicate records. Default is "reject them."

Result
A list containing records imported without errors, skipped and imported with warnings

import purchases
import purchases allows you to import purchase data into your MYOB software.

Value syntax

• of type service/item/professional/miscellaneous

Type of purchases to import.

• from alias

File from which to import data.

• username string

Username of the data file.

• password string

Password for the data file.

• [separated by tabs/commas]

How data will be separated. Default is "tabs."

• [first record is header/data]

Record type of first record in the file. Default is "header."

Result
A list containing records imported without errors, skipped and imported with warnings

import receive payments
import receive payments allows you to import payment receipts data into your MYOB software.

Value syntax

• from alias

File from which to import data.

• username string

Username of the data file.

• password string

Password for the data file.

• [separated by tabs/commas]

How data will be separated. Default is "tabs."

• [first record is header/data]

Record type of first record in the file. Default is "header."

• [duplicates are reject them/update existing record]

Indicates what to do with duplicate records. Default is "reject them."

Result
A list containing records imported without errors, skipped and imported with warnings

import sales
import sales allows you to import sales data into your MYOB software.

Value syntax

• of type service/item/professional/timebilling/miscellaneous

Type of sales to import.

• from alias

File from which to import data.

• username string

Username of the data file.

• password string

Password for the data file.

• [separated by tabs/commas]

How data will be separated. Default is "tabs."

• [first record is header/data]

Record type of first record in the file. Default is "header."

Result
A list containing records imported without errors, skipped and imported with warnings

import spend money
import spend money allows you to import spend money data into your MYOB software.

Value syntax

• from alias

File from which to import data.

• username string

Username of the data file.

• password string

Password for the data file.

• [separated by tabs/commas]

How data will be separated. Default is "tabs."

• [first record is header/data]

Record type of first record in the file. Default is "header."

• [duplicates are reject them/update existing record]

Indicates what to do with duplicate records. Default is "reject them."

Result
A list containing records imported without errors, skipped and imported with warnings