Convert Peachtree to QuickBooks

Migrating from Peachtree to QuickBooks is a very simple process because Intuit has provided several tools that can aid you in the process.

If you’ve already decided to move to QuickBooks from Peachtree, now Sage 50, you can find the required solutions in this post.

You can rely on the QuickBooks conversion tool to move your data from Sage 50 (formerly Peachtree) to QuickBooks. The conversion tool automatically transfers most of your accounting data, especially the most important one.

User Navigation

Know Quickbooks and PeachTree

QuickBooks

QuickBooks is a major type of accounting software, which is developed and sold by a top-notch software package company Intuit. This software is perfectly designed for small and medium-sized enterprises. To make their account and bookkeeping work straight and simple. With the help of QuickBooks, the user will be able to perform multiple accounting tasks.

  • Managing payroll
  • Managing Income and Expenses
  • Tracking the financial business health
  • Bill management and payments
  • Accept and forward business payments
  • Monitoring the growth in the business.
  • Configuring reminders for future payments to be made.

Peachtree

Peachtree Accounting Software is developed by Sage Software Package for Small and Medium Sized Enterprises. Currently, everyone knows by the name of Sage 50. This software allows accountants and managers to accomplish some great work. that takes a lot of time if it’s done by any human. Some features are given below, which process the Sage 50.

  • Tracking bank transfers and payroll.
  • Creating financial statements.
  • track Invoices
  • Import and Edit Spreadsheets
  • Pay attention to the payable and Receivable
  • Processing scanned invoices, receipts, and checks

The features of QuickBooks

  • QuickBooks has a very clean and user-friendly interface
  • QuickBooks supports both Mac and Windows versions
  • QuickBooks has also launched an online version that can be done anytime, anywhere.
  • QuickBooks also has a cloud-based interface.

The features of Peachtree

  • Peachtree can manage inventories as LIFO, FIFO, and serialized
  • 40 users can work on it simultaneously.
  • To check for duplicate and suspicious entries, a feature called Gap comes in Peachtree.

QuickBooks and Peachtree Both accounting packages are world famous. Though Peachtree software is a great package for bookkeeping and accounting and you just need to maneuver in QuickBooks for the performance of Higher Expertise and Advanced Financial. If you want to convert your platform from Peachtree to QuickBooks, then you have to understand all the processes given in this post.

System Requirements for Peachtree to QuickBooks Conversion

Converting Peachtree to QuickBooks Desktop is done using the QuickBooks Desktop Conversion Tool. This tool only converts the 2013 version of Peachtree or the higher version of QuickBooks. This tool fully supports QuickBooks Desktop Professional, Premiere, and Enterprise 2016. This is required to convert peachtree into QuickBooks.

  • Microsoft .NET system rendition 2.0.0. You might encounter a Quickbooks .net system error on the off chance that you don’t have it appropriately installed.
  • Peachtree and QuickBooks Desktop ought to be installed on a Windows 10-based system
  • 512 MB of Slam and 2.5 GB of Free Hard Drive

Steps to Migrate Data from Peachtree to QuickBooks

The QuickBooks conversion tool does not work with Peachtree/Sage 50 version 2014 or older. And it doesn’t work with industry-specific versions of Sage accounting software.

Step 1: View the data that can and cannot be migrated from Peachtree to QuickBooks

You can convert the following data from Peachtree (Sage 50) to QuickBooks:

  • Transactions for vendors and customers
  • Account balances
  • Vendor, customer, employee, item and account lists
  • Paycheck information in Journal Entry format
  • Employee profiles
  • Information general ledger account balance

You cannot convert the following data from Peachtree (Sage 50) to QuickBooks:

  • Fixed assets
  • Closed Purchase Orders, Sales Orders and Estimates
  • Work tickets
  • Hourly and salary payroll items
  • Payroll deductions for social security and medicare insurance
  • Deductions from wages of employees and contractors.

Additional information about Sage 50 (Peachtree) data that you need to note when converting to Quickbooks Desktop:

  • QuickBooks desktop supports charts of account numbers only up to 7 digits. If any account number in Sage 50 is more than 7 digits, then make the required correction, or the conversion process will fail.
  • All Sage 50 transaction data – despite the currency that it is recorded in – is recorded in QuickBooks in the home currency.
  • Not all reversing journal entries are recorded in QuickBooks from Sage 50.
  • You should verify the transactions after the conversion process to make sure that the data has transferred accurately.

Step 2: Get ready to move your data to QuickBooks Desktop

Before you can use the conversion tool to bring over your data to the QuickBooks desktop from Sage 50, you need to get a few things in order. Here’s a list of the things that you should do prior to converting your accounting data:

  • Install and activate QuickBooks desktop
    The conversion tool will directly move the data into a new company file that is compatible with the QuickBooks desktop. If you don’t have the software installed on your system, then you won’t be able to verify the conversion of your accounting data.
  • Store your accounting data on your local hard drive
    Instead of storing the data on a separate server, make sure that you bring the data over to your local hard drive on which you’ll run the QuickBooks conversion tool.
  • Back up your Sage 50 data
    To make sure that you have a copy of your accounting data even if something goes wrong with the original company file, you should create a backup of your Sage 50 accounting data with the steps given below:
    • Launch Sage 50.
    • Click on File, then Back Up.
    • Choose the option to Include Company Name so that the backup file’s name gives a description of the data that it stores.
    • Click on Include Archives, especially if you’ve used Sage 50 to file taxes online.
    • Click on Include Attachments. This prevents the loss of any documents that you may have attached to transactions in Sage 50.
    • Click on Backup.
    • Choose the appropriate directory and click on Save, then Ok.

You’re now ready to convert all of your Sage 50 (Peachtree) data to QuickBooks desktop data.

Step 3: Configure Sage 50 for data migration to QuickBooks Desktop

You need to alter preferences in Sage 50 so that you can use the conversion tool to bring over the data to the QuickBooks desktop. After configuring Sage 50, you can then configure the data conversion tool with the information that you have in Sage 50.

Here are the steps to configure Sage 50 (Peachtree) for QuickBooks data conversion:

  1. Launch Sage 50 and choose the company file containing the data that you want to transfer.
  2. Click on Maintain from the main menu.
    Configure Sage 50 for data migration to QuickBooks Desktop
  3. Choose the Users option, then Set up Security.
  4. Click on the Data Access/Crystal Reports tab, then choose With the following login information option.
  5. Choose change, then input a new password so that you can later authenticate data conversion.
  6. Click on Ok to save the new password.

The password that you create in this step will be required later by the conversion tool to access the accounting data in your Sage 50 company file. If the password doesn’t match, the conversion process will fail.

Step 4: Load the QuickBooks conversion tool

The QuickBooks conversion tool is provided by Intuit and is completely free to use. You can download this program on your system and run it as an administrator to provide it with the required access level to make changes to files on your system.

Here are the steps to load the QuickBooks conversion tool, which you’ll use to migrate your accounting data:

  1. Download the QuickBooks conversion tool.
  2. Open the file that you downloaded and find the QuickBooks conversion tool icon.
    download install QuickBooks conversion tool
  3. Right-click on the Icon, then choose Properties.
  4. From the Compatibility tab, Choose windows 8 for “Run this program in compatibility for”.
    run the QuickBooks conversion tool
  5. Mark the option to Run as Administrator. Click on Ok.

The tool is now ready to use. All you need to do is link it with QuickBooks and Sage 50 (Peachtree) to begin the accounting data conversion process.

Step 5: Start the conversion process

Let’s come to the conversion process now. In this step, you have to choose the database that contains your accounting data so that the conversion tool can extract that data and create a new company file with it.

Here are the steps to convert your Sage 50 (Peachtree) data to QuickBooks desktop data:

  1. Launch the Conversion tool following the previous step.
    Start the conversion process
  2. Choose Browse.
  3. Choose the Sage 50 company file that you want to convert to  QuickBooks Desktop.
  4. Click on the Database Name dropdown menu, then choose your Company File.
    Note: if the database contains multiple company files, then you’ll have to go through them and choose the one that you want to convert to QuickBooks Desktop.
    Start the conversion process 1
  5. Enter the password that you created earlier in Step 3, which had you configure the Sage 50 program. Click on Next.
  6. Choose the QuickBooks version and edition.
    Note: the version is the year, for instance QuickBooks Desktop 2022. The edition is one of Pro, Premier and Enterprise.
  7. Click on Browse, and choose the directory to which save the converted data file to.
  8. Review your preferences, then click on Convert File.
  9. When QuickBooks automatically launches, give it access to the file.
  10. For each certificate that QuickBooks prompts you with, click Yes, then Continue.

The conversion tool will keep running until it converts all of your Sage 50 (Peachtree) data that can be brought into QuickBooks Desktop. When the process completes, the tool will give you a message.

Choose Open in QuickBooks once the conversion process completes. QuickBooks will launch and you’ll be able to review your data post-conversion.

Step 6: Verify the converted data

After the conversion process finishes, you should verify the data that was converted to make sure that your books are still accurate. You can do this by analyzing the failed transaction log and creating reports such as balance sheets.

Here are the steps to view the failed transaction log for Sage 50 to QuickBooks conversion:

  1. Launch the File Explorer from the Start menu.
  2. Open the directory C:\USERS\[Username for windows account]\My Documents\Intuit\QuickBooks.
  3. Open the Failed Transaction Log file in the directory.

The log will list all of the transactions that weren’t brought over into QuickBooks from Peachtree. You can either manually import these transactions into QuickBooks or reconvert the data by following the entire method again. The error generally occurs when users skip some of the steps mentioned above.

If the process fails, then you’ll get one of the following error messages:

  • “It looks like something went wrong”
    • The Sage 50 company file may not be stored locally. In this case, create a copy of the company file and save it on the local hard drive.
    • You didn’t remove special characters from the name of your Sage 50 company file or used a special character when naming the converted QuickBooks file.
    • Your Sage 50 company file has some internal error which has to be fixed before you can complete the conversion to QuickBooks.
  • “We just need a little more info”
    • This message generally occurs when users don’t set the compatibility mode for the conversion tool. We’ve defined the steps for the same Step 4 – load the QuickBooks conversion tool.

You can also create reports, such as a balance sheet, to verify the accuracy of your converted data. 

To create a balance sheet in QuickBooks Desktop, you can follow these steps:

  1. Click on Reports from the main menu.
  2. Hover over Company & Financial.
  3. Click on Balance Sheet Standard.
  4. Choose the As of date. (you can select today’s date.)

You can now view the summary balance sheet. If the total assets do not equal total liabilities and equity, then you need to manually enter the leftover transactions in QuickBooks.


Manually converting transactions and lists from Sage 50 (Peachtree) to QuickBooks Desktop

While you can use the QuickBooks conversion tool to convert most of your data from Sage 50, a lot of lists and transactions may not get converted because of the limitations of the conversion tool. In such cases, manually converting the transactions by exporting from Sage 50 in CSV format and then importing into QuickBooks desktop becomes necessary.

1. Migrate vendor lists from Sage 50 (Peachtree) to QuickBooks Desktop

Migrate vendor lists from Sage 50 Peachtree to QuickBooks Desktop

Steps to export the vendor list in CSV format from Sage 50 to import into QuickBooks:

  1. Launch Sage 50.
  2. Click on the Reports menu.
  3. Click ok Lists, then Vendors.
  4. Choose the Vendor lists that you want to export.
    Note: you can choose the “select all” option to choose all the available lists.
  5. Click on Ok.
  6. After Sage 50 generates the Vendor List Report, click on File, then Export.
  7. Choose the directory to which you want to export the vendor list in CSV format.
  8. Click on Save.

Sage 50 will export all the vendor lists that you chose. You can find the CSV file containing the vendor lists from Sage 50 (Peachtree) in the location that you chose in Step 7.

Before you begin to import vendor lists from Sage 50 into the QuickBooks desktop, you need to launch the CSV file using excel and adjust the columns to make the data compatible with the format that the QuickBooks desktop can import.

If you find this process difficult, then our QuickBooks experts can help you with the same.

Steps to import vendor lists in CSV format from Sage 50 to QuickBooks Desktop

  1. Download QuickBooks Import Excel CSV toolkit.
  2. Choose the directory to which you want to save the executable, then click on Save.
  3. Double click on QuickBooks_Import_Exceland_CSV.exe.
  4. Choose Browse and select the folder in which you want to extract the files for the toolkit.
  5. Click on Ok and wait for the extraction process to finish.
  6. Launch the Toolkit and follow the on-screen instructions to import the files.
  7. Choose the vendor list that you exported from Sage 50.
  8. Wait for QuickBooks to import the data.

You’ve now successfully imported the CSV file containing vendor details into QuickBooks desktop.

2. Migrate customer lists from Sage 50 (Peachtree) to QuickBooks Desktop

Migrate customer lists from Sage 50 Peachtree to QuickBooks Desktop

Steps to export the customer list in CSV format from Sage 50 to import into QuickBooks:

  1. Launch Sage 50.
  2. Click on the Reports menu.
  3. Click ok Lists, then Customers.
  4. Choose the Customer Lists that you want to export.
    Note: you can choose the “select all” option to choose all the available customer lists.
  5. Click on Ok.
  6. After Sage 50 generates the Customer List Report, click on File, then Export.
  7. Choose the directory to which you want to export the customer lists in CSV format.
  8. Click on Save.

Sage 50 will export all the customer lists that you chose. You can find the CSV file containing the customer lists from Sage 50 (Peachtree) in the location that you chose in Step 7.

Before you begin to import customer lists from Sage 50 into the QuickBooks desktop, you need to launch the CSV file using excel and adjust the columns to make the data compatible with the format that the QuickBooks desktop can import.

If you find this process difficult, then our QuickBooks experts can help you with the same.

Steps to import vendor lists in CSV format from Sage 50 to QuickBooks Desktop

  1. Download QuickBooks Import Excel CSV toolkit.
  2. Choose the directory to which you want to save the executable, then click on Save.
  3. Double click on QuickBooks_Import_Exceland_CSV.exe.
  4. Choose Browse and select the folder in which you want to extract the files for the toolkit.
  5. Click on Ok and wait for the extraction process to finish.
  6. Launch the Toolkit and follow the on-screen instructions to import the files.
  7. Choose the Customer List CSV file that you exported from Sage 50.
  8. Wait for QuickBooks to import the data.

You’ve now successfully imported the CSV file containing customer details into QuickBooks desktop.

3. Migrate chart of accounts from Sage 50 to QuickBooks Desktop

Instead of setting up a chart of accounts from scratch on the QuickBooks desktop, you can migrate the one you created in Sage 50. To do this, you have to rely on the chart of accounts report. The data is exported in CSV format, which can be imported directly into QB.

You’ll find the following information about each account in your chart of accounts in the export CSV file:

  • Ledger Name of the account
  • Control account
  • Nominal code
  • Tax rate
  • Category
  • Visibility

After exporting, you have to customize the CSV file so that you can import it directly into QuickBooks.

Note: QuickBooks supports charts of account numbers only up to 7 digits. So you should change the details of any account that doesn’t adhere to this limitation.

Steps to the export chart of account in CSV format from Sage 50 (Peachtree)

  1. From the settings menu, click on Business settings.
  2. Choose the Chart of accounts under the Financial Settings section.
  3. Click on Export Accounts.
  4. Choose CSV.

You’ll be notified by Sage 50 after the export process finishes.

Steps to import your chart of accounts from Sage 50 into QuickBooks

  1. Launch QuickBooks.
  2. From the Lists menu, choose Chart of Accounts.
  3. Click on Accounts, then Import From Excel.
    Note: QuickBooks will prompt you to create a backup of the company file before you import data from the CSV file. I recommend that you follow the on-screen instructions and create a backup to safeguard your data.
  4. Click on Browse, then choose the CSV file that you exported from Sage 50.
  5. Choose the sheet that contains the chart of accounts that you want to import into your company file.

4. Migrate sales tax data from Sage 50 to QuickBooks Desktop

In Sage 50, you can create a Sales tax report, which lists all the sales taxes that you’ve recorded and paid for a particular company file. You can filter the data according to the date. Both detailed and summary reports are available.

Steps to export sales tax data from Sage 50 to QuickBooks:

  1. Go to the Reports menu.
  2. Choose the option Sales Tax Report.
  3. Choose date range in the From and To fields.
  4. Click on Export, then choose CSV, which can be imported into QuickBooks.

Once you’ve exported the sales tax data, you can import it into QuickBooks desktop using the CSV file. The exported file contains information such as the amount of sales tax, tax authority and agency, taxable sales and tax rate.

Steps to import sales tax data from Sage 50 to QuickBooks:

  1. Go to QuickBooks Import Excel CSV toolkit and download the application, which can be used to import CSV files into QuickBooks.
  2. Launch QuickBooks_Import_Exceland_CSV.exe by double-clicking on the downloaded file.
  3. Click on Browse.
  4. Select a folder in which files for the import tool will be extracted.
  5. Launch the toolkit, and follow the on-screen instructions to import the sales tax list.
  6. Select the Sales Tax CSV file that you exported from Peachtree (Sage 50).
  7. Wait for QuickBooks to import the data.

You’ve successfully transferred your sales tax data from Sage 50 (Peachtree) to QuickBooks Desktop. You can create a sales tax report in QuickBooks and match it with the one in Sage 50 to ensure that all your data was correctly imported.

Steps to create a sales tax report in QuickBooks Desktop:

  1. Click on the Reports menu.
  2. Choose Vendors & Payables.
  3. Click on Sales Tax Liability.

5. Migrate payroll data from Sage 50 Payroll to QuickBooks Desktop

You can use the data export option to export all the payroll information including employee information and wages in CSV format, which you can then import into QuickBooks Desktop.

Steps to export payroll data from Sage 50 payroll to QuickBooks Desktop

  1. From the File menu, choose Data Export.
  2. Click on Payroll Data Export.
  3. Click on Next.
  4. Select information that you want to export – information such as employee name, wages, etc.
  5. Click on Next.
  6. Choose the name and location for the exported CSV file in the Path box.
  7. Choose “Create a CSV file with Payroll fields as column headings?” so that the exported file will contain recognizable headings.
  8. Click on Next, then Finish.
  9. Choose Ok to begin the export process.

Now to import this data into QuickBooks desktop, you can enter each list item manually or rely on a third party add-on, which will cost you depending on the subscription price of the add-on. Or you can reach out to our accounting software experts who can transfer your employee, wage and payroll data from Sage 50 to QuickBooks Desktop.

6. Migrate fixed assets data from Sage 50 (Peachtree) to QuickBooks Desktop

You cannot export fixed asset data from Sage 50 to QuickBooks desktop. The QuickBooks conversion tool doesn’t facilitate this yet. And the manual process can take a long time because you need to manually export and then import the fixed asset data.

You have two choices:

  • Use an add-on to transfer fixed asset data from Sage 50 to QuickBooks Desktop.
  • Get in touch with our accounting experts who can transfer your fixed asset data to QuickBooks Desktop.

7. Migrate inventory and services data from Sage 50 (Peachtree) to QuickBooks Desktop

Migrate inventory and services data from Sage 50 Peachtree to QuickBooks Desktop

Sage 50 enables you to export inventory list items in CSV format. You can then edit this list and customize it as per your requirements before you import the CSV file into QuickBooks Desktop.

Steps to export inventory and services from Sage 50 (Peachtree)

  1. From the File menu, choose Import/Export.
  2. Click on Export Records.
  3. Choose “Export records to a Sage 50 import file”.
  4. Click on Next.
  5. Choose Inventory & Services.
  6. Input a Filename and choose a location for the exported CSV File.
  7. Click on Next.
  8. Choose the Items to include in the exported file, then choose Next.
  9. Click on Ok to create the Export Records Summary.
  10. Use Microsoft Excel to make any edits to the exported data.

Steps to use the QuickBooks Excel CSV toolkit to import item lists from Sage 50 to QuickBooks Desktop

  1. Launch QuickBooks_Import_Exceland_CSV.exe by double-clicking on the downloaded file.
  2. Click on Browse.
  3. Select a folder in which files for the import tool will be extracted.
  4. Launch the toolkit, and follow the on-screen instructions to import the sales tax list.
  5. Select the Inventory List Items CSV file that you exported from Peachtree (Sage 50).
  6. Wait for QuickBooks to import the data.

As of now, there is no inbuilt facility available in QuickBooks to import inventory lists in large numbers. So you need to rely on services from add-ons or accounting software experts. The add-ons generally come with a subscription option, so you have to pay a yearly fee to use the basic functions available in those add-ons. The free ones generally have limitations on the number of transactions or list items that you can import into QuickBooks.

If you don’t want to manually import the inventory data from Sage 50 to QuickBooks desktop, then you can get in touch with our team of accounting experts.

Conclusion

That’s all you need to know to easily migrate all your data from Sage 50 to QuickBooks desktop. We’ve covered both automatic and manual methods for transferring your accounting data to QuickBooks from Sage 50 (Peachtree). We’ve covered multiple tools in this post, tools that are provided by Intuit itself to facilitate the import and export of accounting data. You can download these tools from the links that take you to Intuit’s website. 

You can also rely on third-party add-ons to migrate your data, but you’ll have to pay according to the subscription price of the add-on. While using an add-on make sure that you go for a trusted add-on from Intuit’s marketplace. If you download a tool from a random third-party website, you may increase your risk of data theft and loss. You can also reach out to our experts for help related to migration from Peachtree to QuickBooks.

5138226

Get Expert’s Advice to Fix Your All Accounting & Bookkeeping Problems

Phone

+18665400865