cancel
Showing results for 
Search instead for 
Did you mean: 
user23261
Level 2

How do I manually rearrange the chart of accounts? ( Not sort)

As I recall, the original COA list at setup (several versions ago) had a layout pretty much like the Balance Sheet, followed by income and expense accounts.  I sorted it and now cannot get it back to the original layout.  Is there a way to manually move accounts?

Solved
Best answer December 10, 2018

Best Answers
John68-CPA
Level 3

How do I manually rearrange the chart of accounts? ( Not sort)

Go to List > Chart of account >   click & hold on the diamond next to the account name.  Then move the account to the desired location

View solution in original post

36 Comments 36
John68-CPA
Level 3

How do I manually rearrange the chart of accounts? ( Not sort)

Go to List > Chart of account >   click & hold on the diamond next to the account name.  Then move the account to the desired location

user23261
Level 2

How do I manually rearrange the chart of accounts? ( Not sort)

I see no "diamond"
John68-CPA
Level 3

How do I manually rearrange the chart of accounts? ( Not sort)

to the left of the account name or number there is a figure.

Unless you are using 2014 online - then all bets are off.   the online versions do not work like the desktop versions.
user23261
Level 2

How do I manually rearrange the chart of accounts? ( Not sort)

QB 2014 on iMac.  No diamond.  Never used the online version.  FYI, same problem in QB 2011 and 2009
user23261
Level 2

How do I manually rearrange the chart of accounts? ( Not sort)

Eureka!  Under Edit/Re-sort list puts it bak to the original.  Thanks for the help.  (They do hide things, eh?)
donnab1
Level 1

How do I manually rearrange the chart of accounts? ( Not sort)

I was able to click the custom sort option in the utilities menu (bottom of the left pane), but after moving one or two accounts by highlighting and dragging, then the system froze on me and now it is no longer working. One thing I noticed is that an expense account is no longer next to the rest of the expenses...it ended up a the end of my list after "other income". Any ideas how to unlock this?or re-instate the functionality? I am on QB1014 for Macs.
jschmidt
Level 1

How do I manually rearrange the chart of accounts? ( Not sort)

I've tried this but it says accounts of its type must stay together.....
violameme
Level 1

How do I manually rearrange the chart of accounts? ( Not sort)


@user23261 wrote:

As I recall, the original COA list at setup (several versions ago) had a layout pretty much like the Balance Sheet, followed by income and expense accounts.  I sorted it and now cannot get it back to the original layout.  Is there a way to manually move accounts?


 

MaryGraceS
Moderator

How do I manually rearrange the chart of accounts? ( Not sort)

Hi there, everyone.

 

Thank you for posting in the Community. I'd be happy to help share another option to rearrange the Chart of Accounts manually.

 

Here's how:

  1. At the top menu, select Lists.
  2. Select Chart of Accounts.
  3. Highlight the account you want to move.
  4. Using the left mouse button, press and hold the account and drag it to the desired place. 

For additional reference, I'm also including the articles below: 

If you need to reach out for more help, feel free to contact our phone support. They have the tools to get this resolved in no time.

 

Here's how:

  1. Go to https://help.quickbooks.intuit.com/en_US/contact
  2. At the top right, select your QuickBooks version.
  3. Select a topic.
  4. Click on the Get Phone Number button.

That should take care of it. 

 

Drop me a reply below if you have any other questions about rearranging accounts in QuickBooks for Mac. I'll be happy to help you out. 

In_and_Out
Level 1

How do I manually rearrange the chart of accounts? ( Not sort)

I tried going to COA using the diamond & moving it up but than I get "you cannot move the list element while the list is the the "Flat" mode??? I just installed 2020 Desk Top Pro

Angelyn_T
Moderator

How do I manually rearrange the chart of accounts? ( Not sort)

Thank you for joining the thread, @In_and_Out.

 

We can rearrange the accounts from the Chart of Accounts as long as they are on their corresponding type. If you're trying to arrange them out of their type, then that's the reason why you're getting that error. For now, you can resort the list to put them back in order.

 

Here's how:

 

  1. Select Chart of Accounts from the Lists menu.
  2. Go to the View tab, then click on Re-sort List.

For additional reference about managing accounts from the chart of accounts, check out this article.

 

Leave a comment below if you have any other questions. I'm a post away to help. Have a good day!

KellyMac88
Level 1

How do I manually rearrange the chart of accounts? ( Not sort)

How can I do this in Quickbooks Online? Thanks.

IamjuViel
QuickBooks Team

How do I manually rearrange the chart of accounts? ( Not sort)

The default arrangement of your accounts in the Chart of Account is by Account Type, @KellyMac88.

 

Let me share some information on how to rearrange your list of the chart of accounts. QuickBooks displays first on the list all your Bank Accounts, then your Account Receivables account. 

 

You can click the header of each column in the Chart of Accounts page. This way you can re-arrange it by Number, Name, Account Type, Detail Type, Currency, QuickBooks Balance, and Bank Balance. This action will not affect your Profit and Loss report or your books. 

 

I've got these articles to help you organize your chart of accounts:

I'd be more than happy to help you if you have other questions about managing your chart of accounts. Just leave a comment below. 

FairHousingFM
Level 2

How do I manually rearrange the chart of accounts? ( Not sort)

I'm having the same issue in 2020 Desktop.  Any solution yet?


@In_and_Out wrote:

I tried going to COA using the diamond & moving it up but than I get "you cannot move the list element while the list is the the "Flat" mode??? I just installed 2020 Desk Top Pro


 

FairHousingFM
Level 2

How do I manually rearrange the chart of accounts? ( Not sort)

Just figured this out.  While you are in the chart of accounts, click on the drop down menu at the bottom of the screen labelled "Account".  You can toggle between Hierarchical and Flat View here. 

psn
Level 2

How do I manually rearrange the chart of accounts? ( Not sort)

I tried toggling between hierarchal and flat view and dragging the diamond and it did not work.  Got the same error message.

Jovychris_A
Moderator

How do I manually rearrange the chart of accounts? ( Not sort)

Hi, @psn.

 

I'll share a few details about manually rearranging the account in the Chart of Accounts (COA). Where it was shared by my colleague, Angelyn_T in the earlier response.

 

Let's make sure that you only drag and place the parent account with the same account type like in the red box. Also, ensure to drag and drop the same subaccounts under a parent account like in the blue box.

 

Additionally, switching to a Hierarchical view will enable us to drag and drop the account while a Flat view disables us to make these changes.

 

However, if you get an odd error message that is different from one of these reasons below, I'd recommend utilizing the Re-sorting list feature to fix this. This way, it makes your lists go back to their default order and able them to rearrange.

 

  • This account must stay with other accounts of its type.
  • Subaccounts must be the same account type as their parent.
  • You cannot move the list element while the list in the "Flat" mode.

 

You'll want to know about the account types in COA, you can reference this article: Learn about the chart of accounts in QuickBooks.

 

Feel free to tag me if you have other concerns with organizing your accounts. I'll make sure to get back to you. Stay safe and healthy!

Chart of Accounts Sorting
Level 1

How do I manually rearrange the chart of accounts? ( Not sort)

That does not work.  Message pops up "Can't move list element while the list in the flat mode".  I can not find anywhere how to get chart of accounts out of flat mode so you can sort your asset list.

Jovychris_A
Moderator

How do I manually rearrange the chart of accounts? ( Not sort)

Hi, let me share with you how to switch to hierarchical view, @Chart of Accounts Sorting.

 

In the chart of accounts window, you'll find the option to switch to hierarchical view when you click the Account button on the lower right part of the screen.

 

Here's how:

  1. Go to the Lists menu and then select Chart of Accounts.
  2. Below the chart of accounts window, click the Account button.
  3. Select Hierarchical View.
  4. Read the information and then select Yes.

 

You can then click and hold the diamond for each account to sort the asset list. Feel free to read the key points that I shared before your comment.

 

Additionally, you can use this reference when it's time to review your QuickBooks records if it matches your bank account statements: Reconcile an account in QuickBooks Desktop.

 

Please update me (@Jovychris_A) on how it goes so I can quickly reply if you need further assistance with changing list views. I will be here to help! Enjoy your day!

salehaambrin
Level 1

How do I manually rearrange the chart of accounts? ( Not sort)

Getting the following error

You can not move the list element while the list in flat mode

LieraMarie_A
QuickBooks Team

How do I manually rearrange the chart of accounts? ( Not sort)

Don't sweat it, @salehaambrin. I'm here to help you reorder your list.

 

You'll get the error message when trying to reorder your accounts in a flat view. You'll have to switch to the Hierarchical View option. This way, you can move or drag a list element. 

 

Here's how:

  1. Go to the Lists menu and then select Chart of Accounts.
  2. Below the chart of accounts window, click the Account button.
  3. Select Hierarchical View.
  4. Click Yes to confirm.

 

I've also got some helpful articles that will help you organize your accounts:

 

I'm just a reply away if you need any further assistance in managing your accounts. Wishing you and your business continued success.

awecaw
Level 1

How do I manually rearrange the chart of accounts? ( Not sort)

all well and good EXCEPT the drag feature doesn't work half the time. I sit and click the diamond and move it up or down and nothing. I would like my accounts to be ordered by number but no such luck with not being able to drag....what is going on?

Ethel_A
QuickBooks Team

How do I manually rearrange the chart of accounts? ( Not sort)

Thank you for posting here in the Community, @awecaw. Let me share some insights about sorting the Chart of Accounts list.

 

I can see my colleagues provided the steps above to re-sort listing. This way, you can rearrange the lists of your accounts. I believe you sorted your list and want to move some items by dragging them.

 

I also tried it on my end. You can hover your mouse over the account. Once you see the arrows crossing, you can drag them. However, this only works for the same account type. See the screenshot below of the error message when I tried to move an account toward a different account type.

 

Additionally, you can use this reference while reviewing your QuickBooks records to see if they match your bank account statements: Reconcile an account in QuickBooks Desktop.

 

Don't hesitate to click the Reply button below if you need additional assistance sorting Chart of Accounts in QuickBooks Online. I'm always here to help.

Truthaboutnursing
Level 2

How do I manually rearrange the chart of accounts? ( Not sort)

Does it still work this way in 2022? I a't find a diamond to click and hold

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us