Renumbers a Chart of Accounts

I am grateful for your detailed explanation, Michael. I am here to offer insights on managing your Chart of Accounts (COA) in QuickBooks Desktop (QBDT).

First, you will need to manually update the COA numbers in each account of the program. You can follow these steps to do so:

1. Go to the Accountant menu, then select Chart of Accounts.
2. Select the account, then click the Account dropdown and select Edit account.
3. Add account numbers in the Number section.
4. Once done, select Save & Close.

On the other hand, you can choose to retain the existing separate accounts for historical reference and keep them unchanged. Nevertheless, if you prefer to consolidate them into a new account with assigned classes, QBDT provides a merging feature. However, if you're unsure, it's advisable to seek advice from your accountant on the optimal approach for managing both old and new accounts.

If you wish to merge them, opt for merging, ensure to set up class tracking in your accounting preferences initially, and then create a new account with the desired class. Once done, you can merge the old accounts into it. Here are the steps to follow:

1. Go to the Accountant menu, then select Chart of Accounts.
2. Take note or copy the name of the account you want to keep.
3. Right-click the sub-account you would like to merge, then click Edit Account.
4. Replace the name of the old account with the new one.
5. A prompt will appear to merge the account, select Yes to proceed.

Before migrating to QuickBooks Online (QBO), it's recommended that you update your Chart of Accounts and make any necessary changes to your Desktop version. This will help save time and ensure that everything is already set up once you make the move. Also, please know that it's not possible to assign a class to your accounts in QBO like you could in the Desktop version, you can still use class tracking to categorize your transactions.

Lastly, you can refer to these QuickBooks Help articles and video tutorials that can help you migrate your company file from QBDT to QBO:

• Move your QuickBooks Desktop file to QuickBooks Online.
• Learn how features and data move from QuickBooks Desktop to QuickBooks Online.
• Learn what to do after you move from QuickBooks Desktop to QuickBooks Online.

Also, there are various video tutorials shared by experts available on different online video platforms that you can visit for more details.

Furthermore, you can visit this helpful resource about the step-by-step processes in QuickBooks: Get Started QuickBooks Tutorials.

If you have any other concerns about managing your Chart of Accounts and migration process, please don't hesitate to get back here again. I'm just around the corner to help. Take care and have a good one.

Thank you. A few followup questions.

1. If I am merging several accounts into one accont (either a new account or one of the existing ones, but want to keep the entries separate, but rather than in separate accounts they would be reported out by class, could I first assign a class to each of the accounts so that when they are merged the income, expense, or asset would be brought into the merged account with the correct class? that way we maintain the historical department breakdown, it just goes from separate GL account to separate classes. Does that work?

2. What do you mean by "it's not possible to assign a class to your accounts in QBO "?

Does that mean that if we want to assign a class to a transaction we won't be able to do this, or that we cannot add or rename classes? I am not sure what this statement means. We do not currently use classes, we have parallel GL accounts which would be merged as noted above. I want to set up the classes before the merge and switch to QBO. 

3. What about vendors that are assigned to a GL account. Will the new numbering scheme automatically update the vendor list or will we have to manually recode every vendor. We are not planning to add many new accounts. Mostly renumbering and renaming.

I appreciate you getting back to the thread. For the follow-up questions, I'll chime in and handle them for you.

In QuickBooks Desktop, you can only assign classes to transactions and after merging, the transactions from the individual accounts will be combined into the merged account, and the class information should carry over if you have assigned classes to each transaction. This way, you can still report on income, expenses, or assets by class even though they are now consolidated into a single account. 

On the other hand, in QuickBooks Online, you can indeed assign classes to transactions. Classes in QBO are used to categorize transactions by departments, locations, or any other meaningful breakdowns within your organization. You can set up and assign classes to transactions to track and report on these categories. 

Lastly, when changing the numbering scheme or merging accounts, the impact on vendors should be minimal. If vendors are associated with specific GL accounts, account information for each vendor may need to be reviewed and updated manually. QuickBooks Desktop usually doesn't automatically update vendor information based on account numbering changes. It's advisable to check the vendor details after making significant changes to your chart of accounts to ensure accuracy in your financial records. QuickBooks Desktop usually doesn't automatically update vendor information based on account numbering changes.

I'm adding these articles you can use in the future:

• Learn about the chart of accounts in QuickBooks Online.
• Learn about account types and detail types in QuickBooks Online.

Feel free to post here again if you have further QuickBooks-related concerns. We are available 24/7 to lend a hand with each of your queries. Stay safe!

Thank you. To clarify the first point, in QBDT - can I easily assign every transaction in an account to be a particular class (I do not want to go through and manually open every transaction going back many years)? Example: I have 3 office supply GL accounts, one for each department. I add classes to QBDT, one for each department, and then batch assign every transaction in the first account to its corresponding department class, and do the same for the other two. When they are merged into the new account (or two merged in to the first) each transaction in the resulting merged account retains its department, but now through the class. The key is batch assignment of every transaction in a GL code to the same class, without editing each transaction.

Yes, you can, @mrogovin.

Assigning every transaction in an account to a particular class is easy if you're using QuickBooks Desktop (QBDT) Enterprise or QBDT Accountant version. Follow along below to get started:

1. Navigate to the Accountant menu and select Client Data Review.
2. Then, choose Reclassify Transactions.
3. From the Accounts section, choose the View drop-down and select the account type.
4. Next, select an account to view the transactions in the right pane.
5. In the Transactions section, choose a name from the Name drop-down.
6. From the Show transactions drop-down, select the transactions you want to review.
7. Review the list of transactions.

For more information about the process, feel free to read this article: Accountant tools: Reclassify your client’s transactions. 

However, if you're not using any of those version mentioned above, I suggest consulting your accountant to help you through out the process or you have to manually reopen the transaction and assign them to the correct class. 

Once everything is set, you can pull up a report to check those transactions you recently modified. Here's how:

1. Select the Company tab and choose Chart of Accounts.
2. Next, look for the account where the transactions are allocated.
3. Then, right-click and select QuickReport.

I'll be right here in the Community if you need additional help managing your transactions. Please don't hesitate to leave a reply below. Have a great day ahead.