How to Convert from Sage 50 to QuickBooks Desktop?

Do you feel the need to move your accounting data from Sage 50 over to QuickBooks Desktop? You can convert […]

Voiced by Amazon Polly

Do you feel the need to move your accounting data from Sage 50 over to QuickBooks Desktop? You can convert your QuickBooks company data to the Sage 50 format. Sage 50 will convert most QuickBooks lists such as accounts, vendors, customers, items, employees, jobs, transactions, and current balances. Converting Sage to QuickBooks is not the most straightforward do-it-yourself work for companies to handle. Guidance for Sage 50 to QuickBooks Conversion.

Make Your Conversion

Discover if your conversion is possible and what it costs. Get your quote!

An implementation from one software to another will never be an overnight task since there are many factors that need to be taken into consideration: Customer List, Inventory List, Vendor List, Costs, Average costs, Chart of Accounts, Accounts Receivable, etc. All versions of Sage 50 can be converted to QuickBooks Desktop or QuickBooks Online. The QuickBooks Data conversion service audits the results to ensure all financial reports such as the Profit, Loss, Trial Balance, and Balance sheets in QuickBooks will match the original Sage 50 data.

Convert from Sage 50 to QuickBooks Desktop – Steps to Follow

Step 1: Review the Conversion Requirements

Before you start, check the system requirements for the conversion tool.

Operating System:Windows 10, Windows 8.1, Windows 8
Processor:500 MHz Intel Pentium II (minimum)
Memory (RAM):512 MB (minimum)
Hard Drive:2.5 GB of free space (recommended)
Microsoft .NET Framework:Version 2.0 (minimum)
QuickBooks Desktop:Pro, Premier, or Enterprise 2018 or higher
Sage 50, Sage 50 QuantumVersion 2015 and above

Note: If you have have Peachtree, Sage 50 (2014 or older), Sage100, Sage 300, or Sage Industry Specific, this tool won’t work for you.

If you haven’t already, make sure your computer meets the QuickBooks Desktop system requirements.

Items that can be converted using Conversion Tool

  • Account, Employee, Item, Customer, and Vendor lists.
  • Account balances.
  • Employee profile and contact info.
  • Customer and vendor transactions.
  • Paychecks (convert as journal entries)
  • Payroll General Ledger account balance info.

Things that cannot be converted include:

  • Payroll items are used to calculate paychecks (hourly and salary payroll items, deductions, medical insurance, etc.)
  • Payroll transactions and year-to-date employee info (paychecks, year-to-date adjustments).
  • Individual employee wage or deduction information.
  • Work tickets.
  • Fixed Assets.
  • Closed or partly closed Purchase Orders, Sales Orders, and Estimates.

In some instances, fields are not compatible and are not transferred over. You will have to enter such fields after the Conversion manually.

Examples of such are vendor default account numbers, multiple shipping addresses for customers, preferred vendors for inventory, and default Customer Sales Tax settings.

Also, Please keep in mind that you can only convert versions of Sage 50 and QuickBooks desktop from the same region. If you have a US version of Sage 50, then you will need to convert it to a US version of QuickBooks desktop.

The following limitations of service can happen when you move from Sage 50 to QuickBooks Desktop with the QB Conversion Tool:

The following limitations may occur when you are transferring data from Sage 50 to QuickBooks Online:

  • Positions for Chart of Accounts Numbers: QuickBooks does not support a chart of account numbers that exceed the length of seven numerals. The migration will fail if any accounts in your Chart of Accounts are seven numerals or longer.
  • Future Transactions: Transactions will be posted to QuickBooks Desktop in the future if the journals have a future date.
  • Multi-currency limitations: A home currency is used for all foreign currency data transfers.
  • Reversed Journals: Reversed journals will not be posted.
  • Some Debtor or Creditor Transactions may not be Posted as Expected: QuickBooks Conversion Tool might need to use a “dummy” customer or supplier to align your AR and AP history.
  • Historical Migrations of Accounts: Sage 50 enables you to transfer balances to new accounts at the close of the year, which QuickBooks does not support, as it does not support fiscal years.
  • Historical Migrations of Accounts: Sage 50 enables you to transfer balances to new accounts at the close of the year, which QuickBooks does not support, as it does not support fiscal years.
  • Renaming of Sage 50 System Accounts: It can support renaming of normal balance sheet accounts, but renaming the system accounts (for example, Retained Earnings, Accounts Receivable, Accounts Payable, etc.) can cause issues after the Conversion. Revert any renaming of system accounts back to the original settings before attempting to migrate.
  • Data Integrity Check Issues: If your file fails the Data Integrity check (Maintenance -> Data Integrity Check), then you may experience several issues during the Conversion.

Step 2: Prepare for the Conversion

To avoid conversion tool errors, make sure that you save your file locally.

  • If you haven’t already, install QuickBooks Desktop on the same system as Sage 50.
  • Make sure your Sage 50 and your QuickBooks Desktop data are saved on your local hard drive. If it is not, move it to your local hard drive before you start. The conversion tool will encounter an error if you are hosting a file over a network or on a server.

Note: If your data file is located on a server, you need to convert it on the server computer.

  • Now create a backup of your Sage 50 data before you start.

Step 3: Setup Sage 50

Important: You must have admin user access to perform the following steps:

  • First of all, open Sage 50 and the file you want to convert.
  • Then from the main menu, select Maintain.
  • Then select Users and then Setup Security.
  • Next, Select the Data Access/Crystal Reports tab.
  • Then select With the following login information option. (Note: You can’t change the ID field.)
  • Now choose Change and set a password for the transfer.
  • Note: The new password has an 8-character limit, and exceeding the limit will cause the conversion tool not to work.
  • After you set your new password, click on OK, then close Sage 50.

Step 4: Download the Conversion Tool

  • You need to download the QuickBooks Conversion Tool.
  • Find and open the folder you saved the downloaded file to.
  • Then right-click on the QuickBooks Conversion Tool icon, then select Properties.
  • Under Compatibility mode, select the checkbox for Run this program in compatibility for: and choose Windows 8 (even if you have Windows 10) from the dropdown and then click on OK.
  • Now right-click QuickBooksConverstionToolSetup.exe and select Run as Administrator.

Step 5: Convert Your Data

  • In the conversion tool, click on Browse.
  • Locate and select the Sage 50 company file you need to convert.
  • In the Pervasive 32-bit ODBC engine DSN Setup window, select your Sage 50 company file from the Database Name dropdown menu.
  • If you have multiple files, you may need to scroll to find your company name and then click on OK.
  • Then enter the Sage 50 password you just created. Then select Next.
  • Select the QuickBooks Desktop version and edition you’re moving your Sage data into.

Note: Don’t add any special characters (:<?*&/ etc.) as this will result in an error.

  •  Select Browse and choose the folder to save your converted data to, and then select Next. If you don’t pick a folder, the default is your My Documents folder. We highly recommend you import into a file that is no more than 2 folders deep.
  • Now review what you entered. If everything looks good, select Convert File to start the Conversion. This will launch QuickBooks and the QuickBooks – Application Certificate window requesting access to the company file.
  • QuickBooks will launch automatically. A certificate will pop-up. Select Yes, Prompt Each time and then Continue.

Note: This may prompt twice.

The conversion tool runs automatically. It might take some time to convert your data. The tool will let you know if the Conversion is successful or not.

Once the Conversion finishes, you’ll see a prompt to Open in QuickBooks. It will take a few minutes to open your file.

Step 6: Review the Conversion

When the Conversion is completed, select Open in QuickBooks. Review your data in QuickBooks and make sure everything is there. Then review the transfer log:

  • First of all, open the Windows Start menu.
  • Then, search for and open File Explorer.
  • Go to C:\USERS\[Your Windows User Name]\My Documents\Intuit\QuickBooks.
  • Now review the failed transaction log file in the folder. This tells you if any data didn’t transfer over.

After you review the log, you are good to go.

Possible Errors During Conversion

If you notice an error that says, “It looks like something went wrong,” then:

  • Your file might not be saved locally. You will get this error if you are hosting a file over a network or on a server. Install Sage 50 on a different computer that’s not on the network or server. Create a back up in Sage 50 and Restore Local to your computer. This is usually your C Drive.
  • Your file name has a special character in the saved name. Remove any special characters in the name before you save the file.

If you notice an error that says, “We just need a little more info,” then:

It looks like you need to run the Conversion tool in Compatibility mode.

  • First of all, right-click on the QuickBooks Conversion Tool icon, then select Properties.
  • Under Compatibility mode, select the checkbox for Run this program in compatibility: choose from the dropdown your Windows operating system and then select OK.
  • Now right-click QuickBooksConverstionToolSetup.exe and select Run as Administrator.

What Can You Expect After the Conversion?

  • They will send you a complete post-conversion checklist to get you up and to run in your QuickBooks.
  • They will send you a QuickBooks backup file that could restore into a new QuickBooks file on your system.
  •  They will send you a transaction report that failed to import (in most of the conversions, 100% of the transactions are converted).
  • If you are using Assembly Items or Advanced inventory, you might have to manually add inventory adjustments to your converted data file to match quantities in your QuickBooks with Sage 50. This occurs due to the variations in the way inventory is managed in QuickBooks v/s Sage 50.
  • Seldom, the source data file will contain transactions that are supported in Sage 50 but not in QuickBooks. They use standard workarounds to import transactions into QuickBooks Online and will send you notes on what you have to do post-conversion to handle such transactions.
Accounting Professionals, CPA, Enterprises, Owners
Accounting Professionals

Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-800-596-0806 or chat with experts.



Frequently Asked Questions (Faqs)

How can I Export from Sage 50 to my QuickBooks?

First of all, check the system requirements. Then prepare for the Conversion. Setup Sage 50 and download the conversion tool. Now convert your data and review the Conversion.

How much time will it take to Transfer my Data?

The process of converting your data takes, on average, up to 72 hours from the time your data is uploaded.

How will my Business Data be Protected?

Your business data can be protected as long as you use the online form to upload. It is protected using industry-standard SSL encryption. Your data is also governed by Intuit’s Data Stewardship Principles.

Features of Dancing Numbers for QuickBooks Desktop

Imports

Imports

Exports

Exports

Deletes

Deletes

Customization

Customization

Supported Entities/Lists

Dancing Numbers supports all QuickBooks entities that are mentioned below:-

Customer Transactions

Invoice
Receive Payment
Estimate
Credit Memo/Return Receipt
Sales Receipt
Sales Order
Statement Charge

Vendor Transactions

Bill
Bill Payment
Purchase Order
Item Receipt
Vendor Credit

Banking Transactions

Check
Journal Entry
Deposit
Transfer Funds
Bank Statement
Credit Card Statement
Credit Card Charge
Credit Card Credit

Employee Transaction / List

Time Tracking
Employee Payroll
Wage Items

Others

Inventory Adjustment
Inventory Transfer
Vehicle Mileage

Technical Details

Easy Process

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Error Free

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

On-time Support

We provide round the clock technical assistance with an assurance of resolving any issues within minimum turnaround time.

Pricing

img

Importer, Exporter & Deleter

*See our Pricing for up to 3 Company Files

$199/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Unlimited Export
  • Unlimited Import
  • Unlimited Delete

img

Accountant Basic

*See our Pricing for up to 10 Company Files.

$499/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer,Exporter,Deleter
  • Unlimited Users
  • Unlimited Records
  • Upto 10 companies

img

Accountant Pro

*See our Pricing for up to 20 Company Files.

$899/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 20 companies

img

Accountant Premium

*See our Pricing for up to 50 Company Files.

$1999/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 50 companies

Dancing Numbers: Case Study

Frequently Asked Questions

 
How and What all can I Export in Dancing Numbers?

You need to click "Start" to Export data From QuickBooks Desktop using Dancing Numbers, and In the export process, you need to select the type you want to export, like lists, transactions, etc. After that, apply the filters, select the fields, and then do the export.

You can export a Chart of Accounts, Customers, Items, and all the available transactions from QuickBooks Desktop.


How can I Import in Dancing Numbers?

To use the service, you have to open both the software QuickBooks and Dancing Numbers on your system. To import the data, you have to update the Dancing Numbers file and then map the fields and import it.


How can I Delete in Dancing Numbers?

In the Delete process, select the file, lists, or transactions you want to delete, then apply the filters on the file and then click on the Delete option.


How can I import Credit Card charges into QuickBooks Desktop?

First of all, Click the Import (Start) available on the Home Screen. For selecting the file, click on "select your file," Alternatively, you can also click "Browse file" to browse and choose the desired file. You can also click on the "View sample file" to go to the Dancing Numbers sample file. Then, set up the mapping of the file column related to QuickBooks fields. To review your file data on the preview screen, just click on "next," which shows your file data.


Which file types are supported by Dancing Numbers?

XLS, XLXS, etc., are supported file formats by Dancing Numbers.


What is the pricing range of the Dancing Numbers subscription Plan?

Dancing Numbers offers four varieties of plans. The most popular one is the basic plan and the Accountant basic, the Accountant pro, and Accountant Premium.


How can I contact the customer service of Dancing Numbers if any issue arises after purchasing?

We provide you support through different channels (Email/Chat/Phone) for your issues, doubts, and queries. We are always available to resolve your issues related to Sales, Technical Queries/Issues, and ON boarding questions in real-time. You can even get the benefits of anytime availability of Premium support for all your issues.


How can I Import Price Level List into QuickBooks Desktop through Dancing Numbers?

First, click the import button on the Home Screen. Then click "Select your file" from your system. Next, set up the mapping of the file column related to the QuickBooks field. Dancing Numbers template file does this automatically; you just need to download the Dancing Number Template file.

To review your file data on the preview screen, just click on "next," which shows your file data.


What are some of the features of Dancing Numbers to be used for QuickBooks Desktop?

Dancing Numbers is SaaS-based software that is easy to integrate with any QuickBooks account. With the help of this software, you can import, export, as well as erase lists and transactions from the Company files. Also, you can simplify and automate the process using Dancing Numbers which will help in saving time and increasing efficiency and productivity. Just fill in the data in the relevant fields and apply the appropriate features and it’s done.

Furthermore, using Dancing Numbers saves a lot of your time and money which you can otherwise invest in the growth and expansion of your business. It is free from any human errors, works automatically, and has a brilliant user-friendly interface and a lot more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


Is it possible to use the Direct Connect option to sync bank transactions and other such details between Bank of America and QuickBooks?

Yes, absolutely. You can use the Direct Connect Option by enrolling for the Direct Connect service which will allow you access to the small business online banking option at bankofamerica.com. This feature allows you to share bills, payments, information, and much more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


What are the various kinds of accounts you could access in QuickBooks?

QuickBooks allows you to access almost all types of accounts, including but not limited to savings account, checking account, credit card accounts, and money market accounts.

Get Support

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

Top