FREE QuickBooks 2010 Conversion Tool
for Microsoft Small Business Accounting or Office Accounting and Peachtree users
1. What data does the QuickBooks Conversion Tool import?
The QuickBooks Conversion Tool imports lists, open balances, and historical transactions from Peachtree and Microsoft 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)
Customer transactions:
- Estimates
- Sales Orders
- Invoices
- Payment Receipts
- Deposits
- Credit Memos
Vendor transactions:
- Purchase Orders
- Bills
- Bill Payments
- Checks
- Bill Credits
2. Is there any data the tool DOES NOT convert?
Yes. Due to the unique differences between Peachtree and QuickBooks, we cannot convert all of your data, including:
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 you tracked inventory using FIFO or LIFO in Peachtree, then QuickBooks converts these values 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
3. Is there anything I should do before using the tool?
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.
4. What should I do in QuickBooks after the conversion?
First, enter your company information, including company name and address, in your QuickBooks file. The tool doesn’t import this information. To do this:
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 your preferences. Some converted fields will not be visible until you edit the preferences in QuickBooks. Here’s how.
1. In QuickBooks, go to the Edit Menu and select Preferences. You’ll find most preferences on the Company Preferences tab. Review and edit as needed, particularly:
- 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, depending on your accounting method.
- Sales Tax:
- If you charge sales tax, make sure you’ve answered Yes to the question “Do You Charge Sales Tax?†(You must select Yes in order to access sales tax information.)
- If QuickBooks asks you, "Do you want to make all your customer and/or items taxable?" select No. This will ensure QuickBooks will use your customer and item set up from Peachtree.