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,
- Cash accounts have a specified range of 1000 – 1999.
- Eight cash accounts exist but only five of those cash accounts are numbered: 1000, 1100, 1200, 1300, 1400.
- 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:
- If Sage 50 cannot assign a number to a certain account, you will be given the opportunity to assign it manually.
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 |