--- title: "QuickBooks & QuickBooks V2" slug: "quickbooks-quickbooks-v2" description: "How to import your transactions from WineDirect ecommerce to Quickbooks or Quickbooks V2. " tags: ["Store", "Allocations", "Classic WineDirect"] updated: 2024-06-14T20:42:11Z published: 2024-06-14T20:42:11Z canonical: "docs.winedirect.com/quickbooks-quickbooks-v2" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.winedirect.com/llms.txt > Use this file to discover all available pages before exploring further. # QuickBooks & QuickBooks V2 The information below is for running the enhanced report version of these two reports. The QuickBooks & QuickBooks V2 exports are order reports in text format that can be used with a third-party program called [Transaction Pro Importer](https://www.transactionpro.com/?gclid=Cj0KCQiAqbyNBhC2ARIsALDwAsCpGtXpCdjkYPN-ciN693iEGPzVJAkJeKYKwISyL3UFfTTYPTfPqucaAnauEALw_wcB) to import your order and sales data into your QuickBooks software. WineDirect Support does not offer assistance with the setup or configuration of the Transaction Pro Importer. This is a manual process. You will want to contact the application provider or seek a Consultant Partner for more assistance. WineDirect does not supply [Transaction Pro Importer](https://www.transactionpro.com/?gclid=Cj0KCQiAqbyNBhC2ARIsALDwAsCpGtXpCdjkYPN-ciN693iEGPzVJAkJeKYKwISyL3UFfTTYPTfPqucaAnauEALw_wcB). The winery must purchase the program.Two versions of QuickBooks exports are available: **Quickbooks Export** and **QuickBooks Export (V2)**. The filters below are the same for both; only the columns in the Export are different. Select whichever better supports your mapping style with [Transaction Pro Importer](https://www.transactionpro.com/?gclid=Cj0KCQiAqbyNBhC2ARIsALDwAsCpGtXpCdjkYPN-ciN693iEGPzVJAkJeKYKwISyL3UFfTTYPTfPqucaAnauEALw_wcB). --- Running The Report/Export 1. Navigate to **Reports > Financial** and select **QuickBooks** or **QuickBooks (V2)** export. 2. Enter the date range you wish to report on [To & From Date]. Dates should be **MM/DD/YYYY** in North America and **DD/MM/YYYY** in Australia. **If you are looking to export all Authorized, Completed, Voided, and Refunded orders [money in and out], then you can skip to **Step 4**.** 3. Using the **Manage Filters** option, you can expand the filter menu and adjust the following: A) Adjust any additional **Order** **Type** parameters if you only want to export specific order types (i.e., ClubOrder). By default, all order types will be shipped. - All Types - AdminPanel - ClubOrder - POS - Website - ...or Additional custom order types of your creation. B) Select whether you want bundled items to export as their bundle SKU number or per piece (default is the Bundle SKU: **Show Bundle Only**) - **Show Bundle Only:** Only the Bundle SKU will appear in the Export. - **Show Individual SKUs Only:** Rather than showing the Bundle SKU in the Export, the report will display each of the subSKUs that make up the Bundle. C) Adjust alternate **Payment Status** if you want to include declined tenders. (**Bold** Payment Statuses are the defaults used in the report) - All Statuses - Pending - Submitted - **Authorized** - **Paid** - Declined - **Refunded** - **Voided** - **External** D) If you use additional services connected to your WineDirect account, you can filter orders by **Vendor**. 4. Click **View** to view the report data in your browser (Not available on QuickBooks V2 export). Click **Export** to receive an export file. --- ## QuickBooks & QuickBooks V2 FAQs ### What is the difference between QuickBooks & QuickBooks V2? > Both the QuickBooks & QuickBooks V2 reports are designed to be used with the third party application Transaction Pro Importer. Because QuickBooks account setups can vary and because Transaction Pro Importer allows for custom mappings, there are two export versions available. Main differences include: > > A) The columns in the report vary. Each has a different set of columns with different information. > > B) The QuickBooks V2 export displays tips on POS orders as a separate line item. > > If you are working with a consultant for data importing you will want to check with them to see which export sheet they are using. In most cases they will likely be using the newer QuickBooks V2. ### How do orders with multiple (split) tenders work? > Only one payment type (tender) can be imported per order, so to help streamline the import process only one tender from the order will be displayed in the export. For most orders this will not have any affect on the report is the customer made full payment with a credit card or cash then the report will show the card or cash as the payment method. > > For orders when the customer paid for the order with multiple payment types (tenders) then the first successful payment method will be reported on, with priority given first to credit card payments and then to cash. So on an order where a credit card and cash were both used the QuickBooks & QuickBooks V2 reports will only show the credit card payment type (with its card type: Visa, MasterCard, etc). On orders without a credit card tender, example a gift card and cash payments, then the cash tender would show instead of the gift card tender. > > Please be mindful of whether you are placing orders with more than one payment type (tender) as this will affect your QuickBooks & QuickBooks V2 exports and in turn your reporting in QuickBooks.