Showing results for 
Search instead for 
Did you mean: 
Level 1


I use sub-accounts in my COA. When I export my COA in Excel, all accounts show as if they are main accounts. For example, everything in column C say 1234 • Sub Account instead of 1000 • Main Account:1234 • Sub Account. Is there a setting to fix this?


Edit to show a better example:

Supposedly, the chart of accounts would display this way:

1000 • Main Account 1

1000 • Main Account 1:1100 • Sub Account 1

1000 • Main Account 1:1200 • Sub Account 2

2000 • Main Account 2

3000 • Main Account 3

3000 • Main Account 3:3100 • Sub Account 3


However, it shows like this:

1000 • Main Account 1

1100 • Sub Account 1

1200 • Sub Account 2

2000 • Main Account 2

3000 • Main Account 3

3100 • Sub Account 3

Level 15


Did you Export as .iif?


Because you can use Reports menu > List Reports, Account Listing, and then Export this Report to Excel, to see what you asked.

Level 1


I did Reports > List > Account Listing > Excel > Create a new worksheet, In a new workbook > Export. I know that when other people export their COA, the sub-account structure shows up but mine does not.



Hello there, @rynlpn.


Welcome aboard to the Community. I'm here to assist you with the missing sub-accounts when exporting the report from QuickBooks Desktop.


We'll need to make sure the account is active under the Chart of Accounts to ensure it'll show in the report. I've checked here on my end, and I'm unable to locate any reported issues about this concern.


Let's double-check the status of the sub-accounts by following these steps:

  1. Click the List tab at the top menu bar.
  2. Select Chart of Accounts.
  3. Click the drop-down arrow next to Account.
  4. Select Show Inactive Accounts.
  5. In case the account has X symbol, you can click the symbol to make it active.

After reviewing the accounts in Chart of Accounts, you can go back to the Account Listing report and try to export again.  If the problem continues, I recommend contacting out Phone Support Specialists to isolate the issue.


You can reach them through these steps:

  1. Go to:
  2. Select your QuickBooks Desktop version.
  3. Choose a topic.
  4. Scroll-down and select the Get Phone Number option.

If you need further assistance concerning the Account Listing report, please let me know. I'll be on a look out for your response on this thread.

Level 1


Hi AlcaeusF,


The issue is not about missing sub-accounts. All accounts are active, it is just the structure of the main and sub accounts not showing properly in the export file.



Hi again, rynlpn.

I appreciate you for getting back to us with more details about the report you're trying to export into Excel. I want to help figure out why it's not showing correctly in the export file.


We can run the Verify and Rebuild Utility to identify any data issues going on within the company file. This tool usually fixes most of the errors you'll encounter in the system.


Here's how you can verify data:

  1. Click the File tab at the top menu bar.
  2. Select Utilities.
  3. Click Verify Data.

To rebuild data:

  1. Click the File tab at the top menu bar.
  2. Select Utilities.
  3. Click Rebuild Data.

For more information about the Verify/Rebuild process, you can visit this article:


Verify and Rebuild Data in QuickBooks Desktop.


If all fails, please give us a call. You can contact our Phone Support Team through the steps I've attached above. One of them will be able to perform screen sharing to perform some further troubleshooting with the exported report.


Please remember I'm here anytime you need further assistance with the report. The Community team will on a look out for your response.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us