Importing/Exporting - Account 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.

Account Type

If a Header Account, the field can have the following entries:
Asset
Liability
Capital
Income
Cost of Sales
Expense
Other Income
Other Expense

If a Detail Account, the field can have the following entries:
Bank
Accounts Receivable
Other Current Asset
Fixed Asset
Other Asset
Credit Card
Accounts Payable
Other Current Liability
Long Term Liability
Other Liability
Capital
Income
Cost of Sales
Expense
Other Income
Other Expense

In addition, the first digit in the Account Number field must match the account type:

1 = Asset
1 = Bank
1 = Accounts Receivable
1 = Other Current Asset
1 = Fixed Asset
1 = Other Asset
2 = Liability
2 = Credit Card
2 = Accounts Payable
2 = Other Current Liability
2 = Long Term Liability
2 = Other Liability
3 = Capital
4 = Income
5 = Cost of Sales
6 = Expense
8 = Other Income
9 = Other Expense

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, 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.

Account Type

30 characters, alphanumeric.

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 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.

*This is a 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.
Account Type	If a Header Account, the field can have the following entries: Asset Liability Capital Income Cost of Sales Expense Other Income Other Expense If a Detail Account, the field can have the following entries: Bank Accounts Receivable Other Current Asset Fixed Asset Other Asset Credit Card Accounts Payable Other Current Liability Long Term Liability Other Liability Capital Income Cost of Sales Expense Other Income Other Expense In addition, the first digit in the Account Number field must match the account type: 1 = Asset 1 = Bank 1 = Accounts Receivable 1 = Other Current Asset 1 = Fixed Asset 1 = Other Asset 2 = Liability 2 = Credit Card 2 = Accounts Payable 2 = Other Current Liability 2 = Long Term Liability 2 = Other Liability 3 = Capital 4 = Income 5 = Cost of Sales 6 = Expense 8 = Other Income 9 = Other Expense
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, 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.
Account Type	30 characters, alphanumeric.
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 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.