Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
eclayton9182
Level 1

Where can I see a complete list of the account "type" and "detail type" options so I can assign a valid type and detail type to my new chart of accounts before uploading?

I tried to upload the chart of accounts for my business and most of the "Type" and "Detail Types" I included in my original spreadsheet were red and were options in the drop down. Can I see a full list of the options so I can edit my chart of accounts in excel before uploading?
16 Comments 16
AileneA
Moderator

Where can I see a complete list of the account "type" and "detail type" options so I can assign a valid type and detail type to my new chart of accounts before uploading?

Hello, eclayton9182. 

 

I can walk you through how to view the account "type" and "detail type" in the Chart of Accounts in QuickBooks Online.  

 

Here's how:  

 

  1. Click the Accounting, then select Chart of Accounts
  2. Tap the New.  
  3. From the Account Type, drop down arrow and choose the specific account. 
  4. Under Detail Type, drop down arrow and select the correct account. 
  5. Click Save and Close

 

 

 

To learn more about Chart of Accounts, you can refer to these articles: 

 

 

Don't hesitate to visit ask again if you have more questions. We're always delighted to help. Stay safe!

kmeckert
Level 2

Where can I see a complete list of the account "type" and "detail type" options so I can assign a valid type and detail type to my new chart of accounts before uploading?

Isn't there a full list of the preset accounts with numbers, descriptions and mapping that you can provide?  I want to determine what I want to use across multiple companies before I configure them.  

JasroV
QuickBooks Team

Where can I see a complete list of the account "type" and "detail type" options so I can assign a valid type and detail type to my new chart of accounts before uploading?

I'm more than happy to tell you that there is, @kmeckert.

 

When importing your chart of accounts, QuickBooks customizes the chart for you. To learn the list of accounts you can import, you can check the A deeper dive into account types section in this article for reference: Learn about the chart of accounts in QuickBooks.

 

Once you’re ready to import your chart of accounts, check out this link for the complete guidelines: Import your chart of accounts to QuickBooks Online.

 

Let me also share this resource that you can read for future reference in reconciling your accounts effectively: Reconcile an account in QuickBooks Online.

 

Keep me in the loop if you have other queries about importing accounts or any QuickBooks-related questions. I’ll be around to help and back you. Have a good one and keep safe.

kmeckert
Level 2

Where can I see a complete list of the account "type" and "detail type" options so I can assign a valid type and detail type to my new chart of accounts before uploading?

I appreciate the quick response, but I am looking for a full list of the pre configured QB account lines. We are buying a group of businesses and I would like to clean up the mapping and make them as aligned as possible. I really just need the full list to determine what the best out of the box hierarchy would be. Can you point me to that list? 

JessT
Moderator

Where can I see a complete list of the account "type" and "detail type" options so I can assign a valid type and detail type to my new chart of accounts before uploading?

Hi kmeckert,

 

I can see that it would help you to have a list of accounts with the types and their corresponding detail types. However, this list is not available. What we can do is toggle the Account Type and the Detail Type on the Account window to see the list. You can take screenshots.

 

 

I'm just around if you have other questions in mind.

angelacct
Level 3

Where can I see a complete list of the account "type" and "detail type" options so I can assign a valid type and detail type to my new chart of accounts before uploading?

 

QBO Account Types

Balance Sheet Accounts

 

Account Types:

(Assets)

  • Bank

  • Accounts Receivable (A/R)

  • Other Current Assets

  • Fixed Assets

  • Other Assets

(Liabilities)

  • Accounts Payable (A/P)

  • Credit Card

  • Other Current Liabilities

  • Long Term Liabilities

 

(Equity)

  • Equity (examples)

    • Owner's Equity

    • Owner's Draw

    • Opening Balances

 

Profit & Loss Accounts  

Account Types:

    • Income
    • Cost of Goods Sold (COGS)
    • Expenses
    • Other Income
    • Other Expense

NOTE: Don't sweat the "Detail Type." As long as you have the correct Income/Expense, Asset, etc. accounts, you can always work on the rest later.

 

Each company's Chart of Accounts (COA) is different. It is set up to suit their individual company needs.

If you want to practice creating or uploading a chart of accounts, you can always do so with a QB Sample company. http://qbo.intuit.com/redir/testdrive 

Hope the list might help. Best of luck, and have a wonderful day. :)

Julia_udovenko
Level 1

Where can I see a complete list of the account "type" and "detail type" options so I can assign a valid type and detail type to my new chart of accounts before uploading?

Just for an easier upload would be great to have a list of details types and account types for matching it in excel before upload to avoid manual editing. Could you share it please

Roslynne
Level 2

Where can I see a complete list of the account "type" and "detail type" options so I can assign a valid type and detail type to my new chart of accounts before uploading?

I just pulled the whole list and uploaded it here for anyone else needing this as I was having the same issue. I don't understand why QBO doesn't offer this.

Roslynne
Level 2

Where can I see a complete list of the account "type" and "detail type" options so I can assign a valid type and detail type to my new chart of accounts before uploading?

I just created the list in a PDF by highlighting the drop down menu's and copying. I do not understand why QBO doesn't offer this list to all new clients as it would make it so much easier.

JBS
Level 2

Where can I see a complete list of the account "type" and "detail type" options so I can assign a valid type and detail type to my new chart of accounts before uploading?

I don’t see the Detail Tupe list. Anyway to get that too 

SheandL
QuickBooks Team

Where can I see a complete list of the account "type" and "detail type" options so I can assign a valid type and detail type to my new chart of accounts before uploading?

Thanks for reaching out in this forum, @JBS. I'm here to help you view the Detail Type list in your QuickBooks Online.

 

If you create a new or edit an account from your Chart of Accounts page, you'll be able to see the Detail type list. To view it, here's how:

 

  1. Go to the Gear icon, then select Chart of Accounts.
  2. Click the New button.
  3. On the New account window, you'll see the Detail type dropdown.

 

 

However, there are instances where QBO will use the term Tax form section instead of Detail type. Nonetheless, both of them still have the same purpose, which is to help determine where you want to categorize transactions.

 

See this article for reference: Learn where QuickBooks Online detail types appear on your tax forms.

 

Moreover, if you're referring to the screenshots on this thread, please know they're using the old layout instead of the new one.

 

If you want to create organized and more detailed reports in your chart of accounts. Please refer to this article for guidance: Create subaccounts in your chart of accounts in QuickBooks Online.

 

This thread is always open if you need further help in finding the detail type list. Just hit the reply button if you have one.

MiamiAccountant
Level 2

Where can I see a complete list of the account "type" and "detail type" options so I can assign a valid type and detail type to my new chart of accounts before uploading?

Thank you for providing that.  Unfortuneatly, this site only provides Profit & Loss accounts and does not provide anything for the Balance Sheet accounts:

https://quickbooks.intuit.com/learn-support/en-us/help-article/tax-forms/learn-quickbooks-online-det...

 

I found this site which is a much more complete answer to the OP's request for a list of detail types in QBO, but unfortuneatly, this was posted by the QBO UK support team and is meant for their QBO.  We need the U.S. QBO support team to post a corresponding article detailing out the accounts types and detail types for the US QBO product:

A complete guide to account types and detail types in QuickBooks Online (UK Version):

https://quickbooks.intuit.com/learn-support/en-uk/help-article/chart-accounts/understanding-detail-t...

 

This_Software_is_a_Disaster
Level 2

Where can I see a complete list of the account "type" and "detail type" options so I can assign a valid type and detail type to my new chart of accounts before uploading?

Intuit employees appear incapable of understanding your question. I find it difficult to do routine work without a list of all of the Account Types and the corresponding Detail Types.

 

I've attached a pdf with a complete list of every Account Type and the corresponding Detail Type. I found the list here: 

 

https://ryanwingate.com/accounting/other-accounting-topics/quickbook-default-account-types/

katieghi
Level 1

Where can I see a complete list of the account "type" and "detail type" options so I can assign a valid type and detail type to my new chart of accounts before uploading?

morrisstemp
Level 1

Where can I see a complete list of the account "type" and "detail type" options so I can assign a valid type and detail type to my new chart of accounts before uploading?

Sorry, but I can't upload an Excel file.

But you can convert this PDF to Excel with any number of free tools.

Or you can DM me and I can send you the file.

 

NormanAcct
Level 1

Where can I see a complete list of the account "type" and "detail type" options so I can assign a valid type and detail type to my new chart of accounts before uploading?

I am just investigating whether I want to switch from our current accounting system and so I have signed up for a trial period. I am amazed by how Intuit obfuscate what is a straightforward issue for anyone wishing to set up a new set of accounts - and particularly for anyone wishing to migrate their accounts from elsewhere.  

The pdf posted above by @This_Software_is_a_Disaster  is helpful but I hope others will find the list below easier to work with:

Overall categoryTypeDetailed Type
AssetsBank:Checking 
AssetsBank:Savings 
AssetsBank:Money Market 
AssetsBank:Cash on hand 
AssetsBank:Trust account
AssetsBank:Rents Held in Trust
AssetsAccounts receivable (A/R) - Accounts receivable (A/R)
AssetsOther Current Assets:Allowance for Bad Debts
AssetsOther Current Assets:Employee Cash Advances
AssetsOther Current Assets:Prepaid Expenses
AssetsOther Current Assets:Retainage
AssetsOther Current Assets:Undeposited Funds
AssetsOther Current Assets:Development Costs
AssetsOther Current Assets:Inventory
AssetsOther Current Assets:Loans To Officers
AssetsOther Current Assets:Loans to Stockholders
AssetsOther Current Assets:Loans to Others
AssetsOther Current Assets:Other Current Assets
AssetsOther Current Assets:Investment - U.S. Government Obligations
AssetsOther Current Assets:Investment - Tax-Exempt Securities
AssetsOther Current Assets:Investment - Mortgage/Real Estate Loans
AssetsOther Current Assets:Investments - Other
AssetsFixed assets:Buildings
AssetsFixed assets:Furniture & Fixtures 
AssetsFixed assets:Leasehold Improvements 
AssetsFixed assets:Machinery & Equipment 
AssetsFixed assets:Other fixed assets 
AssetsFixed assets:Vehicles
AssetsFixed assets:Accumulated Depreciation 
AssetsFixed assets:Depletable Assets 
AssetsFixed assets:Accumulated Depletion 
AssetsFixed assets:Intangible Assets 
AssetsFixed assets:Accumulated Amortization 
AssetsFixed assets:Land
AssetsFixed assets:Fixed Asset Computers 
AssetsFixed assets:Fixed Asset Copiers 
AssetsFixed assets:Fixed Asset Furniture 
AssetsFixed assets:Fixed Asset Phone
AssetsFixed assets:Fixed Asset Photo Video 
AssetsFixed assets:Fixed Asset Software
AssetsFixed assets:Fixed Asset Other Tools Equipment
AssetsOther Assets:Goodwill
AssetsOther Assets:Lease Buyout
AssetsOther Assets:Licenses
AssetsOther Assets:Organizational Costs 
AssetsOther Assets:Security Deposits
AssetsOther Assets:Other Long-term Assets
AssetsOther Assets:Accumulated Amortization of Other Assets
Assets Accounts payable (A/P)
LiabilitiesAccounts payable (A/P)- Accounts payable (A/P)
LiabilitiesCredit Card- Credit Card
LiabilitiesOther Current Liabilities:Insurance Payable
LiabilitiesOther Current Liabilities:Payroll Clearing
LiabilitiesOther Current Liabilities:Payroll Tax Payable
LiabilitiesOther Current Liabilities:Sales Tax Payable
LiabilitiesOther Current Liabilities:Federal Income Tax Payable
LiabilitiesOther Current Liabilities:State/Local Income Tax Payable
LiabilitiesOther Current Liabilities:Trust Accounts - Liabilities
LiabilitiesOther Current Liabilities:Rents in trust - Liability
LiabilitiesOther Current Liabilities:Line of Credit
LiabilitiesOther Current Liabilities:Loan Payable
LiabilitiesOther Current Liabilities:Prepaid Expenses Payable
LiabilitiesOther Current Liabilities:Other Current Liabilities
LiabilitiesOther Current Liabilities:Undistributed Tips
LiabilitiesOther Current Liabilities:Deferred Revenue
LiabilitiesLong Term Liabilities:Notes Payable
LiabilitiesLong Term Liabilities:Shareholder Notes Payable
LiabilitiesLong Term Liabilities:Other Long Term Liabilities
EquityEquity:Accumulated Adjustment
EquityEquity:Common Stock
EquityEquity:Preferred Stock
EquityEquity:Paid-In Capital or Surplus
EquityEquity:Treasury Stock
EquityEquity:Opening Balance Equity
EquityEquity:Owner's Equity
EquityEquity:Partner's Equity
EquityEquity:Partner Contributions
EquityEquity:Partner Distributions
EquityEquity:Retained Earnings
EquityEquity:Estimated Taxes
EquityEquity:Health Insurance Premium
EquityEquity:Health Savings Account Contribution
EquityEquity:Personal Income
EquityEquity:Personal Expense
IncomeIncome:Service/Fee Income 
IncomeIncome:Sales of Product Income 
IncomeIncome:Non-Profit Income
IncomeIncome:Other Primary Income 
IncomeIncome:Discounts/Refunds Given
IncomeIncome:Unapplied Cash Payment Income
COGSCost of Goods Sold:Cost of labor - COS
COGSCost of Goods Sold:Supplies & Materials - COGS
COGSCost of Goods Sold:Shipping, Freight & Delivery - COS 
COGSCost of Goods Sold:Equipment Rental - COS
COGSCost of Goods Sold:Other Costs of Services - CO
ExpensesExpenses:Auto
ExpensesExpenses:Charitable Contributions
ExpensesExpenses:Taxes Paid
ExpensesExpenses:Payroll Expenses
ExpensesExpenses:Payroll Tax Expenses
ExpensesExpenses:Payroll Wage Expenses
ExpensesExpenses:Legal & Professional Fees
ExpensesExpenses:Dues & subscriptions
ExpensesExpenses:Insurance
ExpensesExpenses:Office/General Administrative Expenses
ExpensesExpenses:Utilities
ExpensesExpenses:Communication
ExpensesExpenses:Rent or Lease of Buildings
ExpensesExpenses:Repair & Maintenance
ExpensesExpenses:Travel Meals
ExpensesExpenses:Entertainment Meals
ExpensesExpenses:Promotional Meals
ExpensesExpenses:Travel
ExpensesExpenses:Entertainment
ExpensesExpenses:Advertising/Promotional
ExpensesExpenses:Bank Charges
ExpensesExpenses:Bad Debts
ExpensesExpenses:Interest Paid
ExpensesExpenses:Cost of Labor
ExpensesExpenses:Supplies & Materials
ExpensesExpenses:Shipping, Freight & Delivery
ExpensesExpenses:Equipment Rental
ExpensesExpenses:Other Miscellaneous Service Cost
ExpensesExpenses:Unapplied Cash Bill Payment Expense
ExpensesExpenses:Finance costs
ExpensesExpenses:Other Business Expenses
Other IncomeOther Income:Interest Earned 
Other IncomeOther Income:Tax-Exempt Interest 
Other IncomeOther Income:Dividend Income 
Other IncomeOther Income:Other Investment Income
Other IncomeOther Income:Other Miscellaneous Income
Other ExpenseOther Expense:Depreciation
Other ExpenseOther Expense:Amortization
Other ExpenseOther Expense:Penalties & Settlements 
Other ExpenseOther Expense:Other Miscellaneous Expense 
Other ExpenseOther Expense:Exchange Gain or Loss 
Other ExpenseOther Expense:Vehicle
Other ExpenseOther Expense:Other Vehicle Expenses 
Other ExpenseOther Expense:Vehicle Insurance
Other ExpenseOther Expense:Vehicle Loan Interest
Other ExpenseOther Expense:Vehicle Loan
Other ExpenseOther Expense:Vehicle Repairs
Other ExpenseOther Expense:Gas And Fuel
Other ExpenseOther Expense:Parking and Tolls
Other ExpenseOther Expense:Vehicle Registration
Other ExpenseOther Expense:Vehicle Lease
Other ExpenseOther Expense:Wash and Road Services
Other ExpenseOther Expense:Home Office
Other ExpenseOther Expense:Homeowner Rental Insurance
Other ExpenseOther Expense:Other Home Office Expenses
Other ExpenseOther Expense:Mortgage Interest Home Office
Other ExpenseOther Expense:Rent and Lease Home Office
Other ExpenseOther Expense:Repairs and Maintenance Home Office
Other ExpenseOther Expense:Utilities Home Office
Other ExpenseOther Expense:Property Tax Home Office

 

 

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us