| Author |
Message |
L Mehl
Guest
|
 Posted:
Sat Nov 05, 2005 9:01 am Post subject:
ACCNTTYPE - what values are acceptable? How include a numbe |
|
|
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
|
|
| Back to top |
|
 |
Gary E
Guest
|
| Posted:
Sat Nov 05, 2005 5:01 pm Post subject:
Re: ACCNTTYPE - what values are acceptable? How include a n |
|
|
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
"L Mehl" <mehl@cyvest.com> wrote in message
news:i3Yaf.9094$BZ5.7318@newssvr13.news.prodigy.com...
| Quote: | 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
|
|
|
| Back to top |
|
|
L Mehl
Guest
|
| Posted:
Sun Nov 06, 2005 12:00 am Post subject:
Re: ACCNTTYPE - what values are acceptable? How include a n |
|
|
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 E" <scarecrow_n_ozNOSPAM@yahoo.com> wrote in message
news:l_3bf.510$bS5.173@fe02.lga...
| Quote: | 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
"L Mehl" <mehl@cyvest.com> wrote in message
news:i3Yaf.9094$BZ5.7318@newssvr13.news.prodigy.com...
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
|
|
|
| Back to top |
|
|
L Mehl
Guest
|
| Posted:
Sun Nov 06, 2005 7:14 am Post subject:
Re: ACCNTTYPE - what values are acceptable? How include a n |
|
|
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
"Gary E" <scarecrow_n_ozNOSPAM@yahoo.com> wrote in message
news:l_3bf.510$bS5.173@fe02.lga...
| Quote: | 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
"L Mehl" <mehl@cyvest.com> wrote in message
news:i3Yaf.9094$BZ5.7318@newssvr13.news.prodigy.com...
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
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in