How are accounts auto numbered?

Sage 50 will use the following rules when it numbers your accounts:

  • Sage 50 will convert Account Types according to the table below.

QuickBooks Type

Sage 50 Type

Bank

Cash

Accounts Receivable

Accounts Receivable

Other Current Assets

Other Current Assets

Fixed Assets

Fixed Assets

Other Assets

Other Assets

Accounts Payable

Credit Card

Accounts Payable

Other Current Liabilities

Other Current Liabilities

Long Term Liability

Long Term Liability

Equity

Equity - doesn't close (if Corporation, S-Corporation, or Partnership)

Equity - gets closed (if Sole Proprietor)

Income

Other Income

Income

COGS

Cost of Sales

Expense

Other Expense

Expense

Sub accounts, sub accounts of, descriptions, and bank numbers are not converted to Sage 50.

The system shall group the accounts, using the current account type mapping, and assign numbers based on the range of account numbers detected for a selected type. The account number range for an account type shall be determined as follows:

  • The smallest number detected for a group of accounts with the same account type to the smallest number determined by Sage 50 for the next account type minus(-) 1. For example, if your bank account types begin at 1000 and your accounts receivable account is 1500, Sage 50 will number all of your bank account types between 1000 and 1499.

Note: If a range of numbers for a GL account type cannot be determined, the system will not assign account numbers for that account type.

  • For a range of account numbers for a specific account type, for any accounts of that type that do not have an account number, Sage 50 will detect the highest number in the range and add 10 to start assigning numbers. For example,
  1. Cash accounts have a specified range of 1000 – 1999.
  2. Eight cash accounts exist but only five of those cash accounts are numbered: 1000, 1100, 1200, 1300, 1400.
  3. Sage 50 will assign the numbers 1410, 1420, and 1430 to the three un-numbered cash accounts.
  • If no QuickBooks account numbers are detected, Sage 50 will assign a range of account numbers based on the current ranges used in Sage 50. The broad ranges are as follows:
  • Account Type Range of numbers
    Assets 1000-1999
    Liabilities 2000-2999
    Equity/Capital 3000-3999
    Income/Revenue

    4000-4999

    Cost of Goods Sold 5000-5999
    Expenses

    6000-9999

  • If Sage 50 cannot assign a number to a certain account, you will be given the opportunity to assign it manually.