Is it possible to import all possible account characteristics to QBO through a spreadsheet? The sample spreadsheet provided is limited.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Export each Chart of Account
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
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!
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
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!
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.