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

How do I change numbering on my chart of accounts?

 
2 Comments 2
Pabz_L
QuickBooks Team

How do I change numbering on my chart of accounts?

Thank you for posting here in the Community, @1anthonyfidalgo.

 

Let me help you change the numbering on the chart of accounts.

 

Here’s how.

 

  1. Go to the Accounting menu.
  2. Select Chart of Accounts.
  3. Select Batch edit in the Action column.
  4. Add account numbers in the Number column.
  5. Once done, select Save and Done.

 

If you don't plan to use an account anymore, you can make it inactive. QuickBooks hides the account from lists and menus but keeps records of past transactions on your reports. Also, this will help you organized your accounts. To know how, check out this article. Delete account on your chart of accounts in QuickBooks Online

 

Feel free to fill me in if you have any other questions. Take care.

Thank you for posting here in the Community, @1anthonyfidalgo.

 

Let me help you change the numbering on the chart of accounts.

 

Here’s how.

 

  1. Go to the Accounting menu.
  2. Select Chart of Accounts.
  3. Select Batch edit in the Action column.
  4. Add account numbers in the Number column.
  5. Once done, select Save and Done.

 

If you don't plan to use an account anymore, you can make it inactive. QuickBooks hides the account from lists and menus but keeps records of past transactions on your reports. Also, this will help you organized your accounts. To know how, check out this article. Delete account on your chart of accounts in QuickBooks Online

 

Feel free to fill me in if you have any other questions. Take care.

thomas4
Level 3

How do I change numbering on my chart of accounts?

There are two methods, depending on how many accounts you want to change. Both are done from Accounting->Chart of Accounts

 

If you're just changing one account, find it in the Chart of Accounts and click on the little downward-pointing arrowhead at the extreme right of that account's row; i.e. in the column headed "ACTION". Choose "Edit" from the resulting dropdown menu, and you can then change the account number in the box that pops up.

 

If you want to change more than one account. there is a bulk editing mechanism. Activate it by clicking the little pencil icon which is also near the right side of the screen, but just above the ACTION column header. That will make the NUMBER and NAME fields editable. Change the ones you want to, hit Save (Green box, up where the pencil icon used to be), and you're done.

 

A few points to note:

  1. With the second (i.e. bulk edit) method, you can change only NUMBER and NAME. That contrasts with the first method which lets you change (with occasional restrictions) everything.
  2. If using the second method, it can be useful to first (i.e. before clicking the pencil) filter the CofA down so you are seeing only the accounts you want to change (or, as near to that as possible). That's only possible if the accounts already have something in common, which they don't share with other accounts.  For example, if your accounts were already numbered and you wanted to change all accounts with numbers beginning 211, then if you put that into the "Filter by name or number" box (just above the top left of the CofA table), it will restrict your view to those accounts and that restriction persists after you click the pencil icon.
  3. There are a couple of bugs in the bulk editing method to keep an eye out for.
    • First, if you try to give more than one of the accounts numbers that have already been assigned to other active accounts, then when you try to save it will throw an error (and won't let you save). HOWEVER, it won't tell you which accounts are causing the problem. So the error message is essentially just saying, "Nope", and you then have to hunt around for what's bugging it.
    • Second, it can do the above even when you have not made an error, in the case where you are moving two or more account numbers around. So, suppose as part of a bulk edit, I want to simply swap 1010 and 1020. That should be fine, because after the save no accounts will be colliding with any others, but it will flag the error all the same. It seems that the error checker isn't smart enough to recognize that although account 1010 is becoming account 1020 and, yes, 1020 does indeed already exist, it's OK because 1020 is simultaneously going to stop being 1020 and will become 1010. You can often get around this one by temporarily adding an "x" (or whatever) to the accounts in question. So you'd do the above in two moves. First, move 1010 to 1020x, and 1020 to 1010x. Save. Then go back in and chop off the x's. Save. Done.
Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us