Moving from Sage 50 to QuickBooks Online can help businesses manage their accounting through a cloud-based platform while making financial information easier to access. However, transferring accounting records between two systems requires careful preparation to avoid data discrepancies.
The Sage 50 to QuickBooks Online conversion process uses the Dataswitcher conversion wizard to transfer supported accounting data automatically. The service supports accrual-basis accounting only, so businesses using cash-basis accounting should review the requirements before starting.
This guide explains how to prepare Sage 50, set up QuickBooks Online, transfer your accounting data, and verify the results after the conversion.
What Data Can Be Converted from Sage 50 to QuickBooks Online?
Dataswitcher can convert up to two fiscal years of selected Sage 50 data at no charge. The supported information includes:
- Opening balances
- Customers and vendors
- Chart of accounts
- Invoices and credits
- Journal entries
- Transactional history
- Matched payments
The conversion has specific requirements and limitations, so reviewing the supported data before migration can help prevent unexpected results.
Sage 50 and QuickBooks Online Conversion Requirements
Before you begin the migration, make sure your accounting software meets the required conditions.
Sage 50 Requirements
You must use the US edition of Sage 50cloud, formerly known as Peachtree, with a 2016 or later version.
QuickBooks Online Requirements
You need a paid QuickBooks Online US subscription. If you are currently using a free trial, upgrade the subscription before completing the conversion.
Accrual Accounting Is Required
The conversion service does not support cash-basis Sage 50 files. Your Sage 50 company must use the accrual accounting method from the beginning. Simply changing a company from cash basis to accrual basis before conversion will not make the file eligible if it was originally created using cash basis.
Required User Permissions
The person handling the conversion needs:
- Full Access permission in Sage 50
- Admin permission in QuickBooks Online
It is also recommended that an accountant or someone with accounting expertise oversee the conversion.
How Long Does It Take to Convert Sage 50 to QuickBooks Online?
The conversion time depends on the size and format of your Sage 50 file. According to the supplied conversion guidance, processing can take up to 72 hours after the data is uploaded to Dataswitcher.
This timeframe does not include the preparation you must complete before submitting the file or the review required after the conversion. If your file has not been converted after 72 hours, contact QuickBooks Online support.
What Sage 50 Data Will Not Transfer?
Not every Sage 50 feature or record transfers to QuickBooks Online. Unsupported data includes:
- Budgets
- Memorized transactions
- Invoice and other templates
- Attachments
- Projects
- Deleted transactions
- Reversed journal entries
- Bank reconciliation history
- Fixed assets
- Sales orders
- Work tickets
- Certain estimates and purchase orders
- Year-end transactions
- Certain payroll information
Payroll information such as employee year-to-date pay data and payroll setup details also cannot be converted through this process.
Because some information does not migrate, keep a secure backup of your Sage 50 company file and important reports for reference and auditing.
Important Sage 50 to QuickBooks Online Conversion Limitations
Understanding the limitations before you migrate can help you plan the process more effectively.
For example, QuickBooks Online does not support account numbers containing eight or more characters. Multiple Accounts Receivable and Accounts Payable accounts in Sage 50 are also merged into the corresponding single accounts used by QuickBooks Online.
Sage 50 jobs become classes in QuickBooks Online, while departments become locations. Foreign-currency transactions are converted using the historical exchange rates recorded in Sage 50. The conversion wizard supports up to 1,000 inventory items; businesses with more inventory may need to import or create additional items manually.
Another important limitation involves transactions entered after submission. Any new transactions added to Sage 50 after the file is sent to Dataswitcher will not be included. Likewise, you should not use QuickBooks Online during the conversion because new QuickBooks transactions can interfere with the process.
How Can You Prepare Sage 50 Before Conversion?
Proper preparation is one of the most important parts of a successful Sage 50 to QuickBooks Online migration.
1. Complete the Current Tax Period
Whenever possible, plan the conversion at the end of a tax period rather than in the middle of one. Complete the required tax reporting in Sage 50 before beginning the migration.
2. Check the Sage 50 File
Run the Sage 50 integrity check before sending your data. Go to Help > Support Utilities > Integrity Check and resolve any inconsistencies that appear.
3. Review Account Numbers
Check your Sage 50 Account IDs and make sure they fall within the appropriate account-number ranges. Review unnecessary or incorrect account numbers and classify transactions sitting in suspense accounts where appropriate.
4. Match Outstanding Payments and Credits
Match outstanding payments and credit memos with their related invoices whenever possible. Unmatched items may be transferred as journal entries and require additional work after conversion.
5. Reconcile Your Accounts
Before conversion, reconcile your:
- Bank accounts
- Tax accounts
- Accounts Receivable
- Accounts Payable
Run the required reports and confirm that the balances agree with the General Ledger.
6. Save Important Reports
Export copies of your Sage 50 financial reports before starting. Recommended reports include the Balance Sheet, Trial Balance, Income Statement, bank balances, Aged Receivables, Aged Payables, and applicable sales tax reports. These reports will provide a reference for checking your QuickBooks Online data later.
7. Create a Sage 50 Backup
Create a backup of your Sage 50 company file before submitting it for conversion. You should also securely store important accounting and tax reports for future reference.
How Can You Prepare QuickBooks Online for the Migration?
Your QuickBooks Online company should be ready to receive the converted data.
If the QuickBooks Online company already contains transactions, those transactions need to be removed before the conversion. Sales tax should also not be enabled before the migration. In addition, do not connect bank or credit card accounts until the post-conversion process instructs you to do so.
If you use multiple currencies, departments, or projects in Sage 50, review the corresponding QuickBooks Online settings and enable the appropriate features after completing the required reset steps.
How Do You Convert Sage 50 to QuickBooks Online?
Once both systems are properly prepared, you can begin the actual conversion.
- Complete all mandatory Sage 50 and QuickBooks Online preparation tasks.
- Create the required conversion file.
- Open the Dataswitcher conversion wizard.
- Enter your company and contact information.
- Select the conversion plan and review the available options.
- Confirm the data you want to migrate.
- Verify that all mandatory preparation tasks are complete.
- Upload the prepared Sage 50 file.
- Allow Dataswitcher to check your QuickBooks Online account.
- Start the conversion process.
- Monitor the conversion status using the provided link.
During the conversion, do not use QuickBooks Online. This helps prevent changes from interfering with the migration.
How Can You Review the Converted QuickBooks Online Data?
After Dataswitcher completes the conversion, you will receive an email indicating that the conversion is ready for review. You have 72 hours to review and approve the conversion.
Before approving the migration, compare your QuickBooks Online reports with the reports you exported from Sage 50.
QuickBooks Online Report | Sage 50 Report |
Balance Sheet | Balance Sheet |
Trial Balance | Trial Balance |
Accounts Receivable Aging Summary | Aged Receivables |
Accounts Payable Aging Summary | Aged Payables |
Profit and Loss | Income Statement |
If the figures do not match and you cannot identify the cause, contact QuickBooks Online support.
Reconcile Converted Transactions
Before connecting bank or credit card accounts, mark the transactions converted from Sage 50 as reconciled. QuickBooks Online does not automatically know that these transactions were previously reconciled in Sage 50. Completing this step ensures future reconciliation begins from the appropriate point.
You should also review unmatched Accounts Receivable and Accounts Payable entries. Manual journal entries posted to AR or AP accounts may appear under suspense customer or vendor accounts and need to be linked to their appropriate invoices or bills.
Start Using QuickBooks Online After Conversion
Once you have reviewed the converted data, completed the mandatory post-conversion tasks, and approved the migration, you can begin using QuickBooks Online.
Take time to familiarize yourself and your team with the new accounting system. Training materials, tutorials, webinars, and getting-started resources can make the transition easier for users who are new to QuickBooks Online.
Final Thoughts
Converting Sage 50 to QuickBooks Online can be a practical way to move your accounting operations to an online platform, but preparation is essential. Start by checking your Sage 50 file, reconciling accounts, exporting comparison reports, creating a backup, and ensuring QuickBooks Online meets the conversion requirements.
After Dataswitcher completes the migration, carefully compare your financial reports and complete the required reconciliation and matching steps. By reviewing the converted data before you begin daily bookkeeping, you can identify potential discrepancies early and make the transition to QuickBooks Online smoother.
