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
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.
Products
Additional Charges (includes customer and vendor promotions)
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
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 ...