Was this page helpful?
Thank you!

Comments or suggestions?



Enter Email Address (optional)
email

What Peachtree data gets converted?

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

    For more information about any of support tables, refer to the QuickBooks in-product Help.

See also

KB ID# H_CONVERT_PEACHTREE_WHAT_IS_CONVERTED
12/7/2016 11:51:48 PM
QYPPRDQBKSWS08 9138 Pro 2017 7f5c31