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

Nov 05, 2005 3 Replies

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


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

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

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

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required