cancel
Showing results for 
Search instead for 
Did you mean: 
reese-michael
Level 1

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

Is it possible to import all possible account characteristics to QBO through a spreadsheet?  The sample spreadsheet provided is limited.

26 Comments 26
reese-michael
Level 1

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

Well, I found my own answer.  You have to import all accounts and then manually go into each account to edit the sub-account status of accounts you want to be sub-accounts.

christina2
Level 1

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

Yes - I am having the same issue.  I even exported my COA list from another client and the sub accounts came out with a colon between them and tried to import the same list I exported... and came up with an invalid character.  If it can export that way, I wish it could import that way!  Would be so helpful!
jzainoun
Level 1

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

it is completely ridiculous that the sub-account structure cannot be imported.  it is adding excessive amounts of unnecessary work. QBO needs to fix this immediately
nizar
Level 1

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

absolutely ridiculous that subaccount import is not supported. QBO people, get your act together!
mark6
Level 1

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

Adding another vote to this... we have 302 accounts to move from one QBO account to another, and having to remove and restore their subaccount status individually is a major pain.
Robin Canaday
Level 1

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

Yes, I agree.  All of the properties of an account should be importable including inheritance.  I suppose this means we'd have to make sure accounts were added in a correct order so that the prerequisite account existed before the sub-account was created, but I'm fine with that.

johnfesp
Level 1

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

Yep i am seeing the same issue trying to import chart of accounts with subaccounts.

Doesn't make sense that Y/N for subaccount field and related account value cannot be addressed in the Mappings section of Account Import Utility. Subaccount is a critical data element. It's bad enough that the account number field length is maxed at 7 characters.

Amy007CPA
Level 1

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

jessicamott
Level 1

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

I feel your pain. I have a client with 590 accounts that need to be used with their 3 companies. Means I have to do this THREE times (sorry for the all caps)!

Anonymous
Not applicable

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

Hello everyone.

 

Thank you all for taking the time to post in the Community. I'd be happy to help provide some information about importing chart of accounts in QBO. 

 

When importing chart of accounts, it's important to make sure that the Type and Detail Type must exactly match the types available in QuickBooks Online, including capitalization. Also, when adding sub accounts, you'll need to use the parent account name followed by a colon followed by the sub-account name. 

 

You can refer to the article provided by @Amy007CPA for more information: How to import chart of accounts.

 

Please know that I hear you all. I want to make sure that you're taken care of, and I'm happy to take your feedback here. If you want, you can also send feedback straight to our product team so they can consider the import process with less limitations in the future update. You can send your feedback directly to this link: https://feedback.qbo.intuit.com/.

 

Feel free to post again if you have other questions about importing chart of accounts in QuickBooks. I'm here to help however I can.

garyet
Level 1

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

What is the easiest way to import my old chart of accounts from one company and transfer it to my new company?

 

David-212915
QuickBooks Team

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

Hey @garyet,

 

Nice to see you in the Community. I can provide clarification on transferring the Chart of Accounts from the old company to your new one. 

 

QuickBooks Online has the ability to export and import spreadsheet information which is an option that you may wish to consider. I'm including an article that goes over this, with the section Chart of Accounts covering the steps for this process: How To Transfer Chart Of Accounts And Lists.

 

I'm confident that this resource will help you to get on the right track.

 

Please let me know if I can be of further assistance. Best regards. 

garyet
Level 1

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

Thank you so much this was very helpful.  Is there a way to import bills and checks from vendors?

 

David-212915
QuickBooks Team

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

Hi again, @garyet,

 

You're most welcome. I'm glad to hear that you found it helpful.

 

There are multiple ways to batch import transactions into QuickBooks Online. One option is to use the Web Connect feature to bring in transactions from your financial institution. Another option that you may find helpful is that there are third party applications which can also assist with importing transactions. For additional information on this, including resources and steps for those processes, I'm linking an article: Import Batch Transactions.

 

I'm just a few clicks away if you should have any questions or need anything. Have a lovely day.  

SC333
Level 1

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

There is a way in the desktop version that may also work in QBO.

 

If your parent account is titled "Name", sub accounts should be entered in the spreadsheet as "Name: Sub Account". This will import everything after ":" as title of sub account and auto categorize to parent account.

 

 

 

david-levy
Level 1

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

If you have a subaccount, add it in the Account Name column in this format: Main account: subaccount. For example, Utilities: Gas. 

 

You don't need to do it manually.

CFOSecrets
Level 4

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

This explains how to move from Quickbooks desktop to Quickbooks Online. How do you copy a chart of accounts between two Quickbooks Online accounts?

Candice C
QuickBooks Team

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

Good Afternoon, @CFOSecrets

 

You can export each chart of account to Excel to save the file as a CSV so that you can upload it into the other company account. It's a simple process. 

 

Here's how: 

 

Export each Chart of Account

 

  1. Open the QuickBooks Online (QBO) account that already has the chart of accounts listed. 
  2. Go to the Accounting tab. 
  3. Select the Chart of Accounts portion. 
  4. In the "Action" section, click View Register

 

 

        5. Press the Export to Excel icon above the Open Balance column. 

 

 

After it's exported to Excel, save the information as a CSV file. 

 

Import an Excel CSV file into QBO

 

  1. Open the new company account. 
  2. Go to the Gear (Settings) icon in the top right-hand corner. 
  3. Under "Tools," choose Import data

 

 

       4. Tap the Chart of Accounts option. 

 

 

       5. Follow the rest of the on-screen instructions to successfully import a chart of account. 

 

Do these steps for every chart of account that's listed in your QuickBooks Online account. Learn more about moving your chart of accounts into QuickBooks Online through this link. 

 

Let me know if this helps. I want to make sure all of your concerns are addressed. Take care!

AdamR123
Level 2

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

I had no issue importingt sub accounts.  Name that is imported must be formatted to have a colon between account and sub account but that's easy to do in excel with concetenation.  This did NOT work for grandchildren accounts, or sub sub accounts which I use a fair number of in restaurant accounting.  If anyone has a solution there, lmk.  Thanks, Adam 

AdamR123
Level 2

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

Possible to import sub, sub accounts?  Grandchildren accounts?  Thank you!

Candice C
QuickBooks Team

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

Good Evening, @AdamR123

 

Thanks for joining in on this thread. I've got you covered. Yes, it's possible to import sub sub-accounts and grandchildren accounts.

 

All you need to do is put another colon after your sub-account name. Here's a visual and written example: 

 

"Utilities: Gas: Truck Gas

 

 

If you still need the steps about importing your Chart of Accounts, here's the link that can provide the details: Move your Chart of Accounts to QuickBooks Online

 

For the future, here's a guide that can help you and your business manage default and special accounts in your QuickBooks Online (QBO) account. 

 

After adding the extra colon between the accounts, you should be able to import them successfully. If you have any other questions, feel free to ask. I'll always be around to help. Have a fantastic day! 

AdamR123
Level 2

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

Strange, I tried that but will try again.  Thanks!

 

AdamR123
Level 2

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

definitely worked this time around.  Thanks!

chrisnormand1
Level 1

Can you import a chart of accounts with sub-account structure to QBO? The sample spreadsheet only shows columns for Account Number, Account Name, Type and Detail Type.

I totally agree with the ridiculous functionality of "Import" and "Export." You would think you could export a COA from one company in QBO and import it into another company, but NO!!! Come on QBO. Please fix these issues. These have been standard in QB Desktop for over a decade.  

Need to get in touch?

Contact us