The data conversion process will convert most of your Peachtree data to QuickBooks. However, some Peachtree-specific information cannot be converted.
To learn about what data will be converted (and not converted) for different areas, click on the appropriate link below.
Customer and Job lists
The QuickBooks Conversion Tool converts most of your customer and job data, with the following exceptions:
Default sales accounts associated with customers
Peachtree-specific fields (Supervisor, % Complete, PO Number, Estimated Expense, and Estimated Revenue)
The following tables list the customer-related information that will be converted (or not converted).
Customer Address Information
Customer Name or ID
Up to 41 characters.
Same as the Peachtree Customer Name.
Contact Name for Primary Contact
Behaves the same.
Phone number for Primary Contact
Peachtree Telephone 1
Address for Bill To
Address for Ship To
Only for Peachtree's Ship-to Address. Additional Ship-to addresses must be manually setup in QuickBooks as separate jobs under the customer name.
Customer Additional Information
QuickBooks enables you to set up a list of terms. Peachtree supports a single set of "standard terms" as well as providing unique terms by customer. The QuickBooks Terms List is created from all the unique terms set within each customer. Each customer will then reference the correct terms that were created in Peachtree.
Preferred Send Method
Sales Tax information (Tax Item and Code)
User-defined (Custom) fields
Preferred Payment Method
Credit Card Information
If an End Date value is not present in Peachtree, then QuickBooks will convert the Projected End Date to this field. Otherwise, the field will be blank.
Customer and Customer:Job Open Transactions
Converted data varies based on the conversion option you chose.
For the "Lists Only" option, QuickBooks converts:
Chart of Accounts, Inventory Items, Customers/Prospects, Vendors, Employees/Sales Reps, and Sales Tax Authorities and Codes.
Customer name: First Middle Last (Default) or Last, First Middle (Results might vary if the name is a company name and you chose this option.)
For the "Lists and Transactions" option, QuickBooks converts:
Complete detailed historical and current transactions and balances.
Customer transactions: Estimates, Sales Orders, Invoices, Payment Receipts, Deposits, and Credit Memos.
Differences between AR Aging Report and the AR account balance
An adjustment will be made in QuickBooks to the Accounts Receivable Clearing account (a current asset account).
The QuickBooks Conversion Tool converts most of your vendor data, with the following exceptions:
Default sales accounts associated with vendors
The following tables list the vendor-related information that will be converted (or not converted).
Vendor Address Information
Vendor Name or ID
Same as the Peachtree Vendor Name.
First Name, M.I., Last Name
Uses the Peachtree contact.
Name and address
Alternate Phone number
Peachtree Telephone 2
Print on Check as
Uses the Peachtree Vendor Name
Vendor Additional Information
Uses Peachtree's "Our Account With Them"
Peachtree Vendor Type
QuickBooks enables you to set up a list of terms. Peachtree supports a single set of "standard terms" as well as providing unique terms by vendor. The QuickBooks Terms List is created from all the unique terms set within each vendor. Each vendor will then reference the correct terms that were created in Peachtree.
Peachtree Federal EIN
Vendor eligible for 1099
Peachtree Type of 1099
Billing Rate Level
Not used in Peachtree.
User-define (Custom) fields
Behaves the same, unless a customer or item has the same custom field. In this case, the data will only be converted for the customer's or item's field. Custom fields can currently only be converted for a customer, an item, a vendor, or an employee, but not shared across these. Custom fields will currently be converted in the following order: customer, item, vendor, employee.
Vendor Open Transactions
Vendor transactions: Purchase Orders, Bills, Bill Payments, Checks, and Bill Credits.
Differences between AP Aging Report and AP Account Balance
If there is a difference between the AP Aging Report and the AP Account Balance, an adjustment will be made in QuickBooks to the Accounts Payable Clearing account (a current liability account).
The QuickBooks Conversion Tool converts your detailed transactions (invoices and bills), except when the information is unique to Peachtree. The conversion tool will fix any inconsistencies in transactions that were posted incorrectly in Peachtree (e.g., an invoice that is not posting to an Accounts Receivable type account or a bill that is not posting to an Accounts Payable type account).
The following sections list the transactions that will be converted (or not converted).
Purchase/Receive Inventory (PJ)
Vendor Credit Memo (INAJ)
Bill Payment (Vendor)
Build Assembly (ASB)
Build Assembly (Inventory assembly items) Premier and ES only.
Receipt (CRJ) Deposit
General Journal (GEN)
General Journal Entry
Sales Invoice (SJ) & (COGS)
Item Receipt (Received for Bill)
Inventory Adjustment (INAJ)
Payroll General Journal (PRJ)
Payroll Liability Check
Sales Tax Payment
Transfer of Fund
General Journal (PRJ)
Note: Converted transactions will include line item details that show the original transaction information and any payments that have been applied to reduce the balance.
If necessary, QuickBooks will also make these adjustments:
Inventory Value Adjustment (Inventory Assembly/Builds) for Premier and Enterprise Solutions: (Item Quantity on hand) x (Average cost) = Total Value Adjustment
This adjustment is made using the items Asset account. It will Debit & Credit the same account for the same amount. The net account result is zero, and the Inventory Quantity and Average cost will be the only affect.
Journal Entries: Accounts Receivable Clearing & Accounts Payable Clearing and Journal(s) for the difference between AR/AP and the Trial balance.
How invoices and credit memos post debits and credits when converted and no Account Receivable account is assigned.
If the Peachtree invoice or credit memo does not post to an Account Receivable account:
Invoices post a Debit amount to Accounts Receivable account for the current amount due on the invoice.
Invoices posts a Credit to the Accounts Receivable Clearing (Other Current Asset) account for the current amount due on the invoice.
Credit Memo's post a Credit to the Accounts Receivable account for the current amount.
Credit Memo's post a Debit to the Accounts Receivable Clearing (Other Current Asset) account for the current amount.
Note: Sales tax is added as a line item within the body of the invoice. Typically QuickBooks uses the Sales Tax box to calculate the sales tax item using the percentage method. The default rate for the Sales Tax Item is 0.00%. The sales tax is converted as a dollar amount from the original amount due on the original Peachtree invoice. Sales tax is reduced when payments are applied to the invoice.
Information that is converted for invoices and credit memos
For all invoices and credit memos, the following information is converted:
All closed, zero balance, historical, and open invoices and credit memos
Items and descriptions including debit/credit posting account information for these items
GL account information (income or expense) and balance sheet account postings
Original amount of invoice/credit memo, any payments and current due/credit
Original Invoice date
Customer's Bill to Address
Ship to Date
A summary of the current total amount due/credit (debited to Accounts Payable for Invoices; credited to Accounts Receivable Clearing for Invoices)
Information that is not converted for invoices and credit memos
For all invoices and credit memos, the following information is not converted:
Invoice or Credit Memo details
Customized invoice or credit memo templates
How bills and bill credits post debits and credits when converted and no Account Payable account is assigned.
Bills post a Credit to the Accounts Payable account for the current amount due on the bill.
Bills post a Debit to the Accounts Payable Clearing (Other Current Liability) for the current amount due on the bill.
Bill Credits post a Debit to the Accounts Payable account for the current amount due on the bill.
Bill Credits post a Credit to the Accounts Payable Clearing (Other Current Liability) account for the current credit amount.
Information that is converted for bills and bill credits
For all bills and bill credits, the following information is converted:
All closed, zero balance, historical, and open bills and bill credits
Items and descriptions including (debit/credit) posting account information for these items
GL Account information (income or expense) and balance sheet accounts posting
Original amount of Bill/Bill Credit; any payments and current amount due/credit
Original Bill date
Bill to date
A summary of the current total amount due/credit (posted on the Expense Tab to Accounts Payable Clearing (Other Current Liability) account.
Information that is not converted for bills and bill credits
For all bills and bill credits, the following information is not converted:
Bill or Bill Credit details
Items (or posting accounts for items) that were on the original Peachtree bill or bill credit
Customized bill or bill credit templates
Memos, customer jobs, or classes
When converting transactions, QuickBooks may create several new accounts in the new company file to resolve various conversion issues. For more information, see New accounts created when converting companies from other software.
In QuickBooks, an item is anything that your company buys, sells, or resells in the course of business, such as products, labor, shipping and handling charges, discounts, and sales tax (if applicable).
Items help you fill out the line item area of a sales or purchase forms quickly. When you choose an item from your Item list, QuickBooks fills in a description of the line item and calculates its amount for you.
QuickBooks provides twelve different types of items. Some (such as the service items or the inventory part items) help you record the services and products your business sells. Others (such as the subtotal item or discount item) are used to perform calculations on the amounts in a sale.
For more information about creating or editing items in QuickBooks, refer to the QuickBooks in-product Help.
The QuickBooks Conversion Tool converts most of your item information, except when the information is unique to Peachtree.
The following tables list the item-related information that will be converted (or not converted).
QuickBooks Item Type
Peachtree Item Class
Definition and Notes
Labor, Service, or Activity Item
Services you charge for or purchase. Examples include specialized labor, consulting hours, and professional fees.
Goods you purchase, track as inventory, and resell.
(Premier and Enterprise Solutions only) Assembled goods you build or purchase, track as inventory, and resell. Note: QuickBooks cannot track the costs associated with the manufacturing process itself. In other words, the cost of a built assembly item depends only on the cost of its components.
Goods you buy but don't track (such as office supplies), or materials you buy for a specific job that you charge back to your customer.
An asset you do not expect to convert to cash during one year of normal operations. A fixed asset is usually something that is necessary for the operation of your business, such as a truck, cash register, or computer.
Miscellaneous labor, material, or part charges such as delivery charges, setup fees, and service charges.
Totals all items above it on a form, up to the last subtotal. Useful for applying a percentage discount or surcharge to many items.
A way of associating individual items that often appear together on invoices, purchase orders, and so on, so that all items in the group can be added to the form at one time.
Subtracts a percentage or fixed amount from a total or subtotal. Do not use this item type for an early payment discount.
Records a partial payment you received at the time of the sale. It reduces the amount owed on an invoice.
Sales Tax Authority
Calculates a single sales tax at a specific rate that you pay to a single tax agency. Each QuickBooks tax item (whether exempt or not) is converted to from a sales tax authority, a component of Peachtree's sales tax codes. Each non-exempt tax item is also converted as its own QuickBooks sales tax code.
Sales Tax Group
Sales Tax Code
Each Peachtree sales tax code is converted to a QuickBooks sales tax group, containing their respective tax item components. Calculates and individually tracks two or more sales tax items that apply to the same sale. The customer sees only the total sales tax.
Item names are limited to 31 characters. If you want to group items, you can create subitems. For example, you can create an item called "Socks" and subitems for "Black" and "Blue".
Description on Purchase Transactions
Cost from Bills
GL Cost of Sales Account
Description on Sales Transactions
Sales or Item Description
Price Level 1 Amount
GL Sales Account
Price Level Amount
Note: If a percent is entered in Peachtree, it calculates the dollar value and Peachtree uses the dollar amount. Since Peachtree does not use a percent method, only the dollar value will be transferred to QuickBooks. If you want to enter the price level in percent terms after conversion, you can manually enter this percent into QuickBooks.
GL Asset Account
QTY on Hand
QuickBooks uses PERPETUAL (Average Cost) Inventory.
For an inventory item, average cost is the total cost of the items currently in stock divided by the number of items in stock. You can set up QuickBooks to use average cost or FIFO to determine the value of your inventory.
Note: FIFO is only available with QuickBooks Enterprise Solutions Advanced Inventory.
QuickBooks recalculates the average cost of an item every time you record the purchase of more units of the item. It adds the cost of the new items to the cost of the old stock and then divides by the total number of new and old items.
If in Peachtree you tracked inventory using FIFO or LIFO then these values are converted to an Average Cost in QuickBooks.
You might want to talk to your accountant (or notify the IRS) if there are changes in the way you are reporting inventory (FIFO, LIFO vs Average Cost).
On Sales Order
When converted, behaves the same.
Behaves the same, unless a customer has the same custom field. In this case, the data will only be converted for the customer's field. Custom fields can currently only be converted for a customer, an item, a vendor, or an employee, but not shared across these. Custom fields will currently be converted in the following order: customer, item, vendor, employee.
For items with no accounts during conversion, QuickBooks creates these accounts:
MissingInvAsset: created if there is not an inventory asset account associated with an Inventory Item. When populated, this is the total current inventory cost (inventory adjustment).
MissingInvSales: created if there is not an income account associated with an Inventory Item.
MissingInvCOGS: created if there is not a COGS account associated with an Inventory Item.
To support the accurate conversion of your customer and vendor lists, QuickBooks converts basic information from these support tables:
Price Level (QuickBooks converts ten sales pricing levels from Peachtree)
Job Type (QuickBooks converts the job type referenced in Peachtree jobs to the QuickBooks Job Type List)
Ship Via (QuickBooks cannot convert the Ship Via list, since they are set up in Peachtree's Inventory defaults. However, you can set up each customer or vendor record to use a default ship-via method, or you can select a ship-via method on a case-by-case basis.)
For more information about any of support tables, refer to the QuickBooks in-product Help.