Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
can you import acct numbers to accts already in the system with getting an error
Solved! Go to Solution.
Thanks for reaching out to us again, @lrhmail451.
I can share some insights about this Chart of Accounts import in QuickBooks Online topic.
Being able to import account numbers for existing registers or accounts in QuickBooks is a good idea. However, at the moment, the system will only allow imports for new accounts that are not yet added to the program.
You will get an error when you try to import data that has a match in QBO: We didn't import some of your data because it's already in QuickBooks. If you still want to import it, change the info in the highlighted fields and try again.
I understand that this isn't what you've expected, but I have an option for you. You can manually edit the Chart of Accounts register, and then add the number to them. You can do it by batch, here's how:
I've listed a few related links about the Chart of accounts, import, as well as some QBO tutorials:
Come back here any time for your questions or concerns. I'll be more than happy to help you out.
Hello there, lrhmail451.
Let me share some insights about importing in QuickBooks Online.
You can only import a Chart of Accounts. Note that you're unable to import an account with the same name to an existing account on COA.
You may consider editing the account name on file. For example:(Bank 1 to Bank 1.0) then merge the accounts. Aside from that, ensure that you'll save the other account without the number to merge them without an error.
Here's how:
You can also use the Batch edit feature in QBO to save time by clicking the Pencil icon from the Chart of accounts window.
Please check this article for more details: Import your chart of accounts to QBO.
Once you're all set, feel free to check out this article that can help you seamlessly match your accounts: Reconcile your accounts in QBO.
Drop me a comment below if you need more help in importing your other data. I'm always here to back you up.
thank for your answer but i know how to import the chart of accounts
what i want to do is do maintenance on my chart of accounts the accountant before me
use all sorts of numbers doing the chart of accts i can keep the acct but the acct #s have to be changed
with the desktop QB you can download the chart of accts file and then fix what you want and then import the file back into QB with your changes
being online is starting to show so many draw backs with its usage
Thanks for reaching out to us again, @lrhmail451.
I can share some insights about this Chart of Accounts import in QuickBooks Online topic.
Being able to import account numbers for existing registers or accounts in QuickBooks is a good idea. However, at the moment, the system will only allow imports for new accounts that are not yet added to the program.
You will get an error when you try to import data that has a match in QBO: We didn't import some of your data because it's already in QuickBooks. If you still want to import it, change the info in the highlighted fields and try again.
I understand that this isn't what you've expected, but I have an option for you. You can manually edit the Chart of Accounts register, and then add the number to them. You can do it by batch, here's how:
I've listed a few related links about the Chart of accounts, import, as well as some QBO tutorials:
Come back here any time for your questions or concerns. I'll be more than happy to help you out.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here