Can’t Display QuickBooks Account Numbers Properly

How to Make QuickBooks Display Accounts by Number

A reader wrote to explain that he'd carefully planned the numbering system for his chart of accounts in QuickBooks, putting everything in the order in which he needed it. However, he doesn't know how to get the QuickBooks COA to display accounts according to his numbers; he wants the list to use his numerical order in every report and window.

QuickBooks sorts accounts by type first, and account number second. Therefore, you have to design your account numbers to match that order if you want to display the COA in numerical order. Here's the sort order:

  • Assets
    • Bank
    • Accounts Receivable
    • Other Current Asset
    • Fixed Asset
    • Other Asset
  • Liabilities
    • Accounts Payable
    • Credit Card
    • Other Current Liability
    • Long-Term Liability
  • Equity
  • Income
  • Cost Of Goods Sold
  • Expense
  • Other Income
  • Other Expense

Just keep in mind that QuickBooks will always ignore your account numbering scheme in favor of the account type. For example, if your liability accounts begin with 10000 and your asset accounts begin with 20000, QuickBooks will sort them by type, putting asset accounts (20000) at the head of the Chart of Accounts, followed by liability accounts (10000).


Be Sociable, Share!

Comments are closed.