cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Jade-Lambert
Level 1

Is it possible to upload a new Chart of Accounts whilst preserving existing ones with balances? Need to add lots of new categories that would be easier to do in bulk.

Only a small number of the existing categories in the CoA have a balance, 3 or 4 maybe. We need to rename many, and add many more, which would be a whole lot easier to do if we could create a spreadsheet and upload. We are not looking to alter the categories that already have balances.

1 REPLY 1
KayePe
QuickBooks Team

Is it possible to upload a new Chart of Accounts whilst preserving existing ones with balances? Need to add lots of new categories that would be easier to do in bulk.

Yes, QuickBooks Online (QBO) allows you to upload a new Chart of Accounts even if your existing account contains balances, Jade.


Firstly, while renaming existing accounts in a spreadsheet seems ideal, it is not currently supported in QuickBooks as the system treats them as another account instead of updating the names. With this, you can bulk edit account names directly in QBO and import the new Chart of Accounts afterward.


Here's how to edit:
 

  1. Go to Transactions in the left-hand menu and select Chart of Accounts.
  2. Click the pencil icon to edit account names.
  3. Select Save when done.

 

 

Once edits are complete, format your spreadsheet properly and import the Chart of Accounts into QuickBooks.
 

  1. Click Settings and select Import Data.
  2. Choose Chart of Accounts.
  3. Click Browse, select the file from your computer, and click Open.
  4. Click Next to proceed.

 

 

For detailed instructions, refer to the article: Import your chart of accounts to QuickBooks Online.


You can also assign account numbers to keep your Chart of Accounts organized and easy to navigate.


You can hit the Reply button below for more inquiries about the Chart of accounts. We're here to help optimize your QBO experience.

Need to get in touch?

Contact us