Turning on Chart of Account Numbers

Turning on Chart of Account Numbers

Turning on account numbers in your source can help you quickly identify the account, streamline selection when entering transactions and customising reports. We recommend developing a consistent naming and numbering convention for chart of account management.

Important information for Conversions

Xero requires account numbers in order to import the chart of accounts. If account codes have not been set up in the source then system generated numbers will be applied during the conversion (EG: "NOCODE52"). Whilst these can be updated post conversion, we recommend turning on account numbers in the source prior to the conversion.
Idea
Example numbering convention:
       1000-1999 - Assets
      2000-2999 - Liabilities
      3000-3999 - Equity
      4000-4999 - Income
      5000-5999 - Cost of Goods Sold

      6000-6999 - Expenses
      7000-7999 - Other Income
       8000-8999 - Other Expense

AlertNOTE: If account numbers/codes are not added to the Chart of Account codes before conversion, system generated codes such as "NOCODE" will be applied.

Turning on Account Numbers Quickbooks Online

1. Click the gear ⚙ in the upper right-hand corner.

2. Click Account and Settings in the Your Company section.

Quickbooks account settings

3. Click Advanced on the left-hand side.

Quickbooks advanced account settings

4. In the 3rd option, Chart of Accounts, you’ll see Enable account numbers is off. Click the pencil ✎ on the right-hand side of this section.

Quickbooks Chart of Accounts advanced setttings

5. Check the Enable account numbers box, you’ll see “off” change to “on.”

Quickbooks enabling account numbers in settings

6. A Show account numbers checkbox will appear, check this box as well.

Quickbooks option to show account numbers

7. Click the green Save button.

8. Click the green Done button in the lower right-hand corner of the screen.

Turning on Account Numbers for Reckon & QuickBooks Desktop

1. Go to the Edit menu > click Preferences.



2. Accounting > Company Preferences > tick Use Account Numbers > OK


AlertInfo
Numbers will now be visible in your Chart of Accounts. If you haven’t assigned any numbers yet, To assign numbers to existing accounts:
1. Go to the Edit Account Window
2. Change the assigned account number

Assigning Numbers to Accounts Quickbooks Online

1. In the right-hand menu select Accounting and then Chart of Accounts.

Quickbooks navigating to Chart of Accounts

2. Click the drop-down next to View register on an account and click Edit.

Quickbooks view account register

3. The Number field will be on the right under Name. Enter a number and then click the green Save and Close button in the lower right.

Quickbooks adding a number to an account

You’ll now see the number in the Number field in your Chart of Accounts. This number will also appear in the Name field in front of the accounts name. The accounts name has not changed this is just how Quickbooks displays it.

Quickbooks, viewing an account number in the Chart of Accounts

If you view your Balance Sheet you will now see your accounts in order by number instead of alphabetically. 

Assigning Numbers for Reckon & QuickBooks Desktop

1. Lists > Chart of Accounts > Select the account and right-click Edit Account






3.  In the Edit Account window,  in the right-hand field labelled Number enter your numbering system.


4. Click Save & Close then proceed with the next account.
      
    • Related Articles

    • Chart of Accounts

      Chart of Accounts All accounts—including bank accounts—are brought into Xero during conversion, regardless of whether they are marked active or inactive in the source. This ensures historical transactions remain intact. If you no longer need certain ...
    • Updating the Chart of Accounts in Xero

      Updating the Chart of Accounts in Xero The Chart of Accounts can be updated after conversion, and the most efficient way to do this is in bulk. Simply export the chart from Xero, make your updates, and re-import it back into the system. IMPORTANT ...
    • Bank Account Mapping

      Bank Account Mapping is available with the Accelerate and Custom Package, and can be added in Standard Package as an optional feature . Under the Standard Package we convert the chart of account based on the account type in the source file - for ...
    • Custom Change your Chart of Accounts Service

      Customising my Chart of Accounts as to how it should appear in Xero With this service, you select how you want the Chart of Accounts to appear in Xero, prior to conversion. The full desktop file history will then present in Xero as though it had been ...
    • Account Types In Xero

      During the conversion we will import the accounts as per the setup of the source file unless you have elected a package that allows you to change bank accounts during the conversion process or you have over 990 accounts in your chart of accounts. It ...