Our Chart of Accounts wasn't set up correctly. We want to load a brand new one. Has anyone tried to do this and if so how did you do it?

I appreciate the comprehensive details you've shared regarding your concern, Sheryl.
 

Your idea to export your data to Excel was a great initiative in handling your situation. This way, you can freely revamp your Chart of accounts (COA) by determining which accounts should stay and which ones should be removed from the platform.
 

Since we can't directly delete an account in COA, you can deactivate the accounts that were added by mistake. Here's how:

1. Go to the Gear icon, then Chart of accounts.
2. Locate and click the designated Checkbox for the accounts you wish to inactivate.
   
3. Scroll up to the upper part of the COA page and select the Batch actions dropdown.
4. Choose Make inactive.
   
5. Confirm the action by ticking the Yes, make inactive option from the Deactivate this account? prompt.
   

The transactions from the deactivated accounts will remain in your records for accurate financial reporting. If you need to transfer them to another account, you can delete the entries, then import or enter the data into the correct accounts by referring to your Excel file before making them inactive.

On the other hand, please know that the tags feature was improved and migrated into custom fields. For this reason, you can generate the needed tags as custom fields to apply them to your transactions.

It's also essential to note the limitations of this feature for each QuickBooks version. Check this link for more details: Overview of custom fields capabilities in QuickBooks Online.

Still, I'd recommend consulting with an accounting expert so you can ensure that your COA setup and transaction management are precise.
 

Let us know if you have more questions by revisiting the Community forum.