what are the valid accounts types to import the chart of accounts from excel?

Hi, Steve. I'll share with you some information about the valid account types in QuickBooks Desktop (QBDT).

The error you're getting usually happens when the system cannot detect the account type you've added from your Excel Sheet. To isolate the issue, I recommend reviewing your file before adding your accounts to QuickBooks. Please ensure that there are no special or incorrect characters.
 

On the other hand, I'm adding this screenshot to see the supported account types in QBDT.

Additionally, here are some articles that you can refer to learn more about importing files in QuickBooks Desktop:

• Export, import, and edit IIF files
• Improved IIF Import in QuickBooks 2019 and later

Once you're able to import your accounts, you're now ready to track your QBDT entries.

If you have any other questions about adding your accounts to QuickBooks Desktop, let me know by adding a comment below. I'm more than happy to help. Have a good one!