What data is exported to QuickBooks Desktop

What data is exported to QuickBooks Desktop

Overview

This article explains what data is exported from SalesPRO when QuickBooks Desktop (QBD) is selected as the accounting application.

QuickBooks Desktop

Employees

  • Employee Name - This the full name which is made up of the First M. Last.
  • Home address
  • The first and second phone numbers
  • The first email address

Customers

  • Customer Name - This can be either the Customer Name field or the full name which is made up of the First M. Last.
  • First Name
  • Middle Initial
  • Last Name
  • Company Name
  • Billing Address
  • Shipping Address - Only the default shipping address is exported.
  • The first and second phone numbers
  • The third phone number - This is applied to the fax number when the customer is imported in to QuickBooks.
  • The first email address
  • The contact name
  • Resale number
  • The sales rep. name
  • Terms - This is optional
  • Sales tax group - This will be either the name of the Sales Tax Group or Sales Tax Code depending on your setup. Refer to this KB article for more information on how sales tax is exported to QuickBooks.

Linked Accounts

  • Account Name
  • Account Type - This will be either an income or cost of good sold account.
  • Description

Terms

Note: Terms are sent over a standard terms. Date driven terms are not supported.

  • Name
  • Due Days
  • Discount %
  • Discount Days

Payment Methods

  • Payment method

Sales Tax Codes

  • Code
  • Sales tax payable account - By default this is Sales Tax Payable but it can be changed in Application Settings
  • Rate %
  • Vendor/Agency

Sales Tax Groups

Note: Sales tax groups reference one or more sales tax codes. Make sure to export and then import the sales tax codes first.

  • Group Name
  • Description

Products

  • Name
  • Sales Account
  • Taxable

Additional Charges (includes customer and vendor promotions)

  • Name
  • Sales Account
  • Taxable

Payments

  • Payment date
  • Payment account - either an undeposited funds or credit card account. 
  • Reference number - this will be the order number only if the payment is fully allocated, otherwise it will be the description you entered on the payment.
  • Customer name
  • Payment amount
  • Payment details - this goes to the memo field

Vendors

  • Vendor name
  • Billing address
  • The first and second phone numbers
  • The third phone number - This is applied to the fax number when the customer is imported in to QuickBooks.
  • The first email address
  • Terms - These are optional

Invoices

  • Invoice date - The invoice date if the sale/order was already invoiced, otherwise the current date
  • Customer name
  • Order total
  • Sale/Order number
  • Sidemark - Either in the memo field or the customer message field
  • To be Printed - Yes or No based on settings
  • Customer billing address
  • Terms - This is optional
  • Shipping method
  • Ship date - Based on settings this is either not sent or it is the estimated delivery date or the order delivered date
  • Installation address of the sale/order
  • Sales rep
  • Customer PO number
  • The due date based on terms

--Line Items

  • Total unit price
  • Item description - This is the description string (1 or 2) as setup in Settings
  • Item name - Either a product name or additional charge name. The export name is used if one is set, otherwise the original item name is used.
  • Quantity
  • Unit price

Purchase Orders

  • PO date - The date the purchase order was created.
  • Vendor name
  • PO total
  • PO number
  • Vendor billing address
  • Ship to address - Either the drop ship address or the installation address of the associated sale/order

--Line Items

  • Total unit cost
  • Item description - This is the description string (1 or 2) as setup in Settings
  • Item name - Either a product name or additional charge name. The export name is used if one is set, otherwise the original item name is used.
  • Quantity
  • Unit cost

APPLIES TO

  • SalesPRO Software

    • Related Articles

    • Requirements for exporting certain data to QuickBooks Desktop

      Overview This article will explain what data is required when exporting to QuickBooks. QuickBooks Desktop Sales Tax Codes Tax Agency/Vendor. This must reference the name of a vendor in QuickBooks that is setup to collect sales tax. This is not ...
    • Unusual data is getting added to QuickBooks Desktop

      Overview When reviewing your QuickBooks Desktop (QBD) company you may see data such as accounts, items, vendors, etc. that you don't recognize. This article will explain where some of these items may come from if you're importing SalesPRO data into ...
    • Update Company Database for QuickBooks Desktop Invoice Exporting

      Summary This package will update the company database so that invoices for QuickBooks Desktop (QBD) can be correctly exported from SWCS (SalesPRO). Without this package the sales tax is not included in the invoice export which will prevent it from ...
    • Customers with parent customers don't export to QuickBooks Desktop correctly

      Symptoms When a customer that has a parent customer is exported to QuickBooks Desktop (QBD) the parent customer information is not included in the export file. Cause This is caused by a bug in the SWCS QBD module. Workaround There is no known ...
    • How to export data to accounting

      Overview This article will explain the general procedure for selecting and export data to your selected accounting application. Details The overall process for exporting data to accounting is quite simple. You select one or more items to export and ...