Accounts Fields

Importing and Exporting Overview > Importing data into MYOB Accounting Plus > Importing and exporting fields> Accounts Fields

Field

Description and Character Limits

*Account Number

5 characters, numeric. May (optionally) have a non-numeric separator between the first digit and the last 4 digits, for example, 1-1234.

Account Name

30 characters, alphanumeric.

Header

1 character. Any non-blank character signifies that it is a header account.

Balance

15 characters (including numbers, pound signs, commas, negative signs). If no decimal entered, Accounting Plus appends .00. If more than 2 decimal places, Accounting Plus rounds to nearest cent.

When exporting, Accounting Plus exports the balance shown in the Current Balance field of each account.

When importing, Accounting Plus enters the balance in the Opening Balance field of each account.

Chebank Privileges

1 character. Any non-blank character signifies that the account has chebank privileges (if this is an asset account) or credit card privileges (if this is a liability account).

Last Cheque Number

7 characters, alphanumeric

Currency Code

3 characters, alpha. Must match a preexisting currency code in the Currency List. If a foreign currency account, must have an exchange account specified.

Exchange Account

5 characters, numeric. May (optionally) have a non-numeric separator between the first digit and the last 4 digits, e.g., 1-1234. Must be a local currency account. Must be same account type (Asset, Liability, etc.) as the foreign currency account.

Inactive Account

If the field is blank or the letter N appears in the field, the account won't be marked; the account will have an active status.

If the field contains a Y or any non-blank character (other than N), the account will be marked; the account will have an inactive status.

For information about updating the status of existing records, see Updating the status of cards, items, activities or accounts.

*This is a required field for importing.