Skip to main content
M
Michael1537
August 15, 2020
Question

Importing COA from Excel to QBO

  • August 15, 2020
  • 2 replies
  • 0 views

When trying to import COA all my Excel fields map properly but then I get a message in the upper left of the screen in a yellow/orange box that no records imported due to errors and to view the highlight items to make corrections.

 

I tried import from a CSV as well as an Excel workbook file.

 

However, there are no highlighted items...Any ideas??

 

Thank you!

2 replies

AlexV
AlexV
August 16, 2020

Good day, Michael1537.

 

Let me help you in importing your Chart of Accounts.

 

It's possible that this is because of a browser issue. We can perform some troubleshooting steps to fix this. Let's start by using an incognito window and import your CSV file from there.

 

I suggest clearing the cache since it's can also cause errors in QuickBooks Online. Aside from that, make sure you're using an updated browser.

 

I've added some of the articles for your reference in importing Chart of Accounts:

Keep on posting if you need anything else. Wishing you all the best!

M
Michael1537Author
August 16, 2020

Hello AlexV,

 

Thank you for your reply and your help but it doesn't appear to be a browser issue.

 

When I first posted my issue, I was in the QB app...This morning I tried it in both Edge and Chrome (after clearing the cache in each) and still go this error message:

 

0 of 86 accounts successfully imported.
We found some problems and couldn't import all of your data. Fix the info in the highlighted fields and try again.

 

A couple of more facts which may be relevant:

 

I'm importing "new" accounts; i.e., I'm not replacing/eliminating any existing accounts. Although I DID try an import with the existing accounts included but still go the same result.

 

I have bank & CC import transactions that need to be posted/cleared; is that a problem? Other than that I have only three (3) accounts with actual posting activity.

 

However, as mentioned in my prior post, nothing is highlighted. I guess I'll have to contact support on Monday?

 

Thanks again for your time and help!

S
SarahannC
August 16, 2020

Thanks for getting back to us, Michael1537.

 

I've read your concern above and would like to help you out with this.
 

I can see you're putting a lot of effort and time to import accounts from Excel to QuickBooks Online. However, the process seems not that successful on your end. In your case, we'll need to investigate this further and look for the main reason why you're experiencing this kind of behavior. Also, our specialist will help us to find out what triggers the process.

 

With that being said, please consider contacting our specialist by following the steps below. This way, everything will be tracked using their appropriate tools and help you to continue to download these accounts accurately.


Here's how to get in touch with them:

 

  1. Click the Help icon at the upper-right corner.
  2. Click the Contact Us button.
  3. Let them know the error you'd received when trying to import accounts in QBO.
  4. Click Let's Talk.
  5. In the Choose a way to connect with us page,  select Get a callback.
  6. Enter needed your information.
  7. Then, hit Confirm my Call.

 

Due to COVID-19, we have limited support and reduced our support hours too. To make sure we address your concern on time, you can check their work schedule in this article: Support hours and types.

 

Let me know how everything goes. I would like to ensure that you're good to go. I'll be around to assist you as soon as I can in case you still need help. Stay safe and be well.

M
mathispaceboy
September 5, 2024

you can try using saasant https://bit.ly/3ZjsfPk 

Terms & ConditionsAccessibility statement