To Order, Call Sales (888) 236-9501
 
 

Frequently Asked Questions for the Peachtree to QuickBooks Conversion Tool

What if I need help with the tool?
What is converted using the Peachtree to QuickBooks Conversion Tool?
What is NOT converted using the Peachtree to QuickBooks Conversion Tool?
What should I do before running the conversion?
What should I do in QuickBooks after the conversion?

Back to QuickBooks Conversion Tool download page

Q: What if I need help with the tool?
A: There is extensive content in the help files in the Peachtree to QuickBooks Conversion Tool. Simply click on the blue Help links on the various screens in the tool. You can also contact the QuickBooks Data Conversion Team at 1-800-816-9304 with questions or for additional support.

Q: What is converted using the Peachtree to QuickBooks Conversion Tool?
A: The Peachtree to QuickBooks Conversion Tool imports lists, open balances, and open transactions from Peachtree to QuickBooks.

Key lists:
  • Chart of Accounts
  • Customers/Prospects
  • Jobs
  • Employees/Sales Reps
  • Vendors
  • Inventory items
Balance information:
  • Opening balances for General Ledger accounts, as of a date you set
  • Customer and Vendor open balances
Open transactions:
  • Open invoices (A/R Aging)
  • Open bills (A/P Aging)
Custom fields


Back to top

Q: What is NOT converted using the Peachtree to QuickBooks Conversion Tool?
A: Due to the unique differences between Peachtree and QuickBooks, some of your data will not be converted.

Customer and Vendor Lists:
  • One shipping address per customer will be converted, additional addresses will not.
  • Default income and expense account information
  • Job % Complete, PO Number, Estimated Expense, Estimated Revenue
  • Ship via list
  • Additional information fields
Employees:
  • Billing Rate Level
  • Payroll and Compensation Info
  • Paychecks or employee year-to-date information.
  • Sick Pay, Vacation, DD Info, Pay rates, Taxes, Withholdings, Deductions
  • Employment (Type) - needs to be manually selected (Regular, Officer, Statutory, Owner)
  • No Position, Birthday, Spouse, Emergency contacts, etc.
Items:
  • QuickBooks uses PERPETUAL (Average Cost) Inventory
    • If in Peachtree you tracked inventory using FIFO or LIFO then these values are converted to an Average Cost in QuickBooks.
    • Clients may need to talk to their accountant (or notify the IRS) if there are changes in the way they are reporting inventory (FIFO, LIFO vs. Average Cost)
  • QuickBooks will convert only 10 sales pricing levels from Peachtree.
Transactions:
  • Banking transactions (checks & deposits)
  • Paid in full (zero balance) Invoices or Bills
  • Transaction Detail is NOT imported with Open Bills and Invoices (Only a summary balance)
  • Closed, zero balance or historical transactions.
  • Paychecks or employees year-to-date information


Back to top

Q: What should I do before running the conversion?
A: Before you convert your Peachtree data to QuickBooks:

  1. Make a backup copy of your Peachtree data folder.
  2. Decide whether to use names or IDs for customer and vendor records.
    Note that QuickBooks names must be unique and are limited to 41 characters. We recommend using the name value, since it is sometimes difficult to select the correct customer or vendor when using ID values.
  3. Remove any duplicate names.
    You cannot use duplicate names in QuickBooks. Note that QuickBooks sees "Smith, Bob" and "Bob Smith" as the same name. If duplicate names are found during the conversion, QuickBooks will add a numeric suffix (001, 002) to differentiate between the two names. After you convert your data, you can update and fine-tune your customer, vendor, and employee records in QuickBooks, if needed.
  4. Delete unneeded Peachtree accounts.
    Delete accounts that you know you won't want in QuickBooks. For example, you might want to delete any personal accounts not related to your business.

Back to top

Q: What should I do in QuickBooks after the conversion?
A: First, enter company information in your QuickBooks file.

Company information, such as company name and address, is not imported and must be manually entered into QuickBooks.

  1. Open QuickBooks, select Company, and then Company Information.
  2. Open Peachtree, select Maintain, and then Company information.
  3. Copy and paste all company information from Peachtree to QuickBooks.

Next, set up the preferences.
Some converted fields in QuickBooks will not be visible until the preferences are edited in QuickBooks.

  • In QuickBooks, go to the Edit Menu and select "Preferences". Most preferences are found on the "Company Preferences" tab.
  • Please review and set up preferences as needed, particularly:
    • Accounting: If you use account numbers, check "Use account numbers" and check "Require accounts."
    • Payroll & Employees: If you create paychecks, select "Full Payroll."
    • Purchases & Vendors: If you use inventory, select the "Inventory and purchase orders are active" checkbox.
    • Reports & Graphs: Under "Summary Reports Basis," check the reports preference for "Accrual" or "Cash" (change as needed).
    • Sales Tax:
      • If needed, change the answer to "Do You Charge Sales Tax?" from No to Yes (must be turned on to access sales tax information).
      • If asked, "Do you want to make all your customer and/or items Taxable?" select "No." This will cause QuickBooks to use how the customers and items were set up in Peachtree.

You're now ready to start using your Peachtree data in QuickBooks!

Back to top

Optionally, you can choose to verify the conversion data by:

  1. Comparing the list items in QuickBooks to those in Peachtree.
    In Peachtree go to Help, Customer Support, then Service and File Statistics. In QuickBooks hit the F2 key. This brings up the Product Information screen. In the lower right corner will be the List Information. Compare the following:
    1. In QuickBooks, see the number of Total Accounts. In Peachtree, see Chart. The number of records in Peachtree will be lower by 3 to 8 accounts, due to accounts that QuickBooks uses to do the conversion.
    2. In QuickBooks, see Customers. In Peachtree, see Customer. These should match. If they do not match, there may be jobs in Peachtree that were assigned to Customers. In QuickBooks these will show on the Customer:job list under the Customer name.
    3. In QuickBooks, see Vendors. In Peachtree, scroll down to see Vendor. The number in QuickBooks may be larger by 1, due to QuickBooks creating a vendor called Sales Tax Vendor. May also be different if there were duplicate Vendor names in Peachtree.
    4. In QuickBooks, see Employees. In Peachtree, see Employee. These should match unless there were duplicate Employee names in Peachtree.
    5. In QuickBooks, see Total Items. In Peachtree see Line Item. This will be the Inventory and other items that were imported. These should match, but the number in QuickBooks will also include Sales Tax items that were created from the Sales Tax Codes in Peachtree.
    6. In QuickBooks, you may see a number in Other Names. Names on this list do not match any Customer or Vendor from Peachtree. Go to Lists, Other Names List to see these names. They are names that were used in transactions, such as checks, but are not on the Customer:job list or the Vendor list.

  2. Comparing QuickBooks reports to Peachtree reports.
    Compare the following reports in both Peachtree and QuickBooks as of the accounting period date you chose when using the Conversion Tool.
    1. Balance Sheet in both. In QuickBooks, this report and the Profit and Loss report are found under the Reports, Company & Financial menu.
    2. Income Statement in Peachtree and Profit and Loss in QuickBooks. See above.
    3. General Ledger Trial Balance in Peachtree and Trial Balance in QuickBooks. In QuickBooks this will be found under Reports, Accountant and Taxes, Trial Balance. This report may be different in QuickBooks than it is in Peachtree. If so, there is likely to be a discrepancy between the receivables/payables reports and the balances of the AR/AP accounts on the balance sheet.
    4. If you had open invoices in Peachtree, run the Aged Receivables report. This will show the open A/R in Peachtree. In QuickBooks go to Reports, Customers & Receivables, A/R Aging Summary report. This will show the open balances for each customer. Total balance should match the total balance showing in Peachtree. Individual customer balances should also match. To see the detail for each customer in QuickBooks, double-click on the total amount for the name.
    5. If you had open bills in Peachtree, run the Aged Payables report. This will show the open A/P in Peachtree. In QuickBooks go to Reports, Vendors & Payables, A/P Aging Summary report. This will show the open balances for each vendor. Total balance should match the total balance showing in Peachtree. Individual vendor balances should also match. To see the detail for each vendor in QuickBooks, double-click the total amount for the name.

  3. Verify list information.
    1. Look at the Chart of Accounts to see that the accounts in QuickBooks match the accounts you had in Peachtree.
    2. On the Home page, click on Customers. You will see a list of Customers and Jobs and their open balances. The default will show Active Customers. You can also choose to see All Customers, including inactive customers, and Customers with Open Balances. To edit a Customer, click on the name and then click on Edit Customer.
    3. On the Home page, click on Vendors. You will see a list of Vendors and their open balances. The default will show Active Vendors. You can also choose to see All Vendors, including inactive Vendors, and Vendors with Open Balances. On the Vendor list you may see names that have a V- in front of the name. These indicate that they are duplicate names, the name may also be on the Customer:job list. QuickBooks does not allow duplicate names. They will have the correct name in a field called Print on Check As and this allows the checks to print without having the V- in front of the name. To edit a Vendor, click on the vendor name and then click on Edit Vendor.
    4. On the Home Page, click on Employees. You will see a list of Employees with their Social Security Numbers, if these were in Peachtree. The default will show Active Employees. You can also choose to see All Employees, which will include inactive employees, and Released Employees. To edit an Employee click on the name and then click on Edit Employee.

Back to top

Intuit respects and protects your privacy and will not rent, sell, or share your personal information with outside companies for their promotional use. If you choose to provide your name and e-mail address it may be used to contact you regarding your experience with the Peachtree to QuickBooks Conversion Tool.

 
 
© 2009 Intuit Inc. All rights reserved. Intuit, the Intuit logo, QuickBooks, ProSeries and Lacerte, among others, are registered trademarks and/or registered service marks of Intuit Inc. or one of its subsidiaries. Other parties' marks are the property of their respective owners. Terms, conditions, features, pricing, support and service are subject to change at anytime without notice.