Importing/Exporting - Account Fields

Accounts Fields

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 have an optional non-numeric separator between the first digit and the last 4 digits (example: 1-1234).

Account Name

30 characters, alphanumeric.

Header

1 character. Any non-blank character signifies a Header Account. A blank indicates 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 2 decimals.
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.)

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 have an optional 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 blank or the letter "N" appears in the field, the account won't be marked; it will have active status.
If the field contains a Y or any non-blank character (other than N), the account will be marked; it will have 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

1 character, alphabetic, 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 have an optional non-numeric separator between the first digit and the last 4 digits (example: 1-1234).
Account Name	30 characters, alphanumeric.
Header	1 character. Any non-blank character signifies a Header Account. A blank indicates 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 2 decimals. 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.)
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 have an optional 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 blank or the letter "N" appears in the field, the account won't be marked; it will have active status. If the field contains a Y or any non-blank character (other than N), the account will be marked; it will have 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	1 character, alphabetic, 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