G/L Accounts

G/L Account Columns: gType,CA_FULL_ACCT,CA_EXTERNAL_ACCT,CA_DESCRIPTION,CA_POSTING,CA_LEVEL

CA_FULL_ACCT = account number WITHOUT any dashes in it. If you add formatting to this field, the record will not be imported. Easiest to just import the CA_EXTERNAL_ACCT as a formatted field, and the import routine will set the CA_FULL_ACCT for you.

Account Types (gType)

• 1, Asset
• 2, Liability
• 3, Equity, Capital
• 4, Income, Revenue
• 5, Cost of Goods
• 6, Expenses
• 8, Other Income, Other Revenue
• 9. Other Expenses

Account Setting (CA_POSTING)

• 0 = Detail - default value for new records
• 1 = Posting

Reporting Level (CA_LEVEL)

• 1 = default value for new records
• 2
• 3
• 4

Unless specified, the External Account Number will default to the Account Number