- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
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)!

- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
What is the easiest way to import my old chart of accounts from one company and transfer it to my new company?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
Thank you so much this was very helpful. Is there a way to import bills and checks from vendors?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
This explains how to move from Quickbooks desktop to Quickbooks Online. How do you copy a chart of accounts between two Quickbooks Online accounts?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
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
- Open the QuickBooks Online (QBO) account that already has the chart of accounts listed.
- Go to the Accounting tab.
- Select the Chart of Accounts portion.
- 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
- Open the new company account.
- Go to the Gear (Settings) icon in the top right-hand corner.
- 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!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
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
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
Possible to import sub, sub accounts? Grandchildren accounts? Thank you!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
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!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
Strange, I tried that but will try again. Thanks!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
definitely worked this time around. Thanks!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Install
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.