Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore Intuit QuickBooks Workforce
Maria-Susana--Harris
Level 1

I am trying to import accounts into qb from excel. There are accounts that are not importing. The highlighted box is the account name, how do i fix them so they import?

 
1 Comment 1
Aldren18
QuickBooks Team

I am trying to import accounts into qb from excel. There are accounts that are not importing. The highlighted box is the account name, how do i fix them so they import?

I'll assist you in successfully importing all your accounts into QuickBooks Online, Maria. I've provided troubleshooting steps below so you can import it with ease.

 

Before proceeding, please ensure that the Account Name and Type in your Excel spreadsheet match the existing accounts in QuickBooks Online. If you have subaccounts, ensure they are formatted correctly in the Account Name column of your spreadsheet.

 

Furthermore, verify that your spreadsheet fields are correctly mapped to QuickBooks fields. You can select No Match for fields without a corresponding column in your spreadsheet.

 

For a more comprehensive understanding of importing formats, refer to this article: Common questions about importing data to QBO.

 

If the issue remains after these steps, let's access your account through an incognito window to rule out potential webpage issues. Below are the shortcut keys for opening an incognito window in various supported browsers:

 

  • Mozilla Firefox: CTRL + Shift + P
  • Microsoft Edge: CTRL + Shift + N
  • Google Chrome: CTRL + Shift + N
  • Safari: Command + Shift + N

 

After starting a new private browsing session, please log into your QBO account and check if it imports successfully. If they appear, clear your browser's cache to help the program run smoothly and eliminate technical issues. You can also use other devices and supported browsers as alternatives.

 

Furthermore, I'll share this valuable resource on handling your accounts effectively. This article provides essential guidance on modifying your Chart of Accounts, ensuring they align correctly with your financial records: Add to or edit the chart of accounts in QBO.

 

Consider this thread your go-to resource whenever you have questions or concerns about your accounts in QBO. You can also create a new discussion here in the Community space for assistance.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us