QuickBooks Conversion - Post-Conversion Checklist
Because Sage 50 Accounting does not work the same way that QuickBooks does, it is important to check your Sage 50 Accounting settings and records to make sure your new company is set up correctly.
Before you begin using Sage 50 Accounting, review the areas that apply to your company in this final checklist and make any necessary changes. To print the full checklist for future reference, click the Show All icon at the top of this topic and then click the Print button on the toolbar.
Settings
Budgets
Make sure that the account balances are correct for your budget. Sage 50 Accounting rolls up multiple budgets from one fiscal year into one budget. If an account was used in more than one budget, only the amount from the first occurance of the account gets imported.
Payroll
- All Incomes that use the Type "Income," are subject to Vacation, EHT (Ontario) and QHSF (Quebec).
- By default all Deductions are deducted after Vacation, EHT (Ontario), and QHSF (Quebec)are calculated. Change these settings for each deduction as necessary.
- Make sure the desired accounts are being used to track payroll transactions (Linked Accounts). Because Sage 50 Accounting uses a different account to track each Payable and Expense, additional accounts may have been created for your company.
- All employees are classified as Salespeople and are available in the Salesperson list in the transaction windows. If you want to remove some employees from this list, you need to open Payroll Settings and create a Job Category that does not include salespeople. You can then assign that category to employees who are not in sales.
- Make sure your payroll settings for Incomes are subject to the correct taxes.
- Make sure payroll Deductions are correctly being taken off paycheques.
- Set up your payroll remittance by creating a remittance vendor record and entering your payroll Taxes and Deductions for your remittance vendor.
- Make sure the Employment Insurance (EI) is correct for future new employee records. During conversion, Sage 50 Accounting automatically assigns a rate of 1.4 in the EI Factor for new employees box.
Currencies
- Make sure your currency names and symbols are correct.
- Check the exchange rate of each currency.
Credit Cards
If your company uses or accepts credit cards, check the credit card information for Sage 50 Accounting to track them. Open Setup, Settings, Company, Credit Cards, and then either Used or Accepted.
Custom Field Names
Any custom field names that you were using in QuickBooks were not converted. You need to re-enter the names for each field. Open the Setup menu, select Settings, the module for which you want to customize the field names, and then select Names.
Records (Lists)
Accounts
- Make sure that all account balances are equal to the sum of all the transaction entries. In the Home Window, from the Maintenance menu, select Check Data Integrity.
- Accounts that had balances and were Inactive in QuickBooks will be Active in Sage 50 Accounting. Make these accounts inactive.
Employee Records
- Make sure the employee names have been entered last name first, first name last. This is required for T4 reporting.
- Make sure the correct birth date has been entered for each employee. This is required for determining CPP contributions. If this field is blank in QuickBooks, Sage 50 Accounting defaults the date to 1980.
- Make sure that all of the address and contact information is correct.
- Enter Historical Amounts for each employee (YTD amount before converting to Sage 50 Accounting).
- Enter the wage information for your employees, including hourly amounts and annual salary amounts.
- Enter the Income, Deduction, and Tax information in all the employee records.
- Make sure the Employment Insurance (EI) rate is correct for each employee records. During conversion, Sage 50 Accounting automatically assigns a rate of 1.4 for each employee.
Customer Records
- Make sure the desired accounts are being used to track customer transactions. Open Setup, Settings, Customers and Sales, and then Linked Accounts.
- Make sure all of the address and contact information is correct.
Vendor Records
- Make sure the desired accounts are being used to track vendor transactions. Open Setup, Settings, Vendors and Purchases, and then Linked Accounts.
- Make sure all of the address and contact information is correct.
Inventory and Service Records
- Compare the inventory values of your QuickBooks Inventory Valuation Summary report to the Sage 50 Accounting Inventory Summary report. If the values are different, correct the opening values in the History tab of each Inventory & Service record.
- Make sure the desired accounts are being used to track inventory. Check the accounts listed on the Linked tab for each item. You should also check the linked accounts located in Setup, Settings, Inventory and Services, and then Linked Accounts.
- If you use the Per Item price level in QuickBooks, set up the Per Item price list in Sage 50 Accounting.
Time Slips
Transactions
Compare your QuickBooks Customer and Vendor Balances reports to the Sage 50 Accounting Customer and Vendor Aged reports. If the balances are different, correct them in Sage 50 Accounting by entering a transaction or general journal entry.
Additional Information
Introduction
Pre-Conversion Checklist
Data Conversion Details
Troubleshooting