General Ledger Account Import Format

A

1

General Ledger Account Number

29

Character

Yes

Enter the general ledger account number unformatted (no hyphens, spaces, or periods).

B

2

Description

60

Character

Yes

Enter a description of the general ledger account. The description is displayed in the software and on reports.

C

3

Detailed Description

600

Character

No

Enter a detailed description of the general ledger account.

D

4

Account Type

2

Character

Yes

Enter the general ledger account type. You must enter one of the following two-letter values:

• AS - Asset

• EQ - Equity

• EX - Expense

• IC - Income

• LI - Liability

• SM - Summary (for reporting use only)

• ST - Statistical

This field cannot be changed later.

E

5

Category

45

Character

Yes

You must enter one of the defined general ledger categories. The category can be changed later to a different category. For more information on general ledger categories, see General Ledger Category Maintenance.

F

6

Default to DR/CR

2

Character

No

Enter DR or CR. This field cannot be changed later.

If this field is blank, it defaults to CR.

G

7

Statistical Unit of Measure

2

Character

No

Enter a statistical unit of measure for a statistical account.

H

8

Allow General Ledger Manual Posting

7

Character

No

Enter Yes if users can manually post journal entries for the account.

Enter No if users cannot manually post journal entries for the account.

Enter Warning if a warning is displayed when users manually post journal entries for the account.

If this field is blank, it defaults to Yes.

I

9

Profit Category Code (Customer)

12

Character

No

Enter a customer scorecard profit category code for the general ledger account. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.

J

10

Profit Subcategory Code (Customer)

12

Character

No

Enter a customer scorecard profit subcategory code for the general ledger account. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.

K

11

Profit Category Code (Supplier)

12

Character

No

Enter a supplier scorecard profit category code for the general ledger account. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.

L

12

Profit Subcategory Code (Supplier)

12

Character

No

Enter a supplier scorecard profit subcategory code for the general ledger account. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.

M

13

Profit Category Code (Product)

12

Character

No

Enter a product scorecard profit category code for the general ledger account. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.

N

14

Profit Subcategory Code (Product)

12

Character

No

Enter a product scorecard profit subcategory code for the general ledger account. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.

O

15

Set Default Category

3

Yes/No

No

Enter Yes if you want to make the imported account the default account for its category. For more information on setting up default accounts for categories, see System General Ledger Account Maintenance.

P

16

Account Currency

8

Character

No

Enter the currency for the general ledger account. You can only change the currency for consolidation ledger accounts or for functional ledger accounts without existing unvoided transactions in the following categories:

• A/P Other

• A/R Other

• Cash

• Other Assets

• Other Liabilities

For information on setting up currencies, see Currency Maintenance.

Q

17

Use Historic Rate

3

Yes/No

No

Enter Yes to use the historic exchange rate for the account. This field is only used if the account currency is not the same as the currency for the ledger.

Note If you enter Yes for this field, the account is not automatically revalued when revaluation is performed in Foreign Currency Revaluation, and manual journal entries must be created for revaluation.

R

18

Currency Gain/Loss Type

10

Character

No

Enter one of the following gain/loss type values to indicate which other account to use when revaluing the account:

• Realized

• Unrealized

S

19

Automatically Reverse Foreign Exchange Entries

3

Yes/No

No

Enter Yes if you want the system to automatically create reversing entries for currency exchange gain/loss journal entries for the account.

T

20

Bank Account Number

20

Character

No

Enter the unique bank account number associated with the account if it is a cash account.

U

21

ABA Routing Number

20

Character

No

Enter the bank ABA routing number for the account.

V

22

Minimum Account Balance

15

>>>>>>>>>>>9.99

No

Enter the minimum account balance if the account is a cash account. If the account balance is below this amount, the balance is highlighted on the Results tab in Cash Flow Management Analysis when performing cash flow analysis for the account.

W

23

Maximum Account Balance

15

>>>>>>>>>>>9.99

No

Enter the maximum account balance if the account is a cash account. If the account balance is above this amount, the balance is highlighted on the Results tab in Cash Flow Management Analysis when performing cash flow analysis for the account.

X

24

No

This field is not used. Leave this field blank.

Y

25

No

This field is not used. Leave this field blank.

Z

26

No

This field is not used. Leave this field blank.

AA

27

No

This field is not used. Leave this field blank.

AB

28

No

This field is not used. Leave this field blank.

AC

29

No

This field is not used. Leave this field blank.

AD

30

Default Output VAT Account

29

Character

No

Enter a valid default output VAT account to use for accounts receivable transactions for the account. This field is only used for A/R Discount, A/R Trade, and A/R Write-Off accounts.

Note This overrides the default output VAT account set up in Tax Control Maintenance.

AE

31

Default Accounts Payable VAT Account

29

Character

No

Enter a valid default general ledger VAT account to use when entering a voucher for the account. This account is used when automatically entering VAT entry lines for accounts payable vouchers. This field is only used for A/P Trade category accounts.

Note This overrides the default accounts payable VAT account set up in Tax Control Maintenance.

AF

32

Default Accounts Payable Country

10

Character

No

Enter a valid default country to use for voucher entry for the account. This field is only used for A/P Trade category accounts.

Note This overrides the default country set up in Tax Control Maintenance.

AG

33

Default Accounts Payable VAT Class Code

30

Character

No

Enter the default VAT class to use for accounts payable transactions for the account. For information on setting up VAT classes, see VAT Class Maintenance. This field is only used for A/P Trade category accounts.

Note This overrides the default VAT class set up in Tax Control Maintenance.

AH

34

Default Accounts Payable VAT Exempt Reason Code

20

Character

No

Enter a valid default VAT exempt reason to use for accounts payable vouchers for the account that are exempt from VAT. For information on setting up VAT exempt reason codes, see VAT Exempt Reason Maintenance. This field is only used for A/P Trade category accounts.

Note This overrides the default reason set up in Tax Control Maintenance.

AI

35

Use VAT Status

3

Yes/No

No

Enter Yes to allow users to specify VAT status codes when using the account for voucher entry. This field is only used for A/P Trade category accounts.

Note This overrides the default setting in Tax Control Maintenance.

AJ

36

Bank Account Name

40

Character

No

Enter the bank account name for the account if it is a cash account.

AK

37

IBAN

40

Character

No

Enter the International Bank Account Number (IBAN) for the account if it is a cash account.

AL

38

Bank Code

12

Character

No

Enter a valid bank code for the account if it is a cash account. For information on setting up bank codes, see Bank Code Maintenance.