Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
rgarcia339
Level 1

When doing an export of COA is it necessary to have account numbers?

I did an export of my COA because I want to start over with nothing in the Transaction ledger.  When I do the import it fails.  I think the reason is because not all of the listed accounts listed have numbers. 

Solved
Best answer 3 weeks ago

Best Answers
MichaelaS
QuickBooks Team

When doing an export of COA is it necessary to have account numbers?

Yes, it will be necessary once you enable the account number feature in the Accounting Settings, Garcia. Here's how you can check:

 

  1. From the Edit menu, select Preferences.
  2. Select Accounting.
  3. Go to the Company Preferences tab.
  4. Check if the  Use account numbers field is Tick (✓).
  5. Click OK.

 

When using the standard/advanced import method, you need to ensure there are no duplicates, that everything is correct, and that the headings and format of your edits match exactly with QuickBooks Desktop (QBDT).

 

You can refer to this article in the "For Customers, Vendors, and Other Lists Data" section for complete details on successfully importing the list using the standard or advanced import methods.

 

Consider checking out the alternative way to import/export lists and transactions using  Intuit Interchange Format (IIF) files.

 

Moreover, view the Account List report to review your chart of accounts and ensure it is accurate. If you'd like to customize a report, please check this article: Customize reports in QuickBooks Desktop.

Keep us posted if you have other questions or concerns about the import/ export list and transaction. We're here to help.

View solution in original post

1 Comment 1
MichaelaS
QuickBooks Team

When doing an export of COA is it necessary to have account numbers?

Yes, it will be necessary once you enable the account number feature in the Accounting Settings, Garcia. Here's how you can check:

 

  1. From the Edit menu, select Preferences.
  2. Select Accounting.
  3. Go to the Company Preferences tab.
  4. Check if the  Use account numbers field is Tick (✓).
  5. Click OK.

 

When using the standard/advanced import method, you need to ensure there are no duplicates, that everything is correct, and that the headings and format of your edits match exactly with QuickBooks Desktop (QBDT).

 

You can refer to this article in the "For Customers, Vendors, and Other Lists Data" section for complete details on successfully importing the list using the standard or advanced import methods.

 

Consider checking out the alternative way to import/export lists and transactions using  Intuit Interchange Format (IIF) files.

 

Moreover, view the Account List report to review your chart of accounts and ensure it is accurate. If you'd like to customize a report, please check this article: Customize reports in QuickBooks Desktop.

Keep us posted if you have other questions or concerns about the import/ export list and transaction. We're here to help.

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

Need to get in touch?

Contact us