Importing/Exporting - Account Fields

Accounts Fields

To view a list of all types of fields: Field descriptions for importing and exporting

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. A blank indicated a Detail Account.

Balance

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

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

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

Account Type

25 characters, alphanumeric.

See Header Account entries and Detail Account entries for more information about what you can enter in the Account Type field.

Last Check 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 classification (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.

B/Account Number

20 characters, alphanumeric

B/Account Name

20 characters, alphanumeric

Company Trading Name

16 characters, alphanumeric

Description

255 characters, alphanumeric

Classification for Statement of Cash Flow

1character, alpha, for all account types EXCEPT Bank, Income, Expense, Cost of Sales and Header accounts.

Use one of these codes:
O - Operating
I - Investing
F - Financing
E - Exclude from Statement for Cash Flow

Subtotal header Accounts

1 character, alphabetical

Y - yes
N - no

*Required Field: When importing, this field must have a valid matching import field.

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. A blank indicated a Detail Account.
Balance	15 characters (including numbers, currency signs, commas, negative signs). If no decimal entered, AccountEdge appends .00. If more than 2 decimal places, AccountEdge rounds to nearest cent. When exporting, AccountEdge exports the balance shown in the Current Balance field of each account. When importing, AccountEdge enters the balance in the Opening Balance field of each account.
Account Type	25 characters, alphanumeric. See Header Account entries and Detail Account entries for more information about what you can enter in the Account Type field.
Last Check 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 classification (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.
B/Account Number	20 characters, alphanumeric
B/Account Name	20 characters, alphanumeric
Company Trading Name	16 characters, alphanumeric

Description	255 characters, alphanumeric
Classification for Statement of Cash Flow	1character, alpha, for all account types EXCEPT Bank, Income, Expense, Cost of Sales and Header accounts. Use one of these codes: O - Operating I - Investing F - Financing E - Exclude from Statement for Cash Flow
Subtotal header Accounts	1 character, alphabetical Y - yes N - no