QB Issue Resolution:

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 data that gets converted to QuickBooks

    Customer Address Information Notes
    Customer Name or ID Up to 41 characters.
    Company Name Same as the Peachtree Customer Name.
    Contact Name for Primary Contact Behaves the same.
    Phone number for Primary Contact Peachtree Telephone 1
    Fax number Behaves the same.
    E-mail address Behaves the same.
    Address for Bill To Behaves the same.
    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 Notes
    Type Behaves the same.
    Terms 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.
    Rep Sales Rep
    Preferred Send Method Not converted.
    Sales Tax information (Tax Item and Code)
    • Each QuickBooks tax item (whether exempt or not) originates 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. Each Peachtree sales tax code is converted to a QuickBooks sales tax group, containing their respective tax item components.
    • In QuickBooks sales taxes are set up as sales tax items. In Peachtree they are set up as sales tax codes. Each sales tax code is made up of at least one sale tax authority. All sales tax authorities in Peachtree (whether exempt or not) are converted as sales tax items. For the purposes of the conversion. All tax codes in Peachtree are converted as sales tax groups in QuickBooks. These can contain one or more sales tax items (Peachtree tax authorities).
    Resale No. Not converted.
    User-defined (Custom) fields Behaves the same.
    Payment Info Notes
    Account No. Behaves the same.
    Credit Limit Behaves the same.
    Preferred Payment Method Behaves the same.
    Credit Card Information Behaves the same.
    Job Info Notes
    Job Status Behaves the same.
    Start Date Behaves the same.
    Projected End Behaves the same.
    End Date 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.
    Job Description Behaves the same.
    Job Type Behaves the same.
    Customer and Customer:Job Open Transactions Notes
    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:

    • 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.)
    • 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).
  • Vendor lists

    The QuickBooks Conversion Tool converts most of your vendor data, with the following exceptions:

    • Default sales accounts associated with vendors
    • Peachtree-specific fields (Supervisor, % Complete, PO Number, Estimated Expense, and Estimated Revenue)

    The following tables list the vendor-related information that will be converted (or not converted).

    Vendor data that gets converted to QuickBooks

    Vendor Address Information Notes
    Vendor Name or ID Up to 41 characters.
    Company Name Same as the Peachtree Vendor Name.
    First Name, M.I., Last Name Uses the Peachtree contact.
    Name and address Behaves the same.
    Contact Name Behaves the same.
    Phone number Peachtree Telephone 1
    Fax number Behaves the same.
    Alternate Phone number Peachtree Telephone 2
    E-mail address Behaves the same.
    Print on Check as Uses the Peachtree Vendor Name
    Vendor Additional Information Notes
    Account No. Uses Peachtree’s “Our Account With Them”
    Type Peachtree Vendor Type
    Terms 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.
    Credit Limit Behaves the same.
    Tax ID 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 Notes
    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:

    • 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.)
    • Complete detailed historical and current transactions and balances.
    • 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).
  • Employee list
  • Transaction data

    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).

    Transaction types

    Peachtree QuickBooks
    Purchase/Receive Inventory (PJ) Bill (Vendor)
    Vendor Credit Memo (INAJ) Bill Credit
    Payment (CDJ) Bill Payment (Vendor)
    Build Assembly (ASB) Build Assembly (Inventory assembly items) Premier and ES only.
    Vendor Credit Memo (INAJ) Credit Memo
    Check/Payment Check
    Receipt (CRJ) Deposit Deposit
    Quote Estimate
    General Journal (GEN) General Journal Entry
    Sales Invoice (SJ) & (COGS) Invoice (Customer)
    Purchase/Receive Inventory (PJ) Item Receipt (Received for Bill)
    Inventory Adjustment (INAJ) Inventory Adjustment
    General Journal (GEN) Liability Adjustment
    Payroll General Journal (PRJ) Paycheck
    Check Payroll Liability Check
    Receipt (CRJ) Deposit Payment (Customers)
    Purchase Order Purchase Order
    Sales Order Sales Order
    Receipt (CRJ) Deposit Sales Receipt
    Check Sales Tax Payment
    General Journal (GEN) Transfer of Fund
    General Journal (PRJ) YTD Adjustment

    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.

    Invoices and credit memos

    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
    • Customer Name:Job
    • 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
    • Original Terms
    • Ship to Date
    • Memo
    • 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
    • Classes

    Bills and bill credits

    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
    • Vendor Name
    • 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
    • Terms
    • Reference Number
    • 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

    New accounts

    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.

  • Item list

    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).

    Item data that gets converted to QuickBooks

    QuickBooks Item Type Peachtree Item Class Definition and Notes
    Service Labor, Service, or Activity Item Services you charge for or purchase. Examples include specialized labor, consulting hours, and professional fees.
    Inventory Part Stock Item Goods you purchase, track as inventory, and resell.
    Inventory Assembly Assembly Item (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.
    Non-inventory Part Non-stock 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.
    Fixed Asset Not converted. 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.
    Other Charge Charge Item Miscellaneous labor, material, or part charges such as delivery charges, setup fees, and service charges.
    Subtotal NA Totals all items above it on a form, up to the last subtotal. Useful for applying a percentage discount or surcharge to many items.
    Group NA 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.
    Discount NA Subtracts a percentage or fixed amount from a total or subtotal. Do not use this item type for an early payment discount.
    Payment NA Records a partial payment you received at the time of the sale. It reduces the amount owed on an invoice.
    Sales Tax 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 Name/Number

    QuickBooks Peachtree Notes
    Item Name/Number Item ID 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”.

    Purchase Information

    QuickBooks Peachtree Notes
    Description on Purchase Transactions Purchase Description Behaves the same.
    Cost Cost from Bills Behaves the same.
    COGS Account GL Cost of Sales Account Behaves the same.
    Preferred Vendor Vendor Name Behaves the same.

    Sales Information

    QuickBooks Peachtree Notes
    Description on Sales Transactions Sales or Item Description Behaves the same.
    Sales Price Price Level 1 Amount Behaves the same.
    Tax Code NA Behaves the same.
    Income Account GL Sales Account Behaves the same.

    Price Levels

    QuickBooks Peachtree Notes
    Item Name Item ID Behaves the same.
    Custom Price Price Level Amount Behaves the same.
    Item Type Item Type Behaves the same.

    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.

    Inventory Information

    QuickBooks Peachtree Notes
    Asset Account GL Asset Account Behaves the same.
    Reorder Point Reorder Quantity Behaves the same.
    On Hand QTY on Hand Behaves the same.
    Average Cost Cost Method 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 P.O. Not converted.
    On Sales Order Not converted.
    User-defined (Custom) fields 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.
  • Support tables

    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)
    • Sales Tax Code
    • Class
    • Sales Rep
    • Customer Type
    • Vendor Type
    • Job Type (QuickBooks converts the job type referenced in Peachtree jobs to the QuickBooks Job Type List)
    • Terms
    • Customer Message
    • Payment Method
    • 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.)