Turning on Chart of Account Numbers

Adding numbers can help you identify the type of accounts, thereby speeding up your account selection on various forms. You might want to develop and follow a consistent account naming and numbering convention. Also please note it is essential for Xero to have a when we are converting the data - if it does not exist we will create one.

For example:

       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

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.

3. Click Advanced on the left-hand side.

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.

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

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

7. Click the green Save button.

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

NOTE: if you do not add Chart of Account codes prior to conversion we will generate a code as "NOCODE" to define coded and uncoded Accounts.

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

Numbers will now be visible in your Chart of Accounts. If you haven’t assigned any numbers yet I’ll show you how to do that as well.

NOTE: if you do not add Chart of Account codes before conversion we will generate a code as "NOCODE" to define coded and uncoded Accounts.

Assigning Numbers to Accounts Quickbooks Online

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

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

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.

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.

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 come across in the conversion regardless of their status. This is because there may be transactions associated with these accounts. If you have accounts that you do not want to use you can ...

• Updating the Chart of Accounts in Xero

  The Chart of Account information can be updated post-conversion. The most efficient way to update this information is in bulk. This includes exporting the chart of accounts from Xero, updating the details and re-importing this information back into ...

• 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 ...

• Other Considerations

  Account numbers The hyphen is removed from the number as part of the process, for example 4-1000 in MYOB becomes 41000 in Xero or 4.100 in Reckon comes across at 4100. Note Xero has a limit of 10 numbers, so if the source is longer it maybe truncated ...