1. Home
  2. QuickBooks Discussions
  3. ACCNTTYPE - what values are acceptable? How include a number for a Chart of Account title?

ACCNTTYPE - what values are acceptable? How include a number for a Chart of Account title?

Hello --

I want to import a 250-account chart of accounts into QB Pro 2005.

I used an export of a sample company to see what codes for Account Types were. But ... when I use those values in the import xls file, I get many instances of the error "Type:InvalidAccountType"

for these codes: ASSET CLIAB LTLIAB

The three header rows and the first 2 data rows of the xls file Saved As csv are:

!HDR PROD VER REL IIFVER DATE TIME ACCNTNT ACCNTNTSPLITTIME HDR QuickBooks Pro Version 15.0D Release R6P 1 11/4/2005 1141050000 N 0 !ACCNT NAME REFNUM TIMESTAMP ACCNTTYPE OBAMOUNT DESC ACCNUM SCD BANKNUM EXTRA HIDDEN DELCOUNT USEID WKPAPERREF AsOf ACCNT CASH BANK 0 100000 0 N 0 N 9/30/2005 ACCNT Bank of America Checking BANK 999.99 100100 0 N 0 N

9/30/2005

Can someone tell me where I can find

- the list of valid ACCNTTYPE values

- a good source for learning how to create files for import into QB

Also, I need help coding the import file to include a number for each account in the chart.

Thanks for any help on either one or both questions.

Larry Mehl

Reply to
L Mehl
Loading thread data ...

An easy way to find out would be to create a sample company with every account type that QuickBooks allows. Export that chart of account list, and review it to find your answers.

Gary

Reply to
Gary E

Gary --

Thank you.

I created a company with a few of the account types. When I imported it to another company, some of the codes were rejected.

I will create one as you suggest and see if I can find other ones which will meet my purpose that are accepted.

Larry

Reply to
L Mehl

Gary --

I must have an error in my files.

I exported the 15 account types and imported the resulting iif file into another company ... no errors.

The 15 account type codes are: (sorry for the spacing) ACCNTTYPE DESC

-------------- --------- BANK Bank acct AR AccountsReceivable OCASSET Other Current Asset FIXASSET Fixed Asset OASSET Other Asset AP Accounts Payable CCARD Credit Card OCLIAB Other Current Liability LTLIAB Long Term Liability EQUITY Equity INC Income COGS Cost Of Goods Sold EXP Expense EXINC Other Income EXEXP Other Expense

Larry

Reply to
L Mehl

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.