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