Chart of Accounts Detail Types

Your confusion ends here, @SLfifty.

Allow me to fill you in on everything about importing Chart of Accounts detail types in QuickBooks Online (QBO) and help you from there.

When you create a new company file, QuickBooks creates some accounts automatically based on your industry. And yes, you will have to make each default account inactive to get rid of them.

On the other hand, detail types don’t have any impact on your financials. However, it gives more information about what you can track with each account type. If you are unsure what detail types to use when importing your Chart of Accounts, you can leave the fields blank and add them later in QuickBooks.

I'm adding these articles to learn more about the Chart of Accounts:

• Learn about detail types in chart of accounts.
• Move your chart of accounts to QuickBooks Online.
• Learn about the chart of accounts in QuickBooks.

Also, just in case you want to create subaccounts to keep your chart of accounts organized, feel free to check out this article: Create subaccounts in your chart of accounts in QuickBooks Online.

Should you need any assistance getting your new company files up and running, I'm available here to help any time!

Mark,

Thanks Mark, but it does not let me import a COA with either a blank field labeled Detail type or elimination of the field altogether( see screen shot with error).  

On another note, it is also super fussy about TYPE and does not like my type of "Asset" for example.  Not AS big a deal, because there are not that many types.  

Hello @SLfifty,

As of the moment, there isn't an integrated way to eliminate the Detail Type column when importing a list of your chart of accounts. As mentioned by my colleague, it is designed to track more defined information when reviewing your financial reports.

In the meantime, you can consider creating a detail type entry for each of your account types base on the list in this article: Find out how to use detail types for your chart of accounts in QuickBooks Online.

Additionally, I've also included this helpful article for the other lists you can create and import into your file: Learn how to import your lists to QuickBooks Online.

If there's anything else that I can help you with, please let me know in the comments below. Stay safe and well!

Thanks but, You cannot leave the detail type blank when you import- that is the problem...

I won't rest until your account data is uploaded to QuickBooks Online properly, @SLfifty.

As per my colleague discussed above, the option to remove the detail type field when importing a CSV file is unavailable. As a workaround, you can create dummy detail types (just like what you've stated in your first post) for those accounts. To ensure your CSV file is in the correct format, check this link. Once imported, you can edit them inside QuickBooks Online. 

Let me guide you on how:

1. In QuickBooks, go to the Gear icon.
2. Choose Chart of accounts.
3. Locate the accounts you want to edit.
4. Under the Action column, click the drop-down arrow and select Edit. 
5. Make necessary changes and hit Save and close to confirm the action. 

To learn more about how the Chart of accounts works in QuickBooks, please head to the chart of accounts overview at this link. This includes steps on how to add a new account, make the account inactive, turn on account numbers, etc. 

Feel free to post a reply below if you have other questions about importing CSV file in QuickBooks. I'll be here to help you. Stay safe.