MYOB Endpoint: Accounts

Overview

The MYOB Accounts endpoint allows you to access the chart of accounts located within MYOB.

Note an alternate endpoint named AccountsTable is available which provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.

Fields

The following fields are available for the Accounts endpoint.

DataFile

A record field that identifies the source data file for this record.

UID

A GUID field representing the internal id of an account. This field can be used to link to other endpoints.

Name

A text field used as the account name.

DisplayID

A text field used as the account number.

Classification

A text field that identifies the high-level type of account. Possible values are:

Asset

Liability

Equity

Income

CostOfSales

Expense

OtherIncome

OtherExpense

Type

A text field that identifies the more detailed type of an account. Possible values are:

AccountReceivable

AccountsPayable

Bank

CostOfSales

CreditCard

Equity

Expense

FixedAsset

Income

LongTermLiability

OtherAsset

OtherCurrentAsset

OtherCurrentLiability

OtherExpense

OtherIncome

OtherLiability

Number

A integer field that represents the last digits of an account number that follows the dash. For example, 4-1234 will have a number of 1234.

Description

A text field used as the account description.

ParentAccount

A record field that identifies the parent account of this account.

IsActive

A true/false value that indicates if the account is active and useable within MYOB.

TaxCode

A record field that identifies the default tax code for this account.

Level

A integer field that represents the indentation level of the account within the MYOB chart of accounts. Possible values are between 1 and 4.

OpeningBalance

A decimal field that represents the original opening balance value for this account when first created.

CurrentBalance

A decimal field that represents the closing balance value for this account as at the end-of-time.

BankingDetails

A record field containing banking details of the account (for Bank Accounts only). It provides access to banking information used when creating ABA files or processing bank feeds.

IsHeader

A true/false value that indicates if the account is a header or detail account.

LastReconciledDate

A date field that stores a date of the last time this account and all transactions attached were reconciled.

ForeignCurrency

A record field that identifies the currency used when posting transactions to this account.

LastModified

A date time field that stores the date/time this activity was last modified.

RowVersion

A row version field.

BankingDetails Fields

The BankingDetails field includes the following fields. It provides access to banking information used when creating ABA files or processing bank feeds.

BSBNumber

A text field used to store the BSB number.

BankAccountNumber

A text field used to store the bank account number.

BankAccountName

A text field used to store the bank account name.

CompanyTradingName

A text field used to store the company trading name used on direct credit ABA files.

BankCode

A text field used to store the bank code included on direct credit ABA files.

CreateBankFiles

A true/false value used to indicate if this bank account is used for direct credit ABA files.

DirectEntryUserId

A text field used to store the direct entry user id included on direct credit ABA files.

IncludeSelfBalancingTransaction

A true/false value used to indicate if the direct credit ABA files will include a self balancing transaction line.

StatementParticulars

A text field used to store the statement particulars included on direct credit ABA files.

StatementCode

A text field used to store the statement code included on direct credit ABA files.

StatementReference

A text field used to store the statement reference included on direct credit ABA files.

MYOB API

For a detailed run through of the endpoint, you can see the MYOB API.

Related Fields

Accounts

Currencies

TaxCodes

Related Topics

MYOB Models

MYOB Endpoints